ELFFAR ANALYTICS
  • Home
  • Services
  • Contact Us
  • About Us
  • Blog

Elffar Analytics Blog

Direct Database Requests & Conditional Formatting

10/8/2018

9 Comments

 
I'd start this blog by issuing a warning that Direct Database requests should be used sparingly. A Direct Database Request (DDR) bypasses the OBIEE metadata defined in the repository and this can have security implications if not managed properly where users could potentially have access to data that they should not have access to.

There are some use cases for DDRs like building an OBIEE analysis to display the status of a transactional process for instance.

According to the OBIEE user guide documentation, you can not specify conditional formatting for columns of a Direct Database Request.

This post describes a "workaround" which enables you to achieve this. In the example below, all you need is a little HTML and bingo!

All you need is a CASE statement to implement the conditions of your logic and on the column that you'd be applying the formatting, go to Column Properties > Data Format and change the Treat Text As field to HTML.
Picture
9 Comments

    Author

    I'm an Oracle Ace Associate, Oracle Cloud Platform Enterprise Analytics 2019 Certified Associate and a certified OBIEE 11g implementation specialist.

    Archives

    March 2020
    February 2020
    December 2019
    August 2019
    June 2019
    February 2019
    January 2019
    December 2018
    August 2018
    May 2018
    December 2017
    November 2016
    December 2015
    November 2015
    October 2015

    Categories

    All
    OAC
    OAS
    OBIEE
    OBIEE 12c

    RSS Feed

Powered by Create your own unique website with customizable templates.
  • Home
  • Services
  • Contact Us
  • About Us
  • Blog