I have a problem. While executing a query, BW is very slow and sometimes I get a time-out error. I have created the indexes, statistics and aggregates on the cube to improve the performance, but the report is very slow, and the cube has a huge volume of data of approximately 150m rows. I am retrieving the data from a third party so please let me know if there is any other way to improve the performance of the cube so that I can execute my report faster.
150m rows in an infocube is not considered that big in BW and should not cause any serious performance issues. Make sure the cube has been designed properly considering all the necessary performance aspects.
Dig Deeper on SAP Business Warehouse
An SAP user is looking to assess the hardware requirements for an SAP BW application and wants to know what the parameters are of sizing hardware for...
An SAP user is looking to change the values of a characteristic in an SAP InfoCube and wants to know if it's possible to use virtual InfoCubes to ...
Find out if a department running SAP R/3 4.7 needs an additional server to install SAP Business Information Warehouse (SAP BW).