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 and attribute relationships 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 - Yes means the view uses paging, and Stratum.Viewer will display view results a page at a time. Default page size properties in the application control the number of rows and columns. 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. Change the Use Paging property to No to show all rows and columns on a single page.

Note: Showing all rows and columns rather than using paging can result in delays when refreshing a view depending on the amount of members and data in the view.

Override View Page Size – When set to Yes, you can control the page size for this view. Enter a numeric value in the Rows and Columns fields.

Show Grid – Use this setting when working with charts. Change the setting to No to hide the grid and only display the chart.

Use the following set of properties to customize the look of the grid including background color, borders, and fonts. Examples of ways to customize the grid format are shown in Customizing The Grid Formatting For Views:

• Use Viewer Defaults – If you want to use the default grid formatting that was set up by your administrator, select the Use Viewer Defaults checkbox.

• Base Color – The fill color for all cells in rows and columns.

• Alternating Row Color – A secondary fill color used for every other row in grid.

• Total Row Color – The fill color for subtotal and grand total rows and columns.

• Border Color – The color for borders in the grid. You can give the grid an appearance of having no visible borders by setting this Border color to be the same as the Base color for the grid. That will make the borders blend into the grid background. For example, make borders white if the Base color is white.

• Data Captions Font – The font, font size, and font color used for captions of measure items, levels, and attribute relationships in the grid.

• Data Values Font – The font, font size, and font color used for values of measures in the grid.