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

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

1175


what is offset? Without offset we create queries?

1101


What is the other flags?

1710


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

538


What are conversion routines for units and currencies in the update rule?

553






what is the component?

1698


What is an infopackage?

556


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

5996


please tell me the most frequently asked interview questions about sap BW with answers

4541


We have standard info cubes given in sap why you created zinfo cubes can u tell me the business scenario

1074


What are the steps to do the configuring third party (bapi) tools.

487


What are the options for conditions for key figures?

1442


How would you measure the size of a infocube?

501


How to fetch the data from sap-r/3, sap-bw/bi to informatica system? what is step by step procedure? at what senario you retrieve the data from sap system to informatica or say dwh system? --

4515


What is a number range object?

1521