cancel
Showing results for 
Search instead for 
Did you mean: 

BW OLAP Universe - If/Then/Else Statement

Former Member
0 Kudos

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>

Accepted Solutions (0)

Answers (1)

Answers (1)

MariannevL
Advisor
Advisor
0 Kudos

Hi Andrew,

Looking at your statement I get the feeling you want this as a dimension/characteristic.

Since an expression has to be numeric and a characteristic in BW cannot be numeric, this will not work.

Only measures/keyfigures are possible.

The direction from SAP is to push any modeling to the BW query or even BW itself.

Hope this helps,

Marianne