Range selection in MDX query

[BGarcia]

Hello to everyone,

Is there anyway to develop a MDX query, using a sap variable, and use the range interval at this query.

For example, at BEX I can define a variable to accept year/month from xxx to yyy.

How can I do this in MDX? I'm only able to execute only with a single value (like in this simple example). Is the other way possible?

SELECT {[Measures].[3ZFR2WD9UJZZZBUBZNRGDIQ9X]}

ON COLUMNS,

NON EMPTY

{[0SALESEMPLY].LEVELS(01).MEMBERS}

ON ROWS

FROM [YSD_M05/YSD_M05_Q0040]

SAP VARIABLES

[YKC_MESN] INCLUDING [0CALMONTH].[200503]

Thanks and best regards from a cloudy day at Lisbon

Bruno

[BGarcia · Accepted solution]

Hello,

Ok... I just figured it out. We must use the ":" operator.

The query must be like this:

SELECT {[Measures].[3ZFR2WD9UJZZZBUBZNRGDIQ9X]}

ON COLUMNS,

NON EMPTY

{[0SALESEMPLY].LEVELS(01).MEMBERS}

ON ROWS

FROM [YSD_M05/YSD_M05_Q0040]

SAP VARIABLES

[YKC_MESN] INCLUDING [0CALMONTH].[200503]:[0CALMONTH].[200504]

Best Regards

Bruno