Interested to Buy Any Domain ? << Click Here >> for more details...
why u go for aggregate? tell me one example?
- 5 Answers
- 17472 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 can you navigate to see the error idocs?
what are the info cube developed in a sap project?name them and what is the requirement?
How do you transform open hub data?
What is the use of db connection in sap bw data acquisition?
How do you add an entry in the monitor log from the update rules?
What is ud connect in sap bw system? How does it allow reporting in bi system?
Give an example for this URL command?
Explain 0record mode?
What is sap bw/bi?
How would you convert an info package group into a process chain?
What are the combined tests?
What is write optimized dso?
Describe transfer rules?
Explain return tables.
What are extractors? Name a few which are used commonly in the sap bw?
