Content Release Notes 2.2.x (SQL)
Updated 1 week ago
by
Stephanie Krenz
Version & Date | Components | Changes |
2.2.4 2024-02-06 | Root Cause | The values of the columns Root_Cause_Count and Root_Cause_Volume are correctly mapped to the SQL column names |
AM_BaseTable | Use of the latest values from | |
AP_DelayedPayments | c_Cluster | |
AP_InvoiceBeforeVendorCreation | c_Cluster | |
AP_OneTimeAccounts | c_LFB1_ERDAT | |
AR_CreditNoteClearing | c_UpdateKey_AnalyticStep | |
AR_CustomerTurnover | c_UpdateKey_AnalyticStep | |
AR_Discount | Filter for results changed to percentage | |
AR_RoundAmounts | More categories added, individual items with | |
AR_PaymentTerms | Filter for | |
AR_PaymentTerms | c_KNB1_ZTAG1 | |
AM_DepreciationCalculation | Fixed error when | |
AM_DepreciationOver | Use of local currency values for detection | |
AM_NoDepreciation | Use of local currency values for identification | |
Currency Conversion | Return to using | |
AP_DelayedPayments | Calculation of | |
AP_OneTimeAccounts | Filter added to exclude old items | |
Currency conversion | Exclude invalid entries in | |
dab DEAN | Introduction of dab: DEAN for AP, AR, BL, DL, GL, MD, MM, PU, SD | |
2.2.3 2024-01-17 | DL_RootCause | Execute Root Cause AI for nearly every DL Analytic Step |
All DL Analytics | Added missing fields for execution of Root Cause | |
AM_RootCause | Execute Root Cause AI for nearly every AM Analytic Step | |
All AM Analytics | Added missing fields for execution of Root Cause | |
GL_RootCause | Execute Root Cause AI for nearly every GL Analytic Step | |
All GL Analytics | Added missing fields for execution of Root Cause | |
MD_RootCause | Execute Root Cause AI for nearly every MD Analytic Step | |
All MD Analytics | Added missing fields for execution of Root Cause | |
MM_RootCause | Execute Root Cause AI for nearly every MM Analytic Step | |
All MM Analytics | Added missing fields for execution of Root Cause | |
SD_RootCause | Execute Root Cause AI for nearly every SD Analytic Step | |
All SD Analytics | Added missing fields for execution of Root Cause | |
EB_CriticalPayeeCountries, EB_PayeeCountryDifference, EB_PayeeDifference | Initial port from dab AnalyticSuite (ACL) | |
Custom Analytics | Added function for alphabetic filtering dabFilterAlphabetic | |
MD_UnusualPostings | Matching analytic name in the sql code | |
Currency conversion | Omit unvalid entries in TCURR | |
BL_BaseTable | Remove T052_ZDART from payment term selection | |
SD_BaseTable | Remove T052_ZDART from payment term selection | |
2.2.2 2023-11-29 | Root_Cause_Analyse.R | Column names are now correctly processed |
Fuzzy_Duplicates_in_Stammdaten_suchen.R | Now all findings are handed over to SQL | |
All Analytics | Fixed decimal shift calculation for TCURX | |
AR_CPD | Fixed AR_CPD_NotUnique table missing | |
Fuzzy_Duplicates_in_Stammdaten_suchen.R | Reduce amount of print statements to increase performance | |
DQM-Scripts | Added missing fields TELF1 and STCEG | |
DQM-Scripts | For Duplicates changed datatype of Duplicate_ID to INT | |
2.2.1 2023-11-09 | PU_OutlineAgreement | Fixed multiple entries for one contract in contract list |
CU_DuplicatesEnhanced & VE_DuplicatesEnhanced | Additional fields needed for R script; Added new field Category; Implemented error handling | |
CU_Outliers & VE_Outliers | Additional fields needed for R script; Implemented error handling | |
Fuzzy_Duplicates_in_Stammdaten_suchen.R | Added new columns; Empty result is now processable | |
Monkey_Typing_in_Stammdaten_suchen.R | Added new columns; Empty result is now processable | |
Fuzzy_Duplicates_in_Stammdaten_suchen.R-Script | Duplicate_ID is now filled with values | |
CU_DuplicatesEnhanced & VE_DuplicatesEnhanced | Use PSTLZ from Basetables and do not use NULL as default value anymore | |
2.2.0 2023-11-06 | Master package | Updated the bundled master package to the new package variant format; For content usage dab Nexus >= 1.11 is now required |
AR_RootCause | Execute Root Cause AI for nearly every AR Analytic Step | |
All AR Analytics | Added required fields for execution of Root Cause AI | |
Root_Cause_Analyse.R | Updated to newest Version of R Script 1.13 | |
PU_RootCause | Execute Root Cause AI for nearly every PU Analytic Step | |
All PU Analytics | Added required fields for execution of Root Cause AI | |
BL_RootCause | Execute Root Cause AI for nearly every BL Analytic Step | |
All BL Analytics | Added required fields for execution of Root Cause AI | |
fMM_Inventory_Coverage | Added T001K_BUKRS to standard result set | |
MM_LocationCodes | Renamed c_UpdateKey to c_UpdateKey_AnalyticStep | |
MM_MaterialTextChanges | Added c_UpdateKey_AnalyticStep to standard result set to avoid duplicates; Removed c_UpdateKey and MARC_WERKS from standard result set to avoid duplicates; Added c_Language, USR02_USTYP, c_USR02_USTYP_Text to standard result set | |
MM_NoMinPOQty | Added T001K_BUKRS, T001W_NAME1, MBEW_LBKUM, c_MBEW_SALK3_RC, MARA_MTART and T134T_MTBEZ to standard result set | |
MM_PriceComparison | Changed calculation for c_SD_Invoice_NETPR_RC; Added c_VBRP_NETWR_RC and c_EKBE_NETWR_RC to standard result set | |
MM_QuantityUnitChanges | Added c_UpdateKey_AnalyticStep to standard result set to avoid duplicates; Removed c_UpdateKey and MARC_WERKS from standard result set to avoid duplicates; Added USR02_USTYP and c_USR02_USTYP_Text to standard result set |
