Lock Rows and Columns – Select this option to “lock” captions and level related data in rows and columns when scrolling through view results. Captions for levels, attribute relationships, and measure items will remain visible and locked in position at all times as you scroll through a view to look at measure item values. In the following example, items in the areas marked by the letter A will remain in a locked and visible position as you scroll up, down, left, or right to see the rest of the level members, Actual Sales Amount, and Percent of Total data in the view (the area marked by letter B).

Use Paging – Select this property to display the view results a page at a time. In the example above, up to 50 rows and 10 columns will display per page. You can customize a view’s page size with the Override View Page Size property.

Override View Page Size – Select the property if you want to customize the page size for this view Enter a numeric value in the Rows and Columns fields.

Show Grid - Use this property when working with charts. Deselect the property to No to hide the grid and only display the chart.

Show Grid Lines – Select the property if you want borders displayed.

Presentation Format - Use to change the format in which the view displays. When Viewer is selected, the view displays in the traditional grid format. When Excel is selected, the View Definition window will display in the background while the view opens as an MS Excel file. A File Download window will prompt you to open or save the file.

Data – Select or deselect options in this part of the window to determine whether or not totals, All Others data (related to filtering), and repeating labels will show on rows and columns.

• Show Totals – Use to show or hide Totals for all levels on an axis. Select the property for an axis to display totals for all existing levels on the axis. By default, all levels added to the axis after this change will also have totals enabled for them by default. Deselect the property for an axis to hide totals for all existing levels on the axis. In that case, all levels added to the axis after this change will have totals disabled by default.

• Show All Others – Use to show or hide All Others values for an axis. Select the property for an axis to display the values for all levels on the axis. By default, all levels added to the axis after this change will have All Others values enabled for them by default. All Others data summarizes the values for items that are excluded from filters on levels. Deselect the property for an axis to hide the values for all existing levels on the axis. In that case, all levels added to the axis after this change will have All Others values disabled by default.

• Repeat Item Labels – Use to show or hide duplicate axis values in the grid. Select the property for an axis if you want to see the following values repeated across axis detail cells in the grid: level display text, level attribute relationships, headings for All Others (if Others Summary is enabled), sub-totals, and grand totals. Deselect the property if you do not want such details repeated.

OK / Cancel – Use buttons at the bottom of the window to refresh a view with your changes or cancel changes. Save the view if you want your display changes to be retained for the next time the view is run.