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.
-----------
* 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: Android, Big Data Analytical Skill, FREE SAP BW BI TRAINING, hot News India, IPL, SAP, SAP BI ABAP Course English India Jobs Career, SAP BW Powered by SAP HANA
posted by SB @ August 22, 2012
0 Comments
0 Comments:
Post a Comment
Subscribe to Post Comments [Atom]
<< Home