Skip to Content
avatar image
Former Member

Help with Script Logic

Hi Experts,

This question pertains to SAP BPC 10.1 NW but am I unable to select the right tag.

I am trying write a Script logic to move data from INTERCO Member "I_NONE" to respective INTERCO member assigned to an Account dimension member where "TYELIM"="INVST" through a property "TP".

Please see below screen shot of the Account dimension for your reference:

I am using the below script to execute my requirement:

*SELECT(%SOURCE_ACCOUNT%,"[ID]",ACCOUNT,"[TYPELIM]='INVST'")

*XDIM_MEMBERSET ACCOUNT= %SOURCE_ACCOUNT%

*XDIM_MEMBERSET AUDITTRAIL= TB_UPLOAD,Input

*XDIM_MEMBERSET CATEGORY= Test

*XDIM_MEMBERSET ENTITY= 1000

*XDIM_MEMBERSET FLOW= F_CLO

*XDIM_MEMBERSET RPTCURRENCY= LC

*XDIM_MEMBERSET SCOPE= S_None

*XDIM_MEMBERSET TIME=2016.03

*SELECT(%DESTINATION_INTRC%,"[TP]",ACCOUNT,"[ID]=%SOURCE_ACCOUNT%")

*FOR %ACC% = %SOURCE_ACCOUNT%

*WHEN AUDITTRAIL

*IS TB_UPLOAD

*REC(FACTOR=1, INTERCO=%DESTINATION_INTRC%, AUDITTRAIL="Input")

*REC(FACTOR=-1, INTERCO="I_NONE", AUDITTRAIL="Input")

*ENDWHEN

*NEXT

However I am getting the error

UJK_VALIDATION_EXCEPTION:Unknown Dimension Name in Keyword: "I_1600:

I_1600 is a valid member in the INTERCO Dimension yet this error is coming.

I even tried Replacing %DESTINATION_INTRC% with I_1600 in line

*REC(FACTOR=1, INTERCO=%DESTINATION_INTRC%, AUDITTRAIL="Input") in the script, that time it works. So I feel there is something going wrong with using

%DESTINATION_INTRC%

Can someone please let me know why this script is not working as expected?

Thanks and Regards,

Collin.

esuds.png (55.2 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Nov 11, 2016 at 11:41 AM

    Ups, your script is incorrect in general... The correct one:

    *SELECT(%SOURCE_ACCOUNT%,"[ID]",ACCOUNT,"[TYPELIM]='INVST'")
    *XDIM_MEMBERSET ACCOUNT= %SOURCE_ACCOUNT%
    *XDIM_MEMBERSET AUDITTRAIL= TB_UPLOAD
    *XDIM_MEMBERSET CATEGORY= Test
    *XDIM_MEMBERSET ENTITY= 1000
    *XDIM_MEMBERSET FLOW= F_CLO
    *XDIM_MEMBERSET RPTCURRENCY= LC
    *XDIM_MEMBERSET SCOPE= S_None
    *XDIM_MEMBERSET TIME=2016.03
    *XDIM_MEMBERSET INTERCO=I_NONE
    
    *WHEN AUDITTRAIL
    *IS *
    *REC(FACTOR=1, INTERCO=ACCOUNT.TP, AUDITTRAIL=Input)
    *REC(FACTOR=-1, AUDITTRAIL=Input)
    *ENDWHEN
    
    Add comment
    10|10000 characters needed characters exceeded