Skip to Content
0
Former Member
Feb 27, 2014 at 05:14 AM

no records generated

17 Views

Hi

gurus

Below is the script for rolling forecast

I am on SP6,EPM 10 NW , though I was using another system with SP16 I had the same issue

why am i seeing no records both in DM and UJKT "norecords generated" there is data in Actuals for the immediate previous periods

//First Month

*XDIM_MEMBERSET CATEGORY_PH = FORECAST

*XDIM_MEMBERSET COMPANY_PH = DPP

*XDIM_MEMBERSET PRODUCT_PH = %PRODUCT_PH_SET%

*XDIM_MEMBERSET RPTCURRENCY_PH = USD

*XDIM_MEMBERSET TIME_PH = %TIME_PH_SET%

*XDIM_MEMBERSET REV_ACC_PH = %REV_ACC_PH_SET%

*FOR %ACCT% = %REV_ACC_PH_SET%

[REV_ACC_PH].[#%ACCT%] = 1/3 * (([REV_ACC_PH].[%ACCT%],[CATEGORY_PH].[ACTUAL],[TIME_PH].[TMVL(-1,%TIME_PH_SET%)]) + ([REV_ACC_PH].[%ACCT%],[CATEGORY_PH].[ACTUAL],[TIME_PH].[TMVL(-2,%TIME_PH_SET%)]) + ([REV_ACC_PH].[%ACCT%],[CATEGORY_PH].[ACTUAL],[TIME_PH].[TMVL(-3,%TIME_PH_SET%)]))

*NEXT

*COMMIT

//Second Month

*XDIM_MEMBERSET CATEGORY_PH = FORECAST

*XDIM_MEMBERSET COMPANY_PH = DPP

*XDIM_MEMBERSET PRODUCT_PH = %PRODUCT_PH_SET%

*XDIM_MEMBERSET RPTCURRENCY_PH = USD

*XDIM_MEMBERSET TIME_PH = TMVL(1,%TIME_PH_SET%)

*XDIM_MEMBERSET REV_ACC_PH = %REV_ACC_PH_SET%

*FOR %ACCT% = %REV_ACC_PH_SET%

[REV_ACC_PH].[#%ACCT%] = 1/3 * (([REV_ACC_PH].[%ACCT%],[CATEGORY_PH].[ACTUAL],[TIME_PH].[TMVL(-1,%TIME_PH_SET%)]) + ([REV_ACC_PH].[%ACCT%],[CATEGORY_PH].[ACTUAL],[TIME_PH].[TMVL(-2,%TIME_PH_SET%)]) + ([REV_ACC_PH].[%ACCT%],[CATEGORY_PH].[FORECAST],[TIME_PH].[TMVL(0,%TIME_PH_SET%)]))

*NEXT

*COMMIT

//Third Month

*XDIM_MEMBERSET CATEGORY_PH = FORECAST

*XDIM_MEMBERSET COMPANY_PH = DPP

*XDIM_MEMBERSET PRODUCT_PH = %PRODUCT_PH_SET%

*XDIM_MEMBERSET RPTCURRENCY_PH = USD

*XDIM_MEMBERSET TIME_PH = TMVL(2,%TIME_PH_SET%)

*XDIM_MEMBERSET REV_ACC_PH = %REV_ACC_PH_SET%

*FOR %ACCT% = %REV_ACC_PH_SET%

[REV_ACC_PH].[#%ACCT%] = 1/3 * (([REV_ACC_PH].[%ACCT%],[CATEGORY_PH].[ACTUAL],[TIME_PH].[TMVL(-1,%TIME_PH_SET%)]) + ([REV_ACC_PH].[%ACCT%],[CATEGORY_PH].[FORECAST],[TIME_PH].[TMVL(0,%TIME_PH_SET%)]) + ([REV_ACC_PH].[%ACCT%],[CATEGORY_PH].[FORECAST],[TIME_PH].[TMVL(1,%TIME_PH_SET%)]))

*NEXT

*COMMIT

ujkt execute simulate with values passed

PRODUCT_PH= EVX00100_XX

TIME_PH =2014.FEB

REV_ACC_PH = MFGUNITS

LGX:

*XDIM_MEMBERSET CATEGORY_PH = FORECAST

*XDIM_MEMBERSET COMPANY_PH = DPP

*XDIM_MEMBERSET PRODUCT_PH = EVX00100_XX

*XDIM_MEMBERSET RPTCURRENCY_PH = USD

*XDIM_MEMBERSET TIME_PH = 2014.FEB

*XDIM_MEMBERSET REV_ACC_PH = MFGUNITS

[REV_ACC_PH].[#MFGUNITS] =1/3 * (([REV_ACC_PH].[MFGUNITS],[CATEGORY_PH].[ACTUAL],[TIME_PH].[ 2015.JAN ]) + ([REV_ACC_PH].[MFGUNITS],[CATEGORY_PH].[ACTUAL],[TIME_PH].[ 2014.DEC ]) + ([REV_ACC_PH].[MFGUNITS],[CATEGORY_PH].[ACTUAL],[TIME_PH].[ 2014.NOV ]))

*COMMIT

*XDIM_MEMBERSET CATEGORY_PH = FORECAST

*XDIM_MEMBERSET COMPANY_PH = DPP

*XDIM_MEMBERSET PRODUCT_PH = EVX00100_XX

*XDIM_MEMBERSET RPTCURRENCY_PH = USD

*XDIM_MEMBERSET TIME_PH = 2015.MAR

*XDIM_MEMBERSET REV_ACC_PH = MFGUNITS

[REV_ACC_PH].[#MFGUNITS] =1/3 * (([REV_ACC_PH].[MFGUNITS],[CATEGORY_PH].[ACTUAL],[TIME_PH].[ 2015.JAN ]) + ([REV_ACC_PH].[MFGUNITS],[CATEGORY_PH].[ACTUAL],[TIME_PH].[ 2014.DEC ]) + ([REV_ACC_PH].[MFGUNITS],[CATEGORY_PH].[FORECAST],[TIME_PH].[ 2014.FEB ]))

*COMMIT

*XDIM_MEMBERSET CATEGORY_PH = FORECAST

*XDIM_MEMBERSET COMPANY_PH = DPP

*XDIM_MEMBERSET PRODUCT_PH = EVX00100_XX

*XDIM_MEMBERSET RPTCURRENCY_PH = USD

*XDIM_MEMBERSET TIME_PH = 2014.MAR

*XDIM_MEMBERSET REV_ACC_PH = MFGUNITS

[REV_ACC_PH].[#MFGUNITS] =1/3 * (([REV_ACC_PH].[MFGUNITS],[CATEGORY_PH].[ACTUAL],[TIME_PH].[ 2015.JAN ]) + ([REV_ACC_PH].[MFGUNITS],[CATEGORY_PH].[FORECAST],[TIME_PH].[ 2014.FEB ]) + ([REV_ACC_PH].[MFGUNITS],[CATEGORY_PH].[FORECAST],[TIME_PH].[ 2015.MAR ]))

*COMMIT

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

LOG:

FILE:\ROOT\WEBFOLDERS\S_Environ \ADMINAPP\REVENUE_PLNG_PH\TEST.LGF

USER:SAPUSER

APPSET:S_Environ

APPLICATION:REVENUE_PLNG_PH

FORMULA : [REV_ACC_PH].[MFGUNITS]=1/3 * (([REV_ACC_PH].[MFGUNITS],[CATEGORY_PH].[ACTUAL],[TIME_PH].[ 2015.JAN ]) + ([REV_ACC_PH].[MFGUNITS],[CATEGORY_PH].[ACTUAL],[TIME_PH].[ 2014.DEC ]) + ([REV_ACC_PH].[MFGUNITS],[CATEGORY_PH].[ACTUAL],[TIME_PH].[ 2014.NOV ]))

CALCULATION BEGIN:

QUERY PROCESSING DATA

QUERY TIME : 261.00 ms. 0 RECORDS QUERIED OUT.

QUERY REFERENCE DATA

QUERY TIME : 239.00 ms. 1 RECORDS QUERIED OUT.

CALCULATION TIME IN TOTAL :132.00 ms.

NO RECORDS GENERATED.

CALCULATION END.

FORMULA : [REV_ACC_PH].[MFGUNITS]=1/3 * (([REV_ACC_PH].[MFGUNITS],[CATEGORY_PH].[ACTUAL],[TIME_PH].[ 2015.JAN ]) + ([REV_ACC_PH].[MFGUNITS],[CATEGORY_PH].[ACTUAL],[TIME_PH].[ 2014.DEC ]) + ([REV_ACC_PH].[MFGUNITS],[CATEGORY_PH].[FORECAST],[TIME_PH].[ 2014.FEB ]))

CALCULATION BEGIN:

QUERY PROCESSING DATA

QUERY TIME : 217.00 ms. 0 RECORDS QUERIED OUT.

QUERY REFERENCE DATA

QUERY TIME : 234.00 ms. 1 RECORDS QUERIED OUT.

CALCULATION TIME IN TOTAL :70.00 ms.

NO RECORDS GENERATED.

CALCULATION END.

FORMULA : [REV_ACC_PH].[MFGUNITS]=1/3 * (([REV_ACC_PH].[MFGUNITS],[CATEGORY_PH].[ACTUAL],[TIME_PH].[ 2015.JAN ]) + ([REV_ACC_PH].[MFGUNITS],[CATEGORY_PH].[FORECAST],[TIME_PH].[ 2014.FEB ]) + ([REV_ACC_PH].[MFGUNITS],[CATEGORY_PH].[FORECAST],[TIME_PH].[ 2015.MAR ]))

CALCULATION BEGIN:

QUERY PROCESSING DATA

QUERY TIME : 216.00 ms. 0 RECORDS QUERIED OUT.

QUERY REFERENCE DATA

QUERY TIME : 234.00 ms. 2 RECORDS QUERIED OUT.

CALCULATION TIME IN TOTAL :65.00 ms.

NO RECORDS GENERATED.

CALCULATION END.

SCRIPT RUNNING TIME IN TOTAL:2.21 s.

thanks