Skip to Content
0
Jul 15, 2016 at 05:13 PM

Script logic question Allocation ans cumulated KPI

45 Views

Hi Experts,

Business logic

I have a KPI wich is rate of production,

So I have Daily production : loaded value and Calendar wich is an input value

rate of production = Cumulative value of production and / cumulative value of calendar.

so normaly the script should be executed after inputing value of calendar loading value of daily production ( DM , daily load )

both of cumulative value of production and cumulative value of calendar are ACCTYPE AST.

normaly the cumulative value should be repated till the end of year .

Scipt :

daily calendar of treatement :EXTR0020

cumulative value of calendar:EXT001757

Daily production :EXTR0094

Cumulative value of production:EXTR00940

rate of production:EXTR0021

so I have in my DEFAULT

//EXTR0020->input value

*XDIM_MEMBERSET MEASURES = PERIODIC

*WHEN TV_EXTRACTION

*IS EXTR0020

*REC(EXPRESSION=[MEASURES].[YTD],TV_EXTRACTION = EXT001757)

*ENDWHEN

*COMMIT

//EXT001757-> input value

*WHEN TV_EXTRACTION

*IS EXT001757

*REC(EXPRESSION=[TV_EXTRACTION].[EXTR00940]/[TV_EXTRACTION].[EXT001757],TV_EXTRACTION = EXTR0021)

*ENDWHEN

*COMMIT

////Allocation

*SELECT(%LASTTID%,[TIMEID],JOUR,ID=%JOUR_SET%)

*SELECT(%Y%,[YEAR],JOUR,ID=%JOUR_SET%)

*SELECT(%BS%,[ID],TV_EXTRACTION,ACCTYPE=AST)

*SELECT(%TARGET%,[ID],JOUR,TIMEID>%LASTTID% AND YEAR=%Y% AND CALC=N)

*XDIM_MEMBERSET TV_EXTRACTION=%BS%

*RUNALLOCATION

*FACTOR=1

*DIM JOUR WHAT=%JOUR_SET%;WHERE=%TARGET%

*ENDALLOCATION

*COMMIT

CUMUL.LGF

//Cmulatiive production

*XDIM_MEMBERSET JOUR=BAS(2016)

*XDIM_MEMBERSET TV_EXTRACTION=EXTR0094

*XDIM_MEMBERSET MEASURES = PERIODIC

*WHEN_REF_DATA = MASTER_DATA

*WHEN TV_EXTRACTION

*IS *

*REC(EXPRESSION=[MEASURES].[YTD],TV_EXTRACTION = EXTR00940)

*ENDWHEN

*COMMIT

//

//rate of production

*XDIM_MEMBERSET TV_EXTRACTION=EXTR00940

*XDIM_MEMBERSET JOUR=BAS(2016)

*WHEN_REF_DATA = MASTER_DATA

*WHEN TV_EXTRACTION

*IS *

*REC(EXPRESSION=%VALUE%/[TV_EXTRACTION].[EXT001757],TV_EXTRACTION = EXTR0021)

*ENDWHEN

*COMMIT

When I execute The Default.LGF and then CUMIL.LGF I have correct result

in the loaded value but not the input value.

and when I write an input value the cumulative value of the loaded value is not correct .

You find bellow the sceenshots.

thank you.

regards