Hi,
I have a requirement create graphs, charts and maps based on data from a data warehouse (dw). As I see things, there are two possibilities:
- Graphs, charts and maps based on an XML file
- Graphs, charts and maps based on Oracle tables
Both would contain small data sets that will allow for quick response. The intent of these graphs, charts and maps is to generate a dashboard that would allow the user to quickly drill down to the desired warehouse data.
The proof of concept has already been validated using the Oracle table scenario. My question is whether or not this could be accomplished reading xml files for generating the same set of dashboard items?
My Oracle database and APEX environments configuration are as follows:
NLSRTL 11.2.0.1.0 Production
Oracle Database 11g Enterprise Edition 11.2.0.1.0 64bit Production
PL/SQL 11.2.0.1.0 Production
TNS for Solaris: 11.2.0.1.0 Production
Application Express 4.2.2.00.11
APEX Listener Release 2.0.2. / Tomcat
An Oracle database directory has been setup and is accessible to our APEX application.
Any suggestions/help is appreciated.
Thanks,
Charles