OBIEE FusionCharts Part3 – Advanced Integration

OBIEE FusionCharts Part3 – Advanced Integration

A quick link to previous parts:

Part 1 – Installation

Part 2 – Data Integration

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)

1NewDashboardPrompt

2. Add a Column Prompt: Fiscal Year

2ColumnPrompt

3. Expand the Options and Set a variable to ‘Presentation variable’ and Enter ‘FiscalYear’ in the field below.

3SetPresentationVariable

4. For the sake of testing speed, let’s remove the apply and reset buttons. You will need to click the pencil to edit.

4EditPageSetting

4RemoveApplyReset

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.

6PostfixPresentationVariable

7. Save your report.

8. Create a dashboard and put both Prompt and Analysis (Answer) Report inside. Results should be as follows:

8PresentationResult

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.

1ThreeColumns

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.

3SampleMSBar

3HideSeries

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:

5DashboardSample

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.

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

3 thoughts on “OBIEE FusionCharts Part3 – Advanced 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