OBIEE FusionCharts Part2 – Data Integration

OBIEE FusionCharts Part2 – Data Integration

For those who have already seen Part1, please continue, else here is the link back to Part1 OBIEE FusionCharts Part 1 – Installation.

So I guess everyone’s got their installation done and tested. This part will be about data integration.

First thing to do with data integration is creating a new Analysis. On the “Criteria” tab, plug in a time dimension and a measure (fact) like below:

Next step is to set the measure so that the thousand separator does not have a comma, so basically disabling the default setup of the thousand separator. This is required as JSON data does not allow the comma. This is done by clicking the sales measure and going to data format. Then click override default data format and uncheck the “Use 1000’s Separator” checkbox.

Now, you’re basically done with the criteria, let’s move on to the “Results” tab.

Create a new Narrative View which is located in Others.

In the Narrative, you are required to fill in Prefix, Narrative and Postfix.

Please copy the following for your easy referencing:

//Prefix

<html>

<head>

<title>My First chart using FusionCharts XT – JSON data URL</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”, “900”, “600”, “0” );

var data_array = new Array();

function add_data(month,figure){

var data_obj = {“label”:month,”value”:figure};

data_array.push(data_obj); }

//Narrative

add_data(‘@1’,@2);

//Postfix

myChart.setJSONData( {

“chart”: {

“caption” : “Monthly Sales Summary” ,

“xAxisName” : “Monthly”,

“yAxisName” : “Sales”,

“numberPrefix” : “$” },

“data”:data_array } );

myChart.render(“chartContainer”);

//alert(JSON.stringify(data_array));

</script></body></html>

Please be reminded that you should fill in “Rows to display”. This can be 12 for 12 months, 7 for 7 days or 1000 just for the sake of showing all the data.

Once done, you are able to view the results like the following.

Stay tuned for Part 3 Advanced Integration. This will cover dynamic titles and names. I will be flying around from now till next week so the next post will probably be ready sometime next mid-week.

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

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

4 thoughts on “OBIEE FusionCharts Part2 – Data Integration”

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