why u go for aggregate? tell me one example?

Categories >> Software >> ERP CRM >> SAP >> SAP BW (Business Warehouse)
Suggest New Category

Question Posted / rav

5 Answers
15951 Views
Accenture, HP, TCS, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

why u go for aggregate? tell me one example?..

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.

Is This Answer Correct ?

15 Yes

2 No

why u go for aggregate? tell me one example?..

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

Is This Answer Correct ?

7 Yes

0 No

why u go for aggregate? tell me one example?..

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.

Is This Answer Correct ?

6 Yes

0 No

why u go for aggregate? tell me one example?..

Answer / arun

also save space and speed of accessing data because of
indexing

Is This Answer Correct ?

3 Yes

0 No

why u go for aggregate? tell me one example?..

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.

Is This Answer Correct ?

3 Yes

0 No

Post New Answer

More SAP BW (Business Warehouse) Interview Questions

What is the procedure to implement structural authorization in BW?

0 Answers

what is structure in reporting?

0 Answers Rockwell, TCS,

What is replacement path?

2 Answers

What are the data sources that are supporting non cumulative and give some examples?