Defining the sign for data entry pages and reports

Use the Report Display tab to specify the sign for displaying the values in data entry pages and reports. You can specify a different sign than the sign used to store the values.

Users specify data in data entry pages according to the sign defined on the Report Display tab. For example, if a data entry page displays expenses as positive numbers, the user specifies the values as positives. The sign is changed when the data is written back to the cube.

You can also define how financial variances display in reports. You can specify, by account type, how increases or decreases display. For example, specify whether the favorable variances display as positive numbers or negative numbers (by account type). On the Report Display tab, the example balance sheet and profit and loss statement are adjusted to show how a report looks according to your selections.

As you make changes in the Define How Values Display in Reports section, the 2014 and 2015 columns (columns 1 and 2) in the Balance Sheet, and Profit and Loss Statement examples show the effect of your changes.

As you make changes to the Define How Variances Display in Reports section, the Change, % Change, and Comparison columns (columns 3, 4, and 5) in the Balance Sheet, and Profit and Loss Statement examples show the effect of your changes.

  1. In Financial Consolidation, select Parameterization > Group Parameterization > Global Sign Definition.
  2. Click the Report Display tab.
  3. In the Define How Values Display in Reports section, select the sign to use when displaying data for each account type.