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
*IS < 0
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?