Creating an Org Chart RTF Report -- Help!

mathew74

Summary

Creating an Org Chart RTF Report -- Help!

Content

First, thank you in advance for your help.

I'm trying to create an Org Chart BI Publisher RTF (version 11.1.1.9) report and running into issues building dynamic columns.

My sample XML looks like this:

<?xml version='1.0'?>

<query numrows="24" queryname="LEVEL1DETAIL" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="">

<row rownumber="1">

<LEVEL1NAME><![CDATA[Manager 1]]></LEVEL1NAME>

<LEVEL2NAME><![CDATA[Mike]]></LEVEL2NAME>

</row>

<row rownumber="2">

<LEVEL1NAME><![CDATA[Manager 1]]></LEVEL1NAME>

<LEVEL2NAME><![CDATA[Tim]]></LEVEL2NAME>

</row>

<row rownumber="3">

<LEVEL1NAME><![CDATA[Manager 2]]></LEVEL1NAME>

<LEVEL2NAME><![CDATA[James]]></LEVEL2NAME>

</row>

<row rownumber="4">

<LEVEL1NAME><![CDATA[Manager 2]]></LEVEL1NAME>

<LEVEL2NAME><![CDATA[Chris]]></LEVEL2NAME>

</row>

<row rownumber="5">

<LEVEL1NAME><![CDATA[Manager 2]]></LEVEL1NAME>

<LEVEL2NAME><![CDATA[Rex]]></LEVEL2NAME>

</row>

<row rownumber="6">

<LEVEL1NAME><![CDATA[Manager 3]]></LEVEL1NAME>

<LEVEL2NAME><![CDATA[Jack]]></LEVEL2NAME>

</row>

</query>

I'm trying to Display the Level1Name values accross and the Level2Name values below.

 

Manager 1		Manager 2		Manager 3
Mike	Tim	James	Chris	Jack

I can get the level1Names to print accross without a problem, but when adding the Level2Name row becomes an issue.  I can't get the Level1Name to expand accross the level2names.

Is this possible?

Thank you!

Matt

Thomas Dodds

If you have OBIEE the Sample App shows how to do it with Google Charts (here's a blog about it: Google Organization Chart in OBIEE 11G | The Big Data - Business Intelligence by Sandeep Venu ),  taking that and coupling it with:

https://blogs.oracle.com/xmlpublisher/integration-with-google-chart-and-map

You might be able to get somewhere ...