How To create Two hierarchies for two separate columns in fact which refers to single dimension

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » Business Intelligence » How To create Two hierarchies for two...

How To create Two hierarchies for two separate columns in fact which refers to single dimension

Rate Topic

Display Mode

Topic Options

Author

Message

NIRANJANA1977

Posted Friday, November 30, 2012 2:41 PM

SSC Rookie

Group: General Forum Members
Last Login: Thursday, January 10, 2013 10:50 AM
Points: 36, Visits: 282

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

Koen Verbeeck

Posted Wednesday, December 05, 2012 3:51 AM

SSCrazy Eights

Group: General Forum Members
Last Login: Today @ 2:14 PM
Points: 9,370, Visits: 6,468

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 »

Permissions