Using the Informix MetaCube SQL Method for reporting

There are two methods for creating OLAP reports based on Informix MetaCube information. The first is using the OLAP Report Expert, and the second is using the Informix MetaCube SQL Method.

This section provides you with instructions for creating OLAP reports for Informix MetaCube databases using the Informix MetaCube SQL Method.

Creating a report with Informix MetaCube is very similar to creating a report based on any relational database. When creating a report, you will see a list of Tables, Sample tables, and Predefined queries with dimensions, attributes, and measures. When working with OLAP data, it is often a good idea to create a Cross-Tab style report. In addition, it is also a good idea to add a filter to your report to limit the number of records that are returned when you run the report. This filtering can be done using the Record Selection Formula Editor.

The following procedures use the Metademo DataSource included with the Informix Metacube CD.