InfoCube performance.

[former_member199653]

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?

[Former Member]

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]

Hi,

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:

/people/prakash.darji/blog/2006/01/27/query-creation-checklist

/people/prakash.darji/blog/2006/01/26/query-optimization

Also check these OSS Note

557870 'FAQ BW Query Performance'

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

Bye

Dinesh