Hi all, i use the sql RS 2008R2. And now want to do a calculated member with iif statement. But MDX says that my code is invalid. i don't understand why. I already try all possibilities I find on the net, same bug. Please help me! I am very desperated.. Here is my code. IIF([0GL_ACCOUNTINT].[LEVEL01].AllMembers.properties("MemberCaption" )=[0GL_ACCOUNTINT].[INT 1000000 0HIER_NODE], [Measures].[7W2ESQFWHRIX0QSCGCBR2L7ZR]- [Measures].[BV06E2UYWYCBMXDZOW104GHOB], 0) another variant: IIF([0GL_ACCOUNTINT].[LEVEL01].CurrentMember.name = "Meeting", [Measures].[7W2ESQFWHRIX0QSCGCBR2L7ZR]- [Measures].[BV06E2UYWYCBMXDZOW104GHOB], 0) another variant: IIF([0GL_ACCOUNTINT].[LEVEL01].CurrentMember.name = [0GL_ACCOUNTINT].[INT 1000000 0HIER_NODE], [Measures].[7W2ESQFWHRIX0QSCGCBR2L7ZR]- [Measures].[BV06E2UYWYCBMXDZOW104GHOB], 0) but all failed!! Thank for each idea!

Can you try IIF([0GL_ACCOUNTINT].[LEVEL01].CurrentMember.Member_Caption ="Meeting", [Measures].[7W2ESQFWHRIX0QSCGCBR2L7ZR]- [Measures].[BV06E2UYWYCBMXDZOW104GHOB], 0)Cheers, Jason P.S. : Please click the 'Mark as Answer' button if a post solves your problem! :)

hi, thank you for your anwer. Your idea don't work . RS tells me "Invalid MDX Commando by CurrentMember" Do you have another proposal?

Try the below change IIF([0GL_ACCOUNTINT].[LEVEL01].CurrentMember.Properties(‘Name’)="Meeting", [Measures].[7W2ESQFWHRIX0QSCGCBR2L7ZR]- [Measures].[BV06E2UYWYCBMXDZOW104GHOB], 0) I am assuming [0GL_ACCOUNTINT] is the dimension name and [LEVEL01] is the attribute name. The syntax is [Dimension].[Attribute].currentmember.properties('Name') Cheers, Jason P.S. : Please click the 'Mark as Answer' button if a post solves your problem! :)

i try and it fails also anyhow ("Invalid MDX Commando by CurrentMember"). I really don't understand but if i try with IIF([0GL_ACCOUNTINT].[LEVEL01].name ="Meeting", [Measures].[7W2ESQFWHRIX0QSCGCBR2L7ZR]- [Measures].[BV06E2UYWYCBMXDZOW104GHOB], 0) the result ist NULL values but the syntax is correct

can you write the entire MDX query instead of just the calculation?Cheers, Jason P.S. : Please click the 'Mark as Answer' button if a post solves your problem! :)

this is already the complete query. the calculated member name is AKValue. I am in query designer IIF([0GL_ACCOUNTINT].[LEVEL01].name ="Meeting", [Measures].[7W2ESQFWHRIX0QSCGCBR2L7ZR]- [Measures].[BV06E2UYWYCBMXDZOW104GHOB], 0) Thanks!

hello, has someone any idea about my bug??? Please i need help!! Newfon

Hi, Have you tried to do the calculation on the reporting services instead of in the MDX query, for example, right click the report mdx dataset and select "New a Calculated field" to create your own calculated field for usage. thanks, Jerry

Hi, this is exactly what i am trying to do. I am not on mdx query window. I am on the " Calculated a new field" window. the new field shall be a new measure thanks, Newfon