Hello
I would like to ADD three independent accounts, like A0001.35 + A0002.45 + A0003.55 to TOTAL.
*FUNCTION LIST = "A0001.35","A0002.45","A0003.55"
*XDIM_MEMBERSET P_ACCOUNT = %ACCTLIST%
*WHEN DATASRC
*IS INPUT
*WHEN CATEGORY
*IS PLAN,ACTUAL
*WHEN P_ACCOUNT
*IS %ACCTLIST%
*REC(Expression=%VALUE%,P_ACCOUNT="TOTAL")
*ENDWHEN
*ENDWHEN
*ENDWHEN
*COMMIT
Thanks and any help is greatly appreciated.
SAP BPC
Hi
try:
*XDIM_MEMBERSET P_ACCOUNT = "A0001.35","A0002.45","A0003.55"
*XDIM_MEMBERSET CATEGORY = "PLAN","ACTUAL"
*WHEN DATASRC
*IS INPUT
*WHEN P_ACCOUNT
*IS "A0001.35","A0002.45","A0003.55"
*REC(Expression=%VALUE%,P_ACCOUNT="TOTAL")
*ENDWHEN
*ENDWHEN
*COMMIT
Hi,
if A0001.35 + A0002.45 + A0003.55 are children of TOTAL account then you don't need nothing you will have automatically the TOTAL, is sufficient to use the parenth1 property, or you can try
*XDIM_MEMBERSET P_ACCOUNT = A0001.35,A0002.45,A0003.55
*XDIM_MEMBERSET CATEGORY = PLAN,ACTUAL
*XDIM_MEMBERSET DATASRC = INPUT
*WHEN *
*IS
*REC(FACTOR=1,P_ACCOUNT="TOTAL")
*ENDWHEN
*COMMIT
Kind regards
Roberto
Add a comment