When you select a cube, the list of dimensions and measures of that cube appear under the Fields tab. You can either double-click or drop the dimension onto the analysis area. This would create a crosstab view with the default measure only if the default view is crosstab, else you must explicitly change the view type.
Moving dimension/measure to column/row axis
For the selected view, you can drag and drop the dimensions onto Column or Row sections as per your design needs. Drag and drop the measure(s) to the Measure box in the right-bottom pane. The crosstab will be re-drawn and newly moved dimension/measure will be displayed onto it. You can also drag and drop Measures from Column to Row.
Removing dimension/measure from column/row axis
Click the cross symbol adjacent to the dimension or measure (on mouse-hover) to remove it from Column, Row or Measure. The crosstab will be re-drawn which will not contain the removed dimension/measure.
You can also drag and drop the dimension out of the view to remove it.
Actions on Crosstab
To display child members of a parent (Expand)
Click on left of expandable member of respective dimension to expand and view child members along with parent. When the list is in expanded state, the button turns to .
Figure 16: Displaying members of a parent
To hide child members of a parent (Collapse)
Click on left of expandable member of respective dimension to collapse (hide) its child members. When the list is in collapse state, the button turns to .
Figure 17: Hiding members of a parent
All column titles have a button on the left of column title indicating the current sort order. Clicking the order button will sort the crosstab in ascending order, then in descending order and back to natural order of values in that column.
: Natural order: It is the order in which data is represented initially i.e. in ascending order of dimension. Click to sort by ascending order.
: Ascending order: It is the order that will represent the data in ascending order (Lowest to highest). Click to sort by descending order.
: Descending order: It is the order that will represent the data in descending order (Highest to lowest). Click to return to natural order.
Figure 18: Effect of sorting: Natural order, Ascending order and Descending order
Drilling down through data involves accessing information by starting with a top level and moving through the hierarchy. It allows you to explore multidimensional data by moving from one level of detail to the next. Drill-down levels depend on the data granularity. For example, you can drill down to see total insured value at country, state or city level.
Drill down level: This symbol appears at top level. Click to drill down one level. This will hide parent information and display next level detail.
Figure 19: Effect of drill down on the crosstab
: Drill up level: This symbol appears at top level. Click to hide the detail opened by drilling down and return to one level up. Drilling up has the same effect as rolling the data up one level or aggregating.
Figure 20: Effect of drill up on the crosstab
Drill down member: Click a member to drill down and view its detail. For example, clicking “Canada” changes the view which shows all states of Canada. If you further drill down British Columbia, you get the list of all cities of British Columbia.
Figure 21: Effect of drill down member
Drill up member: Click icon to close the detail of the member and move up one level.
Figure 22: Effect of drill up member