Interested to Buy Any Domain ? << Click Here >> for more details...
why u go for aggregate? tell me one example?
- 5 Answers
- 17814 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
What is translation key?
Does it have delta facility?
What is bp master data.
what are the extractions made in a sap bw project using lo cockpit extraction in mm and sd and fi?what is the requirement and name them?
What is a dashboard in sap bw and how it is created?
What is an exception cell?
What is SAP exit?
What is modelling?
Where do we use write optimized dso?
What is sap bw/bi? What is the purpose of sap bw/bi?
what is offset? Without offset we create queries?
How do you enter data in real-time infocubes?
Explain about cubes?
What are the settings for data transfer?
is it possible to avoid special characteristic in infocube level permanently?
