Carry-Forward Rule

Carry-forward rules enable you to generate the Opening Balance of any category based on the following properties:

• Flow_Type in the Flow dimension: the value of this property should be OPENING on the relevant Opening flow and CLOSING in the relevant Closing flow.

• Category_for_ope, Opening_year, Opening_period in the Category dimension

  Carry-Forward rules can be used to initialize a new reporting period with the closing balances of the last period from the previous year into the opening balances of the current period. It can also copy closing balances from a designated year ( Opening_year property) and period ( Opening_period property) to the current period. The designated year and period can be an absolute or relative number. You can also specify a Category in which to store the closing data using the Category_for_ope property. For example, you may need to create opening data in a Budget category using data from a Forecast category.

• DataSrc_Type, Opening_Datasrc, Copyopening in the Audit dimension

  Currently this procedure is limited to copying the opening balances as found in the Audit dimension members flagged as I and M in the DATASRC_TYPE property. The procedure copies only the input balances and their related manual adjustments. The balances generated automatically by the consolidation procedure ( Audit members flagged as A) are taken into account during the consolidation process by the consolidation procedure itself.

  The Copyopening property enables you to identify the members on which the carry-forward rule should be executed.

  The Opening_Datasrc property enables you to post data on a specific datasource when running the Carry-Forward rules.

• Within a carry-forward rule, the field Account specifies the Destination account. The property Same_period enables you to copy the same period balances to the current period. The YTD property enables you to sum up the balances of YTD to the current period.

In a legal consolidation model, such flows are often identified as members of a dedicated dimension. In simpler models, however, it is also possible to store them as additional accounts in the Account dimension.