Intellicus Enterprise Reporting and Business Insights 19.0

Interacting with Crosstabs

0 views June 28, 2020 0

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 arrow button 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 arrow button.

Displaying members of a parent
Figure 16: Displaying members of a parent

To hide child members of a parent (Collapse)

Click arrow button 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 arrow button.

Hiding members of a parent
Figure 17: Hiding members of a parent

Sorting

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 icon: 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 icon: 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 icon: Descending order: It is the order that will represent the data in descending order (Highest to lowest). Click to return to natural order.

sorting effects
Figure 18: Effect of sorting: Natural order, Ascending order and Descending order

Drilling

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 drill down iconappears at top level.  Click to drill down one level.   This will hide parent information and display next level detail.

drill down effects on crosstab
Figure 19: Effect of drill down on the crosstab

drill up icon: 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.

drill up effects on crosstab
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.

Effect of drill down member
Figure 21: Effect of drill down member

Drill up member:  Click arrow icon icon to close the detail of the member and move up one level.

Effect of drill up member
Figure 22: Effect of drill up member