Hiding a Sort Field

How to:

In OLAP, you can hide a sort field by clicking the Hide check box in a report. In past releases, the text (hidden) was displayed to the right of the field name in the Drill Down pane in the OLAP Control Panel. Beginning with Version 7 Release 7.02, hidden sort fields are indicated by reversing the color of the icon that appears at the left of the field name.
Top of page
x
Procedure: How to Hide a Sort Field
  1. Enter the following code in an ad hoc page. 
    -OLAP ON
TABLE FILE CAROLAP
SUM CAROLAP.BODY.DEALER_COST
CAROLAP.BODY.RETAIL_COST
BY CAROLAP.ORIGIN.COUNTRY
BY CAR
END
  2. Open the OLAP Control Panel.
  3. Double-click on the Country field in the Drill Down panel of the OLAP Control Panel. In the resulting window panel, select the Hide check box.
  4. Click OK.

    Notice that the color of the sort icon has been reversed. The Drill Down panel now appears as shown in the following image.

WebFOCUS