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!