...
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.
...
Code Block |
---|
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.
...
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.
...
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.
...