How Check the Performance of BW infocubes-----VVUREGENT

[Former Member]

Hi All

How to check the Performance of BW infocubes?

Please tell me the procedure...Thanks in advance!!!

Regards

[Former Member · Accepted solution]

If you mean cube definition,

Go to SE38

Run the program SAP_INFOCUBE_DESIGNS

It will shown dimension Vs Fact tables Size in percent

If you mean speed of queries on a cube as performance metric of cube,measure query runtime.

[Former Member]

Hi,

To collect the information about the Database time, OLAP Time, Front End time, No. of records selected /transfered etc in the following three ways:

1.By analysing the contents of table " RSDDSTAT"

2.By using T-codes ST03 or ST03N

3.By implimenting BW Statistics Business Content - you need to install, feed data and through ready made reports which for analysis.

You can go to T-Code DB20 which gives you all the performance related information like

Partitions

Databases

Schemas

Buffer Pools

Tablespaces etc

Hope this helps.

Regards,

Rahul.