Problem solve Get help with specific problems with your technologies, process and projects.

Slow BW reporting with 150m rows infocube

Slow query reports can be the result of an improper infocube. FInd out if your infocube is too big here.

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

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.