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?

MariMekkoChart

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 (http://www.fusioncharts.com/explore/charts ). 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.

Installation

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 (http://www.fusioncharts.com/download/ ).

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

FileStructure1

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

FileStructure2

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:

FileStructure3

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.

<html>

<head>

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

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

</head>

<body>

<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( {

“chart”:{

“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” }]} );

myChart.render(“chartContainer”);

</script>

</body>

</html>

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

Your expected result:

ExpectedOutput

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

Advertisements

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 MondayBI.com 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: http://docs.fusioncharts.com/archive/3.4.0/tutorial-setup-upgrading-from-previous-versions.html

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

      Regards,

      Steve Yeung

      Like

  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.

    Like

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