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.
Doing Drill Down operation
To do the Drill Down operation just click on a member that has a plus symbol on it (). It will modify the Olap Table showing Children contained in the clicked Member. It will automatically change its icon for the "
" symbol.
Members that have a "" icon on its label are Leafs, and you won't be able to do a Drill Down on them.
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 "" 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 button on the Toolbar . It will automatically change the axis of the Table.
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.
Result:
The result of this operation is the elimination of the selected Member.
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.
Result:
The result of this operation is the elimination of the selected Members.
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.
Result:
The result of this operation leaves the selected Members and eliminates the rest of them.
Doing Dice operation
To do a Dice operation, open the "Dice Cube" panel at the right side of the window or click on the 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.
.
Doing Slice operation
To do a Slice operation just use the Navigator Panel (Click on the panel or active it by clicking on the button 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.
Adding or removing measures
To add or remove a Measure from the Olap Table, go to the "Measures" panel or click on the 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.
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.