Script logic not working after upgrade

[Former Member]

Dear experts

we have a script logic which is called from default logic.

However after we upgraded from BPC SP09 to SP16 and epm addin to SP18, the script logic is not working properly and data is not in sync.

Could you please help if any below syntax are depreciated and donot work with SP16 of BPC 10.

however, i have tried to remove the Data selection reporting -> Badi below and tried to input values.

But we couldnt see data being deleted by the first 10 lines which posts 0s in C_REPORTING_YTD, C_REPORTING_QTD members

please advise.

//Delete values from Reporting AudiTrail

*XDIM_MEMBERSET TIME=BAS(CALCTIME)

*XDIM_MEMBERSET AUDITTRAIL=C_REPORTING_YTD, C_REPORTING_QTD

*XDIM_MEMBERSET UOM_REPORTING=BASE

*XDIM_MEMBERSET PR_ACCOUNT = <ALL>  //all base members without member formulas

*XDIM_FILTER CATEGORY = [CATEGORY].PROPERTIES("NO_INPUT") = "N" //select categories open for inputs

*WHEN PR_ACCOUNT

*IS *

*REC(FACTOR = 0)

*ENDWHEN

*COMMIT

//Data selection Reporting

*XDIM_MEMBERSET TIME=BAS(CALCTIME)

*XDIM_MEMBERSET AUDITTRAIL=C_MANUAL

*XDIM_MEMBERSET UOM_REPORTING=BASE

*XDIM_MEMBERSET PR_ACCOUNT = <ALL>  //all base members without member formulas

*XDIM_FILTER CATEGORY = [CATEGORY].PROPERTIES("NO_INPUT") = "N" //select categories open for inputs

//insert BADI

*START_BADI AVERAGES_CALC

//[{parameter_name}={value}]

//...

*END_BADI

[former_member186338 · Accepted solution]

Please show the result of this minimal script in UJKT (😞

*XDIM_MEMBERSET TIME=BAS(CALCTIME)

*XDIM_MEMBERSET AUDITTRAIL=C_REPORTING_YTD, C_REPORTING_QTD

*XDIM_MEMBERSET UOM_REPORTING=BASE

*XDIM_MEMBERSET PR_ACCOUNT = <ALL>  //all base members without member formulas

*XDIM_FILTER CATEGORY = [CATEGORY].PROPERTIES("NO_INPUT") = "N" //select categories open for inputs

*WHEN PR_ACCOUNT

*IS *

*REC(FACTOR = 0)

*ENDWHEN

Vadim

P.S. *COMMIT is absolutely useless in this script...

[Former Member · Accepted solution]

Dear Vadim

here are  the results when i execute simulate in UJKT

LGX:

*XDIM_MEMBERSET TIME=BAS(CALCTIME)

*XDIM_MEMBERSET AUDITTRAIL=C_REPORTING_YTD, C_REPORTING_QTD

*XDIM_MEMBERSET UOM_REPORTING=BASE

*XDIM_MEMBERSET PR_ACCOUNT = <ALL>

*XDIM_FILTER CATEGORY = [CATEGORY].PROPERTIES("NO_INPUT") = "N"

*WHEN PR_ACCOUNT

*IS *

*REC(FACTOR = 0)

*ENDWHEN

-------------------------------------------------------------------------------------------------------------------------------------

LOG:

FILE:\ROOT\WEBFOLDERS\ZODW \ADMINAPP\METRICS\TEST.LGF

USER:NPONNAGANTI

APPSET:ZODW

APPLICATION:METRICS

[INFO] GET_DIM_LIST(): I_APPL_ID="METRICS", #dimensions=7

AUDITTRAIL,CATEGORY,MEASURES,PR_ACCOUNT,PR_BUS_UNIT,TIME,UOM_REPORTING

#dim_memberset=5

TIME:2011.01,2011.02,2011.03,2011.04,2011.05,...60 in total.

AUDITTRAIL:C_REPORTING_QTD,C_REPORTING_YTD,2 in total.

UOM_REPORTING:BASE,1 in total.

PR_ACCOUNT:PR_01,PR_02,PR_03,PR_04,PR_05,...52 in total.

CATEGORY:DATA_INPUT,1 in total.

REC :%value%*(0)

CALCULATION BEGIN:

QUERY PROCESSING DATA

QUERY TIME : 12.00 ms. 23669  RECORDS QUERIED OUT.

QUERY REFERENCE DATA

CALCULATION TIME IN TOTAL :2.00 ms.

23669  RECORDS ARE GENERATED.

CALCULATION END.

SCRIPT RUNNING TIME IN TOTAL:14.00 s.

---

Please advise..

[former_member186338 · Accepted solution]

As you can see the clear part is working fine!

If your badi part is not working - you have to debug the badi...

Vadim

[Former Member · Accepted solution]

Dear Vadim

yes, its clearing..

I just just found one thing.

Whenever I input certain combination from input schedule, the BADI calculation for YTD and QTD happening for that Product only and not all products.

However in script we scoped all products before calling BADI.

User reporting at total product level and hence un-converted values causing discrepancy.

should the scope from script logic go to BADI?Because we are scoping all products before calling BADI.

however its happening for only values which are inuptted from input schedule.

Please advise.

[former_member186338 · Accepted solution]

Sorry, but without understanding of the badi code it's not possible to help you!

Ask abaper to help you!

Vadim

P.S. To my mind this script is not developed to be launched as default.lgf... Please read