EPM 10.1 Script Logic NW

[former_member792108]

Hi,

We are on EPM BPC - 10.1, EPM 38, SP20 release 10.5

I am writing below script in in Default logic. When i am saving the data using input form for same period and different year, this logic is considering the last year period value and posting in STAT_001 Account for all periods.

*FUNCTION C_CALC_SUM = [ACCOUNT].[SYS_COST]/[ACCOUNT].[ACC_LYF]

*SELECT(%GET_YEAR%, "[YEAR]", TIME, [ID] = %GET_TIME_ID%)

*SELECT(%SRC_MONTHS%, "[ID]", TIME, YEAR = %GET_YEAR% AND CALC ='N')

*SELECT (%SYEAR%,[YEAR],TIME,"[ID] = %MONTH_012%")

*SELECT (%SMNTHS%,"[ID]","TIME","[YEAR] = %GET_YEAR%' AND [ID] >= %TM_SM% AND [LEVEL] = 'MONTH'")

*XDIM_MEMBERSET ACCOUNT = <ALL>

*XDIM_MEMBERSET DATASOURCE = DS1

*XDIM_MEMBERSET CURRENCY = TLC, TUSD

*XDIM_MEMBERSET TIME = %SMNTHS%,%SRC_MONTHS%

*XDIM_MEMBERSET MEASURES = PERIODIC

*XDIM_FILTER PRODUCT = [PRODUCT].PROPERTIES("PD_TP")="RETAIL"

*WHEN CATEGORY

*IS ACT

*WHEN ACCOUNT

*IS SYS_COST

*WHEN PRODUCT.PD_TP

*IS RETAIL

*FOR %ACTYEAR% = %GET_YEAR%

*WHEN TIME.MONTHNUM

*FOR %A1% = 1,2,3,4,5,6,7,8,9,10,11,12 AND %A3% = 001,002,003,004,005,006,007,008,009,010,011,012

*IS %A1%

*REC(EXPRESSION = ([ACCOUNT].[VOLUME],[TIME].[%ACTYEAR%.%A3%],[MEASURES].[YTD])*C_CALC_SUM, ACCOUNT = STAT_001)

*NEXT

*ENDWHEN

*NEXT

*IS RETAIL

*REC(EXPRESSION = C_CALC_ACT, RE_ACCOUNT = STAT_002)

*ENDWHEN

*ENDWHEN

[former_member186338]

Sorry, but instead of incorrect script it's better to describe in details business logic required!