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:
IIF ([0STKEYFIG].currentmember.properties("[20STKEYFIG]") = "0304",1,0)
And I get an mdx error when trying to use it in a webi. This is an old UNV. Any help would be appreciated.
Database error: Error in MDDataSetBW.GetCellData. Invalid MDX command with <usrdf_property>.VALUE. (IES 10901) (WIS 10901)