Conditional format in Direct Database Request in OBIEE 12c — Oracle Analytics

Oracle Analytics Cloud and Server

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Conditional format in Direct Database Request in OBIEE 12c

Received Response
61
Views
3
Comments
s234
s234 Rank 3 - Community Apprentice

Hi,

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

Regards,

Sudhakar

Answers

  • Pedro F
    Pedro F Rank 6 - Analytics Lead

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

  • Robert Angel
    Robert Angel Rank 8 - Analytics Strategist

    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
    Joel Rank 8 - Analytics Strategist

    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:

    pastedImage_0.png

    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.