Navigation Table

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.

Navigation Table Icons and Options

Icon

Name

Description

[attachment=103280:name]

Expand Position

Expands rows at a specific hierarchy member.

[attachment=103281:name]

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.

[attachment=103282:name]

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.

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.

[attachment=103284:name]

[attachment=103285:name]

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.

[attachment=103286:name]

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.

[attachment=103287:name]

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.

[attachment=103288:name]

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.

[attachment=103289:name]

Collapse All

Located in the top-left corner of the navigation table, collapses the navigation table to its initial view.