Hi,
We are currently working on the validation of BQ3 HANA system when we encountered a problem with a data manager package link CORP_CALC. The CORP_CALC computation itself is working but it is run in a package link which starts with a CLEAR process chain. Below is the detailed log in the CLEAR package
/CPMB/MODIFY completed in 0 seconds
/CPMB/CLEAR_COMMENTS_FOR_CLEAR completed in 0 seconds
/CPMB/CLEAR_CUBE completed in 1 seconds
[Selection]
--------------------------------------------------------------
SELECTION = /AOS/Planning/PRIVATEPUBLICATIONS/105191/TempFiles/FROM.TMP@@@SAVE@@@@@@EXPAND@@@|DIMENSION:ACCOUNT|3011000,2205000,2205001,1019000,1019001,5900000,5900001,5835000,5835001|DIMENSION:AUDITTRAIL||DIMENSION:BRAND||DIMENSION:CATEGORY|F03|DIMENSION:COSTCENTER||DIMENSION:FLOW||DIMENSION:FUNC_AREA||DIMENSION:PC_ENTITY|PF_WHQ|DIMENSION:PC_INTERCO||DIMENSION:PRODUCT||DIMENSION:RPTCURRENCY||DIMENSION:SOURCE_ENTITY||DIMENSION:TIME|2018.03,2018.04,2018.05,2018.06,2018.07,2018.08,2018.09,2018.10,2018.11,2018.12
SELECTION_KEYDATE =
ENABLETASK = Yes
CHECKLCK = Yes
CHECKJOUR = No
[Message]
--------------------------------------------------------------
Task name CLEAR CUBE DATA:
Submit count: 0
Reject count: 0
model: Planning. Package status: SUCCESS
As you can see SUBMIT COUNT = 0, BQ3 is a backup of the PROD environment and when we compared it to the CORP_CALC process in PROD this is the detailed log of CLEAR in PROD.
/CPMB/MODIFY completed in 0 seconds
/CPMB/CLEAR_COMMENTS_FOR_CLEAR completed in 0 seconds
/CPMB/CLEAR_CUBE completed in 1 seconds
[Selection]
--------------------------------------------------------------
SELECTION = /AOS/Planning/PRIVATEPUBLICATIONS/105191/TempFiles/FROM.TMP@@@SAVE@@@@@@EXPAND@@@|DIMENSION:ACCOUNT|3011000,2205000,2205001,1019000,1019001,5900000,5900001,5835000,5835001|DIMENSION:AUDITTRAIL||DIMENSION:BRAND||DIMENSION:CATEGORY|F03|DIMENSION:COSTCENTER||DIMENSION:FLOW||DIMENSION:FUNC_AREA||DIMENSION:PC_ENTITY|PF_WHQ|DIMENSION:PC_INTERCO||DIMENSION:PRODUCT||DIMENSION:RPTCURRENCY||DIMENSION:SOURCE_ENTITY||DIMENSION:TIME|2018.03,2018.04,2018.05,2018.06,2018.07,2018.08,2018.09,2018.10,2018.11,2018.12
SELECTION_KEYDATE =
ENABLETASK = Yes
CHECKLCK = Yes
CHECKJOUR = No
[Message]
--------------------------------------------------------------
Task name CLEAR CUBE DATA:
Submit count: 71
Reject count: 0
model: Planning. Package status: SUCCESS
The SUBMIT COUNT = 71. The problem in BQ3 is that client detected variances on the CORP_CALC result and we suspect it is because the CLEAR is not working properly. Is there any way or reason why in BQ3 SUBMIT COUNT = 0 while in PROD SUBMIT COUNT = 71.? We are almost going live and we need to fix the CORP_CALC so we can move forward.
Regards,