BPC script logic not work

[Former Member]

HI,gays

There is problem I want put all interco to Thiedparty,Here is my logic,but it not work,

*XDIM_MEMBERSET ACCOUNT = 2202000098
*XDIM_MEMBERSET AUDITTRAIL=BAS(AU_0002 )
*XDIM_MEMBERSET CUSTOMER = BAS(CUSTOMER)
*XDIM_MEMBERSET ENTITY=%ENTITY_SET%
*XDIM_MEMBERSET EXP_FM=BAS(EXP_FM)
*XDIM_MEMBERSET FLOW=F99
*XDIM_MEMBERSET FZHS_01=BAS(FZHS_01)
*XDIM_MEMBERSET INTERCO=BAS(INTERCO)
*XDIM_MEMBERSET PRODUCT=BAS(PRODUCT)
*XDIM_MEMBERSET RPTCURRENCY=CNY
*XDIM_MEMBERSET TIME=%TIME_SET%
*XDIM_MEMBERSET CATEGORY =%CATEGORY_SET%
*XDIM_MEMBERSET TRANSTYPE=BAS(T_ALL)
*XDIM_MEMBERSET VENDOR=BAS(VENDOR)
*XDIM_MEMBERSET YL01=Y01_NONE
*XDIM_MEMBERSET YL02=Y02_NONE
*XDIM_MEMBERSET YL03=Y03_NONE
*XDIM_MEMBERSET TRANSCURRENCY=BAS(TRANS_ALL)


*WHEN ACCOUNT
*IS 2202000098
*REC(FACTOR = 1,INTERCO=ThirdParty)
*ENDWHEN
*COMMIT

Thanks

Regards

[paliwalamit9]

Hi,

Does your BAS(INTERCO) include ThirdParty ID?

If it does, your current script won't work. You will have to post the entire data on separate audit trail else it would keep on posting wrong data.

Create additional auditrail ADJ under same parent as AU_0002 and report at parent level.

Try using following logic then:

//Clearing data on ADJ audittrail

*XDIM_MEMBERSET ACCOUNT = 2202000098
*XDIM_MEMBERSET AUDITTRAIL=ADJ
*XDIM_MEMBERSET CUSTOMER = BAS(CUSTOMER)
*XDIM_MEMBERSET ENTITY=%ENTITY_SET%
*XDIM_MEMBERSET EXP_FM=BAS(EXP_FM)
*XDIM_MEMBERSET FLOW=F99
*XDIM_MEMBERSET FZHS_01=BAS(FZHS_01)
*XDIM_MEMBERSET INTERCO=BAS(INTERCO)
*XDIM_MEMBERSET PRODUCT=BAS(PRODUCT)
*XDIM_MEMBERSET RPTCURRENCY=CNY
*XDIM_MEMBERSET TIME=%TIME_SET%
*XDIM_MEMBERSET CATEGORY =%CATEGORY_SET%
*XDIM_MEMBERSET TRANSTYPE=BAS(T_ALL)
*XDIM_MEMBERSET VENDOR=BAS(VENDOR)
*XDIM_MEMBERSET YL01=Y01_NONE
*XDIM_MEMBERSET YL02=Y02_NONE
*XDIM_MEMBERSET YL03=Y03_NONE
*XDIM_MEMBERSET TRANSCURRENCY=BAS(TRANS_ALL)


*WHEN ACCOUNT
*IS 2202000098
*REC(FACTOR = 0)

*ENDWHEN

//Reclassification

*XDIM_MEMBERSET ACCOUNT = 2202000098
*XDIM_MEMBERSET AUDITTRAIL=BAS(AU_0002 )
*XDIM_MEMBERSET CUSTOMER = BAS(CUSTOMER)
*XDIM_MEMBERSET ENTITY=%ENTITY_SET%
*XDIM_MEMBERSET EXP_FM=BAS(EXP_FM)
*XDIM_MEMBERSET FLOW=F99
*XDIM_MEMBERSET FZHS_01=BAS(FZHS_01)
*XDIM_MEMBERSET INTERCO=BAS(INTERCO)
*XDIM_MEMBERSET PRODUCT=BAS(PRODUCT)
*XDIM_MEMBERSET RPTCURRENCY=CNY
*XDIM_MEMBERSET TIME=%TIME_SET%
*XDIM_MEMBERSET CATEGORY =%CATEGORY_SET%
*XDIM_MEMBERSET TRANSTYPE=BAS(T_ALL)
*XDIM_MEMBERSET VENDOR=BAS(VENDOR)
*XDIM_MEMBERSET YL01=Y01_NONE
*XDIM_MEMBERSET YL02=Y02_NONE
*XDIM_MEMBERSET YL03=Y03_NONE
*XDIM_MEMBERSET TRANSCURRENCY=BAS(TRANS_ALL)


*WHEN ACCOUNT
*IS 2202000098
*REC(FACTOR = 1, INTERCO=ThirdParty, AUDITTRAIL=ADJ)

*REC(FACTOR = -1, AUDITTRAIL=ADJ)

*ENDWHEN

[former_member186338]

"Does your BAS(INTERCO) include ThirdParty ID?" - this is not clear from the original post and the topic author did not provide any info about INTERCO dimension hierarchy...

But even if BAS(INTERCO) include ThirdParty ID the script has to produce some value in ThirdParty 🙂

[paliwalamit9]

Hi Vadim,

I provided the solution based on general issues I experienced.

As he mentioned "it did not work" I construed it as not working as expected.

Regards,

Amit

[former_member186338]

In the report I see nothing in ThirdParty cell 🙂

[former_member186338]

Please read https://blogs.sap.com/2014/01/31/how-to-ask-questions-about-script-logic-issues/ and provide missing info!

P.S. And remove not related tag from the question:

SAP Business Planning and Consolidation for Public Sector, option for SAP NetWeaver

[Former Member]

i updata my logic but still not work

*XDIM_MEMBERSET ACCOUNT = 2202000098
*XDIM_MEMBERSET FLOW= F99
*XDIM_MEMBERSET CATEGORY =V1001
*XDIM_MEMBERSET TIME = 2016.01
*XDIM_MEMBERSET INTERCO = BAS(INTERCO)


*WHEN ACCOUNT
*IS 2202000098
*REC(FACTOR = 1,FLOW=F99,INTERCO=ThirdParty)
*ENDWHEN
*COMMIT