Grid Toolbar

Toolbar Icons -

  • Save and Save As - Click the respective buttons to save the active view or create a new view from the active view. The Save button will be disabled in certain cases, such as for users who are running global views and have a casual or advanced level of access for the application. Those users cannot save changes to global views, but they can use the Save As button to save changed views as shared views or their own personal views.  

  • Display Options  - Click to open the Display Options window. Use it to control properties for the view grid. You can control items such as whether or not row and columns headers are locked, the page size of the view, and the display of totals and all others values. Save the view if you want your display changes to be retained for the next time the view is run.

  • Print - Click to print the active page of the view.

  • Export to Excel - Click to initiate an export of the view and chart to Microsoft Excel.

  • Email View - Click to access the window for emailing views.

  • Change Filters - Click to access the window for adding, clearing, or changing filters.

  • Show / Hide View Explorer - Click to show or hide view explorer. This button does not display if you have a casual level of access for the application.

  • Show Prompt Window - Click to access the View Prompt window for parameters. This button only displays if parameters exist for the view.

  • Insert New Chart - Click to access a wizard for creating charts for the active view.

  • Execute the Update Plan Process  - This icon only displays in the toolbar if the Planning property for the view is set to Yes. After making planning changes in a view, click this icon to update the Analysis Services and Stratum storage databases for your environment with those planning changes.

  • Help  - Click to access help that is specific to working in views.

Paging Controls - Use the rows and columns paging arrows to move between pages of multi-page views. Controls are active only when there are multiple pages on rows and columns respectively.

Show All – Click to display all rows and all columns of the view. This option is only available when paging is enabled in a view and all rows or columns of the view do not fit on a single page. For example, if a view is set up to display 50 rows and 10 columns at a time then the Show All option would display if there is more than one page for the view. The Show All option will be displayed or hidden based on the current state of a view as it refreshes after filtering, drilling, or other changes made by a user.