Modelling Dimension relations over time
Page 1 of 1
Modelling Dimension relations over time
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
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
![-](https://2img.net/i/empty.gif)
» Combined Date Time dimension vs. Separate Day and Time dimensions and timezones
» Time dimension design for cross time zone and custom calendar warehouse, 1min granularity
» Time Dimension, NULLs and Time datatype
» Problem with Single Surrogate Keys in the AS-IS/Point in Time Dimensional Modelling
» Modelling many to many relationships in a dimension
» Time dimension design for cross time zone and custom calendar warehouse, 1min granularity
» Time Dimension, NULLs and Time datatype
» Problem with Single Surrogate Keys in the AS-IS/Point in Time Dimensional Modelling
» Modelling many to many relationships in a dimension
Page 1 of 1
Permissions in this forum:
You cannot reply to topics in this forum
|
|