To create an OLAP report using the Informix MetaCube SQL Method

1. On the File menu, click New.

   The Seagate Crystal Report Gallery appears.

2. Confirm that Report Expert and Standard are selected, then click OK.

   

3. Click Database.

   The Data Explorer appears.

4. Expand the More Data Sources folder, then click the Informix MetaCube folder.

   

5. In the RDBMS Login & Choose DSS System dialog box, enter the Password, then click OK.

   

6. Select the Brand Channel Net Profit table.
7. Click Add, then click Close.

   The Standard Report Expert appears.

8. Click Next.

   The Fields tab appears.

9. For this example select the Channel.Channel, Product Brand, and Sales Transactions fields then click Add.

   

10. Click Preview Report to view the report.

Note:    You may have to adjust the column widths of the fields and field headers to see all the data. If you wish to hide the Channel Field column simply select the top element in the field, click the right mouse button and select Delete from the shortcut menu.