In this section we are building the Operational Chart of Account dimension in Apliqo FPM. To start, access the Chart of Accounts setup through the page: Administration > Chart of Accounts.

Building the Management Trial Balance

Step 1: Loading the Management Trial Balance rollup

We are going to start building the Balance Sheet rollup excluding the natural accounts. You will need to download this Balance Sheet file to be uploaded in the walk through.

Step 2: Adding the natural accounts from an ODBC source

Next, we are going to create an automation step that load the natural accounts from an ODBC source using the SQL query statement:

Select * from [vw.dim.coa]

The query returns the natural accounts and their direct parent account code that is in the Balance Sheet rollup loaded in the previous section. The query includes the attribute information for the natural accounts.

Unwind the Business CoA rollup.

To allow for changes in the rollup we need to unwind the rollup before rebuilding the rollup for the data sources. 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. This is where order of the automation steps is important.

In the first step, Load Operational Chart of Account Hierarch, change the Rebuild Option parameter to be Unwind. The Unwind Consolidation parameter should be the top consolidation of the Business CoA in the Operational CoA. In this case 9999 - Total - All Accounts Total.

Subsequent automation steps should use the Rebuild Option parameter value of Add Component Only.

Syncing the FIN OCoA dimension

Finally, we have built the Operational CoA in the staging area.

Add an automation step to sync the 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 button to execute.

Syncing the Accounts

Whenever the Operational CoA does not agree with the FIN OCoA dimension a warning icon will appear on the Operational CoA tab. Click the Process CoA Update button to sync the FIN OCoA dimension with the staging area.

Adding accounts

Accounts and Consolidations can be manually added to part of the Operational CoA that is not managed an Automation step. In this example, are going to add statistical accounts to the Operational CoA.

Repeat the same steps to add the following statistical accounts.

• Quantity Consolidated

• Quantity Unconsolidated

• Memory Shipped in GB Consolidated

• Memory Shipped in GB Unconsolidated

Click Process CoA Update button to update the FIN OCoA dimension.

Moving accounts (Map).

The statistical accounts, Quantity Consolidated and Quantity Unconsolidated can be summed up into a consolidated element called Quantity using the Map function.

Remap the Memory Shipped in GB Consolidated and Memory Shipped in GB Unconsolidated statistical accounts to a new consolidation Memory Shipped under the Statistical Accounts rollup.

Adding the Cash Flow rollup

Now that we have built the Operational Chart of Account we can add the Cash Flow rollup. Here is the source data file: .

More Information