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.
[attachment=103283:name]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 DataClick 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.
Recommended Comments
There are no comments to display.