Interested to Buy Any Domain ? << Click Here >> for more details...
why u go for aggregate? tell me one example?
- 5 Answers
- 17383 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
How will you debug errors with SAP GUI?
How would you change the default template?
wt is difference between user group and reference user group?
What is the purpose of sap bw/bi?
How will you change the default destination of open hub files?
What are the steps to create classes?
What is transactional ODS object?
When you are using sap bi7.x, you can load the data to which component?
What is partition of an infocube?
What are the advantages of new LO extraction?
How do you upload currency exchange from a flat file?
What is the procedure to create a data mart?
How the dimensions are optimized?
What are the template options?
What are the steps to do the converting from lis to lo extraction.
