3 Replies Latest reply on Sep 26, 2016 8:38 AM by Andrew Watson

    assigning a value to a dimension to use in filter

    Yunus Gittham



      I have a dimension called Type which will have two values - Strategy or Action

      I have a calculated field which is as follows

      vStrategyorAction = IF calculated_field = 1 THEN 'Strategy' ELSE 'Action' END


      I want to assign the value of vStrategyorAction to the dimension Type and use it as a filter.

      If I try to do that, I get an error because the calculated_field which I am using contains LOD and Aggregation calculations.

      As simple as a calculated variable holding gthe following

      Type = vStrategyorAction

      and then use it as a filter.


      How do i do that?