MicroStrategy ONE

How to Control the Number of Grid Rows and Columns

You can limit the number of rows and columns that can be displayed at the same time in a report, to help improve performance in MicroStrategy Web. If the report contains more rows or columns than Web can display at one time, users can use the incremental fetch icons Previous page icon Next page icon to view additional data.

How to Control the Number of Grid Rows and Columns

  1. Log in to a project using an account with administrative privileges.

  2. From the upper right of any page, click the username drop-down and select Preferences. The Preferences page opens.

  3. From the pane on the left, select Project Defaults.

  4. From the pane on the left, select Grid Display. The Grid Display project defaults page opens.

  5. Enter the maximum number of grid rows that can be displayed at once in the Maximum rows in grid field. If a report has more rows than the number entered here, users can use the incremental fetch icons Previous page icon Next page icon to view additional data. The default value is 50.

  6. Enter the maximum number of grid columns that can be displayed at once in the Maximum columns in grid field. If a report has more columns than the number entered here, users can use the incremental fetch icons Previous page icon Next page icon to view additional data. The default value is 10.

  7. From the drop-down list at the bottom, select one of the following:

    • To apply the changes to the current project, select Apply to current project.

    • To apply the changes to all the projects you have access to that are stored on the Intelligence Server, select Apply changes to all projects on the current Intelligence Server.

  8. Click Apply.

Related Topics

How to Access Project Defaults and User Preferences

Grid Display Dialog