x

1. If it is not already open, expand the OLAP project folder.
2. Click the Procedures folder.
3. Right-click the Procedures folder and select New then select Procedure.

   The Add Procedure dialog box opens.

4. Name the procedure CENTREP and choose Report Painter from the Create with drop-down list.

   

5. Click Open.

   The Open dialog box asks you to specify the data source you will use to create your hierarchy.

6. Select CENTORD.MAS.

   

7. Click Open.

   The Report Painter opens, where you will create a report using fields from the CENTORD data source.

x

To create a report, you must add fields to it. Follow these steps to add fields to your report in the Report Painter.

The Object Inspector window, located at the left side of the Report Painter, lists the fields in the CENTORD Master File.

1. Double-click the following fields in the Fields tab on the Object Inspector to add them to the report:
   • QUARTER
   • STORENAME
   • PRODTYPE
   • ORDER_DATE
   • LINE_COGS

   

2. Select the Quarter column and press the Shift key and click the Store Name column to select them simultaneously.
3. Click the By button on the main toolbar to sort the data for the Quarter and Store Name columns vertically.
4. Click the PRODTYPE column.
5. Click the Sum button.
6. Place the cursor in the Page Heading area.

   Tip: If your report boundaries are not showing (the Page Heading and Page Footing areas), click the Report menu and select View. Click the check box for Boundaries in the General section and then click OK.

7. In the Page Heading area, type Quarterly Store Report.
8. Press the Enter key to add a blank line to the heading.
9. Highlight the first line of heading text and select Fonts from the Properties menu.

   The following font attributes are the default:

   • Font: Arial
   • Font Style: Bold
   • Size: 10
10. Click the Color button and select blue.
11. Click OK to close the Font dialog box.
12. Click the Center Justify button on the toolbar.

    Your report should now look like the following image.

    

x

You can OLAP-enable reports so that users can benefit from Online Analytical Processing (OLAP) to quickly change the presentation of data.

Complete the following steps to OLAP-enable your report.

1. From the Report menu, select Features. The Report Options dialog box opens at the Features tab.
2. In the OLAP area, select Top Panel from the Enable OLAP drop-down list. When you later run your report, the OLAP selections panel will appear above your report output.

3. Select Dimensions and Measures from the Automatic Drill Down list. When you later run your report, this will enable automatic drill-downs on dimensions and measures.

   

4. Click OK.
5. Click Run.

   

   Notice that the OLAP selections panel opens above the report output, as you requested in step 2. Use this panel to manipulate your output. Also, notice that drill-down hyperlinks are active for the dimensions and for measures.