I currently have a query that looks like this:
SELECT
NON EMPTY ([Measures].[TOTAL]) ON 0,
NON EMPTY (([ENROLL DATE].[CALENDAR].[YEAR].["
+ Parameters!EnrollDate.Value +
"] * [DIM ENROLLMENT].[ENROLLMENT].[ENROLLMENT PROG].ALLMEMBERS)) ON 1
FROM (SELECT (([DIM ENROLLMENT].[ENROLLMENT].[TERMINATION REASON].[Still Enrolled])) ON 0 FROM [NapaCHI]);
The bold section comes from the parameters section where I manually specified the parameters with Label = 2006 and Value = 2006
. I have tried just about every acceptable syntax and read about every article about this and cannot seem to get it to work whether I define the values myself or use a separate MDX statement that selects distinct non-empty years and (NULL) for the aggregate.
Help please, it's driving me insane! Thanks.