3 Replies Latest reply: Nov 13, 2012 8:55 AM by MickeyGreen RSS

    Substring on substitution variable in MDX query

      I'm trying to write an MDX query that gets one of the member names from part of a substitution variable, but I keep getting an error.

      The variable name is: LastFcst
      The variable value is: FY2013-F4
      The piece I want to pull is the fiscal year only (first 6 characters), or FY2013 (which is actually the alias name for the member FY13)
      The dimension in question is: Years

      According to the Oracle documentation, I'd expect this to work


      But I get an error: Unknown member FY2013-F4 used in query.

      So it seems to be picking up the entire variable value and not performing the substring function properly.

      Any ideas about how to make this work?