Creating Values based on conditions

[Former Member]

I am using a universe based on a Bex Query. What i want to do is to create metrics based on the data retrived from the query with all the characterisitics.

e.g. if the Kyf is gt 10, then its "Class 1", if gt 20 "class 2" and so on.

The reason I am looking to do this at the Universe level is that I want adhoc report users to use standard definition.

Q: Is this possible to do this at Universe level? If yes, how? At present all i can get is if conditions and they result in giving integer values such as 1, 2 and so forth. How can I get text such as "Class 1", "Class 2 "?

Thanks in advance

[Former Member · Accepted solution]

Did you try CASE statement at the universe level ?

[Former Member]

Hi,

Unfortunately SAP MDX cannot return text but only numeric values.

So you cannot do this at universe level but try to this at the BEx query level.

Didier

[Former Member]

For those values 1,2 & so forth, Do you have text info??

YES, then you use them after THEN /ELSE.

I'm Back

[Former Member]

iif statement in BO returns interger value, not text.

My thought was to create a Detail Object containing text, but I am not sure as to how to write the MDX fot this

Thanks

NS