creating a new object (measure) with IIF function on BW Olap universe and getting a mdx error

[Former Member]

hello

i have a universe based on a BEX query

i want to create a new object (a measure) with the IIF(,,) function

i created the following select:

<EXPRESSION>

IIF ([0STKEYFIG].currentmember.properties("[20STKEYFIG]") = "0304",1,0)

</EXPRESSION>

And I get an mdx error when trying to use it in a webi.  This is an old UNV.  Any help would be appreciated. 

Error:

Database error: Error in MDDataSetBW.GetCellData.  Invalid MDX command with <usrdf_property>.VALUE. (IES 10901) (WIS 10901)

[Former Member · Accepted solution]

Were you able to parse it at universe layer?

Did you try testing the MDX expression written on SAP Tcode MDXTEST to verify if its valid syntax.

Try using below if your key 20STKEYFIG is of number type.

IIF ([0STKEYFIG].currentmember.properties([20STKEYFIG]) = 0304,1,0)

Thanks

Mallik