RSS

New Waterfall Chart in OBIEE 11G

03 May

Disclaimer: Before reading this post. I would like to make a request to all readers. This feature is not supported by oracle at this version and so please do not go to the oracle support for further information. This was the reason that I have removed this post for sometime. But I have seen so many other bloggers are re blogged my content in their blogs and hence I thought of republishing this. Again, I am not responsible for any issues caused because of this. 

OBIEE has a new graph called “waterfall” chart in future versions. A waterfall chart is a special type of floating-column chart. A typical waterfall chart shows how an initial value is increased and decreased by a series of intermediate values, leading to a final value. An invisible column keeps the increases and decreases linked to the heights of the previous columns.

By default this is not visible in our graph list and need to enable manually. To do that, add this tag in your instanceconfig.xml file between <views> element. Save the file and restart the OPMN services.

After successful OBI services startup, Log into OBIEE analytics.

Now create a new analysis and go to results tab. On the results tab, Click on New view ->Graph menu, there you will find this new “Waterfall” chart.

Click on Waterfall chart to create a new view. It has nice features and properties to represent your data.

A quick screenshot of available features and types of data representation:

I created a sample report with Year and Revenue columns using Waterfall chart. You can see how the data is scattered on graph with respect to the data we have in table.

The last bar in the graph represents a value. That will be called as ‘End Balance‘ value in waterfall chart.

This graph definitely open doors to so many thoughts on data representation.  For me, I am seeing an option for Gantt charts now :) .

Thanks,

Shiva

About these ads
 
3 Comments

Posted by on May 3, 2012 in BI Publisher, OBI EE, OBIEE 11g

 

Tags: , , , ,

3 responses to “New Waterfall Chart in OBIEE 11G

  1. OBIEEfan

    May 15, 2012 at 1:14 pm

    What happened to this post?

     
  2. Shib

    June 22, 2012 at 8:03 pm

    Hi Shiva,

    Do you have any guidelines on how to combine two OBIEE Graphs/Charts in 11g so that we can have two vertical readings on both sides.

    G-1: Sales-Revenue by Year
    G-2: Sales-Billed Qty by Year

    Need to combine both G-1 & G-2…

    Thanks in advance for your inputs..!

    Thanks,
    Shib
    Email@: shibshankar.seal@gmail.com

     
  3. bnvsaratarat

    March 27, 2013 at 5:10 am

    Hi Siva

    Waterfall graph will not work in version 11.1.1.6.6 version , it is available only in 11.1.1.6.2 version .
    See below reply from oracle .

    See below oracle reply for this issue in OBIEE 11.1.1.6.6 version.

    Error Unknown Element ‘EnableWaterfall’ Using BP1 11.1.1.1.6 (Doc ID 1477069.1)

    Symptoms

    The following error message is received in the BI Server when using BP1 11.1.1.1.6 :

    [Util Logger] Exception occurred:
    Severity:5
    Type:class saw::Exception const * __ptr64
    File:main/project/webutil/configreaderinstance.cpp
    Line:558
    Message:Invalid settings in config file: Bad config instance ‘\\?\C:\Oracle\BI64\instances\instance1\config\OracleBIPresentationServicesComponent\coreapplication_obips1\

    Cause

    This Parameter is not currently supported by OBI EE 11g

    This parameter is not documented in any official OBI EE documents or resources.

    Solution

    OBI EE does not support this Parameter yet, therefore you will need to remove this parameter or set it to ‘false’ to resolve this issue.

    We hope to have this functionality supported in a future releases, however, no date or release version have been decided.
    Any external websites which advise about this new functionality should be ignored.
    Also, see this external posting :-

    http://shivabizint.wordpress.com/2012/05/03/new-waterfall-chart-in-obiee-11g-2/

    Disclaimer: Before reading this post. I would like to make a request to all readers. This feature is not supported by oracle at this version and so please do not go to the oracle support for further information. This was the reason that I have removed this post for sometime. But I have seen so many other bloggers are re blogged my content in their blogs and hence I thought of republishing this. Again, I am not responsible for any issues caused because of this.

    Many Thanks,

    Oracle Customer Support

     

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

 
Follow

Get every new post delivered to your Inbox.

Join 618 other followers

%d bloggers like this: