When I run the query in the QAAWS window , I am able to see the results/data for all the 5 columns in Query Results Preview pane.
When I publish this query and use this connection in the Xcelsius dashboard , data for the Country_Dim_AL2.Cntry_Name column is absent.
Only other 4 columns has data.
The Country_Dim_AL2.Cntry_Name column is blank for all the rows , when all other 4 columns has data.
Country_Dim_AL1 and Country_Dim_AL2 are alias tables for Country_Dim dimension table.
In the Universe Country_Dim_AL1 is joined with Fact_Table on the column Start_Cntry_cd .
Country_Dim_AL2 is joined with the same fact table Fact_Table on the column End_Cntry_cd.
how do you know that the Country_Dim_AL2.Cntry_Name
column is not returning data in xcelsius ? what method are you using to show the data ?
It is possible maybe your component is not bound to the correct range of cells. If the data exists in the web service preview, then it is certainly incoming into the xlf model.
Have you set aside enough columns in your landing area - by that I mean that you should check that the area you specified in your qaaws connection in connection manager using the ‘Insert In’ option is wide enough to encapsulate all of the columns you’re returning.
Secondly did you by any chance add this column after first defining the QaaWS query? If so you would need to reimport the web service definition using the import button in the connection manager.
Thirdly - check that the grid or whatever you are using to expose the query results on the canvas does actually encapsulate the missing column. I’ve done that one a few time myself…
(BOB member since 2008-06-05)
(BOB member since 2013-03-20)
(BOB member since 2005-03-01)