SCRIPT LOGIC ON PARENT MEMBERS NOT WORKING??

[Former Member]

Hi Team,

We are working on BPC 11.0.

Actually i am trying to write a logic script on parent members. The requirement is as follows.

Travelling Expenses check =

(ACCOUNT= STAT_Travelling Total(Parent member consist 5 members) , Audittrail = INPUT)

LESS

(ACCOUNT = 43000(Travelling Expenses) , AUDITTRAIL = ERP(ERP is parent member consist of 6 child members))

I wrote the following logic but it is not working .

*XDIM_MEMBERSET ACCOUNT AS %Traveling_TOT%=BAS(STAT_Travelling Total) *XDIM_MEMBERSET DATASRCE AS %ERPALL% = BAS(ERP) *XDIM_ADDMEMBERSET DATASRCE AUDITTRAIL = INPUT *XDIM_ADDMEMBERSET ACCOUNT = 43000

*FOR %Traveling_ALL% = %Traveling_TOT%

*FOR %ERP_TOT% = %ERPALL%

*WHEN ACCOUNT

*IS 43000

*REC(EXPRESSION = ([AUDITTRAIL].[INPUT],[ACCOUNT].[%Traveling_ALL%]) - ([AUDITTRAIL].[%ERP_TOT%],[ACCOUNT].[43000]) , ACCOUNT = Travelling Expenses check, DATASRCE = CALC )

*ENDWHEN

*NEXT

*NEXT

Can somebody suggest how to solve this logic?

Thanks in Advance,

Uma

[former_member186338 · Accepted solution]

The correct script will be something like:

*XDIM_MEMBERSET ACCOUNT AS %Traveling_TOT%=BAS(STAT_Travelling_Total) //this line will not change scope!
*XDIM_MEMBERSET DATASRCE AS %ERPALL% = BAS(ERP) //this line will not change scope!
*XDIM_MEMBERSET ACCOUNT=%Traveling_TOT%
*XDIM_MEMBERSET DATASRCE=%ERPALL%
*XDIM_ADDMEMBERSET DATASRCE = INPUT
*XDIM_ADDMEMBERSET ACCOUNT = 43000

*WHEN ACCOUNT
*IS %Traveling_TOT%
  *WHEN DATASRCE
  *IS INPUT
    *REC(EXPRESSION=%VALUE%,ACCOUNT=Travelling_Expenses_check,DATASRCE=CALC)
  *ENWHEN
*IS 43000 //base member
  *WHEN DATASRCE
  *IS %ERPALL%
    *REC(EXPRESSION=-%VALUE%,ACCOUNT=Travelling_Expenses_check,DATASRCE=CALC)
  *ENWHEN
*ENDWHEN

[Former Member]

Hi Vadim,

Thank you for your reply.

Its working fine.

Regards,

Uma

[former_member186338]

I see something strange in your script: do you really have member id's with spaces inside???

"STAT_Travelling Total" -??

"Travelling Expenses check" - ??

If not - please post real names.

43000 - is it a base member?