on 05-04-2011 9:13 AM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
83 | |
24 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.