Skip to Content
0
Jul 28, 2016 at 11:19 AM

Script logic Question

37 Views

Hi exprets ,

I have an AST member that should be repeated over time

I did it with this script the KPI is an inputed value.

*SELECT(%LASTTID%,[TIMEID],TEMPS,ID=%TEMPS_SET%) //get TIMEID of last upload

*SELECT(%Y%,[YEAR],TEMPS,ID=%TEMPS_SET%) //get Year of last upload

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

//%TARGET% will contain remaining periods

*XDIM_MEMBERSET TEMPS=%TEMPS_SET%

*WHEN TV_COUTS_CHARGES.ACCTYPE

*IS AST

*FOR %T%=%TARGET%

*REC(EXPRESSION=%VALUE%,TEMPS=%T%)

*NEXT

*ENDWHEN

*COMMIT

and then this value should be send to another cube with destination app, the problem here is that the value that is send is just the I wrote in a the specific month not for all months .

here is the script of destination app

*DESTINATION_APP = Ressources_humaines

*SKIP_DIM =Nature

*SKIP_DIM =Famille

*RENAME_DIM TV_COUTS_CHARGES=TV_KPI_RH

*WHEN TV_COUTS_CHARGES

*IS CA002

*REC(FACTOR=1 , TV_COUTS_CHARGES = KPIRH003)

*ENDWHEN

*COMMIT

the problem here is the repeated values aren't sent to the desnation cube . how could I resolve that .

thank you .