Line Item Dimension

line item dimension:if the size of dim table is more than 30% of fact table---then make that dim as line item dimension////

dim tab--lot of data---longer read time

fact table---dim table----sid---mdata tables


u can selct it as line item dimension-----if i make any dim as line item dim--

if u want to make nay dim as line item dimensio----ther should be only one char in that dim

sales order dim---(sales doc no)--line item ---sales docno(sid)---directly sid is placed to fact table

fact table--sid---master data