OBIEE FusionCharts Part3 – Advanced Integration
A quick link to previous parts:
At this point, everyone should have completed Parts 1 and 2. I can see that there are quite a lot of feedback and views, so I’ve decided to go a bit more with advanced integration.
This part will cover 2 areas which is integrating presentation variables for your header as well as multi-series charting.
Integrating Presentation Variables with Chart Titles
First of all things is to create your dashboard prompt. The way I did it is simply creating a column prompt for Fiscal Year then adding a presentation variable name to it. If you need to know the basics, you can view it here on the Oracle Blog.
1. Create a New Dashboard Prompt (New->Dashboard Prompt)
2. Add a Column Prompt: Fiscal Year
3. Expand the Options and Set a variable to ‘Presentation variable’ and Enter ‘FiscalYear’ in the field below.
4. For the sake of testing speed, let’s remove the apply and reset buttons. You will need to click the pencil to edit.
5. Go back to the report you have created in OBIEE FusionCharts Part 2 – Data Integration. The save the prompt and naming as you like.
6. In the Narrative Postfix, modify the “caption” : “Monthly Sales Summary” to “caption”.”@{FiscalYear}{FY10/11} – Monthly Sales Summary” but of course this is dependent on your own subject area.
7. Save your report.
8. Create a dashboard and put both Prompt and Analysis (Answer) Report inside. Results should be as follows:
9. Now while you change the prompts, you should have the title of the graph in sync with the prompt.
Creating FusionCharts Multi-Series Chart Types
I would give an example of using Multi-Series Chart Type using FusionCharts. Using the previous report, we would change Fiscal Month to Fiscal Year and adding another column before Sales which will be Product Category.
1. Modify the Analysis Report so that you get Fiscal Year, Product Category and Sales columns.
2. In Narrative, copy and paste the following back to Prefix, Narrative, and Postfix.
//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/MSColumn3D.swf”,
“myChartId”, “900”, “600”, “0” );
var category = new Array();
var category_name = new Array();
var data = new Array();
var dataset = new Array();
var data1 = new Array();
var seriesname = new Array();
function add_data(content){
var data_obj = {“label”:content};
category.push(data_obj);
}
function add_dataset(value){
var data_obj = {“value”:value};
data.push(data_obj);
}
var first_category = 0;
var row_id = 1;
var add_category = 1;
var last_seriesname = 0;
var rolling_id =1;
var matching_id =1;
//Narrative
if (row_id == 1)
{
first_category = ‘@2’;
}
if (first_category == ‘@2’ && row_id !=1)
{
add_category = 0;
}
if (add_category ==1)
{
add_data(‘@2’);
category_name.push(‘@2’);
}
if(last_seriesname!= ‘@1’)
{
seriesname.push(‘@1’);
}
last_seriesname = ‘@1’;
while (add_category==0 && ‘@2’ != category_name[(matching_id-1 )% category_name.length])
{
add_dataset(0);
matching_id++;
}
add_dataset(@3);
row_id++;
matching_id++;
//Postfix
for(var i=0;i<seriesname.length;i++)
{
data1[i]=data.slice(i*category.length,i*category.length+category.length);
dataset .push({“seriesname”:seriesname[i],”data”:data1[i]});
}
myChart.setJSONData( {
“chart”: {
“caption” : “@{FiscalYear}{FY10/11} – Product Category Sales Comparison” ,
“xAxisName” : “Monthly”,
“yAxisName” : “Sales”,
“numberPrefix” : “$” },
“categories”:[{
“category”:category
}
],
“dataset”:dataset
}
);
myChart.render(“chartContainer”);
</script>
</body>
</html>
3. Sample result as follows. Note that a feature of FusionCharts is that you can click on the series so that it hides/shows the specific series.
4. Modify the dashboard prompt so that you get multiple selection for Fiscal Year.
5. Choose 2 or 3 years. Notice the header also displays your presentation variables. Results similar to mine as follows:
That’s it for today. Next up will be more on Charts Configuration .
*Feel free to share this article but please give me credits and a link back to this original article.
mondaybi.com 
3 thoughts on “OBIEE FusionCharts Part3 – Advanced Integration”