OBIEE FusionCharts Part1 – Installation

OBIEE FusionCharts Part1 – Installation

*Feel free to share this article but please give me credits and a link back to this original article.

This tutorial is meant to be for more advanced OBIEE users and not beginners.

There will be a total of 4 parts to the full OBIEE FusionCharts Integration.

Part 1 – Installation

Part 2 – Data Integration

Part 3 – Advanced Integration

Part 4 – FusionCharts Configuration

I have always wondered why there aren’t any topics on integrating FusionCharts, amCharts and HighCharts? They work all the same using javascripts.

So why would you want to integrate them?


OBIEE lacks the ability to generate specific charts especially for marketing departments. A simple but important MariMekko chart is already impossible or too tedious to implement for OBIEE. Integrating FusionCharts makes everything much simpler and it’s really not expensive at all.

I will go through FusionCharts installation in this article.

What does FusionCharts provide?

The basic FusionCharts that I will integrate is called the FusionCharts XT which is its flagship product. It more or less duplicates everything in OBIEE but with an extra chart which is MariMekko chart. But once integrated, you can always add FusionWidgets XT, PowerCharts XT or FusionMaps XT. Those will include charting features that OBIEE lack including Gantt Charts, Pyramid Charts, Heat Map, Multi-Level Pie Chart and Error Charts. I just picked up selected ones, but feel free to check out on FusionCharts website ( ). It also natively support HTML5 which is ideal for iPad. If you’re worrying about export, then don’t because it natively supports export to jpg and pdf.


So let’s begin with the following steps.

Download FusionCharts XT which is free trial to begin with. Fill in the information on the provide page and download. It’s a zip file and when unzipped about 80mb ( ).

Once downloaded, extract in any location. The file structure as follows:


Next go into charts folder and the file structure will be similar to this:


Create a new folder called FusionCharts for easy referencing purposes and then select all the files and copy them to this new folder.

Now copy the whole folder to the following OBIEE installation addresses.

… \ Oracle_BI1\bifoundation\web\appv2\res\b_mozilla\

… \user_projects\domains\bifoundation_domain\servers\bi_server1\tmp\_WL_user\analytics_11.1.1\7dezjl\war\res\b_mozilla

Your file structure should be similar to mine as follows:


Restart all services.

Installation is basically finished.

Test if it works

Login to OBIEE.

Create new analysis.

Put some dummy members and measures.

Create a new narrative.

Tick contains HTML markup.

Copy and paste the following in the Prefix to see if integration works.



<title>My First chart using FusionCharts XT – Using JavaScript</title>

<script type=”text/javascript” src=”res/b_mozilla/FusionCharts/FusionCharts.js”></script>



<div id=”chartContainer”>FusionCharts XT will load here!</div>

<script type=”text/javascript”>

var myChart = new FusionCharts( “res/b_mozilla/FusionCharts/Column3D.swf”,

“myChartId”, “400”, “300”, “0” );

myChart.setJSONData( {


“caption” : “Weekly Sales Summary” ,

“xAxisName” : “Week”,

“yAxisName” : “Sales”,

“numberPrefix” : “$”},

“data” :[

{ “label” : “Week 1”, “value” : “14400” },

{ “label” : “Week 2”, “value” : “19600” },

{ “label” : “Week 3”, “value” : “24000” },

{ “label” : “Week 4”, “value” : “15700” }]} );





Then click any blank space outside the text box to generate testing results.

Your expected result:


Congratulations! Installation done.

I will be a bit busy during this week and will probably continue on Part2 which is more on integration passing data with FusionCharts. Stay tuned.

Continue to Part 2


Author: Steve Yeung

Being in the EPM & BI field for more than 8 years, it's about time I contribute to newcomers! As a founder of I wish to give you all the help I can. Feel free to give any suggestions or questions. Hope you will all enjoy this blog! William Wong Essbase Certified Specialist OBIEE Certified Specialist

11 thoughts on “OBIEE FusionCharts Part1 – Installation”

    1. Hi SK,

      Thanks for your kind comments. Yes, I tried to download again and it seems that it is only around 2mb when zipped.

      When the blog was written, it FusionCharts was on Version 3.3.1 SR3. Now it is on 3.5.0 and the file structure is now different. Moreover, they took away the Flash Rendering which is a good thing. The upgrade started in Version 3.4.0, and you can view the documentation here:

      I will write a blog to include the latest version, hopefully before 2015. Thank you for notifying me.


      Steve Yeung


  1. . The grouped leengd and the syncing of multiple y-axes are the only custom visualization code that I’ve written for FlexChart. Reimplementing the DSL in the context of some other charting environment (or even building one from scratch) would be relatively straightforward; that’s intentional.


Leave a Reply

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

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

Facebook photo

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

Connecting to %s

%d bloggers like this: