3 Replies Latest reply: Mar 16, 2012 11:22 AM by j i RSS

    How to use a dimension of a straight table as a parameter of an expression

      Hello,

       

      I'm using a variable with parameters and I want that one of the parameter be the dimension of a straight table. So that the calculation is made depending on the value of the dimension. Each value of the dimension corresponds to a different field in my facts table. It's OK if I choose only one value in my dimension, but if I choose no values are several values, it doesn't work anymore.

       

      My variable is :

      V_Amount_Country

      Sum({1 <View = {"$2"},$CalendarId={"$3"}>} [$1])

       

      The dimension in the straight table is called PnlDim, and I call it through the parameter $1 in my expression :

      =$(V_Amount_Country($(=PnlDim),Actuals,20120100))

       

      Any idea ?