WebFOCUS Online Help > Managed Reporting End User > Analyzing Data in an OLAP Report > Three Ways of Working With OLAP Data

Three Ways of Working With OLAP Data

In this section:

There are three ways to work with OLAP data: from the report itself, from the Selections pane, and from the Control Panel. This documentation is organized to help you understand what you can do from each location and which method is most suitable and efficient for your particular OLAP settings.


Top of page

The Report

You can perform a wide range of basic analytic functions from the report itself. Changes you make in the report are implemented instantly. Every OLAP user can perform these tasks:

For an illustration of report-powered OLAP analysis, see We Do It Every Day: Typical Web Query.


Top of page

Selections Pane

When the OLAP Selections pane is turned on, you can quickly limit the data in the report by selecting specific values for the dimensions in the hierarchy. A drop-down list is available for each dimension. You can multi-select values from one or more dimension lists to refine your report output.

If you wish to add a dimension element to the report you can drag it from the Selections pane into the report frame. (The cursor changes to a + sign to indicate an acceptable location.)

Each dimension has a relational operator button located to its left. This button toggles through a selection of basic numeric operators that enable you to quickly define your selection criteria. The operators are: Equal to, Not equal to, Less than or equal to, Less than but not equal to, Greater than or equal to, Greater than but not equal to. For details, see Selection Criteria Relational Operators.

The following image shows the Equal to operator as the selection for each dimension in the Selection Pane.

The name of the dimension field appears as defined in the Master File, even if an alternate column title has been specified.

In addition, you can customize the display of the measures in your report from the Selections pane. You can click either the Measures or the Graphs arrow in the upper left corner of the pane to list the measures.

Note that the Selections pane is resizable; the controls for dimensions, measures, and graphs float as you resize the report window so that they continue to be visible in the frame.

Five buttons appear below the Selections pane: OLAP, Run, Reset, Save, and Help.


Top of page

OLAP Control Panel

From the Control Panel you can perform every analytic function available to a WebFOCUS OLAP user as shown in the following image.

The main window of the Control Panel contains the following components:

Although the most frequently used functions are available directly from an OLAP report and/or from the Selections pane, several can only be performed from the Control Panel.

Unique Control Panel operations include:


WebFOCUS