MicroStrategy ONE
Grid Display Preferences
The Grid display preferences section allows you to personalize some display options for your grid reports, such as the number of rows and columns to display. You can also specify what features you would like to access in your grid reports.
- Click your user name and select Preferences from the drop-down list.
- Select Grid display. The following options are available:
- Grid style: Select one of the following
options from the drop-down list to specify the grid style to use with
reports in Web:
- Use the format stored in the report definition (default): Reports are displayed using the grid style specified in the report definition by the designer of the report.
- Use my selected default grid style: Your selected default grid style (see the Default grid style option below) is applied to all reports in Web. If you choose to use a selected grid style, you will not be able to change any formatting on any of the reports that you run.
- Default grid style: Select a grid style from the drop-down list to be the default grid style for all reports. The default grid style is used for all reports that are run in Web if the Use my selected default grid style option is selected.
- Maximum rows in grid: Limit the number of rows displayed on your report at one time. If your report has more rows than the number entered here, you can use the incremental fetch icons or to view additional data. The default value is 50.
- Maximum columns in grid: Limit the number of columns displayed in your report at one time. If your report has more columns than the number entered here, you can use the incremental fetch icons or to view additional data. The default value is 10.
- Show attribute form names: Format
the display of headers for attributes and attribute forms in a grid.
For example, you can choose to have a header automatically displayed
for each attribute in the grid, with each header containing the attribute
name. The following options are available:
- Yes: Select this option to have headers automatically displayed for each attribute or each attribute form depending on the number of attribute forms visible in the grid for each attribute. If only one attribute form is shown in the grid for an attribute, the attribute is displayed with a header containing the attribute's name. If more than one of the attribute's forms are visible in the grid, each attribute form is displayed with a header containing the attribute name followed by the attribute form name.
- No: Select this option to have the attribute name automatically displayed in the header of each attribute in the grid. No attribute form names are included in the grid.
- Read from report (default): Select this option to allow individual grid or grid report settings to determine how attribute or attribute form headers are displayed. For steps to format how headers are displayed in a grid report, see the Advanced Reporting Help. For steps to format how headers are displayed in a grid in a document, see the Document Creation Help.
- Show pivot buttons: Show or hide pivot buttons on all your reports. This checkbox is cleared by default.
- Show sort buttons: Show or hide sort buttons on all your reports. This checkbox is cleared by default.
- Show unused attributes in page-by panel: Determine whether attributes in the report that have not been added to the grid report are automatically added to the page-by panel when the report is executed.
- Display empty grid axes in view mode: Show or hide a grid report when objects do not exist in the rows. For example, you have a report that does not contain objects in its rows, but has objects in the columns. If this checkbox is selected, an empty grid is displayed in the part of the report in which there are no objects, in this case, the rows. The empty grid may display messages similar to the following: "Drop objects here to add rows." If this checkbox is cleared, only portions of the grid that contain objects (in this case, the columns) are displayed. This checkbox is selected by default.
- Enable sorting by attribute forms that are not displayed on the grid: Determine whether you can sort according to attribute forms that are not displayed on the grid. For example, the ID attribute form for the Category attribute is displayed on a report, but DESC is not. If this checkbox is selected, you can still sort the report based on the DESC form even though the DESC form is not present on the report. This checkbox is selected by default.
- Automatic page-by: Determine whether a new page of information displays immediately after you select a choice in a page-by drop-down list. If this checkbox is cleared, you must click the Apply icon to see the new information after making a selection. This can be useful if there are multiple page-by drop-down lists and you want to select several before clicking the Apply icon only once. This checkbox is selected by default.
- Show page-by axis by default: Determine whether to show the Page-by panel by default whenever reports are run.
- Use images for depicting expand and contract in outline mode: Use this setting to adjust the expand and contract symbols in Outline mode. If the expand and contract images do not appear correctly in Outline mode, clear this setting. This checkbox is selected by default.
- From the drop-down list, determine which projects to apply the changes to.
- Click Apply.
To reset all preference settings, click Load Default Values.