USA Map using google code in OBIEE 12C

Hi Friends,

Most of the time we have a requirement to configure MAP Viewer and it's not straight forward. Here, by using a simple code we can at least implement a simple USA map. Let's move to example to make things more clearer.

OBIEE Versions -> OBIEE 11.9 & OBIEE 12c .
Required Data:
1. 1 Attribute column which has all the US states names (MANDATORY!!!!)
2. 1 Metric Column.

I have prepared a excel sheet where it has 2 column named States and Revenue.

Sheet attached:

My final table will look like:

NOTE: Here I have removed comma (,) and desimal (.) from column properties in Revenue Column.

Now open Narrative view paste below code:
Source from Google Gallery:
https://developers.google.com/chart/interactive/docs/gallery/geochart
Code which I modified:

Then final outcome will be:

We can change its dimension by its :

We can change its color:

Donut Chart In OBIEE 12C

In this blog we will be implementing Donut  Chart in OBIEE 12c.
OBIEE Versions ->OBIEE 11.9 & OBIEE 12c.
Used Columns:
1. 1 Attribute column
2. 1 Metric column

Here I have divided Revenue by /10000 as I don't have any other metrics which has 102,107,111 etc. data format. I have also made data format as Number and my final result would be like:

Now open Narrative view:

Code is taken from -https://developers.google.com/chart/interactive/docs/gallery/piechart#donut
Code I modified:
https://drive.google.com/open?id=1o9KCd-j-AOQZYxxGFeYOhbpbuqWot0FJ
Once implemented:

Note: There would be chances that we won't able to see this chart, but once we placed this report in the dashboard it will appear.
I hope that you have enjoyed this blog. In case of any suggestion, you guys are heartily welcome.

Calendar Chart in OBIEE 12c

Sometimes we have a requirement to show certain metrics for a single day. For this calendar chart is the best example and YES we can create in OBIEE too.

OBIEE Versions -> OBIEE 11.9 & OBIEE 12c.
Required Data:
1.Date dimension with MM/DD/YYYY format
2.One aggregate column
RPD and Catalog
I have used the default “Sample App Lite Data” that comes with the default obiee installation.

Implementation Steps

1.Drag and drop “Calender Date” from Time and “Revenue” from Base Fact from Subject Area as “Sample Sales Lite”

2. Remove commas, $ sign etc. from Revenue column. It should be whole numbered.

3.Open Narrative view and paste the code as shown below.

Calender chart code is taken from - https://developers.google.com/chart/interactive/docs/gallery/calendar
Code which I modified :https://drive.google.com/open?id=1SVxDWJFCI9kS2Mr2zLxB0voHqvn1xQZM
NOTE
1.Contain HTML Markup should be tick marked.
2. Rows to display should be 250 or 365 based on our data.
4.Once we clicked done .We will get below: 

Here we have a scale of 0-23000 that denotes the maximum value in Revenue Column. If we click any cell if will give us the revenue wrt its date as shown below:

As I clicked on a cell it shows its data i.e Revenue is 20732 on July 16,2008.

I hope that you have enjoyed this blog. In case of any suggestion, you guys are heartily welcome.