Cortex Framework
Changed
- 1-Click Deployer: 1-Click deployer now deploys the Sustainability module when SAP ECC or S/4 is selected.
- SAP:
- The CDC script now considers the
L
flag alongsideI
andU
when determining which records are updated in the raw dataset. This is to account for situations where the pipeline is somehow re-configured after data load, but the CDC dataset can still be reused to avoid re-processing existing data. - Column names in
StockInHand
views (ECC and S/4) forMATNR
andWERKS
have been aligned with other views to beMaterialNumber_MATNR
andPlant_WERKS
. Previous column namesArticleNumber_MATNR
andSite_WERKS
still exist for compatibility reasons, but will be removed in a future release. Customers are advised to change their upstream consumption assets accordingly. - Column names in
SalesOrders_V2
views (ECC and S/4) forERDAT
andERZET
have been aligned to new namesSalesDocumentCreationDate_ERDAT
,SalesOrderItemCreationDate_ERDAT
,SalesOrderCreationTime_ERZET
andSalesDocumentItemCreationTime_ERZET
to account for the correct granularity of their source table (eitherVBAP
orVBAK
) . Previous column namesCreationDate_ERDAT
andCreationTime_ERZET
still exist for compatibility reasons, but will eventually be removed in a future release. Customers are advised to change their upstream consumption assets accordingly. Also, Sales Order Item level calendar dimensions are now added by default. - Column names in
Deliveries
view forVGBEL
,VGPOS
, andXBLNR
are updated toInternalReferenceDocumentNumber_VGBEL
,InternalReferenceDocumentItem_VGPOS
ExternalReferenceDocumentNumber_XBLNR
for more clarity. Previous column namesSalesOrderNumber_VGBEL
,SalesOrderItem_VGPOS
, andReferenceDocumentNumber_XBLNR
still exist for compatibility reasons, but will eventually be removed in a future release. Customers are advised to change their upstream consumption assets accordingly. - Sales Order Item level calendar dimensions are now added by default.
- In
AccountingDocuments
view as well as the downstreamAccountingDocumentsReceivables
views,DoubtfulReceivables
, andDaysInArrear
metrics are now positive instead of negative to align with official SAP guidelines. SalesFulfillment
andSalesFulfillment_PerOrder
views are updated to useSalesOrders_V2
instead ofSalesOrders
view as their upstream source for both ECC and S/4. The view signatures are unchanged.- ERD for both ECC and S/4 have been cleaned up and updated based on the latest changes.
- The CDC script now considers the
- Marketing: Cortex for Meridian reporting views adapted to TikTok, Meta, and YouTube (DV360) to focus on top of the funnel marketing campaigns. Search Ads data is skipped from aggregates as higher quality data is now available from Marketing Mix Modeling (MMM) Data Platform.
Fixed
- SAP:
Qty
field data type inStockInHand
views (ECC and S/4) has been changed fromSTRING
toNUMERIC
.- Currency conversion and currency decimal shift in
PurchaseDocuments_Flow
views (ECC and S/4) now align with the logic implemented in all other SAP reporting views. - Fixed incorrect GR quantity caused by an incorrect
JOIN
condition. - Removed an excessive
LEFT JOIN
in the Unit of Measure Function and View Utility code to avoid possible duplicate rows. - Cleaned up unnecessary date casting and
ORDER BY
clauses in some views to improve performance.
- Salesforce (SFDC):
- Currency conversion logic is now updated to account for possible source
currency fields that are not corporate currency in the objects
(for example,
Opportunities
). - Updated ERD to include proper linkage to calendar dimension.
- Currency conversion logic is now updated to account for possible source
currency fields that are not corporate currency in the objects
(for example,
Deprecated
- SAP: The views
GLDocumentsHdr
andRegionsMD
are now removed as they are no longer relevant.
Issue
- Oracle builds may time out when using a private worker pool created with default parameters.
Announcement
Release 6.3.2
Source: Google Cloud Platform