Wednesday, November 11, 2009

Setup BI dashboard in APEX

I have been looking around for some good Business Intelligence Dashboard templates to be used together with APEX. What our customer wanted was a dashboard which was easy to navigate and functional to use.

We wanted to put in some web 2.0 functionality such as drag and drop for placing portles in the position the user wanted and and lots more Jquery stuff such as tabs, modal popup windows, nice help window, date picker, resize of menu navigator, hide/show portlets. The layout is automaticly saved in the database.

The web 2.0 features is made by using Jquery to get a slick and fast refresh of the page.

What we ended up with was a APEX theme which you can have a look at

http://www.apex-home.com/pls/apex/f?p=56502:300:2432006777088735::::NEWSID:200

Thanks to Stephen Blair at apex-themes which made a very good job putting this together.

Together with Oracle Warehousebuilder, BI Publisher, APEX Interactive reporting, and Anycharting it should be possible to make functional and good solutions without high starting cost.

regards
Jon