What is the optional size of the aggregates?

Answer Posted / annobw

It should have around 10-20% of the size of fact table;

for ex: if fact table contains 1 million rows the aggregate
should have less than 200,000 rows

Is This Answer Correct ?    3 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What do you mean by the term rollup in the sap bw?

631


how would you do the unloading non-cumulative cubes.

613


Is the user exit common for all data sources?

1556


I created process chain 1st day it taking 10 min after that 1st week it taking 1 hour after that next time it taking 1 day with a same loads what happen how can u reduce the time of loading

1675


What are the delta options available when load from flat file?

635






How we do the sd and mm configuration for bw?

645


What is the attributes only flag?

619


Where to check the log for warning messages appearing in activation of transfer rules?

605


What is the read mode in generic navigation block web item- read mode specifies

1702


In real world when do you recommend aggregate?

1983


what are the benefits of cubes?

663


Describe the new BW 3.x authorizations?

1683


What is the web download scheduler?

1579


How do you enter documents?

1628


What is the use of real-time infocube?

544