BPC script: Clearing base element values based on node value

[former_member720264]

Hi,

I have to do following operation in BPC:

based on "node" value in one dimension I have to clear values for all accounts for that "node".

Example:

FLOW     ACCOUNT     VALUE

F1           A1                    100

F1           A2                    -200

I need to implement following rule:

If sum of all members for flow F1 is less than 0, clear all values for F1, so in above example I want to get:

FLOW     ACCOUNT     VALUE

F1           A1                    0

F1           A2                    0

I made some tries in script but it always ends up with  sth like this:

FLOW     ACCOUNT     VALUE

F1           A1                    100

F1           A2                    0

Can you suggest some way to do it?

Thanks, ak

[former_member186338 · Accepted solution]

Strange requirement, but can be implemented like:

1. You have some root parent for the accounts A1,A2... - PARENTA

Then:

*XDIM_MEMBERSET FLOW=F1

*XDIM_MEMBERSET ACCOUNT=BAS(PARENTA)

*WHEN ACCOUNT

*IS *

*REC(EXPRESSION=([ACCOUNT].[PARENTA]<0) ? 0 : %VALUE%)

*ENDWHEN

Vadim

[former_member720264 · Accepted solution]

Thanks a lot, works just fine.

ak