Interface Service performance improvements

Interface Services are updated to improve general performance for transferring transactional data from SCV. The interface query is modified to remove links to the hierarchy tables based on the hierarchy type (_H) and link to the profile view tables (SC_V_) for the main table of the interface.

This applies to all standard Interface Services where the Type is Database and Data Entity is Scenario value.

Example:

  • DPLS - SCV - Import Budget Measures (Prices). Removed these links from the interface query:
    • and HL.hierarchy_type = 'LOCATION'
    • and HI.hierarchy_type = 'ITEM'

This feature is enabled after appending the base template (base.zip) and the demand planning template (dpls.zip) for this version.

Note: By default, this feature is enabled. No additional role or privilege is required to access this feature.