Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Performance Factors

Hi All,

Please answer for the below questions.

Todesign a CUBE wht performance factors that we need to consider(KPI'S)?

And also let me know in which areas that we need to concenntrate on KPI and how?

Regards

Ramakanth.

replied

Hi Ramakanth,

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:

Business Intelligence Performance Tuning

Check these weblogs:

Query Creation Checklist

Query Optimization

Also check these OSS Note

557870 'FAQ BW Query Performance'

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

From: InfoCube performance.

Take also a look:

InfoCube Performance

http://help.sap.com/saphelp_nw04s/helpdata/en/80/1a6473e07211d2acb80000e829fbfe/frameset.htm

Regards

Andreas

0 View this answer in context

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question