The Retrieving Data section includes examples showing some commonly encountered retrieval issues.
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. |
Drilling To Relational Detail Using MSAS DrillThrough | With MSAS DrillThrough support enabled and a properly configured cube, you can right-click on a data cell in a GridBlox to drill down into in interactive ReportBlox view showing relational details. |
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. |