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

How To create Two hierarchies for two separate columns in fact which refers to single dimension Expand / Collapse
Author
Message
Posted Friday, November 30, 2012 2:41 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Thursday, September 19, 2013 2:22 PM
Points: 36, Visits: 283
Hi All,

I want to create Two hierarchies for two separate columns in fact which refers to single dimension.

e.g

I have SndCountryKey and Paycountry key in fact table that refers to single countryKey in Dimcountry

I want SendCountry as one hierarchy and Paycountry as another.

Thanks in Advance.
Post #1391561
Posted Wednesday, December 05, 2012 3:51 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 3:27 PM
Points: 12,185, Visits: 9,134
You'll need two dimensions in your cube. One SendCountry dimension (linked to the fact with the SndCountryKey) and one PayCountry dimension (linked to the fact table with the PayCountryKey)

This modelling concept is known as role-playing dimensions.

You can also create one general dimension and add the same dimension twice in the cube (so two cube dimensions) and change the keys used in the dimension usage tab.




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 #1392902
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse