on 2017 Dec 04 3:48 PM
Hello BPC experts,
We had a consolidation package that worked perfectly until today (4th December).
We tried to improve BPC performance by allowing parallel processing on 30rd November (
https://launchpad.support.sap.com/#/notes/1792408 ) and it seems like this setting "broke" the consolidation package. This is just an hypothesis, maybe it is not related but nothing specific has been done in the settings between those days.
Therefore, we removed all the settings in SPRO (removed in global and model settings + removed in data manager PARALLEL_EXECUTION(ON)) relating to parallel processing but the consolidation is still not working.
Issue : when launching a consolidation package, no input data from S_NONE Scope dimension is copied into input in S_LU11 Scope.
I have gone through
https://launchpad.support.sap.com/#/notes/1941497 to check what could have gone wrong. There are some points to note :
1) Package has still the status "Succeeded" and also have records (IC_ELIM business rule somehow works. we do not use BPC to consolidated equity nor investments).
2) INPUT has Y for IS_CONSOL and IS_CONVERTED
3) Ownership manager is correctly set (simple structure with holding and full companies)
4) Entities like LU11 has I_LU11 in their property as well Interco has LU11 in their property.
5) Even if business rules for Eliminations and adjustments are wrong (which is not the case, since it worked before), INPUT data should still be copied.
6) logic script for consolidation comes from the starterkit.
*RUN_PROGRAM CURR_CONVERSION
CATEGORY = %VERSION_SET%
GROUP = %SCOPE_SET%
TID_RA = %TIME_SET%
//OTHER = [ENTITY=%ENTITY_SET%]
FXRATENTITY = GLOBAL
*ENDRUN_PROGRAM
*RUN_PROGRAM CONSOLIDATION
CATEGORY = %VERSION_SET%
GROUP = %SCOPE_SET%
TID_RA = %TIME_SET%
*ENDRUN_PROGRAM
*RUN_PROGRAM CALC_ACCOUNT
CATEGORY = %VERSION_SET%
CURRENCY = LC,EUR
TID_RA = %TIME_SET%
OTHER = [INTERCO=I_NONE]
CALC = NETINCOME
*ENDRUN_PROGRAM
7) SLG1 log does not show any error
😎 I also have tried in another scope but the system puts the data into 0,00. It is considering that the data source (INPUT+S_NONE+LC+LU11+I_NONE) is empty.
9) Currency translation works fine. S_NONE+LC are correctly converted into S_NONE+EUR.
Is there anything else to check ?
Request clarification before answering.
No magic idea at the moment but BW 7.5 SP05 has a lot of issues... it's better to upgrade to something recent.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
11 | |
10 | |
2 | |
2 | |
2 | |
1 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.