Skip to Content

SAP BPC 10.1 NW - Script logic decimal issue

Dear expert,

I am working on BPC 10.1 NW on HANA (version CPMBC81008 with HANA accellerator on BW 740) and I have the following issue on script logic.

Basically I am trying to write a very simle script, just to copy a value from an Account to another one. The script is:

*XDIM_MEMBERSET CATEGORY = Actual
*XDIM_MEMBERSET RPTCURRENCY = LC
*XDIM_MEMBERSET AUDITTRAIL = Input
*WHEN ACCOUNT
*IS BS111
*REC(FACTOR=1,ACCOUNT=BS121)
*ENDWHEN

When I run it for an integer, it works correctly

However if I run it with a number with decimal positions, it works very strangely:

It's like the system is copying only the decimal digits (after the comma) and not the integer part. I guess this may be related to some Language settings or a Bug.

Do you have any opinions about this?

Thanks a lot for your valuable feedback

Best regards

Francesco

cattura.png (10.6 kB)
cattura2.png (10.1 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • Best Answer
    Jul 31, 2017 at 04:43 PM

    Dear all,

    the problem is solved and the solution was provided by SAP, after opening an incident.

    The issue was related to a flag in table T005X

    For LAND=US, XDEZP had to be set to X (initially was set to blank).

    After this, the script logic worked fine

    Thanks anyway for your support

    Rgds

    Add comment
    10|10000 characters needed characters exceeded

  • Jul 11, 2017 at 03:32 PM

    I have run the script in UJKT and this is the result:

    LGX: *XDIM_MEMBERSET CATEGORY =Actual
    *XDIM_MEMBERSET RPTCURRENCY = LC
    *XDIM_MEMBERSET AUDITTRAIL = Input
    *WHEN ACCOUNT
    *IS BS111
    *REC(FACTOR=1,ACCOUNT=BS121)
    *ENDWHEN -------------------------------------------------------------------------------------------------------------------------------------
    LOG: LOG BEGIN TIME:2017-07-11 17:30:06
    FILE:\ROOT\WEBFOLDERS\TEST_ALIMCO \ADMINAPP\Consolidation\TEST.LGF
    USER:SAPGARAVINI
    APPSET:TEST_ALIMCO
    APPLICATION:Consolidation
    [INFO] GET_DIM_LIST(): I_APPL_ID="Consolidation", #dimensions=10
    ACCOUNT,AUDITTRAIL,CATEGORY,ENTITY,FLOW,INTERCO,MEASURES,RPTCURRENCY,SCOPE,TIME #dim_memberset=3
    CATEGORY:Actual,1 in total.
    RPTCURRENCY:LC,1 in total.
    AUDITTRAIL:Input,1 in total. REC :%value%*(1) CALCULATION BEGIN:
    QUERY PROCESSING DATA
    QUERY TIME : 0.00 ms. 1 RECORDS QUERIED OUT.
    QUERY REFERENCE DATA
    CALCULATION TIME IN TOTAL :0.00 ms.
    1 RECORDS ARE GENERATED.
    CALCULATION END. ENDWHEN ACCUMULATION: 1 RECORDS ARE GENERATED. DATA TO WRITE BACK:
    ACCOUNT AUDITTRAIL CATEGORY ENTITY FLOW INTERCO RPTCURRENCY SCOPE TIME SIGNEDDATA
    BS121 Input Actual DE Balance ThirdParty LC S_None 2014.01 13.00
    1 RECORDS HAVE BEEN WRITTEN BACK.
    WRITING TIME :1.00 ms. SCRIPT RUNNING TIME IN TOTAL:1.00 s.
    LOG END TIME:2017-07-11 17:30:06

    Add comment
    10|10000 characters needed characters exceeded

  • Jul 11, 2017 at 02:23 PM

    Looks very strange!

    But I have to ask a lot of questions - please read:

    https://blogs.sap.com/2014/01/31/how-to-ask-questions-about-script-logic-issues/

    and provide required info!

    If it's default.lgf please test it in UJKT with the fixed scope like in your report!

    Add comment
    10|10000 characters needed characters exceeded

  • Jul 11, 2017 at 03:11 PM

    Hi Vladim,

    thanks for your reply and please find the required info:

    1. Version: BPC 10.1 NW on HANA (version CPMBC81008 with HANA accellerator on BW 740)
    2. Engine shold be Javascript, as UJKT validated correctly the test script with MATH
    3. Environment is a copy of ENVIRONMENTSHELL with no customizations. Model consolidation. Dimensions are ACCOUNT, AUDITTRAIL, CATEGORY, ENTITY, FLOW, INTERCO, RPTCURRENCY, SCOPE, TIME. Account type I used for my testing are AST but I guess it's not relevant for my problem. I had the same issue in another environment of the same installation (so it looks like something general of the system and not related to a specific environment/model)
    4. The script has to be run through a DM package
    5. The script is the most basic one I could imagine to reproduce the issue. It's just copying a value from an Account to another one
    6. *XDIM_MEMBERSET CATEGORY =Actual
      *XDIM_MEMBERSET RPTCURRENCY = LC
      *XDIM_MEMBERSET AUDITTRAIL = Input
      *WHEN ACCOUNT
      *IS BS111
      *REC(FACTOR=1,ACCOUNT=BS121)
      *ENDWHEN
    7. No prompts are needed
    8. There is no data region or param to set in UJKT
    9. Report is the following one:
    cattura.png

    Add comment
    10|10000 characters needed characters exceeded