1. User Guide
  2. Object Management
  3. Modifying the Precision of Balance Columns In Ledger Stat

3.10 Modifying the Precision of Balance Columns In Ledger Stat

Steps to modify the Precision
  1. Open the ALM, FTP, or PFT model using All Fusion ERwin Data Modeler.
  2. Switch to ALM-FTP-PFT-HM-BSP – Ledger Stat subject area.
  3. Select Logical view.
  4. Edit the Ledger Stat table by double clicking the table in the Logical Layer.
  5. Change the data type in Datatype tab to the revised precision and scale (example, NUMBER (22, 3)) for the following columns:Month 01 Amount, Month 02 Amount, Month 03 Amount and so onYTD 01 Amount, YTD 02 Amount, YTD 03 Amount and so on.
  6. Save the changes.Select the Physical view.
  7. Click LEDGER_STAT table and view the datatype of columns – MONTH_01 till MONTH_12 and YTD_01 till YTD_12. The data type of these columns should display the new precision and scale.
  8. Save the model as xml in All Fusion Repository Format.
  9. Perform incremental model upload.NOTEIn case, users decrease the precision and scale for the columns, such columns should not have any values during model upload.