I'm trying to write an if/then/else statement similar to the one below for BW OLAP Universe....Please help with the syntax....
<EXPRESSION>
IIF([/CPMB/JKDCC2E].LEVEL01 IN ("D01","D02","D03") AND [/CPMB/JKD4N0F].LEVEL01 = "USD",1,
IIF([/CPMB/JKDCC2E].LEVEL01 IN ("D04","D05","D06") AND [/CPMB/JKD4N0F].LEVEL01 = "Local Currency",2,
IIF([/CPMB/JKDCC2E].LEVEL01 IN ("D07","D08","D09") AND [/CPMB/JKD4N0F].LEVEL01 = "Local Currency",3,4)))
</EXPRESSION>