Skip to Content
avatar image
Former Member

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

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Feb 02, 2015 at 04:16 PM

    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!!!

    Add comment
    10|10000 characters needed characters exceeded