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

  • 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.

  • 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.

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply