Skip to Content
0
Former Member
Jun 19, 2007 at 01:29 PM

Star Schema doubts?

17 Views

Exepert's,

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?