The layout of the dimension columns in a navigation table is configured using these options:

Show all parent columns

The Show all parent columns check box displays a header for every dimension column. When the check box is cleared, all the columns are collapsed into one; the rows of that column have the same hierarchy as the separate columns. For example, in “Comparing Layout: All Parent Columns and No Parent Columns”, the All parent column view has separate columns for STORE, STORE COUNTRY, and STORE STATE. The No parent view has only one column; the topmost header is STORE, then ALL STORES, then USA, then the individual states.

Show all parent columns is often used with Zoom on Drill to provide complete context after zooming in.

Show individual parent cells

The Show individual parent cells check box determines whether redundant dimension hierarchy member labels are displayed or hidden. The check box takes effect when the Show all parent columns check box is checked. The following figure shows the example in “Comparing Layout: All Parent Columns and No Parent Columns” with Show individual parent cells selected. This view is useful when outputting the table to an Excel spreadsheet so that headers appear on every page. It also prevents cell-spanning and the empty cells that can result.

Hide Empty Rows/Columns

Clicking toggles between showing and hiding rows that do not have a value for the selected measures. By default, all rows of measures display, even when they have no value.

Swap Axes

Clicking changes the orientation of a navigation table by switching the columns with the rows—each column becomes a row, and each row becomes a column.

Suppose a table contains five dimension rows and two measure columns. Clicking changes the orientation of the table so it has one measure row and five dimension columns.