Business Intelligence – Oracle

Oracle BI EE 10.1.3.3/2 – Marquee, Images and Gantt Charts

Posted by Venkatakrishnan J on December 6, 2007

Thanks to Matt Bedin, BI EE product managment and Thomas Lukens for sharing this. One of the important requirements for any user is to have multiple formatting options within a Tabular View table. For example, one might need scrolling Marquee within a column i.e make a column value move from left to right or one might want to display images from a site or one might want to even put submit forms directing to an external application and last not the least to display Gantt like charts within a tabular column. So, lets look at enabling each one of the above one by one.

Marquees:

   Lets start with creating a sample report. Lets create a report with Product Names and the their corresponding Sales. Our aim is to make the Product names rotate like a Marquee.

      

Now go to the formula window of the Product Names and enter the below HTML text.

      ‘<MARQUEE bgcolor=”#CCCCCC” loop=”-1″ scrollamount=”2″ width=”100%”>’||PRODUCTS.PRODUCT_NAME||'</MARQUEE>’

      

Now go to the Properties of this columns and navigate to Data Format and change the data format to HTML. Now if you look at the report the product names would be scrolling.

      

      

Now you can realize the kind of extensibility this can have. You can have your own HTML formatted columns. All the remaining 2 that we would be seeing are actually extensions of this property.

Images:

   Lets use the same methodology above to display images. Lets display the Oracle logo that we have in the Oracle.Com website. The procedure is same. In the column formula enter following HTML

      ‘<IMG SRC=”http://oracleimg.com/admin/images/ocom/hp/oralogo_small.gif” WIDTH=”80″ HEIGHT=”80″ BORDER=”0″ ALT=”Oracle”>’

And change the column format to HTML as above.

      

Gantt Charts:

   One amazing use of the above HTML property is that you can mock and create Gantt Charts. Gantt Charts are basically bar charts wherein the bars would denote the size of the metric for which they are plotted on. There are many variations of this chart. But for illustration purposes lets create a simple one. In the column formula enter

      ‘<table><tr><td style=”padding-left:0″ width=’ || CAST(SALES1.Sales/1000 AS VARCHAR(20)) || ‘ bgcolor=#9C9ECE height=16> </td></tr></table>’

Now change the data format to HTML.

      

Here, we are basically creating a horizontal bar whose size varies according to SALES1.Sales column. We have divided by 100 in order to bring the size relevant to HTML format. One can use this to have multiple other formatting options. If you are good in HTML then this is just for you.

Advertisements

12 Responses to “Oracle BI EE 10.1.3.3/2 – Marquee, Images and Gantt Charts”

  1. agm said

    After upgrading to oracle BI, I realised that I had to set the HardenXSS setting to false in the instanceconfig.xml to be able to do html tags like these.

  2. ia said

    Just a small note for people who follow these instructions: it’s better to copy-paste the html first to a text editor and make sure that all the special characters are ok; for me ” had changed to ? and so on.. Probably a problem deriving from different keyboard settings or smthng

    Thanks for the posting Venkatakrishnan, I’ve found your blog very interesting and useful. Keep up the good work!

  3. Tina said

    Hi,Venka
    Cool!

    Thanks & Regards,
    Tina

  4. sreenu said

    Hi,
    When i am giving the marque as same i am not able to get the result. it is showing the odbc error

  5. Venkatakrishnan J said

    Remember to use your corresponding column name within the HTML. The one shown above is an example showing making the Products column to rotate.

  6. Bilal said

    hi,
    very interesting features within BI. Specias characters are a problem for novice users.

    Good work! please keep it up.

    Thx
    Bilal

  7. […] BI EE 10.1.3.3 and mapviewer – Step by Step Integration Phase2 / Phase3OBI EE 10.1.3.3 and VPDOracle BI EE 10.1.3.3/2 – Marquee, Images and Gantt ChartsOracle BI Publisher and BI EE – Invisible Admin Tab!!!BI Publisher 10.1.3.2 and VPDOracle BI EE […]

  8. sangeetha said

    Hi

    For Gantt chart …… i have taken two columns EMP&Sal i applied this
    ’ ’
    i set the HTML also……….
    But i am not getting answer … That sal column showing blank ………

  9. Venkatakrishnan J said

    @Sangeetha – Did you change the presentation column to match to your report Salary

  10. Megan Mo said

    Great blog, keep it up!

    One question: the images I have to use for a customer are quite large, and it’s not possible to reduce their size or the image details will be lost. Is it possible to set up a behavior similar to ‘Action Link’ so that if the user wants to see a particular image and clicks on the action link icon, the image will appear on a separate, larger window?

    Thanks

  11. Bruce Szalwinski said

    If I’m storing the images in the database as a blob column, is there a way to display them in Answers? Would I be better off storing the URL of the image and using the technique?

  12. Bruce Szalwinski said

    Never mind, found it on your site at https://oraclebizint.wordpress.com/2007/12/10/oracle-bi-ee-101332-displaying-blob-images-using-plsql-gateway/.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

 
%d bloggers like this: