runlogic_ph creates lots of replicated lgx files

[mark_pirks]

anyone know how to fix this?

Using RUNLOGIC_PH to run an FX calc within the TRANSF_TO_PLAN script

end up with 100's of LGX copies

*START_BADI RUNLOGIC_PH

QUERY = OFF

WRITE = ON

VALIDATION = OFF

DEBUG = OFF

LOGIC = FXTRANS_CCR.LGF

APPSET = BPC

APP = Planning

DIMENSION CATEGORY = ACTUAL

DIMENSION TIME = %TIME_SET%

...{all other dimensions etc etc}

DIMENSION AUDITTRAIL = <ALL>

DIMENSION RPTCURRENCY = GBP

*END_BADI

ADMINAPP\REPORTING\TRANSF_TO_PLAN.LGF

ADMINAPP\REPORTING\TRANSF_TO_PLAN.LGX

ADMINAPP\REPORTING\5HM9SAREANLYE3WRDDHOB8PK7_TRANSF_TO_PLAN.LGX

ADMINAPP\REPORTING\5HM9SAREANLYE4GAMCWDQRRTS_TRANSF_TO_PLAN.LGX

ADMINAPP\REPORTING\5HM9SAREANLYE4ZTL8JU7QHY4_TRANSF_TO_PLAN.LGX

ADMINAPP\REPORTING\5HM9SAREANLYE5JD37RLOPKRI_TRANSF_TO_PLAN.LGX

ADMINAPP\REPORTING\5HM9SAREANLYE5KOB61XC24ZL_TRANSF_TO_PLAN.LGX

ADMINAPP\REPORTING\5HM9SAREANLYE5KRCR2415KQV_TRANSF_TO_PLAN.LGX

ADMINAPP\REPORTING\5HM9SAREANLYE5LAUT7FBIAWZ_TRANSF_TO_PLAN.LGX

ADMINAPP\REPORTING\5HM9SAREANLYE5MDEVYD9CJ3A_TRANSF_TO_PLAN.LGX

ADMINAPP\REPORTING\5HM9SAREANLYE5R3RUMGSXL75_TRANSF_TO_PLAN.LGX

ADMINAPP\REPORTING\5HM9SAREANLYE5RPXPD02RT0Z_TRANSF_TO_PLAN.LGX

ADMINAPP\REPORTING\5HM9SAREANLYE6AN2R5QEMT8M_TRANSF_TO_PLAN.LGX

ADMINAPP\REPORTING\5HM9SAREANLYE6OD4S9Q2CHS2_TRANSF_TO_PLAN.LGX

ADMINAPP\REPORTING\5HM9SAREANLYE7PHRSWX5V9UC_TRANSF_TO_PLAN.LGX

ADMINAPP\REPORTING\5HM9SAREANLYE8AYKS4A48OHN_TRANSF_TO_PLAN.LGX

ADMINAPP\REPORTING\5HM9SAREANLYE8VLPZSSDG076_TRANSF_TO_PLAN.LGX

ADMINAPP\REPORTING\5HM9SAREANLYE8VN3HKEB4E4T_TRANSF_TO_PLAN.LGX

ADMINAPP\REPORTING\5HM9SAREANLYE8XA7COUO6988_TRANSF_TO_PLAN.LGX

ADMINAPP\REPORTING\5HM9SAREANLYE8XC05KLXKT97_TRANSF_TO_PLAN.LGX

ADMINAPP\REPORTING\5HM9SAREANLYE8YYBG8U8E315_TRANSF_TO_PLAN.LGX

ADMINAPP\REPORTING\5HM9SAREANLYE8Z4DUCB93ALD_TRANSF_TO_PLAN.LGX

ADMINAPP\REPORTING\5HM9SAREANLYE8Z4EQIC0UJC5_TRANSF_TO_PLAN.LGX

ADMINAPP\REPORTING\5HM9SAREANLYE8Z7EAP50CPN8_TRANSF_TO_PLAN.LGX

ADMINAPP\REPORTING\5HM9SAREANLYE8Z9EEQNUB0UT_TRANSF_TO_PLAN.LGX

ADMINAPP\REPORTING\5HM9SAREANLYE8Z58OEYRFC6F_TRANSF_TO_PLAN.LGX

ADMINAPP\REPORTING\5HM9SAREANLYE8ZATTXLNX5FX_TRANSF_TO_PLAN.LGX

ADMINAPP\REPORTING\5HM9SAREANLYE8ZBTNJ47IIMZ_TRANSF_TO_PLAN.LGX

ADMINAPP\REPORTING\5HM9SAREANLYE8ZJ94JQZBYKQ_TRANSF_TO_PLAN.LGX

