why u go for aggregate? tell me one example?
Answers were Sorted based on User's Feedback
Answer / vinod
to improve performence aggregates r used the main use of
aggregates are
1) when infoobject data is used repeatedley
2) when master data do not change much
3) to improve the performance in reporting
4) aggregates acts like indexes
demerites :-
1) denormilisation of data in cube and aggregates
if u cube contains infoobject object country we can create
fixed aggregate on country
Is This Answer Correct ? | 7 Yes | 0 No |
Answer / ravikumar
To optimize the performance of reporting and analysis
processes.
Example:
If the client want to see the report of particular customers
(some 8) daily.
In this scenario instead of creating variables we can go
with aggrecates.
Is This Answer Correct ? | 6 Yes | 0 No |
Answer / arun
also save space and speed of accessing data because of
indexing
Is This Answer Correct ? | 3 Yes | 0 No |
Answer / govardhan
INSTEAD OF SEARCHING WHOLE DATA(WHAT EVER THE MILLIONS OF RECORDS) FROM CUBE FOR CERTAIN DATA ACCORDING TO THE QUERY REQUIREMENT WE GO FOR AGGREGATES.
AND IT'S REDUCE THE NUMBER OF RECORDS WHICH USE AS A SAVING DATA WAREHOUSE SPACE.
AGGREGATES WOULD BE CREATED ACCORDING TO THE FREQUENTLY USING QUERIES.
AND DIS ADVANTAGE OF AGGREGATES :
IF WE MAINTAIN THE AGGREGATES WE WOULD HAVE THE SAME DATA ALSO IN INFO CUBE AS WELL AS AGGREGATES ITS LEADS TO MUCH OCCUPY THE DATABASE SPACE.
Is This Answer Correct ? | 3 Yes | 0 No |
How would you change the default template?
Why CO-PA is a generic extraction and not a business content extraction?
WHAT IS PBJECT DOCUMENTATION? WHERE YOU CAN DO IT? WHAT IS THE USE OF THAT?
How do you activate personalization for bex?
How do you transform OH data?
Hi frnds , this is kondaiah iam new to SAP kindly can u people help me some basic material for sap-BW/BI Thanks in advance. BestRegards Kondu
Give us sample third party ETL tools supported by SAP?
I have 2 cubes,1 is sales cube 2 is billing cube.I've loaded data to 2 cubes separately.Now i want to load sales data to Billing Cube.How can i Load?
How can a cube have partitioned for which the data already exists?
What is the difference between LIS to LO in init of delta and delta?
1 Answers Advent Global Solutions,
What makes it more advanced than sap business warehouse (sap bw) 7.5?
What is the maximum number of key fields that you can have in an ods object?