I have build OLAP Universe based on BW cubes and reporting on the Universes using Web Intelligence.
When i pull arpund 4 Dimension objects in the Select panel and hit on Run Query, it takes around 10-11 mins and gives me the message No data to retreive. But when i run the same query immediately it gives me the data in 2-3 secs. This happened everytime when i try to pull objects in the query panel.
Has anybody faced this kind of pattern while reporting on Olap Universes. Please let me know as this has been a long standing issue.
Just to be clear, you create the query and run it. After 10+ minutes you get the No Data to Fetch message. If you then immediately rerun the same query, after a few seconds data is displayed. The difference in time could potentially be explained away by database caching…but as to why you don’t see the information first time around…my initial thoughts would be some kind of connection time out, which isn’t manifesting itself in the usual way. Any time limit set in the universe (File / Parameters)?
I have checked the paramters in the Universe end and a the CMC level as well and everything seems to be fine. But if the query is running beyond the allocated time it should be giving a different error message like Session Time Out or something.
[quote:9b8480b644=“chetan.mudike”]But if the query is running beyond the allocated time it should be giving a different error message like Session Time Out or something.
[/quote]
I agree. But given the peculiar behaviour you are experiencing, why not up those limits well beyond the 10-11 minutes you mentioned to see if that resolves the problem. That gives you a workaround while you investigate further.
Hi, I’ve been creating reports with universes created on infocubes, and bex queries, and have NEVER seen this happen.
Check your universe connection parameters, row limits especially. Then I’d suspect something on the BW side. Try recreating the same universe using a different userid/pass to see if it does the same.
Good luck!
Things have actually improved a bit, Previously when the report used to run for 10-11 mins it would give me the error ‘No Data to Retreive’. I had removed the restrictions on the universe parameters and now the query is running for ~7 mins and fetching the data. Is there anything else that can be done at the WebIntelligence Server Properties on CMC.
What does the parameter ‘Server Polling Interval’ mean?
I too faced this type of problem many times and now also facing.
Today i run it’s happening like that when i ran the same next day am seeing data
I think it behaving like that because of Navigational attributes of BW- InfoCube and if you run query without Measure object then also same message one can see.
So…I am glad I am not the only one facing this issue.
I have checked some forums on SAP Community Network Forums and i see that there is a SP2 for BO XI 3.0 version and if it is on BO XI 3.1 there is FP1.3 which would resolve Performance Issues with WebIntelligence on OLAP Cubes.
It’s best practice to put your universe on top of a BEx query rather than the cube itself. Also be sure to check out all the sap notes, as there have been several improvements in this area since last year, on both the BOBJ side and the BW side.
One can design Universe on BEx query only , right? by Enabling OLAP form extended properties for Infocube and MultiProvider?
How to directly use Infocube without BEx query??
One can create an SAP OLAP based universe either from a BEX query (recommended) or directly from an Infocube (you will just browse to the Infocube when creating the universe connection, it is rather straight forward).
Keep in mind that an Infocube is a bad choice, performancewise as featurewise, as many features do not exist at the Infocube level such a calculated key figures, etc.
We are using BEx master query as source to design Universe only.(Recommended by BO also). But still facing lots of problems while working on it.
BO needs to take care of whats going on…
This is an old thread but I thought I’d add that we’re observing a similar issue at a client:
I’ve scaled down a large sales WebI report that the client has been struggling with performance-wise. The first time it’s refreshed, it will process for a while and then return with “No Data to Retrieve”. I’ll refresh it again immediately after and it will return with data in just a second or two.
You can do this all day long… no data, data, no data, data, etc.
This is the environment:
BOE 3.1 SP4
BW 7.2
I’m told the underlying BEx query is pretty large, with probably > 50 “key figures”. The universe has no timeout restrictions (Limit Execution Time is not checked).
As bugs go, this is pretty bad because receiving a “no data” message is different than an error and can be misleading.
(BOB member since 2008-02-13)
(BOB member since 2002-08-15)
(BOB member since 2002-06-20)
(BOB member since 2008-02-13)
(BOB member since 2006-12-18)
(BOB member since 2002-08-15)