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

Why is one request falls, all the subsequent requests are turned to ?red? in an info provider?

1557


What are transfer rules?

544


How the mapping is done in bw?

555


How dashboard is created in sap bw?

534


what is the difference between pdf and excel format after saving the report?

6004






I have cube.for cube data coming from 3dso's.in one dso having special chars.in cube you got special char error.how u can resolve this?

1392


What are the proposal options available?

1947


what is offset? Without offset we create queries?

1113


What is the format of LO data sources?

1640


Explain about the dimension in the warehouse?

510


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

1226


Explain dash board?

525


What exactly do you know about the sap bw?

516


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

549


Can anyone send me the what the scenario's client given in the real time,I mean functionalspecs,reporting scenarios?

1682