SAP BW Aggregates

Former Member · ‎06-11-2007

Dear SAP Gurus,

I want to know the way of building Aggregates on Cubes on which the Multi provider is built by taking the 7 cubes into consideration.

How we can improve the Query performance of a Query which was fetching data from multiprovider built on 7 cubes?

Former Member · ‎06-11-2007

Hi,

Aggregates is to built, when queries on that cube frequently in use.

And the database parameters for that query exceeds the SAP specified values.

How to Tell if an Aggregate Will Help

Do the following Steps

Call query or InfoCube overview in technical content or ST03

&#56256;&#56452;Sort by mean overall time to find queries/InfoCubes with highestruntimes

Calculate the KPI ‘aggregation ratio’= number of records read from DB / number of records transferred

Check quota of database time to total runtime As a rule of thumb, an aggregate will be helpful if the query statistics show:

Summarization Ratio > 10Summarization Ratio > 10,I.e. 10 times more records are read than are displayed, AND

Percentage of DB time > 30%Percentage of DB time > 30%,I.e. the time spent on database is a substantial part of the whole query runtime

Go thorough following link

Presentation

If it helpful assign points

Regards

Rajanikanth Reddy

Former Member · ‎06-11-2007

1. Dont try to take any report if the data is in a single cube; even though the cube may be a part of the multi cube.

2. If you build aggregates on the basic cubes, and when the query is executed, the system will automatically use aggregates if required.

3. RSDDSTAT is the key table.

4. Explore other performance options like caching, RRI, etc.

Ravi Thothadri

How to do client copy in SAP BW after database con...