...

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.

...

Step 3: 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.

...

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

...