Skip to Content
avatar image
Former Member

BPC 10.1 BW 7.5 SP05 : Consolidation package does not copy input data anymore

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

8) 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 ?

oimmx.png (50.9 kB)
mbaat.png (7.9 kB)
tfhn2.png (13.0 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Dec 04, 2017 at 04:43 PM

    No magic idea at the moment but BW 7.5 SP05 has a lot of issues... it's better to upgrade to something recent.

    Add comment
    10|10000 characters needed characters exceeded