Post reply

Indicator Dimension Attribute

  • November 28, 2017 at 8:47 am

    #326522

    New to SSAS but I have a user who is asking for an indicator field be added to our Cube.
    The cube has a dimension called Customer. When Customer Type = New 
    AND
    when Dimension Product Type = Clothes
    Then this new column would be 1 otherwise 0.

    So I need to look to two separate dimensions and evaluate each of their attributes for a condition.

    Is this possible?

  • November 28, 2017 at 9:18 am

    #1969739

    It's not impossible, but the question is what the value of that indicator will be when you're looking at more than one customer type or more than one product type? If you can answer that question, your calculated measure be developed to take that into account and display the correct value.

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

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