why u go for aggregate? tell me one example?
- 5 Answers
- 15187 Views
- Accenture, HP, TCS, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
You want to convert bex query global structure to local structure. How would you do that?
What is the use of multi-provider in the sap?
When you are using sap bi7.x, you can load the data to which component?
How do you activate personalization for bex?
What is the option of ?pause Automatic Refresh??
How does the time dependency works for bw objects ?
What is the source for FIAR extractor from R/3?
What are the minimum no of dimensions in info cube?
what is the difference between pdf and excel format after saving the report?
How many types of info sources are there? What are they?
What is extraction setup?
Do you have any idea how to improve the performance of the bw?
How do you check the alert monitor?
I have a process chain is running the infopackage get error don't process the error of that info package and then you can run the dependent variants is it possible?
Explain about ods?
