Start and Finish dates and role-playing dimensions
2 posters
Page 1 of 1
Start and Finish dates and role-playing dimensions
I have a bunch of date dimensions, such as BaselineDate, TargetDate, etc... I created role-playing views over my Date dimension for each of the different types of dates.
But each fact row will have a StartDateID and a FinishDateID for each (like BaselineStartDateID and BaselineFinishDateID), which leaves me wondering how to join to the fact table. I think I'm just going to join both to the same dimension (BaselineDate, for instance). But that doesn't sound right. Is that the right way to go?
Thanks for your advice.
But each fact row will have a StartDateID and a FinishDateID for each (like BaselineStartDateID and BaselineFinishDateID), which leaves me wondering how to join to the fact table. I think I'm just going to join both to the same dimension (BaselineDate, for instance). But that doesn't sound right. Is that the right way to go?
Thanks for your advice.
cube.head- Posts : 6
Join date : 2009-08-03
Re: Start and Finish dates and role-playing dimensions
Each FK should reference a view of or an alias of the date dimension table. Personally, I don't bother creating views as most BI tools provide an easy way to alias tables with multiple rolebased FK references.
Similar topics
» Role Playing dimensions
» Role-playing dimensions
» Role-playing dimensions
» Role playing Dimensions: When is it appropriate?
» How to role playing dimensions in PostgreSQL
» Role-playing dimensions
» Role-playing dimensions
» Role playing Dimensions: When is it appropriate?
» How to role playing dimensions in PostgreSQL
Page 1 of 1
Permissions in this forum:
You cannot reply to topics in this forum