Banner1

Navigating and manipulating the Olap Table and Chart

When you have started your analysis two components are displayed: the Olap Table and Chart.

In the Olap Table you will find all the information contained in your Cube Schema represented as a dinamic table. In this object you can do all type of navigations like: Drill Down, Roll Up, Pivot and an additional operation which is Delete Members.

table

Doing Drill Down operation

To do the Drill Down operation just click on a member that has a plus symbol on it (plus). It will modify the Olap Table showing Children contained in the clicked Member. It will automatically change its icon for the "minus" symbol.

Members that have a "circle" icon on its label are Leafs, and you won't be able to do a Drill Down on them.

Drill down

Doing Roll Up operation

Is almost the same as do a Drill Down operation, except in this case you have to do click on the Members that have a "minus" icon on it.

 

Doing Pivot operation

To do the Pivot operation just do click at the top left corner of the Olap Table or click on the pivot button on the Toolbar . It will automatically change the axis of the Table.

Pivot

 

Manipulating Table Members

To delete a single member select it doing right click, press the Mouse Wheel button to display the "Delete Member" popup menu, and then click the option.

Delete Member

Result:

The result of this operation is the elimination of the selected Member.

Result

To delete a Members group select them having the CTRL key pressed, when you have your selection done press the Mouse Wheel button to display the popup menu and then choose the "Delete Members Selection" option.

Delete Member Selection

Result:

The result of this operation is the elimination of the selected Members.

Result Mem Selection

To hold a Members group select them having the CTRL key pressed, when you have your selection done press the Mouse Wheel button to display the popup menu and then choose the "Hold Members Selection" option.

Hold Member Selection

Result:

The result of this operation leaves the selected Members and eliminates the rest of them.

Result Hold Member Selection

 

Doing Dice operation

To do a Dice operation, open the "Dice Cube" panel at the right side of the window or click on the dice button , then choose which member will be the restriction to your Query.

NOTE: To do a Dice operation you most have at least one Dimension that doesn't exist on your Analysis, that is to say a Dimension that is not on your Olap Table.
.

Dice

 

Doing Slice operation

To do a Slice operation just use the Navigator Panel (Click on the panel or active it by clicking on the navigatorbutton in the toolbar), which allows you to aggregate or remove any Hierarchy from the "ON ROWS" or "ON COLUMNS" lists.

Choose the new Hierarchies you would like your analysis have, or remove which you don't want in your analysis, and press the "Start Analysis" button again. It will restructure the Olap Table automatically.

Slice

 

Adding or removing measures

To add or remove a Measure from the Olap Table, go to the "Measures" panel or click on the measures button and select which Measure you want (or not) to display, by clicking on their checkboxes. .

NOTE: There must be at least one Measure selected.

Measures

 

Chart

An important component of the analysis is the Chart object. In this useful component is shown all info contained in the Olap Table, making easier the analysis and decision-making. You will be able to change the type of chart to a variety of graphics by clicking on the combo box list above.

In addition, you can customize and save the Chart by doing right click on the component and selecting one of the options shown.

Chart