4.3.2 Dimension Member Synchronization
The SYNCHRONIZE_INSTRUMENT procedure synchronizes the dimension member tables
and the hierarchy tables with LEDGER_STAT and instrument tables, using default values
for member descriptions and other information columns. You can then add the correct data
to the new dimension members in AMHM member maintenance. The procedure performs the
following functions:
- Checks the specified table (LEDGER_STAT or instrument) for new dimension members in each of that table's key dimension columns and adds the new dimension value as leaf members to the respective dimension member tables.
- Adds the new dimension member to the corresponding attribute tables with default values for mandatory attributes.
- When new dimension members are added to the dimension tables these members include 'No Description' in the DESCRIPTION column and contain default values for mandatory attributes.
- Reverse populates the newly added dimension members into legacy OFSA tables. During reverse population, new members are created as orphan members, under corresponding hierarchies.
- After the SYNCHRONIZE_INSTRUMENT utility run is completed you should look for any new dimension members using the AMHM member maintenance UI and enter the correct descriptions and other member information. You should also look at the orphan node of each Hierarchy for new dimension members and move these members to the appropriate branch in the rollup.