Setting Display Options

You can select whether to display the data, the calculation status, or the process review level of the data 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 any changes.

See Viewing Calculation Status and Viewing Process Level.

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

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

  To set display options:

  1. Open a data grid.

  2. Click Grid Settings and select Display Options.

  3. 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.

  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. For Row Suppression, 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 Zero.

  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.

  7. From Scale, select a scale value, or use the default scale defined for the currency assigned to the entity.

  8. When you finish selecting display options, click OK.