Skip to Content
0
Former Member
Apr 12, 2011 at 11:53 AM

script logic: simple *REC based on values generated by business rule

21 Views

Hi,

I need to get the following done:

Using the BPC business rules for ACCOUNT TRANSFORMATION in a consolidation appset I eliminate investment in subs and equity and the result is good- or badwill. The business rule generates this good- or badwill on a set account but I need to show it on two separate ones, depending on whether it is good- or badwill.

The business rules generate the posting on a datasrc type A. I have then simply tried, with a new script logic that is added to the consolidation logic with an *INCLUDE statement, to post the good- or badwill to a different account, depending on whether the amount is positive or not.

This is the extra script:

*SELECT (%CONSOLVIEW_SRC%,"ID","CONSOLVIEW","[CURRENCY_TYPE]='G'") //CONSOLVIEW is my currency dimension

*XDIM_MEMBERSET ACCOUNTL=BS1,BS2 //BS1 is the account used by the business rule, BS2 is the alternative account

*XDIM_MEMBERSET DATASRCL=AA_40,AA_46 //AA_40 is type A and the one used by the business rule, AA_46 is type I

*XDIM_MEMBERSET CONSOLVIEW=%CONSOLVIEW_SCR%

*XDIM_MEMBERSET CATEGORY=%CATGEORY_SET%

*XDIM_MEMBERSET TIME=%TIME_SET%

*WHEN CATEGORY

*IS %CATEGORY_SET%

*WHEN TIME

*IS %TIME_SET%

*WHEN DATASRCL

*IS "AA_40"

*WHEN ACCOUNTL

*IS "BS1"

*WHEN SIGNEDATA

*IS < 0

*REC(EXPRESSION=1, ACCOUNTL="BS2",DATASRCL="AA_46")

*ENDWHEN

*ENDWHEN

*ENDWHEN

*ENDWHEN

*ENDWHEN

I know that I am missing a second *REC statement but since not even the first one is working, I am ignoring that fact for the moment.

Am I missing something or can I not use script logic to perform this task?

Thanks,

Arnold