Showing results for 
Search instead for 
Did you mean: 

InfoCube performance.

0 Kudos

dear all,

i have problem querying for large amount of datas from a cube via a web interface. before the results can be output to me, i get a timeout error.

I need suggestions from you experts on how to optimize my cube so that even querying for datas ranging from 2 years would not be a problem.

What are the things i can do on my side for infocube performance?

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

the first thing you can do is build aggrragrte on the cube.according the query

cretae partition for cube.

maintain indexes

pls assig points if helpful.

Former Member
0 Kudos


These are the general performance tuning measures:

1. Create and maintain indexes on the cube.

2. Create aggregates.

3. You can use the RSRT tool to analyze further.

4. Compress the cube.

5. Maintain OLAP Cache.

Check this document on Performance tuning:

[original link is broken]

Check these weblogs:



Also check these OSS Note

557870 'FAQ BW Query Performance'

and 567746 'Composite note BW 3.x performance Query and Web'.