Post reply

SSAS - Build a measure that ignores one of the dimensions

  • November 16, 2011 at 3:01 pm

    #247937

    Hi!

    I need to model a measure in a SSAS Cube, where i can be able to ignore one of its dimensions.

    I mean:

    FactTable

    ------

    IdCountry

    IdProduct

    IdDate

    Amount

    Measures

    --------

    M1: Sum of amount (simply sum) -> that's ok

    M2: I need to count how many Country-Product tuples exists, ignoring the Date dimension. -> it's missing

    I have tried the SCOPE sentence but i haven't could done, i have tried the dimensions usage, and MeasureExpression but none of them has worked... 🙁

    Any ideas? is it clear enough? Thanks!

  • November 17, 2011 at 1:49 pm

    #1409521

    Dear,

    I'm not sure what you mean with 'ignoring the date dimension'.

    Possibility 1 :

    You can create a distinct count measure on the combination of the country product combination. For doing that, you could add a concatenation of the country and product ID's to your data source view of the underlying fact table (supposing you are using a view for the fact ).

    Possibility 2 :

    You can create another Fact : 'Country Product Combination', consisting of the distinct combinations of countries and products. On that measuregroup you can use a simple count measure.

    Franky L.

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

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