Skip to Content
author's profile photo Former Member
Former Member

BPC 10 MS: script logic calculates zeros for REC statements

We did a migration from a BPC MS 7.5 to a BPC MS 10 according to the migration guide. The functionality of running a script logic via a data manager package did work before and was used a lot. After the migration of the system the same procedure of calling up a script logic with a data manager package was used but gave different results. The log showed that all data was set to zero and this was written back to the database. There was data in the source record but the system just made it zero and wrote that back to the database. An example of the script logic:

*XDIM_MEMBERSET VERSIE=%VERSIE_SET%

*XDIM_MEMBERSET PERIODE=%PERIODE_SET%

*XDIM_MEMBERSET BRON=A9

*XDIM_MEMBERSET GROEP=PG_TOT

*WHEN ENTITEIT.PG_PI

*IS "Y"

*REC(FACTOR=1,GROEP="PG_PI",BRON="A99")

*ENDWHEN

*COMMIT


The log file show that only zeros are written back to the database:

Model: FINANCIEEL - Records to be posted are 97 (calc diff = 0)

PERIODE,VERSIE,BRON,ENTITEIT,GROEP,INTCO,KOSTENDRAGER,KOSTENPLAATS,REKENING,SPECIFICATIE,VERLOOP,SIGNEDDATA

  1. 2014.JAN,ACTUAL,A99,FI001,PG_PI,IC040,KD999,KP999999,L136500,SP999,F_ARES,0
  2. 2014.JAN,ACTUAL,A99,FI001,PG_PI,IC040,KD999,KP999999,L136500,SP999,F_CLO,0
  3. 2014.JAN,ACTUAL,A99,FI001,PG_PI,IC040,KD999,KP999999,L145000,SP999,F_ARES,0

However, if we run the same logic using the logic debugger in the BPC administration client with options ‘run logic and save result’ and ‘calc diff=0’ then the logic script works as it should be. When we look at the log of this file it calculates the value correctly:

Model: FINANCIEEL - Records to be posted are 97 (calc diff = 0)


PERIODE,VERSIE,BRON,ENTITEIT,GROEP,INTCO,KOSTENDRAGER,KOSTENPLAATS,REKENING,SPECIFICATIE,VERLOOP,SIGNEDDATA

  1. 2014.JAN,ACTUAL,A99,FI001,PG_PI,IC040,KD999,KP999999,L136500,SP999,F_ARES,45179.7400000000
  2. 2014.JAN,ACTUAL,A99,FI001,PG_PI,IC040,KD999,KP999999,L136500,SP999,F_CLO,45179.7400000000
  3. 2014.JAN,ACTUAL,A99,FI001,PG_PI,IC040,KD999,KP999999,L145000,SP999,F_ARES,-45179.7400000000

No Sap note could be found on this issue.

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • Best Answer
    Posted on Jul 07, 2014 at 02:07 PM

    Hi Jens,

    When we made the switch from BPC 7 to BPC 10, some of our scripts needed to have this code at the top of them to work. We would see the correct calculations in the log but it was not writing the data.

    *CALCULATE_DIFFERENCE=1

    Maybe try adding this after you call in your dimensions and see if this works?

    -Tracey

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jul 07, 2014 at 11:47 AM

    Hi,

    for which dimensions are you prompted when you run the script via data mangager? And are those the same dimensions for which you have selected a member when you debug the script?

    Is PG_TOT a summation member in your group dimension?

    BR,
    Arnold

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi Arnold,

      Yes I have used the same selection in my debugger as in the data manager package: 2014.JAN, ACTUAL.

      PG_TOT is a base level member in the parenth1 hierarchy but for consolidation purposes it is used as a parent in the PARENT_GROUP Property. What is more, I have the same issue for scripts that have a fixed member or variable for the 'GROEP' dimension

      kr

      jens

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.