Skip to Content
0
Former Member
Dec 02, 2011 at 02:38 AM

How to write parent member (TOTAL) to basemember?

34 Views

Hi experts!

This code doesn't work. Why? Task is - write "TOTAL" member to another member.

*XDIM_MEMBERSET CATEGORY=ACTUAL
*XDIM_MEMBERSET MEASURES=PERIODIC
*XDIM_MEMBERSET RPTCURRENCY=USD

//KBO1000000 is parent node,ZCX1000000 is basemember
*XDIM_MEMBERSET KB_ACCT=KBO1000000,ZCX1000000

//TOTAL MEMBERS G100,E100 are parent nodes,EMPTY are basemembers which not included to G100 or E100
*XDIM_MEMBERSET P_CC=BAS(G100),EMPTY
*XDIM_MEMBERSET P_ENTITY=BAS(E100),EMPTY
*XDIM_MEMBERSET P_TIME=2010.JAN.01

*WHEN P_TIME
*IS 2010.JAN.01
*WHEN CATEGORY
*IS ACTUAL
*WHEN P_ENTITY
*IS E100
*WHEN P_CC
*IS G100
*WHEN KB_ACCT
*IS KBO1000000

*REC(EXPRESSION=%value%,KB_ACCT=ZCX1000000,P_TIME=2010.JAN.01,P_ENTITY=EMPTY,P_CC=EMPTY)

*ENDWHEN
*ENDWHEN
*ENDWHEN
*ENDWHEN
*ENDWHEN

*COMMIT