Release 93

by

Release 92 absorbed in DEV Pipeline Release validation

1. BusOpp (EUR & NA) – Structural Refactor

Views affected

  • busopp_core_details_EUR / NA
  • busopp_item_values_EUR / NA
  • busopp_meta_codes_EUR / NA
  • busopp_meta_dates_EUR / NA

What has changed

We have refactored the MP8 / MP9 source logic to remove duplicated transformation code and consolidate the sources via an early UNION pattern.

The primary driver was identification of multiple editions of the same opportunity appearing across reporting periods in the supplied spreadsheets. The revised logic:

  • Reduces duplication between MP8 and MP9 tables
  • Improves identification of Opportunity Numbers across periods
  • Removes repeated opportunity references caused by historic spread
  • Simplifies transformation layers (DRY principle applied) Don’t Repeat Yourself

Expected impact

You may observe changes in item values where duplication previously inflated totals.
This is a correction of structural duplication rather than a change in business logic.

Performance and maintainability are materially improved.

2. Customer Core – JSON & History Stabilisation

Views available

  • customer_core_details (cvw)
  • customer_core_details_export (evw)
  • customer_core_details_UKS

What has changed

  • Fix applied to malformed JSON caused by cust.COUNTRY.
  • Full rebuild of core history logic for consistency.
  • Customer core now aligned across:
    • Collated view (cvw)
    • Export view (evw)

Expected impact

  • Stable JSON payloads.
  • Improved historical integrity.
  • Cleaner export structure for API / downstream use.

3. Global Company – CDM Pattern Alignment

Views introduced

  • global_core_details_company
  • global_core_details_export_company

The previous global.company has been formalised into CDM Core pattern and made available in export form.

  • OBJECT_CLASS set to 9900 to identify global configuration entities.
  • Available in both internal (cvw) and export (evw) formats.

This establishes consistent modelling of global configuration entities going forward.

Leave a Comment