Skip to Content
0
Former Member
May 18, 2010 at 10:26 AM

Error querying OLAP universe based on BEx query

32 Views

Hi all,

I have a problem extracting larger (more than 80 000 rows) amounts of data through querying an OLAP universe with WebI.

The error is:

Query 1 - NAME_OF_THE_QUERY

A database error occurred. The database error text is: Error in MDDataSetBW.GetCellData. &INCLUDE INCL_INSTALLATION_ERROR. (WIS 10901)

The error occurs when I define larger scope of analysis in the query (four levels). With more modest scope (three levels or less) it's working OK. I need larger data set (more than 200 000 rows) to be populated at night through scheduling the report. We can't afford shrink the scope of analysis because it will hit the BW server during the day when it's needed by other users.

Besides this the speed of the report refresh is very slow - more than 3 minutes per just 400 rows of data. I'm still unable to identify the source of the problem with this slowdown. Executing the same query over the web through the SAP BW BEx Viewer is much much faster - just 3 seconds. Maybe the reason for this is that the BEx viewer aggregates data on the higher level of the hierarchy rather than down to transaction level (like we do by expanding the scope of analysis).

Anyway, if anyone have ideas about the error above I'll be very grateful if you share your thoughts. Thanks!

Our environment:

BO EDGE BI 3.1, standard

SAP BW 3.0

SAP Integration Kit (all transports installed)

BW user with full access