Ask the Expert

Slow BW reporting with 150m rows infocube

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.

    Requires Free Membership to View

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 was first published in September 2006

There are Comments. Add yours.

 
TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
Sort by: OldestNewest

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to: