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.
mondaybi.com 
4 thoughts on “OBIEE FusionCharts Part2 – Data Integration”