Start and Finish dates and role-playing dimensions

View previous topic View next topic Go down

Start and Finish dates and role-playing dimensions

Post  cube.head on Sun Jan 17, 2010 5:55 pm

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.

cube.head

Posts : 6
Join date : 2009-08-03

View user profile

Back to top Go down

Re: Start and Finish dates and role-playing dimensions

Post  ngalemmo on Mon Jan 18, 2010 4:34 am

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.
avatar
ngalemmo

Posts : 3000
Join date : 2009-05-15
Location : Los Angeles

View user profile http://aginity.com

Back to top Go down

View previous topic View next topic Back to top

- Similar topics

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