cancel
Showing results for 
Search instead for 
Did you mean: 

Case Statement in OLAP Universe

Former Member
0 Kudos

HI

Can any one help me in rewriting the Expression in OLAP Universe

Case when [/MPR/RCHARREIN].[LEVEL01].[[2/MPR/RCHARREIN]].[Value] = "10" then "Property"

when [/MPR/RCHARREIN].[LEVEL01].[[2/MPR/RCHARREIN]].[Value] = "20" then "Marine"

when [/MPR/RCHARREIN].[LEVEL01].[[2/MPR/RCHARREIN]].[Value] = "30" then "Aviation"

else "Motor"

I have created a Universe on Bex Query, now i have to use this kind of expressions. i greatly thankful for your help

Regards

Siva

Accepted Solutions (1)

Accepted Solutions (1)

0 Kudos

You have to do this at report level or modify your data model. As far as I know it is not possible to do this dimension translation an SAP BW universe.

Regards,

Stratos

Former Member
0 Kudos

HI Stratos

Thank you so much for your reply, unfortunately i dont have any document in using the MDX Functions. So, i found through Internet on function IIF but it seems to be keyfigure expression.

I thought there should some thing for dimensions as well...

Former Member
0 Kudos

Unfortunately SAP BW can only return keyfigures, you'd need a virtual characteristic for this, see [this doc|http://www.sdn.sap.com/irj/scn/index?rid=/library/uuid/007c46ec-1185-2d10-da82-b9a994ef5809] as an example

Answers (0)