Defining the sign for data entry pages and reports

Use the Global Sign Definition page 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 data values.

Users specify data in data entry pages according to the sign defined on this page. For example, if a data entry page displays expenses as positive numbers, the user specifies the data 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 set, by account type, how the increase or decrease displays. For example, should the good variances display as positive numbers or negative numbers (by account type). The example balance sheet and profit and loss statement adjust based on your selections to show how a report looks depending on 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 example show the effect of your change.

As you make changes to the Define How Variances Display in Reports section, the Variance and % Difference columns (columns 3 and 4) in the Balance Sheet example show the effect of your change.

The Benchmark column (column 5) in the Balance Sheet example is based on the account type and does not change based on any selections on this page.