Question:
Hello Gurus,
It is advisable in BW that , Dimension table size should be less than of Fact table 10 %. But plz can any one tell me how can i measure the dim table.? how can i check the table size for Dim Table and comapre with fact.
Shld i compare both table through number of records ?
may be this is very simple question...
immediate reply will be appriciated..
thnx in advance
Mahavir
Answer:
use transaction rsrv...
_________________
Gr,
M.
Answer:
Hi,
in addition to RSRV, there is a very good program you can run via SE38: SAP_INFOCUBE_DESIGNS where you'll get the size of the dimension tables (number of records) and a comparizon with the fact tables for each info cube.
Make sure you have run statistics first.
Kind regards
/martin