How to exclude values in when end when statement in script logic .

[former_member339201]

I have a requirement like below :

ACCOUNT DIMENSION MEMBERS :

  ID     PROPERTY1

  A1      A

  A2      A

  A3

  B1      B

  B2      B

  C1      C

  C2    

  C3      C

  A

  B

  C

transaction data record is as below :

A1   10

A2   20

A3   30

B1   20

B2   30

C1   30

C2   20

C3   10

A      0

B      0

C      0

Now I want to post the values like below:

A   30    ( 10 + 20 i.e.  A1+A2)

B   50    (  20  + 30 i.e. B1+B2)

C   40    ( 30+10  i.e.   C1+C3)

Now I want to post this data as mentioned above.

We tried to exclude the members for  which "PROPERTY1"  property is blank, but without success.

Please suggest the script .

Regards,
SHUBHAM

[former_member186338 · Accepted solution]

Hi Shubham,

In PROPERTY1 you have destination ACCOUNT ID - is it correct?

Then:

//Select Accounts with not empty PROPERTY!

*SELECT(%ACPR1%,"[ID]",ACCOUNT,"[PROPERTY1]<>''")

*XDIM_MEMBERSET ACCOUNT=%ACPR1%

*WHEN ACCOUNT

*IS * //already scoped

*REC(EXPRESSION=%VALUE%,ACCOUNT=ACCOUNT.PROPERTY1)

*ENDWHEN

Vadim

P.S. Hope that in PROPERTY1 you have only valid base member ID's or nothing!

P.P.S The solution is for DM package, not for default.lgf!!!

[former_member339201 · Accepted solution]

Thanks Vadim,

Yes  PROPERTY1 is the  destination ACCOUNT ID.

It worked.

Reagrds,
SHUBHAM