Tuesday, June 4, 2013

OBIEE 11.1.1.7.0 Waterfall chart.


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.



I created a sample report with Year and Policy Count 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 ‘Total‘ value in waterfall chart.







 

OBIEE 11.1.1.6 Vesrsion:





“The waterfall chart was not introduced in 11.1.1.6.0. Rather, partially implemented work has been discovered via inspection of config files. This functionality is not going to work predictably, will not upgrade, and most importantly may yield incorrect data. It should not be used or promoted. A robust Waterfall chart is planned for our upcoming release. “

Oracle introduced one new graph called “Waterfall” chart in OBIEE 11.1.1.6.0.

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.

<Charts>
<EnableWaterfall>true</EnableWaterfall>
</Charts>
</Views>



Save the file and Restart the OPMN services.





Good Luck!!!!

Thanks,
Satya Ranki Reddy

1 comment:

  1. Cheers Satya!!, for poosting wonderful work done.

    I have one issue and need you your help.

    Could you please post a blog on how to send a bi publisher report in mail attachment specific to country(based on user's country).Any help would greatly appreciated.

    Regards
    raghu
    bhavanthi@gmail.com

    ReplyDelete