Conditional format in Direct Database Request in OBIEE 12c

s234

Hi,

Can we use conditional format in Direct Database request Obiee 12c.?

Regards,

Sudhakar

Pedro F

No, it's one of the limitations of DDR. See here

Robert Angel

Direct database requests are not supposed to form part of your wider end user experience - they are more meant for admin level queries, they do not leverage the wider benefits of using OBIEE.

If it becomes a regular business requirement then invest the time in modelling a fully formed OBIEE rpd based solution.

Joel

Let me start by agreeing that DDRs should be treated with caution and used sparingly to avoid security breaches as repository metadata layer is bypassed.

You can technically perform conditional formatting in a roundabout way but will need to do this with HTML markup. Screenshots below show how this can be done:

Finally, DDRs should be used by Admins and as tactical solutions until data model has been updated with the new data set and should not form part of your client solution for reasons stated above.