Skip to Content
0
Oct 18, 2005 at 05:08 PM

Range selection in MDX query

428 Views

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