how do u deceided to go create Aggregates for cube. what
purpose u want to create aggregates?

Answer Posted / hari priya

When we access the data frequently for reporting and when
the data is in huge quantity, we face delayed data retrival
problem.
To overcome this problem we can go for aggregates.

This improves the query performance.

Is This Answer Correct ?    24 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

I have 80 queries which query is taking so much time how can you solve it

1247


What is the use ':' as an authorization value?

521


When you compressed multiple requests, how would you know which had ?marker update? enabled or not?

1367


What is the use of infocube in the bw system?

510


Give the step by step approach to set up LIS?

1605






You want to see the error idocs. Tell the navigation you would use.

475


What is the licensing requirement you should be aware of?

1549


What is SAP exit?

1647


what is meant by safety upper limit and safety lower limit in all the deltas tell me one by one for time stamp, calender day and numberic pointer?

1139


I have 3 cubes for that I created multiprovider and I created a report for that but I didn’t get data in that report what happen?

2441


What are the 3 sap defined dimensions?

547


Please tell what are the tables we can use in FISL and COPA in real time.. Explain clearly?

1840


how would you do the unloading non-cumulative cubes.

512


You have 10 cubes for which you created multiprovider but you want data only for one cube. What will you do?

529


What do you understand by start and update routine?

548