I have cube ZSAL_ANA .I am having Two dimensions 1.Sales and 2.Customer.
Sales Region contains Sales Region and Sales Location.Customer Dimension contains Customer Type and Customer location.Ok
Now Correct me if I am wrong?
In Fact table ie BIC/FZSAL_ANA we will be having keyfigures and Dimension IDs ie for Sales and Customer.
Ok ,Now The Dimension Sales (BIC/DFZSAL_ANA51) Contains only Dim Ids and
also Sids ok./BIC/SZSAL_RGN is a SID for Sales Region and it contains SID and also Sales regions. ./BIC/SZSAL_LOC is a SID for Sales Location and it contains SID and Sales Locations.
similarly for Customer Dimension (BIC/DFZSAL_ANA52).
Now /BI0/SZCUST_TPE is a SID table for Customer type.
Similarly /BI0/SZCUST_LOC is a SID table for Customer Location.
Please correct me if I am wrong?