In this section we are going to build the Operational Chart of Accounts dimensions. All changes are made into staging dimension and synced the FIN OCoA dimension.

Menu: Apliqo Settings / Chart of Accounts

Building the OCoA Rollup from File

In this example we are going to load the OCoA sample file into the Chart of Accounts.

Add the Natural Accounts from ODBC Source

In this example we are going to load the natural accounts from an ODBC source. The query lists the natural accounts and their direct parent element in the in the OCoA rollup loaded in the previous section. The query included the attribute information for the natural accounts.

Using the SQL query statement:

Select * from [vw.dim.coa]

Reviewing the rollup.

The changes to the rollup can be review in the Operational CoA page.

Unwind the rollup

To allow for changes in the rollup we need to unwind the rollup before rebuilding the rollup for the data source. In the above example we are updating the rolling in two automation steps. Each step can unwind the rollup however we only need to unwind the existing roll once.

In the first step that builds the rollup the Rebuild Option should be set to Unwind and Unwind Consolidation should be the top element of the rollup that is being built.

Subsequent Automation step that rebuild the rollup should use the Rebuild Option of Add Component Only.

Set the Fixed Accounts

We have only load the Operational Chart of Account to the Chart of Account staging area. Before we can build the FIN OCoA dimension we need to map some Fixed Accounts.

There are a number of fixed accounts that can be mapped to your Opearational Chart of Account. They are used for reporting, planning and KPI calcuations. Before we can build the FIN OCoA dimension the compulsory Fixed Accounts must be mapped to the Operational Chart of Account.

Once the Fixed Accounts have been mapped the Automation can be set to Update Flags in the Operational Chart of Accounts.

Syncing the FIN OCoA dimension

Syncing the dimension is when we take what we have build in the staging dimension and apply to the actual FIN OCoA dimension.

Build the Operational Chart of Account (FIN OCoA) dimension

Click on the [Process CoA Update] button to build the FIN OCoA dimension.

All Active Steps should be selected. Click on [Process CoA Update] to execute.

Manually adding Accounts

Next we are going to add statistical accounts to the Chart of Accounts.

Repeat the process and add the following statistical accounts.

• Quantity Unconsolidated

• Memory Shipped in GB Consolidated

• Memory Shipped in GB Unconsolidated

Click [Sync Dimension] to update the FIN OCoA dimension.