Kimball Forum
Would you like to react to this message? Create an account in a few clicks or log in to continue.

Modelling Dimension relations over time

Go down

Modelling Dimension relations over time Empty Modelling Dimension relations over time

Post  menon_manish Fri Jan 28, 2011 12:26 pm

Hi,

We are planning to model a star schema based data warehouse with the following challenges:
1- The fact table is dimensioned across sales rep postion (a logical designation), geography, product, sales and atime
2- The sales reps have different positions over time, work in different geogs and with different products
3- Each of the dimensions have a hierarchy (Sales Rep Name-> manager name etc.), position hierarchy (Sales rep position name -> manager position name etc.) and product and geography also

Given this, do we put the sales rep key in the fact table and capture the dimensional relations of sales rep with Geog, Prod etc using factless fact? Or do we put all the keys in the fact table and lose the ability to navigate dimensions solely but only through the fact

THanks
Manish

menon_manish

Posts : 1
Join date : 2011-01-28

Back to top Go down

Back to top

- Similar topics

 
Permissions in this forum:
You cannot reply to topics in this forum