Best Practice - Universe to BW Query? Many small or Few Large?

[Former Member]

Wanted to confirm few things from SAP Best practices and architecture of SAP BW and BO integration.

1. As per best practices document "the WebI query panel definition is what defines the "MicroCube" and thus the MDX query which is executed on SAP BW". It means that the actual query performance / query execution time / memory consumption is directly related to number of objects dragged into WebI query panel not in SAP BW query. if this is true then what is the reason not to have all infoObjects / keyfigures of InfoCube in a single sap bw query?

2. I found another Best practices document which says that "DO NOT build one query per infoProvider because elements can add processing time even though you are not using them into the Web Intelligence Report"

In one statement it says that the WebI Query panel definition is what MDX query going to execut on SAP BW and in other statement it says that the elements in SAP BW query can add processing time even though we are not using them in Web Intelligence Report.

Can I get some clarification on this?

Thanks

[IngoH · Accepted solution]

Hi,

1. As per best practices document "the WebI query panel definition is what defines the "MicroCube" and thus the MDX query which is executed on SAP BW". It means that the actual query performance / query execution time / memory consumption is directly related to number of objects dragged into WebI query panel not in SAP BW query. if this is true then what is the reason not to have all infoObjects / keyfigures of InfoCube in a single sap bw query?

>> Having all InfoObjects in the Web Intelligence query panel would mean you including all InfoObjects for data retrieval which will most likely be not really what you want in the report

2. I found another Best practices document which says that "DO NOT build one query per infoProvider because elements can add processing time even though you are not using them into the Web Intelligence Report"

>> correct - this is now the BW query. If you create a single BW query and create reports on top of these queries. As an example if you have a BW query with 50 characteristics and a report that uses 10 characteristics then the execution of the overall workflow can be slower compared to a situation where you BW query would only include 20 characteristics.

Ingo