Skip to Content
0
Former Member
Aug 05, 2005 at 09:07 AM

Question on WHERE-statement in MDX

16 Views

Hi All,

i have a MDX like this

SELECT NON EMPTY {[Measures].[A_MBERT44]} ON AXIS(0),

NON EMPTY [A_MBERT00].[LEVEL01].MEMBERS ON ROWS

FROM $A_MBER93

I want to filter the shown values by the following parameters:

[Measures].[A_MBERT42]

[Measures].[A_MBERT43]

These two measures contain numbers with type "DEC". When I look at them in the mdxtest, I get values like "3,00" or "5,00" and so on.

I tried the following:

SELECT NON EMPTY {[Measures].[A_MBERT44]} ON AXIS(0),

NON EMPTY [A_MBERT00].[LEVEL01].MEMBERS ON ROWS

FROM $A_MBER93

WHERE ([Measures].[A_MBERT42].[4,00],

[Measures].[A_MBERT43][5,00])

This doesn't work because the system doesn't seem to accept the [4,00] and [5,00]. I tried it also with 4.00; 4,0; 4.0; .....

Thanks in advance for any help!

Markus