"NOTEQUAL " IN MDX query

[Former Member]

Is there any way to give NOT in an MDX query instead of EQUAL

I want ZMARKET NOT EQUAL "#"

Please help

[edwin_harpino]

hi,

try create bex variable for zmarket and using exclude in mdx statement like

.. SAP VARIABLES [zvarmarket] EXCLUDING [ZMARKET].[#]

[edwin_harpino]

hi,

if # for empty, have you tried 'SELECT ... non empty [ZMARKET].members on row FROM ...' ?

[Former Member]

Hi ,

1)If it is a numeric value . you can give a condition ZMARKET > 1 .

2)If not, in the formulae node select -> Data Functions -> DELTA. DELTA(ZMARKET)

3)It give 1 value if its # else 0.

4)So give it in a another condition stating where the formulae not equal to 1 .

Hope this might help you

[Former Member]

It should be NE!

Hope it helps.

Regards