[OBIEE 10g] Google Charts

 

OBIEE Google Charts

This is how to work  with real venn diagrams:

First get your data:

Add an extra column with a row count:

Hide it:

Add an narrative view:

<img src="" id="venn_chart@9"/>  <!– creates an unique img tag –>
<script type="text/javascript">
var chartURL = "http://chart.apis.google.com/chart?cht=v&chs=200×200&chd=t:@2,@3,@4,@5,@6,@7,@8&chtt=@1&chdl=a|b|c&chdlp=b" ;
/* cht = chart type
   chs = chart size
  chd = chart data
  chtt = chart title
  chdl = chart legend
  chdlp= chart legend position
  more info http://code.google.com/intl/nl/apis/chart/ */ 

/* get the chart */
document.getElementById(’venn_chart@9′).src = chartURL;
</script>

Put all together: