Add Measures from different Dimensions

  • I have a Cube with 2 Dimensions and 2 Measures.

    [Code]

    CUBE(FactTable F)

    DIMENSION A(DimensionTable A)

    DIMENSION B(DimensionTable B Based on some sql)

    MEASURE A(FactTable Column based on some conditions from DimensionTable A)

    MEASURE B(FactTable Column based on some conditions from DimensionTable B)

    [/code]

    Columns C1, C2, C3 are common in Dimension Tables A and B.

    Is it possible to add up these 2 measures i.e., Measure A and Measure B.

    Thanks,

    Raj.

  • If you only have one fact table and both dimensions are related to the fact table then I see no reason why you couldn't do this. Sounds like you have some specific scenarios and conditions on how you want this to work, so I would recommend exploring SCOPE statements to make this to work the way you want it. If I recall the Adventure Works DW SSAS project on codeplex has some examples of SCOPE statements if you are not familiar with them. Just setup the SCOPE statements and/or calculations in the cube.

    ----------------------------------------------------------------------------------------
    Dan English - http://denglishbi.wordpress.com

  • Dan English,

    Thanks for your reply.

    Can you please post the links to the examples of SCOPE statement.

    Thanks,

    Raj.

  • Take a look at the BOL material http://msdn.microsoft.com/library/ms145989.aspx and you can take a look at downloading the Analysis Service sample database, Adventure Works, here http://www.codeplex.com/SqlServerSamples. They have some examples in there also and I am sure you can find plenty more online.

    ----------------------------------------------------------------------------------------
    Dan English - http://denglishbi.wordpress.com

Viewing 4 posts - 1 through 3 (of 3 total)

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