April 20, 2008 at 7:02 pm
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
April 21, 2008 at 5:52 am
You could wrap your calculation around another iif condition setting your yes/no field equal to NULL based on another measure being NULL. The NONEMPTY will then filter these results out. There maybe a more elagant way to handle, but this down and dirty has gotten me by before.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply