Skip to Content
0
Former Member
Nov 09, 2011 at 06:18 PM

BW OLAP Universe - If/Then/Else Statement

24 Views

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>