Skip to Content

Range selection in MDX query

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

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Best Answer
    Posted on Oct 18, 2005 at 05:42 PM

    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

    Add a comment
    10|10000 characters needed characters exceeded