Answer / anand

Aggregates are the Small Cubes.We create Aggregates only on
Cubes.We use this Aggregates to Improve the Reporting
Performence.Inspite of fetching the Whole data from Cube we
can selectively Fetches the data with aggregates.

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

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.

Answer / arun

also save space and speed of accessing data because of
indexing

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.

what are the reports used from business content in sap bw project?name them and what was the requirement?

0 Answers   Satyam,

what is a multiprovider? what are the uses and in which case supposed to be use? difference between bi7.0/bw3.5?

0 Answers  

What are processing commands?

0 Answers  

R/3 extraction failed - recovery procedure? R/3 extraction is running from past 2 years. Suddenly it failed since 5 days and again today it is running fine. But how i do get data loaded to cube for failed loads? What are the procedures that can be followed?

0 Answers   Cap Gemini,

What is ASAP?

4 Answers  

Do you have any idea how to improve the performance of the bw?

0 Answers  

Hi, I need to know anything and everything abt datamarts and thier behaviours. Please suggest any links/whitepapers/articles which explain datamarts from scratch. This is required for my admin job at hand. Appreciate your help :)

0 Answers  

How does the time dependency works for bw objects ?

0 Answers  

what is 0unit of meassure?

3 Answers   HP,

tell me infoobject errors?

1 Answers   CS,

Name two types of multi providers and compare them to each other?

0 Answers  

You want to convert bex query global structure to local structure. How would you do that?

0 Answers