Wednesday, August 22, 2012

SAP-BI@Aggregates

Aggregates:-
-----------
* Smaller Cube built on a Info Cube to Improve the Query pderformance.
* If we dont rollup the request it will not be available for reporting.
* Thumb rule for Aggregate - DB time is greater than 30% of the total time and Aggregation Ration > 10.
* Activate / Deactivate
* Switch on / off
* Delete
* nAVIGATIONAL aTTRIBUTE CAN BE USED IN BUIDING THE AGGREGATE.
* Attribute change run
* Aggregate hierachy levels
Limitation:-
----------
1) It stores data redundently.



Labels: , , , , , , ,

0 Comments:

Post a Comment

Subscribe to Post Comments [Atom]

<< Home