Creating ZEUS Analyses - Table

Creating OLAP Analyses - Table

First open OLAP Analyses window.

Here a table is set up. You can move columns at will.

The table can be customized by following the procedures described below. Usually, the sequence of procedures does not matter.

Details of Last Cube Processing

Details of last cube processing are located just below title bar.

Measures

Tick the checkbox   or leave it unchecked   to select specific measures.

Example: On the image you can see that only Value is selected.

Take care when selecting measures since not all measures give satisfactory results and information across all levels of individual dimension. Example: Using the Quantity measure (in unit of measure) across all item levels, a chance exists that incompatible data is retrieved ("to compare apples and pears").

Setting up Preferences and Tools

For detailed treatment see Preferences and Tools.

Pivot Table

To generate various analyses, simply drag and drop (using a mouse) individual dimensions from one border to the other. If a certain dimension is not required in the current analysis, eliminate it by dragging it outside the table area (before that you need to open Field list by clicking right mouse button on filters border and choose Show Field List). You can have multiple dimensions listed at the same time.

Click in taskbar to restore dimensions.

Filter Settings

Filter data by clicking column field and selecting corresponding values. That is, click
 
triangle icon to set filter. Selection is done in the same way as in the Parameters panel.

Drilldown

Drilldown can be performd for dimensions currently located at the line border and for those that are on the column border. Drilling down means that you can collapse any dimension member to child attribute items (if they exist) and view detailed data.

That is, click

right oriented triangle icon by the level name (e.g. Primary categories). Then click similar icon by the any dimension member.

On the other hand, clicking down oriented triangle icon

hides child items.

Intersection of Multiple Dimensions

To analyze data by intersection of multiple dimesions, simply follow the procedure desribed under the Pivot Table section and drag them to the line or column borders. Dimensions located together at one border form intersections. Collapse them in a similar way as child items that can be found under Drilldown.

Rollback Initial Settings

Click in taskbar to rollback to pivot table's initial settings (position of dimensions on borders, sets of preferences...).

Pivot table is in an interactive way connected with the chart. Changes made to the table influence chart layout.

PANTHEON Guide:

• OLAP Analyses

Related topics:

• OLAP Analyses