Home Forums SQL Server 2005 Business Intelligence How To create Two hierarchies for two separate columns in fact which refers to single dimension RE: How To create Two hierarchies for two separate columns in fact which refers to single dimension

  • 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