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