Skip to Content
0

Help with Script Logic

Nov 01, 2016 at 04:27 PM

56

avatar image

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)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Best Answer
Vadim Kalinin Nov 11, 2016 at 11:41 AM
0

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
Show 1 Share
10 |10000 characters needed characters left characters exceeded

Thanks Vadim. Seems like I was overcomplicating the solution. :)

Regards,

Collin.

0