Anyone have any idea why this MDX would be failing

(iif([SIC Code].Currentmember.level.name = "(All)", "[LevelFlag].[Level
Flag].&[Z]", "[LevelFlag].[Level Flag].&[S]"),[Measures].[zContact])

The error that I keep getting is:
Unable to update the calculated member.
Formula error - syntax error - token is not valid: "(iif([SIC
Code].Currentmember.level.name = "(All)", "[LevelFlag].[Level
Flag].&[Z]", "[LevelFlag].[Level Flag].&[S]")^,^[Measures].[zContact])"

I broke it apart and the following versions of the statement work fine
separately:

iif([SIC Code].Currentmember.level.name = "(All)", "[LevelFlag].[Level
Flag].&[Z]", "[LevelFlag].[Level Flag].&[S]")

([LevelFlag].[Level Flag].&[S], [Measures].[zContact])

I also tried the statement as:

(iif([SIC Code].Currentmember.level.name = "(All)", [LevelFlag].[Level
Flag].&[Z], [LevelFlag].[Level Flag].&[S]),[Measures].[zContact])

Jason

iif() is returning a string, which then needs to be converted to the
corresponding dimension member:

"[LevelFlag].[LevelFlag].&[Z]",
"[LevelFlag].[Level Flag].&[S]")),
[Measures].[zContact])

- Deepak

Deepak Puri
Microsoft MVP - SQL Server

*** Sent via Developersdex http://www.developersdex.com ***

Thanks, that solved the problem.

Jason