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