BPC script: In When condition Check Property blank If blank then skip record

[Former Member]

E.G Need to chek property having value before writing in model

*WHEN Flow

*IS F00

Here Need check C_ACCOUNT.BEGIN_IC (Property) shouldn't blank

*REC(EXPRESSION = %VALUE%,C_ACCOUNT = C_ACCOUNT.BEGIN_IC)

*IS F210

Here Need check C_ACCOUNT.IN_IC (Property) shouldn't blank

*REC(EXPRESSION = %VALUE%,C_ACCOUNT = C_ACCOUNT.IN_IC)

*IS F220

Here Need check C_ACCOUNT.OUT_IC (Property) shouldn't blank

*REC(EXPRESSION = %VALUE%,C_ACCOUNT = C_ACCOUNT.OUT_IC)

ENDWHEN

Tried with C_ACCOUNT.BEGIN_IC <> " " , it not working

[former_member186338 · Accepted solution]

Before WHEN/ENDWHEN you have to select accounts having not empty property IN_IC and OUT_IC.

For example:

*SELECT(%INIC%,ID,C_ACCOUNT,IN_IC<>'')
*SELECT(%OUTIC%,ID,C_ACCOUNT,OUT_IC<>'')

Then you can use variables %INIC% and %OUTIC% in *XDIM_MEMBERSET statements

But without full understanding of your script I can't provide final code.

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

And provide required info!!!

[Former Member]

Thanks !!

this workes but only I need to keep separate scoping with thier logic as property.

[former_member186338]

Sorry, but I do not understand your words about separate scoping. Please, provide full script and other info based on the mentioned link.