Skip to Content
0
Mar 19, 2009 at 06:27 PM

Is there any limitation in rows returned by our MDX driver for LOV? XI R3

43 Views

Hello All:

A customer has created a prompt with a LOV with more than 60000 rows - i.e. 60000 members in SAP BW cube. However, when searching for values in the prompt, the prompt doesnt show up values which are located beyond 50500 rows. When looking at the SOFA trace, we can find that webi splits the research result set into 2 batches, one of 500 rows, then another one of 50 000 rows:

Fri Mar 06 17:09:18.639: SAPMODULE: SAPConnection: SAPConnection::getMaxRowsPerLoad

Fri Mar 06 17:09:18.639: SAPMODULE: SAPServerConfiguration: SAPServerConfiguration::getSAPServerLoadLimits

...

Fri Mar 06 17:09:18.639: SAPMODULE: SAPServerLoadLimits: Looking for tlsrv052.swna.wdpr.disney.com from the list of ServerLoadLimits...

Fri Mar 06 17:09:18.639: SAPMODULE: SAPServerLoadLimits: Unable to locate the server name tlsrv052.swna.wdpr.disney.com from the list of ServerLoadLimits.

Fri Mar 06 17:09:18.639: SAPMODULE: SAPConnection: Enable to locate the MaxRowsPerLoad for the server(tlsrv052.swna.wdpr.disney.com) from the SAPServerLoadLimits. Using the default value 50000

...

Fri Mar 06 17:09:20.968: SAPMODULE: FIS: SAPHierarchy::get_members

...

Fri Mar 06 17:09:20.968: SAPMODULE: FIS: MDDataProviderBW.GetMembers(Cat=PSCPROJ3,Cube=PSCPROJ3/YFTPR_PSC_PSCPROJ3_Q006_ODBO,Dim=[0PROJECT],Hry[0PROJECT],Lvl=[0PROJECT].[LEVEL01],Mem=,OpCode=,PropFlag= )

Fri Mar 06 17:09:20.968: SAPMODULE: FIS: MDDataProviderBW.GetMembers(StartRow=0,EndRow=499)

...

Fri Mar 06 17:09:32.828: SAPMODULE: FIS: RFC function call MDDataProviderBW.GetMembers returned S

Fri Mar 06 17:09:32.828: SAPMODULE: FIS: Got 500 members

...

Fri Mar 06 17:09:33.250: SAPMODULE: FIS: SAPHierarchy::get_members

...

Fri Mar 06 17:09:33.250: SAPMODULE: FIS: MDDataProviderBW.GetMembers(Cat=PSCPROJ3,Cube=PSCPROJ3/YFTPR_PSC_PSCPROJ3_Q006_ODBO,Dim=[0PROJECT],Hry[0PROJECT],Lvl=[0PROJECT].[LEVEL01],Mem=,OpCode=,PropFlag= )

Fri Mar 06 17:09:33.250: SAPMODULE: FIS: MDDataProviderBW.GetMembers(StartRow=500,EndRow=50499)

..

Fri Mar 06 17:10:18.239: SAPMODULE: FIS: RFC function call MDDataProviderBW.GetMembers returned S

Fri Mar 06 17:10:18.239: SAPMODULE: FIS: Got 50000 members

In Designer, we have tried the object option "Delegate search", but it did not work.

So, here are the questions:

  • How come MDA_SAP asks for 500 and then ask for an additional 50,000 members? Is this limit configurable? Why does it not read the entire member set?

  • Should WebI not delegate the search to MDA_SAP which could then forward that search criterion to SAP via get_members?

  • Because users have access to different member sets, how does WebI cache these values and make sure that users can only see the members they have access to and all the members they have access to in BI?

Thanks in advance,

- Gabriel

Edited by: Gabriel De Lapparent on Mar 19, 2009 7:28 PM