Design the cube

[Former Member]

It's my first time to design a cube. Now I have few questions:

1. Key Figures like UOMs, Quantities, Unit Cost, Unit Price, etc. Should I put them all in one Fact table?

2. We are extracting data from other system, not R/3. There is a table has five fields combined as the primary keys. They are related to Sales orders. Should I put them in one dimension called Order Dimension?

I have hard time to figure out which field should become transactional data or Master Data. Do you have any document which can help me? <email ID removed>

Thank you so much!

[Former Member · Accepted solution]

Hi,

1. Key Figures are automatically assigned to the Fact table.

2.Depends on those characteristics that form the key - let's suppouse you have Order Id, Item Id, Sales Org, Sales Group and Sales Emp as primary keys. Then you can split them to two dims : Order/Document Details and Sales Org.

3. I will send you the modeling How to for BW - it will surely help.

Please assign points if useful,

Gili

[former_member188975]

Hi Qingbo,

There is only one fact table per cube, so yes, all the transactional KF will go to the fact table.

One other good modeling fact to keep in mind is to try and design smaller dimensions tables, and if you need a char which will have a large number of unique values, like Order Number, then assign it to a line item dimension.

http://help.sap.com/saphelp_nw04/helpdata/en/a7/d50f395fc8cb7fe10000000a11402f/content.htm

This is a very good doc if you have not gone through it earlier:

https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/docs/library/uuid/6ce7b0a4-0b01-0010-52ac-a6e...

Hope this helps...