Dear all,
We are trying to write a dynamic filter statement for the columns of a slice. Everything works well when we hard-code the filter criteria like this:
VAL(LEFT([DPERIOD].CurrentMember.Name,2)) >= 10
When we try to use variables, the system throws an error message (The unique name [ReportVariables].[rv_SourcePeriod].[Text] could not be resolved)
VAL(LEFT([DPERIOD].CurrentMember.Name,2)) >= & ReportVariables.rv_SourcePeriod.Text
How can we use variables in custom MDX statements?
Thank you very much.
Best regards,
Malte
