cancel
Showing results for 
Search instead for 
Did you mean: 

"NOTEQUAL " IN MDX query

Former Member
0 Kudos

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

I want ZMARKET NOT EQUAL "#"

Please help

Accepted Solutions (0)

Answers (3)

Answers (3)

0 Kudos

hi,

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

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

0 Kudos

hi,

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

Former Member
0 Kudos

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
0 Kudos

It should be NE!

Hope it helps.

Regards