Skip to Content
author's profile photo
Former Member

Case Statement in OLAP Universe

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

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

1 Answer

  • Best Answer
    author's profile photo
    Former Member
    Posted on May 04, 2011 at 09:44 AM

    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

    Add comment
    10|10000 characters needed characters exceeded