Sunday, October 18, 2009

OOW09 - Dashboards in APEX

One of the presentations I did at OOW09 was Impress Your Clients with Interactive Dashboards in Oracle Application Express.

The session was booked in the Franciscan A and B room of the Hilton Hotel. So the room was pretty big (around 200 people I think) as two rooms were put together. I like to do interactive presentations, but in such a room e.g. there were two project (one at every side of the room) that is not that easy.

In this presentation I first explained which charting capabilities you get out-of-the-box with APEX, followed by how you can transform these charts into nicer ones. If you really want to impress your clients, Interactive Dashboards are the way to go. Basically a dashboards is one big chart which consist out of different views who have all an own chart.

Having only one swf and one data feed makes it faster than when you would create three separate charts. Anychart 5 provides a nice API to generate these dashboards.

You have different possibilities to feed the chart with data, one of them is creating an Application Process that generates the XML for the dashboard. e.g.

If you want to add Interactivity to your chart, you will need to use JavaScript.

In the presentation I covered all steps in detail. At OOW the presentation got recorded as well so when they release the audio streams, you can hear it there too. I'm also giving this presentation again at UKOUG.

You find the example I explained in the presentation here.

In APEX 4.0 the creation of dashboards will become easier as there will be a wizard in. So far I didn't see a demo of that yet, so I'm not sure how and what features they will include.

At the end of my presentation I also showed a preview of the new chart engine Anychart is working on, called Stock Charts. They are not released yet, but I'm working with them to make the integration with APEX easy. I'm really exited about these new charts! If you need financial charts or charts that are based on dates, these new charts rock!


Scott Horowitz said...

Can you repost the download link for this? I'm working on a dashboard and interested in seeing your presentation

Dimitri Gielis said...

Hi Scott,

Have a look at

Hope that helps,

Unknown said...

Hi Dimitri,
I have hundreds of dashboards in my APEX 3.1 Oracle 11g, building xml code with pl/sql process.
Now i'm upgrade to APEX 4.1 but my dashboards don´t work with the follow message in the dash area:
"This Chart is not supported by Oracle APEX version of Anychart..."
I download your upgrade kit and installed, but i cant put the xml dashboard code in any area of the plug-in.
I tried to copy de swf and js files in a new folder in web server images directory but it still doesn't work. Please can you help me!

Dimitri Gielis said...

Hi Rodrigo,

You would need to adapt the plugin to use your xml or the function that generates the xml.

Not sure how much you know about APEX plugin development.

We will come out with another plugin where you can just put the xml of the chart you want in the coming weeks.