19.5 Extracting the maximum version of ML balances

To extract maximum version of ML balances for a given contract and CoA combination, follow these steps:
  1. Navigate to Data Extraction Summary page to edit the Sys ML Balance Extract OOTB connector. Add the filter expression [Management Ledger Period Balance].[Run Identifier] = '#DIH.runskey' and [Management Ledger Period Balance].[Effective Date] = '#DIH.MIS_DATE' on Effective Date and Run Identifier of Management Ledger Period Balances entity and save the connector definition.

    Note:

    To extract the latest balances, execute the following pipelines:
    • Execute the Balance Computation Management Ledger Incremental Results Area Load pipeline and then execute the incremental named extract connectors.
    • For the Sys ML Balance connectors such as Sys ML Balance Extract as of Date and Sys ML Balance Extract as of Effective Date, the filter expression to extract the latest balances is - [Management Ledger Period Balance And Movement].[Run Surrogate Key] - '#DIH.WF_OBJECT_ID' .

    Note:

    For the Data Quality Error Report extract connector, the filter expression to extract the latest error records is - [Data Quality Error Records].[Run Surrogate Key] = '#DIH.WF_OBJECT_ID'.
  2. Create a custom PMF with a data service linked to the connector.

    Note:

    For more information on Connectors, see the Connectors section.

    Note:

    For the Data Quality Error Report connector, in a custom PMF, follow the sequence as adding the DQ component, and then the DQ Reporting Engine, and finally linking them to the connector component.
  3. Edit the Data service and select the data service name as Integration Management Ledger Periodic Balances.

    Note:

    Select the data service as RA Management Ledger Period Balance Movement for the connectors Sys ML Balance Extract as of Date and Sys ML Balance Extract as of Effective Date.
  4. Edit the connector and select the Sys ML Balance Extract OOTB connector. Enter the MIS_DATE runtime variable expression as MIS_DATE = $MISDATE:dd-MMM-yyyy and save the custom PMF pipeline.
  5. Execute the custom PMF pipeline with a MIS_DATE.

    Note:

    Selecting the Hierarchy parent will be available only for this out-of-the-box extract.