Oracle Analytics Publisher

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

Conditional font color setting is not working for pivot table based BIP in oracle fusion

Incorrect Answer
82
Views
5
Comments
Sanjoy Barnwal
Sanjoy Barnwal Rank 2 - Community Beginner
edited Jul 18, 2024 10:01AM in Oracle Analytics Publisher

Hi ,

I need to set the font color as red for negative measure values getting pivot table based BIP report.

I found the doc id 23A Known Issue related to conditional color coding formatting in pivot table. (Doc ID 2922143.1)

Is it due to the patch mentioned in this doc id.

Answers

  • Sumanth V -Oracle
    Sumanth V -Oracle Rank 8 - Analytics Strategist

    @User_CAMKT - Could you please confirm if you are using standalone BIP, Fusion BIP, or OBIEE/OAS with BIP? The document you mentioned is applicable for Fusion applications. Providing these details will help us assist you further and point you in the right direction. Thank you!

  • Sanjoy Barnwal
    Sanjoy Barnwal Rank 2 - Community Beginner
    edited Jul 18, 2024 11:45AM

    Hi @Sumanth V -Oracle,

    I am using oracle fusion BIP only.

    Thanks,

    Sanjoy

  • Sanjoy Barnwal
    Sanjoy Barnwal Rank 2 - Community Beginner


    I am using below in pivot table based BIP report

    <?format-number:./M1;'9999PT'?><?if:./M1<0?><?attribute@incontext:color;'red'?><?end if?>

    Font color is not changing to red for negative values although formatting to single bracket is working. But font color changing red color is working to normal BIP report.

  • Sanjoy Barnwal
    Sanjoy Barnwal Rank 2 - Community Beginner

    Does any one have idea, why font color change is not working in pivot table BI publisher report in fusion. #BIPUBLISHER #OraclefusionBI

  • Sanjoy Barnwal
    Sanjoy Barnwal Rank 2 - Community Beginner

    @Sumanth V -Oracle could you please help on it.