I have an MDX query returning information. The query uses NON EMPTY keyword to clear the rows which have no information for the user to see.
I need to add another column, which would contain only "YES" or "NO" string depending on the condition, such as when one measure member value is > 0 or <= 0.
If I add a WITH MEMBER [Measures].[YesNo] AS 'iif(condition, "YES","NO"), it sticks these YES or NO strings everywhere in the resulting set so that NON EMPTY does not work anymore.
What I need is to apply IIF statement only to the NON EMPTY rows, but not to the whole lot.
Could you please tell me if there is a way round this effect?
Valentin
M.Sc.IT, M.B.A, MCTS BI 2008, MCITP BI 2008, MCTS SQL Dev, CSM, CDVDM