Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

AdventureWorksDW-No Role Playing Dimensions? Expand / Collapse
Author
Message
Posted Tuesday, April 1, 2014 1:09 PM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Yesterday @ 8:11 AM
Points: 284, Visits: 1,130
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 Answer marked as solution


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 1:05 AM
Points: 13,730, Visits: 10,683
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 -- DateKey
ShipDateKey -- DateKey
DueDateKey -- DateKey

You 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

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Yesterday @ 8:11 AM
Points: 284, Visits: 1,130
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
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse