5 Replies Latest reply: Aug 1, 2012 9:47 PM by Simon Saugier RSS

    Set Analysis variable with parameters?

      I am trying to make a set analysis variable that takes a parameter, so I can pass in any date I want.

      Like so:

      vDateSetAnalysisExpr = {$ <Year=, Month=, Week=, Date={'$1'}>}

      And then I would use it like so:

      sum($(vDateSetAnalysisExpr('1/1/2012')) Revenue)

       

      But I haven't been able to get it to work. If I use the same set analysis expression variable using a literal '1/1/2012' in the variable itself, it works just fine.

      Any thoughts on if this is possible, and if so how?

       

      Thanks,

       

           -Simon-