Condtional (If...Then...Else) Object in a Universe

[MJRBIM]

Can you create a condtional (If...Then...Else) Object in the Universe to allow for PROMPTING...?

I have a condtional (If...Then...Else) field that I created as a variable in a DeskI report which is fine for display purposes - but now I want to be able to use that same condition as a PROMPT on the Query.

If I can't create the condtional (If...Then...Else) Object in the Universe, am I stuck with having to create it as a new field on the underlying Oracle view then pulling that orcale field into the Universe...?

Thanks in advance!

 

[blom0344]

When working with universes you're dealing directly with the native SQL of the database. If..then..else constructs are not directly supported.
All major RDBMS support the CASE construct which has the same effect. (Oracle did have it's own solution using DECODE).
In general:

CASE 
WHEN
<<condition1>>
THEN <<expression1>>
WHEN
<<condition2>>
THEN <<expression2>>
WHEN
<<condition3>>
THEN <<expression3>>
...
...
...
ELSE <<other option>>
END

Ties Blom

 

[MJRBIM]

Thanks!