Account Mapping

Purpose

Account mapping rules are defined to map or copy data from a source dataset, single account, or group of accounts to another dataset, considering the combination of movement and dataset. Account mapping allows mapping a group of accounts to another account or the same source account, and it also enables users to slice a more detailed chunk of the data definition to its dataset and transaction movement. Scenarios using this rule type include building indirect cash flow by mapping balance sheet (BS) and profit & loss (PL) to cash flow.

Prerequisites

Account mapping requires defined dataset, account, and flow type fields based on the tagged model used for this calculation. Account mapping rules read and aggregate values for specific dataset, account, and flow in the Input section and post the aggregated data to the output dataset, account, and flow in the Output section.

Source data for fields other than dataset, account, and flow are identified from rule header filters. Source data for time and version have a special application:

• Time: Input data can be fetched from a different time period than the one specified in the rule filters by using the offset function.

• Version: Input version can be different from the rule filters by using lookup or presetting a specific member.

Other fields can be filtered with Applicable To under the Update List option.

Output data for dimensions other than dataset, account, and flow are identified from calculation filters Post To under the Update List window.

Calculation filters are either passed as Fixed Values, Context Member, or a combination of both.