cancel
Showing results for 
Search instead for 
Did you mean: 

Issue Script Logic PUSH TO BPC 10.1

Former Member
0 Kudos
139

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

Accepted Solutions (0)

Answers (5)

Answers (5)

Former Member
0 Kudos

Hello all,

I can't find the solution to my problem yet.

I currently have a very simple script to do push but it's not working.

*SELECT(%CE_SO%,"[ID]","CECO",SOCIEDAD = AYS1)

*DESTINATION_APP = EEFF

*RENAME_DIM CECO = ENTITY

*SKIP_DIM = CONCEPT

*XDIM_MEMBERSET TIME = BAS(%TIME_SET%)

*XDIM_MEMBERSET CATEGORY = BAS(%CATEGORY_SET%)

*XDIM_MEMBERSET RPTCURRENCY = CLP

*XDIM_MEMBERSET CECO = %CE_SO%

*WHEN TIME

*IS 2013.01

*REC(EXPRESSION = 1000)

*ENDWHEN

*DESTINATION_APP = EEFF

*RENAME_DIM CECO = ENTITY

*SKIP_DIM = CONCEPT

*COMMIT

When i try to change the condition when "2013.01" or WHEN CECO IS CCA11 or WHEN RPTCURRENCY IS CLP i cant't validate the script.

The model's name is EEFF.

Thanks for your answers.

Regards

former_member186338
Active Contributor
0 Kudos

Hi Cristobal,

Please read my document

and provide all required info (including info about BOTH models). Use UJKT to test scripts! If you have some messages - translate to English...

Your script is strange, please remove useless:

*DESTINATION_APP = EEFF

*RENAME_DIM CECO = ENTITY

*SKIP_DIM = CONCEPT

*COMMIT

At the end of the script.

Vadim

Former Member
0 Kudos

Hi all,

Thanks to everybody for your answers, Now i'm checking the model with my coleague.

I'll post the solution when we finish the revision.

Regards

former_member186338
Active Contributor
0 Kudos

Hi Cristobal,

First ensure you have data to write:

//*SELECT(%TIME%,"[ID]","TIME",ID = %TIME_SET%) - useless!

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

//*XDIM_MEMBERSET TIME = %TIME% - useless, the scope is already %TIME_SET%

//*XDIM_MEMBERSET CATEGORY = %CAT%- useless, the scope is already %CATEGORY_SET%

*XDIM_MEMBERSET RPTCURRENCY = CLP

*XDIM_MEMBERSET CECO = CCA1 // why not to scope it?

//Comment writing to EEFF

//*DESTINATION_APP = EEFF

//*RENAME_DIM CECO = ENTITY

//*SKIP_DIM= CONCEPT

*WHEN CECO

*IS * //scoped to CCA1

*REC(EXPRESSION = %VALUE%) //just write to itself!

*ENDWHEN

//*COMMIT - never use COMMIT - useless!

Test result!

Vadim

former_member200327
Active Contributor
0 Kudos

Can you please check if Model Gastos has at least 1 records with CECO = CCA1?

damovand
Product and Topic Expert
Product and Topic Expert
0 Kudos

Hello,

Do you have read / write access in the destination model?

Regards,

Leila