Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

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

SQL Direct REport Conditional formatting on columns - OBIEE 11.1.1.7.151020

Received Response
11
Views
13
Comments
2»

Answers

  • Morel Cornnery
    Morel Cornnery Rank 3 - Community Apprentice

    Thanks for the clarification Christian, So let me try to use  HTML in my sql statement .

  • Joel
    Joel Rank 8 - Analytics Strategist

    So you'd have to build your SQL statement for your DDR report. An example with pseudo code is:

    DDR screenshot.PNG

    SELECT

    CASE WHEN column1 = 'ABC' THEN '<FONT COLOR="#00FF00">' || column1 || '</FONT>' ... END column1name,

    CASE WHEN column2 = 'ABC' THEN '<FONT COLOR="#00FF00">' || column2 || '</FONT>' ... END column2name

    FROM tablename

  • Morel Cornnery
    Morel Cornnery Rank 3 - Community Apprentice

    Thank you to all !  works now Just happy to have advice from  oracle's Experts .

    @Christian Berg Now I can close the thread as advised .