Start and Finish dates and role-playing dimensions
Page 1 of 1 • Share •
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.

ngalemmo- Posts: 1729
Join date: 2009-05-15
Location: Los Angeles

Similar topics» Who's Playing
» 5 Best Approaches to Start A New Business With a Shoestring Budget.
» Start and Finish dates and role-playing dimensions
» Role playing Dimensions: When is it appropriate?
» Role-playing dimensions
» 5 Best Approaches to Start A New Business With a Shoestring Budget.
» Start and Finish dates and role-playing dimensions
» Role playing Dimensions: When is it appropriate?
» Role-playing dimensions
Page 1 of 1
Permissions in this forum:
You cannot reply to topics in this forum