Reference Fiscal Year 

Definition

The fiscal year that is used as the reference characteristic for drilling into the consolidation units of a consolidation group. The reference fiscal year of a report is the fiscal year that is used during the selection of transaction data to determine the (date-sensitive) grouping of consolidation units in a consolidation group.

If the attributes of the organizational units are version and date sensitive, the reference fiscal year is also the year for which the attributes of the organizational unit are determined.

Use

The reference fiscal year determines the fiscal year for which the consolidation group hierarchy and the attributes are read. The latter (consolidation group hierarchy and attributes) are the basis for interpreting the transaction data. The fiscal year determines the fiscal year of the transaction data to be read.

In this case the following applies: The fiscal year must be specified for each cell (or row or column) of the report. If more than one fiscal year is entered, the highest fiscal year specified is used as the reference fiscal year.

The reference fiscal year can only be used in conjunction with the consolidation group, the totals consolidation group or a version and date-sensitive attribute. If the reference fiscal year in a form is determined in the cell definition, instead of in the general selection, the reference fiscal year must then be specified in all cells.

Example

Temporal Restatement in Reporting: Yearly Comparison

You define a form with one coordinate as follows:

Single values

Dimension

Totals consolidation group

Consolidation version

Reference fiscal year

Columns

2 columns with the same key figure

Difference between the columns

Fiscal year 2001 vs. fiscal year 2000

The corresponding report shows transaction data for the two fiscal years in the two columns. However, the report uses the composition of the consolidation group as the basis for the reference fiscal year. If you specify the fiscal year of the first column (2001) as the reference fiscal year, reporting then re-interprets the data of the second column. This means that the data of the second column is selected for fiscal year 2000. However, this is based on the composition of the consolidation group according to fiscal year 2001 - the reference fiscal year. This enables the report to show a drilldown on the characteristic consolidation group that shows a hierarchy for fiscal year 2001.