on 02-02-2015 4:05 PM
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
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!!!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
13 | |
2 | |
2 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.