Retrieving Data - Overview

The Retrieving Data section includes examples showing some commonly encountered retrieval issues encountered with DB2 OLAP Server and Hyperion Essbase.

Note: These files can be used for learning or for use as templates to create your own Blox templates. Copy these files to a new application for testing purposes, instead of changing settings in these files.

You can access the files through either the menu on the left or by clicking on one of the links below:

Title Description
Initial Query Using JSP Scriptlet Shows a Blox being loaded with the initial query set using a JSP scriptlet.
Retrieving Customized Data Shows the use of a ResultSetBlox to retrieve and customize results from a relational data source.
The customized result set is then fed into a DataBlox so that it can be displayed in the PresentBlox.
To use this example, you need to install one of the relational database versions of QCC (available in the
<code>sample data</code> directory of the DB2 Alphablox installation CD) and modify the JDBC driver information
below to point to that database.