Problem while deriving property of dynamic member and assigning value to it

[Former Member]

Hello All,

I am new to BPC and i have been asked to work on BPC scripts. I appreciate your help as i am not able to create even basic script.

I will tell you about my data in BPC

Value          Dimension          Member     Property

                  GL account        1006          E70

1000.00       RC                     RCDEF

My requirement is i have multiple gl account members in GL account dimension. Each member has property which can have value E70 or M70 or so on.

I have another dimension RC which has member RCDEF and value for this record is 1000.00 (This is just example)

I want my final record like this

Value          Dimension          Member     Property(RC)

1000.00       GL account        1006          E70

1000.00       RC                     RCDEF

I am trying to create script for this which i have mentioned below.

*SELECT (%ACCSET%, "[ID]" , GL_ACCOUNT, "[RC]<>' ' ")    // To select all accounts where RC(property is not initial)

*SELECT (%RC1%, "[RC]", GL_ACCOUNT,"[ID]='%ACCSET%'")  // To select all values of properties in derived accounts

*XDIM_MEMBERSET GL_ACCOUNT = %ACCSET%

//*XDIM_MEMBERSET GL_ACCOUNT.RC = %RC1%

*FOR %LOOP_ACCSET%=%ACCSET% AND %RC2%=%RC1%

*WHEN RC

*IS = "RCCDEFAULT"

//*WHEN GL_ACCOUNT.RC

//*IS = %RC2%

*REC(EXPRESSION =[GL_ACCOUNT].%LOOP_ACCSET%,RC=%RC2%)

//*ENDWHEN

*ENDWHEN

*NEXT

i am getting error "UJK_VALIDATION_EXCEPTION:LINE 22 syntax error: " missing ; before statement""

Can you please tell me where i am going wrong?

Thanks

[former_member186338]

Hi,

Please, describe your task in more detail because I can't understand your dimensions and values.

Like this:

Dimension: GL_ACCOUNT

Property: RC

Members:1006,..

Property values: E70,M70,...<Empty>

Dimension: RC

Members: RCDEFAULT,E70,M70...

Existing Value: 1000

GL_ACCOUNT= 1006? GL_ACCOUNT.RC=E70?

RC=RCDEFAULT?

Resulting records (looking on your code...):

Value: 1000

GL_ACCOUNT= 1006? GL_ACCOUNT.RC=E70?

RC=E70?

There are number of errors in your code but I need to understand what this code is for to present a correct version.

B.R. Vadim