Our company has created a number of Xcelcius dashboards using QAAWS to access the Business Objects universe. I am having difficulty with graphs/tables when a secondary call is not resulting in the data being refreshed.
For example:
The first query retrieves a count for 2008. The data is displayed in the graph and the sub-title is linked to the year selected, so 2008 is shown in the sub-title.
If a second call is made to the universe to retrieve data for 2009 and there is no data for that year the count for 2008 will still be displayed in the graph, but the subtitle for the graph has been amended to 2009. The data should refresh and display a zero!
How can I get the data to refresh to show a zero when there is no data for that item/time period?
Thanks in anticipation.
Phil