Skip to Content
Former Member
Dec 13, 2006 at 04:05 PM

Design the cube


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!