ADMINAPP\REPORTING\5HM9SAREANLYE8ZJGTVYUJPQL_TRANSF_TO_PLAN.LGX

ADMINAPP\REPORTING\5HM9SAREANLYE9C3R7WWTC19I_TRANSF_TO_PLAN.LGX

ADMINAPP\REPORTING\5HM9SAREANLYE9DCAUDG46XE1_TRANSF_TO_PLAN.LGX

ADMINAPP\REPORTING\5HM9SAREANLYE9DDSQMEXARW5_TRANSF_TO_PLAN.LGX

ADMINAPP\REPORTING\5HM9SAREANLYE9DNIBI9B00AL_TRANSF_TO_PLAN.LGX

ADMINAPP\REPORTING\5HM9SAREANLYE9DNNLIAC2FT7_TRANSF_TO_PLAN.LGX

ADMINAPP\REPORTING\5HM9SAREANLYE9E1CLNDX3HF0_TRANSF_TO_PLAN.LGX

ADMINAPP\REPORTING\5HM9SAREANLYE9F0SSNVYFLD9_TRANSF_TO_PLAN.LGX

ADMINAPP\REPORTING\5HM9SAREANLYE44I86AFDI91Y_TRANSF_TO_PLAN.LGX

ADMINAPP\REPORTING\5HM9SAREANLYE51RA0TTG4YCI_TRANSF_TO_PLAN.LGX

ADMINAPP\REPORTING\5HM9SAREANLYE57KQD91ASTUZ_TRANSF_TO_PLAN.LGX

ADMINAPP\REPORTING\5HM9SAREANLYE64TZ8Q5TV5AS_TRANSF_TO_PLAN.LGX

ADMINAPP\REPORTING\5HM9SAREANLYE75YMVFHT652N_TRANSF_TO_PLAN.LGX

ADMINAPP\REPORTING\5HM9SAREANLYE77W97XO3S57G_TRANSF_TO_PLAN.LGX

ADMINAPP\REPORTING\5HM9SAREANLYE90QOB5CLOQ70_TRANSF_TO_PLAN.LGX

ADMINAPP\REPORTING\5HM9SAREANLYE91YI3OUNQG34_TRANSF_TO_PLAN.LGX

ADMINAPP\REPORTING\5HM9SAREANLYE913DIZYGPEJN_TRANSF_TO_PLAN.LGX

ADMINAPP\REPORTING\5HM9SAREANLYE914YGA3W6LS4_TRANSF_TO_PLAN.LGX

ADMINAPP\REPORTING\5HM9SAREANLYE8916RVOO4FAR_TRANSF_TO_PLAN.LGX

ADMINAPP\REPORTING\5HM9SAREANLYE66034G4QI3BH_TRANSF_TO_PLAN.LGX

ADMINAPP\REPORTING\5HM9SAREANLYEA3DL41JJRBQ6_TRANSF_TO_PLAN.LGX

ADMINAPP\REPORTING\5HM9SAREANLYEA5B9201U7MR5_TRANSF_TO_PLAN.LGX

ADMINAPP\REPORTING\5HM9SAREANLYEAH3PPEPTYXGY_TRANSF_TO_PLAN.LGX

ADMINAPP\REPORTING\5HM9SAREANM04EEV9SH05TFWN_TRANSF_TO_PLAN.LGX

ADMINAPP\REPORTING\5HM9SAREANM04F0BZ50G4TY48_TRANSF_TO_PLAN.LGX

ADMINAPP\REPORTING\5HM9SAREANM04FEY12EAYOFSX_TRANSF_TO_PLAN.LGX

ADMINAPP\REPORTING\5HM9SAREANM04FHXKFO6XQS2M_TRANSF_TO_PLAN.LGX

ADMINAPP\REPORTING\5HM9SAREANM04FJVBNODJI64T_TRANSF_TO_PLAN.LGX

ADMINAPP\REPORTING\5HM9SAREANM04FL0855KQOA42_TRANSF_TO_PLAN.LGX

ADMINAPP\REPORTING\5HM9SAREANM04FWJAR7TSC5FD_TRANSF_TO_PLAN.LGX

ADMINAPP\REPORTING\5HM9SAREANM04FWP1TG8H2SCC_TRANSF_TO_PLAN.LGX

ADMINAPP\REPORTING\5HM9SAREANM04FWPXUGA5UWNM_TRANSF_TO_PLAN.LGX

ADMINAPP\REPORTING\5HM9SAREANM04FWWGLKIQEBS4_TRANSF_TO_PLAN.LGX

