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

Answer Posted / vivek

you can check it from RSDDSTAT_OLAP table that which query
is being used mostly, and wht is the performance on that
basis you will create the aggregates on the cubes.
Aggregates are the small cubes through which the data
extraction is faster

Is This Answer Correct ?    12 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

In compression level all requests are becoming zero which data is compressing tell me detail

1184


What are the other tables created for master data?

1509


What is the dimension in bw?

517


what is compatable and incompaltable bojects? plz ssend to my mail noorsoft143@gmail.com i need a declinations and example thanks in advance..............

1792


Give an example of the content key figure OTOTALSTCK (quantity total stock)?

1730






What is the difference between ods and info-cubes?

494


What is the process chain and when you can use the same in the data warehouse?

487


Without taking downtime how to fill logistics extractors (2lis types)

1227


What are the data sources supported?

1713


What is extended star schema? Which of the tables are inside and outside cube in an extended star schema?

687


What are different types on virtual providers?

531


what is the component?

1707


What are the minimum no of dimensions in info cube?

515


What are the naming conventions for aggregates created from statistics?

1398


How would you change the default template?

1546