Logic Script BPC10: Boolean test with %value% returns reference not defined

[Former Member]

Hello Experts:

     I try to write a script logic to test account dimension value that it is 0 or different.

*XDIM_MEMBERSET SENARYO = BP_2015_V1

*XDIM_MEMBERSET DONEM = NA_DNM

*XDIM_MEMBERSET VERSIYON =VE01

*XDIM_MEMBERSET YATIRIMKLM = Y6000

*WHEN YATIRIMKLM

*IS Y6000

*REC(EXPRESSION=(%VALUE%>0) ? VERSIYON=VONAY : 0)

*ENDWHEN

*COMMIT

I want to check that if YATIRIMKLM dimension's Y6000 member is different than 0, than I want to copy VE01 to VONAY member of VERSIYON. But it returns reference not defined error. I have to resolve this and try many different options. What should i do to manage this problem.

Please help me about my logic.

Waiting for a help.

Thanks

Can

[Shrikant_Jadhav · Accepted solution]

Hi Can

Try this

*REC(EXPRESSION=%VALUE%>0? VALUE% : 0, VERSIYON=VONAY )

(Not tested)

Shrikant

[Former Member · Accepted solution]

Hello Shrikant,

   Thank you for your reply. But this code only copies Y6000 value from VE01 to VONAY

   I try to check that if Y6000 greater than 0, than i want that Y9000,Y01001,Y01002 account values, VE01 to VONAY. Is there any solution for that.

[former_member186338 · Accepted solution]

Hi Can,

Your statements:

1. "I want to check that if YATIRIMKLM dimension's Y6000 member is different than 0, than I want to copy VE01 to VONAY member of VERSIYON."

2. "I try to check that if Y6000 greater than 0, than i want that Y9000,Y01001,Y01002 account values, VE01 to VONAY."

are absolutely different!

Your final requirements are not clear - "Y9000,Y01001,Y01002 account values" ... what?

Can you clearly explain what you want with some sample?

Vadim

[Former Member · Accepted solution]

Hello Vadim,

  My problem was resloved. Thank you all.

[former_member186338]

Hi Can,

"I want to check that if YATIRIMKLM dimension's Y6000 member is different than 0, than I want to copy VE01 to VONAY member of VERSIYON"

There is no way to copy based on condition, the copy will always happen! But you can copy destination over destination to simulate no copy:

*REC(EXPRESSION=%VALUE%==0? [VERSIYON].[VONAY] : %VALUE%, VERSIYON=VONAY )

if zero then [VERSIYON].[VONAY] - destination, else - %VALUE%

Vadim

[dinesh_veluru]

Hi Can,

Please check below.

Thanks,

Dinesh.V