how to create FK from fact table to role playing dimensions

[Omid Golban]

Good morning

I am creating our first cube in our relational data warehouse. We are just
learning SASS and will not be moving this to SASS for a while. We are
following the Kimball books for creating facts & dimensions.

Following Kimball's suggestion for role playing dimensions (example: Date):
Should I create a view for each of the date dimensions in the relational
database? i.e. Should I create views called
PolicySubmitDate
PolicyApproveDate
PolicyEffectiveDate
PolicyExpirationDate
... other date dimensions
How would I create a FK from our Policy fact table to each of these views?

Thank you,
Omid

[Todd C]

So you have a FACT table with several Date properties.

In the Data Source View, link each field to the ONE Date Dimension.

Then in the SSAS Dimension Usage tab, you would simple add the Date
Dimension several times over, and give it a pseudo-name.

In SSAS 2000 you would need to make multiple copies of the Date Dimension to
accomplish this but in 2005, you can simply re-use the Dimension.

FYI: The Kimbal books are good, but also check out Teo Lachev's book on
SSAS. It will take you to the next step.

HTH
--
Todd C
MCTS SQL Server 2005

Post by Omid Golban
Good morning
I am creating our first cube in our relational data warehouse. We are just
learning SASS and will not be moving this to SASS for a while. We are
following the Kimball books for creating facts & dimensions.
Should I create a view for each of the date dimensions in the relational
database? i.e. Should I create views called
PolicySubmitDate
PolicyApproveDate
PolicyEffectiveDate
PolicyExpirationDate
... other date dimensions
How would I create a FK from our Policy fact table to each of these views?
Thank you,
Omid