Automatic migration process

Automatic migration process involves these steps:

  1. The new Schedules (BPDSCHEDULES) dimension is added to the system to replace the usage of schedule attributes in the Schedule Details dimension.
  2. A schedule element in the Schedules dimension is created for each attribute of the Schedule Detail dimension which has the P_ prefix.
  3. The Closing Balance (_CB) parent element is created for each schedule in the Schedule Detail dimension.
  4. If the attribute value of the OPENING_BALANCE element is TRUE, the Opening Balance (_OB) element is created for each schedule. It is assigned to the Closing Balance (CB) parent element in the Schedule Detail dimension.
  5. The assigned details of all elements under the MOVEMENTS element are added under appropriate Closing Balance (_CB) elements in the Schedule Detail dimension.
  6. In the Schedule Details dimension, the OB (Sum of Opening Balances) parent element is added, and the OPENING_BALANCE element is moved under it.
  7. The Unassigned (N.A.) element is moved under the MOVEMENTS element in the Schedule Detail dimension.
  8. The ACCOUNTS OB and the ACCOUNTS NO OB subsets are updated.
  9. After the database is created the data migration starts. All base values with the OPENING_BALANCE detail are deleted from the OPENING_BALANCE element and written to an appropriate Opening Balance (_OB) or Unassigned (N.A.) element.