3 Replies Latest reply: Apr 9, 2014 10:23 PM by Ramkumar Ramagopalan RSS

    Alternate state in calculated dimension - Set analysis



      I have two alternate states, one is <inherited> the other one is <Healthy_Food_State>...


      I have one chart table that it is in the inherited stated, but I want one dimension to be in get the possible selections in the Healthy_Food_State, and then they match...


      Can you guys say to me a possible expression?


      I am trying something like:


      =only({$<item_substitute= ::[Healthy_Food_State]>}item_substitute)


      I do suck at those kind of expressions.


      Can you guys tell me a possible solution for that?