7 Replies Latest reply on Nov 18, 2017 4:16 PM by Steve Gesuale

    Help with calc based on parameter and dimension hierarchy

    Steve Gesuale



      I'm looking for some help with a calc.


      Region and Country dimensions are hierarchical. I’m trying to build a calc that will return the Region value based on the value of a country parameter. For example, if Italy is chosen via the parameter, I want Europe returned.


      Tried this but no luck…

      { INCLUDE : [Region] , ATTR(STR([Country Parameter])) }


      Thanks for any help!