I am using Xcelsius 2008 over BW queries. I have four charts returning data from three queries. Each qrery retruns a small set of data (about 24 values). In each case the result set of the query passes through simple Excel formula to handle scaling and chack for nulls etc.
My problem is that about 30% of the time one of the queries displays no data. I have put a grid in my dashboard to see the raw result area. If I press refress in my browser and make the same selections at the prompt I will usually (but not always) get data. Pressing refresh again might cause the data to again vanish.
I think that what is happening is that the flash is rendering to the screen before the query finishes running. Has anyone experienced this? Is there any known fix.