Hi,
I am faced with a problem where a set of data is sorted based on the value in a table in Webi. This table is called into Xcelsius using Qaaws through webservice. The issue here is the data is showing correctly in Webi and is sorted, but not displaying properly in the dashboard.
When I display the data in dashboard, the sorting doesn’t take effect.
Any work around or ways to rectify this?
Thanks,
Arun
Arun.K 
(BOB member since 2011-10-18)
Is it possible to schedule the Webi, and force the datasource to use the last instance? If you are refreshing the block at the webservice runtime, I think your sort might change, since its a dynamic sort.
A slow workaround would be to bring the in the value that the sort is based on…in another query, and do some excel work to format/sort the dataset inside xcelsius.
Cairmor (BOB member since 2008-06-05)
Thanks Cairmor.
The report is scheduled to run every day and the web service is getting the last instance run by inserting 1 on the xcelsius. I will try your suggestion.
Arun
Arun.K (BOB member since 2011-10-18)