ADMINAPP\REPORTING\5HM9SAREANM04FWZSGQLUIH3J_TRANSF_TO_PLAN.LGX

ADMINAPP\REPORTING\5HM9SAREANM04FYD4VNFKBHWA_TRANSF_TO_PLAN.LGX

ADMINAPP\REPORTING\5HM9SAREANM04G0C3WXRF4O1J_TRANSF_TO_PLAN.LGX

ADMINAPP\REPORTING\5HM9SAREANM04G1EU047JIR5V_TRANSF_TO_PLAN.LGX

ADMINAPP\REPORTING\5HM9SAREANM04G1FGI7P4XGI8_TRANSF_TO_PLAN.LGX

ADMINAPP\REPORTING\5HM9SAREANM04G3EO78RVG8BG_TRANSF_TO_PLAN.LGX

ADMINAPP\REPORTING\5HM9SAREANM04G4NBZPV5BJVZ_TRANSF_TO_PLAN.LGX

ADMINAPP\REPORTING\5HM9SAREANM04G090C77SFDK3_TRANSF_TO_PLAN.LGX

ADMINAPP\REPORTING\5HM9SAREANM04G617YKB6RAO8_TRANSF_TO_PLAN.LGX

ADMINAPP\REPORTING\5HM9SAREANM04GG20U8UFKWBK_TRANSF_TO_PLAN.LGX

ADMINAPP\REPORTING\5HM9SAREANM04GHNS3OPUZB8E_TRANSF_TO_PLAN.LGX

[former_member186338]

Sorry, but not clear!

Please post both lgf files! FULL files!

[mark_pirks]

Hi Vadim

Both lgf's attached - the purpose is to transfer current actuals for the month to the planning cube and convert at a constant currency rate (different rate from actuals)

the problem is that at every runtime the RUNLOGIC_PH call is creating a new LGX file

the FX package is run on an associated category which uses ACTUAL as its "FX Simulation: Base Data Category"

Reporting Model

transf-to-plan.txt

Planning model

fxtrans-ccr.txt

[former_member186338]

Read and implement:

https://launchpad.support.sap.com/#/notes/0002590360

[former_member186338]

Very strange code....

For example:

DIMENSION P_PROFITCENTRE = %PCS%

Variable %PCS% not defined...

Then you are transferring LC and GBP and performing FX in Planning...

And FX is done individually by month...

Strange

[mark_pirks]

Hi Vadim

Yes some of the projects code is a little bit backwards but probably down to changing specs and not enough time 🙂

The DIMENSION P_PROFITCENTRE = %PCS% has been copied from a different script which had it as a select - must have been removed by accident at some point - thanks for the spot. - We are due to review all logic scripts once Year End / various projects are resolved.

Re the LGX issue - it happens in a different model on 2 very simple scripts

- this has resulted in 4,000 unnecessary LGX files

Can you help ?

//Clear destination audit trails in Reporting before data is sent

//This code could be removed if light optimise is turned off in the SAP_ED model (ensuring zero's are always sent)

*START_BADI RUNLOGIC_PH

QUERY = OFF

WRITE = ON

DEBUG = OFF

LOGIC = TRANSF_CLEAR.LGF

APP = Reporting

DIMENSION SAP_ED_CO = <NONE>

DIMENSION SAP_ED_PC = <NONE>

DIMENSION SAP_ED_CC = <NONE>

DIMENSION SAP_ED_GL = <NONE>

DIMENSION SAP_ED_CP = <NONE>

DIMENSION SAP_ED_AN = <NONE>

DIMENSION M_AUDITTRAIL = <NONE>

DIMENSION COMPANY = %COMPANY_SET%

DIMENSION TIME = %TIME_SET%

DIMENSION ACCOUNT = BAS(AC_TB),BAS(AC_DIVS),BAS(AC_INTMARKETSTATS)

DIMENSION AUDITTRAIL = BAS(INT_INT_TOT)

DIMENSION CATEGORY = ACTINT

DIMENSION FLOW = FL_BAL, BAS(FL_CALC), BAS(FL_AGETOT)

DIMENSION GROUPS = G_NONE

DIMENSION INTERCO = BAS(IC01_TOT)

DIMENSION PARTNER = BAS(PT_TOT)

DIMENSION PROFITCENTRE = BAS(PC01_TOT)

DIMENSION RPTCURRENCY = LC

DIMENSION VALUEDRIVER = BAS(VD_TOT)

*END_BADI

// Script to clear data in Reporting before transfer from mapping models

*RUNALLOCATION

*FACTOR = 0

*DIM CATEGORY WHAT = ACTINT; WHERE = ACTINT

*ENDALLOCATION