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?
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:
Check these weblogs:
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: