aggregate

[Former Member]

Hi

Ho to deactivate aggregate.

Thanks

[ravi_chandra3 · Accepted solution]

Hi

If u want to deactivate the aggregate then at the top most left side u will see the symbol like i and click that symbol,so automatically the aggregate will be deactivated .

Thanx & Regards,

RaviChandra

[former_member182343]

Hi,

Building Good Aggregates

Tips for Building (and Maintaining) Good Aggregates:

Relatively small compared to parent InfoCube

Try for summarization ratios of 10 or higher??Find good subsets of data (frequently accessed)

Build on some hierarchy levels, not all

Not too specific, not too general -should serve many different query navigations

Consider "component"aggregates??Should be frequently used and used recently (except basis aggregates)

Analysis Tools: Workload Monitor (ST03)

Scenario

Find out the queries with the worst performance and try to optimize them.

Useful Features

Expert Mode

BW System Load -->Analysis of table RSDDSTAT

Check following parameter values:

Check queries with highest runtimes and check where most time has been consumed

OLAP init

DB??OLAP

Frontend

Check for ratio of selected to transferred

Deactivate performance less aggregates based on above stratagy.

Regards,

rvc

[Former Member]

hi

To delete all the data and database tables of an aggregate, select the required aggregate and choose Deactivate button in the top.

or

use SAP_AGGREGATES_DEACTIVATE program