Recent PostsRecent Posts Popular TopicsPopular Topics
 Home Search Members Calendar Who's On

 AdventureWorksDW-No Role Playing Dimensions? Rate Topic Display Mode Topic Options
Author
 Message
 Posted Tuesday, April 1, 2014 1:09 PM
 SSC Veteran Group: General Forum Members Last Login: Tuesday, November 18, 2014 7:26 AM Points: 288, Visits: 1,174
I'm trying to read up on SSAS and going through some tutorials.
They show the DimDate and FactResellerSales.

What I don't understand is how Fact can have 3 date dimensions all to the same DimDate table.

Kimball (and what I though was common sense at least in my head) says you need a role playing dimension.

I assume I am missing something here?

Post Attachments
 RolePlayingDim.png (27 views, 9.81 KB)
Post #1557172
 Posted Tuesday, April 1, 2014 2:40 PM This worked for the OP
 SSChampion Group: General Forum Members Last Login: Today @ 7:58 AM Points: 13,529, Visits: 11,326
 Those are the role playing dimensions.You have the order date, the ship date and the due date.This is realized by joining 3 times to the same date dimension, but each time using a different date column from the fact table.OrderDateKey -- DateKeyShipDateKey -- DateKeyDueDateKey -- DateKeyYou could use 3 different views on top of the date dimension, but the result is the same.When you create the cube, you add the date dimension three times as a cube dimension and there you can rename them as well. How to post forum questions.Need an answer? No, you need a question.What’s the deal with Excel & SSIS?Member of LinkedIn. My blog at LessThanDot. MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1557208
 Posted Tuesday, April 1, 2014 4:44 PM
 SSC Veteran Group: General Forum Members Last Login: Tuesday, November 18, 2014 7:26 AM Points: 288, Visits: 1,174
 OF COURSE, I forgot about the CUBE and it being an abstraction layer.So when it generates itself it will just know that it joins to the Date dimension and the cube will populate up as needed.Thanks!
Post #1557277

 Permissions