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.
This Content Component encountered an error
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 ...continue reading
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...continue reading
Find out if a department running SAP R/3 4.7 needs an additional server to install SAP Business Information Warehouse (SAP BW).continue reading
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.