Setting Grid Display Options

You can select whether to display data, calculation status, or process review levels in data grids. The calculation status indicates, for example, whether data needs to be calculated, translated, or consolidated. The review levels indicate the process management level for combinations of data called process units. You can easily toggle between the data and the calculation status and review level. The data grid automatically refreshes to reflect changes.

See Viewing Calculation Status and Viewing Process Level.

You can also select whether to display metadata labels, descriptions, or both. When you enable descriptions, they are displayed in the language that you specified in the User Preferences dialog box. If you select to view both labels and descriptions, the dimension member is displayed as “Label - Description.” For entities, the member is displayed as “Parent.Entity - Description”, where Description is the description of the entity, not of the parent entity.

In addition, you can select a scale value to determine how data is displayed. For example, if the U.S. dollars currency (USD) is defined with a scale of 3, an amount of 300,000 USD is displayed as 300.

To set grid display options:

1. Open a data grid.
2. For Cell, select an option:

   • To show calculation status, select Calculation Status.

   • To show data, select Data.

   • To show process review level, select Process Level.

3. For Row suppressions, select one or both options:

   • To suppress cells that do not contain data, select Suppress No Data.

   • To suppress cells that contain zero values, select Suppress Zeros.

   Note:

   The data grid suppression options work with base level members, but do not apply to parent members.

4. For Metadata, select an option:

   • To display metadata labels, select Label.

   • To display metadata descriptions, select Description.

   • To display both metadata labels and descriptions, select Both.

5. From Scale, select a scale value, or use the default scale defined for the currency assigned to the entity.
6. For Page Size, set these options:

   • Enter a Columns Per Page value, or use the default value of 128.

   • Enter a Rows Per Page value, or use the default value of 1024.