Skip to Content
avatar image
Former Member

Consolidation Logic aggregating the earlier record and not overwriting

Hi All,

I am facing an issue wherein if I run the CONSOLIDATION logic for the first time then it works fine. However when I change some of the records and run again then it aggregates the earlier records and post the result. Below mentioned is my config and data

Business Rule for Elimination:

Script Logic

*RUN_PROGRAM CURR_CONVERSION

CATEGORY = %CATEGORY_SET%

GROUP = %SCOPE_SET%

TID_RA = %TIME_SET%

//OTHER = [ENTITY=%ENTITY_SET%]

RATEENTITY = GLOBAL

*ENDRUN_PROGRAM

*RUN_PROGRAM CONSOLIDATION

CATEGORY = %CATEGORY_SET%

GROUP = %SCOPE_SET%

TID_RA = %TIME_SET%

//OTHER = [ENTITY=%ENTITY_SET%]

*ENDRUN_PROGRAM

Result when package was run first time:

In below case data for LC was manually entered first and then the above script logic was run to get USD values for Scope - S_NONE & MGMT_BDX

Result when data was changed for LC

So when the package was run for the first time value posted to DS_ELIM_AUTO is the reversed value of DS_LOAD. However when the data changes is made then it aggregates the value which was already present in DS_ELIM_AUTO .
xhhb5.png (28.3 kB)
d9p2x.png (28.3 kB)
ri7pg.png (37.4 kB)
jbqcm.png (44.8 kB)
mfbqp.png (36.3 kB)
e2v34.png (56.0 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Best Answer
    avatar image
    Former Member
    Mar 07 at 10:27 AM

    Hi Vadim & Lucas,

    Thanks for you help,

    I got the issue resolved by applying SAP Note

    1514944 - Duplication of data when running Legal consolidation package again - BPC

    Add comment
    10|10000 characters needed characters exceeded

  • Mar 06 at 08:26 PM

    It feels like something wrong with your audit trail dimension, but as Vadim said, without further details it's hard to help.

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi Lucas,

      I have applied SAP Note

      1514944 - Duplication of data when running Legal consolidation package again - BPC

      and maintain the property value Y for IS_CONSOL property of Audit dimension
  • Mar 06 at 05:57 PM

    Sorry, but full setup has to be posted!

    Add comment
    10|10000 characters needed characters exceeded