You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register
Skip to content
  • Register
    • Get Started: AI Resources for Oracle Cloud HCM – Go Here

    Progress with Redwood: Redwood Resources for Oracle Cloud HCM -  Go Here

    Conditional formatting in Logical SQL OTBI report

    edited Oct 20, 2020 12:01PM in Reporting and Analytics for HCM 7 comments

    Summary

    Conditional formatting does not reflect in OTBI report where Logical SQL is used

    Content

    We have a requirement where we had to write a logical SQL query to show previous and current attributes in an OTBI report. We wanted to color code the changes if that attribute had a change using conditional formatting however we are unable to do so. We do have some outer queries in the logical SQL which is why the values are not auto-populated as it does with a simple logical SQL. Even if we type in the values and apply formatting, the styles does not get applied to the column values.We have a requirement where we had to write

    Tagged:

    Howdy, Stranger!

    Log In

    To view full details, sign in.

    Register

    Don't have an account? Click here to get started!