Script logic Issue

[former_member247531]

after-running-script-f-headcount.pngafter-running-script-pl99.pngbefore-script.pngHi All,

we have a script logic to move the numbers to flow F_headcount to flow PL99.

this is the script

//Clears the Headcount Closing Position
*XDIM_MEMBERSET AUDITTRAIL = <ALL>
*XDIM_MEMBERSET ACCOUNT = Japanese Secondee FTE_CB,Payroll Contractor FTE_CB,Standard Full Time FTE_CB,Standard Part Time FTE_CB,Japanese Secondee HC_CB,Payroll Contractor HC_CB,Standard Full Time HC_CB,Standard Part Time HC_CB
*XDIM_MEMBERSET CATEGORY = %CATEGORY_SET%
*XDIM_MEMBERSET TIME = %TIME_SET%
*XDIM_MEMBERSET COSTCENTER = <ALL>
*XDIM_MEMBERSET RPTCURRENCY = <ALL>
*XDIM_MEMBERSET PARTNERPC = <ALL>
*XDIM_MEMBERSET PROFITCENTER = <ALL>
*XDIM_MEMBERSET TRADINGPARTNER = <ALL>
*XDIM_MEMBERSET COMPANYCODE = <ALL>
*XDIM_MEMBERSET FLOW = PL99 *WHEN FLOW
*IS PL99
*REC(FACTOR=0)
*ENDWHEN
*COMMIT

*RUN_PROGRAM CALC_ACCOUNT
CATEGORY = %CATEGORY_SET%
RPTCURRENCY=LC,GBP
//Need GBP to bring the opening cash balance for the year for LC and GBP, other CF balances will be overwritten by Currency translation
TID_RA=%TIME_SET%
CALC=HEADCOUNT
*ENDRUN_PROGRAM

Business rule

After running this script it posts correct numbers to flow PL99, however flow F_Headcount numbers also changing after script run(numbers getting doubled for my source flow).

Please find attached results after running this script.

Could you please help me on this.

Version :BPC 10 Netweaver

BW 730 SP07

Thank you in advance.

Regards,

Srikanth

[former_member186338 · Accepted solution]

I have already told you that the script and rule are OK!

[former_member186338]

There is nothing wrong with your script and the rule is also fine!

May be you are showing not the full script or not all lines of the rule.

[former_member247531]

Hi Vadim,

Created same business rule and same script again with new name and tested it and it is working fine now.

Not sure what was the issue before.

Anyway thanks for your help.

Regards,

Srikanth

[former_member247531]

Hi Vadim,

I could not able to reply to you through comment, not sure why.

I have used insert image now,please see below and advise.

Pl99 is OK.

Business rule:

Thanks for your help.

Regards,

Srikanth

[former_member186338]

Can you show hierarchy of flow dimension?

[former_member247531]

Hi Vadim,

Please see below.

Regards,

Srikanth

[former_member186338]

Sorry, but if you want my answer use correct "Insert Image" instead of "Insert File"

P.S. I will not answer unreadable questions!