Google Organization Chart in OBIEE 11G | The Big Data - Business Intelligence by Sandeep Venu

Enter key word

Google Organization Chart in OBIEE 11G

  1. Oracle Database
  2. OBIEE Server
  3. OBIEE RPD
  4. OBIEE Maps
  5. Weblogic
  6. Errors
  7. Upgrade
  8. Customize
  9. Patch
Here are the steps to create an organization Chart in obiee (Google Chart)

Step 1 - Add the manager and position column in criteria






Step 2: Create a Narrative View as below

Prefix:

    <script type='text/javascript' src='https://www.google.com/jsapi'></script>
    <script type='text/javascript'>
if(document.URL.indexOf("saw.dll?Answers") == -1) {
      google.load('visualization', '1', {packages:['orgchart']});
      google.setOnLoadCallback(drawOrgChart);
}
      function drawOrgChart() {
if(document.URL.indexOf("saw.dll?Answers") == -1) {  
      var data = new google.visualization.DataTable();
        data.addColumn('string', 'Name');
        data.addColumn('string', 'Manager');
        data.addColumn('string', 'ToolTip');
        var myOrgArray=[];
        var tempStr = "";


Narrative:

myOrgArray.push([{v:"@2".replace("  "," "), f:"@2<br/><font color=red><i>@3<i></font>".replace("  "," ")}, "@1".replace("--",""), "@3"]);



Postfix:

        data.addRows(myOrgArray);
        var chart = new google.visualization.OrgChart(document.getElementById('div_orgchart'));
        chart.draw(data, {allowHtml:true});
}
      }
    </script>
    <div id='div_orgchart'></div>





Till Next time..

  1. Oracle Database
  2. OBIEE Server
  3. OBIEE RPD
  4. OBIEE Maps
  5. Weblogic
  6. Errors
  7. Upgrade
  8. Customize
  9. Patch

SHARE

About Sandeep Venu

    Blogger Comment
    Facebook Comment

7 comments:

fahadiqbal said...

what is the use of var tempStr = ""; in this code?

yoJimbo said...

this is very useful - i have tried this on a dashboard to draw an org chart. I have added prompts to change the top level org level shown and the chart just disappears have you tried similar?

Hemant said...
This comment has been removed by the author.
Jangomonty said...

Hi, Thank you for sharing this wonderful chart with us.
But I think i have hit the dead end with extra functionality with this Org chart, I am trying to use Employee pictures in this chart instead of employee names. Now when i make reference to the pictures it shows in my table report but when i try to use this in Narrative view it doesnt work.

Is there any way to show pictures instead of names in this report. + can we make this interactive as when i click on employee picture it shows the detailed report for that empoyee?
Thank you

Jangomonty said...

If you keep filter for manager as Prompted and create a prompt for Manager name and then try to run this report from dashboard yes it does change the graph values on its own.

Rani S said...

Hi, Thanks for this information on organization chart. I implemented this on OBIEE 11.1.1.7.0. But the chart did not get displayed in narrative view. Could you please let me know if there are any prerequisites for creating an org chart?

Anirban Mitra said...

Hi
Thank you very much for sharing this organization
Chart concept, I have implemented this
And it is working as expected, now one thing
I am not able to do is, how I can make it collapsible.
Say, I click on 1st level then only 2nd level should
Appear and so on.
Please let me know is it possible to do?

Thanks in advance.

Top Links

Upgrading BI Publisher

Add Google Search

OBIEE- LDAP

Change Admin Password

Best Practices

ORACLE 11GR2

Host Files

Customization

OBIEE-SIEBEL

Bug Fixes

Setting Default

OBIEE Installation failed

OBIEE Installation

Oracle Databse

Oracle In Linux

Loopback Adapter

Weblogic Failed

Yum Commands

Weblogic Admin

Linux Static IP

OBIEE LDAP

Admin Paswword

Scaling

Weblogic Starting Error

Localizing BI

Physical Schemas

Multimedia Dashboard

Video in OBIEE

Variables in OBIEE

Ago 30 Days

Email Link

ODI Installation

AGO Function

Sort Pivote table

OBIEE Patch

Reset Sys password

Date Calculation

Add Row in Report

Increase Row limit

OBIEE with Essbase

Reset Weblogic

BIP Login Error

MDS and BI Platform

ORA 28001 Error

ORA 12560 TNS Protocal Error

ORA 12154 TNS Error

OBIEE ON AIX

Pre Requsite

AIX Commands

Commands