The navigation table appears at the top of the OLAP view (Foodmart Sample Analysis View). It shows the data that is retrieved by the current MDX query, which appear in both the main view and in drill-through tables.
|
Icon |
Name |
Description |
|
|
Expand Position |
Expands rows at a specific hierarchy member. |
|
|
Collapse Position |
Collapses rows at a specific hierarchy member. |
|
|
Expand/Collapse Member |
Synchronizes the expansion or contraction of rows across all hierarchy members when they are clicked.
|
|
|
Zoom In/Out |
Click hyperlinked hierarchy members to replace the current table with a sub-table that depicts the selected member. This option is only available when Zoom on Drill is enabled. |
|
Zoom Out All |
Restores the navigation table to its initial view after having zoomed. This option is only available when you’re in Zoom on Drill mode. |
| Show Source Data |
Click hyperlinked fact data to display additional columns from that specific fact data. The following drill-through table shows the drill-through of Total Unit Sale for Alcoholic Beverages. For more information about the drill-through table’s options, refer to Drill-through Table.
|
|
|
|
Natural Order |
Located next to measure labels, indicates that the navigation table is sorted according to the order of hierarchy members. Click it to change the sort order. |
|
|
Ascending |
Located next to measure labels, indicates that the navigation table is sorted according to their numeric value, from smallest to largest. Click it to change the sort order. |
|
|
Descending |
Located next to measure labels, indicates that the navigation table is sorted according to their numeric value, from largest to smallest. Click it to change the sort order. |
|
|
Expand All |
Located near the top-left corner of the navigation table, expands all of the currently displayed members (all those that display the plus sign) to the next level of detail in the hierarchies. This can be selected repeatedly to expand all levels of detail. This option is only available when Zoom on Drill is not active. This operation is limited by the memory available to the application server that hosts JasperReports Server. It stops expanding members when this limit is reached. |
|
|
Collapse All |
Located in the top-left corner of the navigation table, collapses the navigation table to its initial view. |
