Skip to Content
0
Former Member
May 08, 2015 at 07:05 PM

Issue Script Logic PUSH TO BPC 10.1

111 Views

Hello Gurus,

I'm trying to do a script logic to push records from one model to other.

The script is very basic and isn´t recording records in the destination model.

This is the script that is not working.

*SELECT(%TIME%,"[ID]","TIME",ID = %TIME_SET%)

*SELECT(%CAT%,"[ID]","CATEGORY",ID = %CATEGORY_SET%)

*XDIM_MEMBERSET TIME = %TIME%

*XDIM_MEMBERSET CATEGORY = %CAT%

*XDIM_MEMBERSET RPTCURRENCY = CLP

*DESTINATION_APP = EEFF

*RENAME_DIM CECO = ENTITY

*SKIP_DIM= CONCEPT

*WHEN CECO

*IS CCA1

*REC(EXPRESSION = %VALUE%, CECO = AYS1)

*ENDWHEN

*COMMIT

Here the log application

LOG BEGIN TIME:2015-05-08 15:02:03

FILE:\ROOT\WEBFOLDERS\AN100\ADMINAPP\Gastos\ZPUSH_TO_EEFF.LGF

USER:CALCALDE

APPSET:AN100

APPLICATION:Gastos

[INFO] GET_DIM_LIST(): I_APPL_ID="Gastos", #dimensions=8

CATEGORY,CECO,CONCEPT,DRIVERS,F_ACCOUNT,MEASURES,RPTCURRENCY,TIME

#dim_memberset=3

TIME:2013.01,1 in total.

CATEGORY:ACTUAL,CONSO1,CONSO2,CONSO3,FORECAST1,...10 in total.

RPTCURRENCY:CLP,1 in total.

SCRIPT RUNNING TIME IN TOTAL:0.00 s.

LOG END TIME:2015-05-08 15:02:03

Ruta del archivo: \ROOT\WEBFOLDERS\AN100\Gastos\PRIVATEPUBLICATIONS\CALCALDE\tempfiles\20150508150203\ZPUSH_TO_EEFF.LOG

I hope someone can please help

Best Regards