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.