I upgraded to APEX 3.2.1 which is supposed to have AnyMap and AnyGantt support. I have modified region and chart XML to display the world map (world.amap). But in order to get the map to show up I had to reference the AnyChart.swf file in the Region source area. However, a message ("Your license does not include the AnyMap extension") shows across the map and clicking on the message takes you to AnyCharts.com.
There does exist an AnyGantt.swf file, which led me to ask if there is a missing AnyMap.swf.
Also data from the SQL Query does not highlight the countries, but when I replace #DATA# with a hard coded series it does highlight the countries as required:
select null link, country label, people value
FROM
(
select 'United States' country, 303824646 people from dual
UNION ALL
select 'China' country, 1330044605 people from dual
UNION ALL
select 'India' country, 1147995898 people from dual
UNION ALL
select 'Indonesia' country, 237512355 people from dual
UNION ALL
select 'Brazil' country, 191908598 people from dual
)
vs
<data>
<series>
<point name="China" y="1330044605"/>
<point name="India" y="1147995898"/>
<point name="United States" y="303824646"/>
<point name="Indonesia" y="237512355"/>
<point name="Brazil" y="191908598"/>
</series>
</data>
Thanks,
John