Issue Script Logic TMVL

[Former Member]

Hi gurus,

i'm having a problem with the function TMVL.

When i try to rec a register, the funtion tmvl only takes the year and i can't concatenate with the current period.

the script Logic.

*SELECT(%MYYEAR%,"YEAR",TIME,ID=%TIME_SET%)

*XDIM_MEMBERSET CATEGORY = %CATEGORY_SET%

*XDIM_MEMBERSET TIME = %TIME_SET%

*WHEN F_ACCOUNT

*IS BAS(A4_EBITDA)

*REC(EXPRESSION = %VALUE%, F_ACCOUNT = CF01101)

*ENDWHEN

*WHEN F_ACCOUNT.EFE

*IS CF01102

*REC(EXPRESSION = %VALUE%*-1, F_ACCOUNT = CF01102)

*IS CF01103

*REC(EXPRESSION = %VALUE%, F_ACCOUNT = CF01103)

*IS CF01104

*REC(EXPRESSION = %VALUE%, F_ACCOUNT = CF01104)

*IS CF01106

*REC(EXPRESSION = %VALUE%, F_ACCOUNT = CF01106)

*IS CF01107

*REC(EXPRESSION = %VALUE%, F_ACCOUNT = CF01107)

*IS CF01303

*REC(EXPRESSION = %VALUE%, F_ACCOUNT = CF01303)

*ENDWHEN

*WHEN F_ACCOUNT

*IS BAS(CF_CAJA_FINAL)

*WHEN TIME.MONTHNUM

*IS 1

*REC(EXPRESSION = %VALUE%, F_ACCOUNT = CF_CAJA_INICIAL, TIME = TMVL(1, %MYYEAR%.01))

// *IS 2

// *REC(EXPRESSION = %VALUE%, F_ACCOUNT = CF_CAJA_INICIAL, TIME = TMVL(1, %MYVAR%".02"))

// *IS 3

// *REC(EXPRESSION = %VALUE%, F_ACCOUNT = CF_CAJA_INICIAL, TIME = TMVL(1, %MYVAR%".03"))

// *IS 4

// *REC(EXPRESSION = %VALUE%, F_ACCOUNT = CF_CAJA_INICIAL, TIME = TMVL(1, %MYVAR%".04"))

// *IS 5

// *REC(EXPRESSION = %VALUE%, F_ACCOUNT = CF_CAJA_INICIAL, TIME = TMVL(1, %MYVAR%".05"))

// *IS 6

// *REC(EXPRESSION = %VALUE%, F_ACCOUNT = CF_CAJA_INICIAL, TIME = TMVL(1, %MYVAR%".06"))

// *IS 7

// *REC(EXPRESSION = %VALUE%, F_ACCOUNT = CF_CAJA_INICIAL, TIME = TMVL(1, %MYVAR%".07"))

// *IS 8

// *REC(EXPRESSION = %VALUE%, F_ACCOUNT = CF_CAJA_INICIAL, TIME = TMVL(1, %MYVAR%".08"))

// *IS 9

// *REC(EXPRESSION = %VALUE%, F_ACCOUNT = CF_CAJA_INICIAL, TIME = TMVL(1, %MYVAR%".09"))

// *IS 10

// *REC(EXPRESSION = %VALUE%, F_ACCOUNT = CF_CAJA_INICIAL, TIME = TMVL(1, %MYVAR%".10"))

// *IS 11

// *REC(EXPRESSION = %VALUE%, F_ACCOUNT = CF_CAJA_INICIAL, TIME = TMVL(1, %MYVAR%".11"))

// *IS 12

// *REC(EXPRESSION = %VALUE%, F_ACCOUNT = CF_CAJA_INICIAL, TIME = TMVL(1, %MYVAR%".12"))

*ENDWHEN

*ENDWHEN

*COMMIT

the error message.

[Message]

--------------------------------------------------------------

RUN_LOGIC:Member "2014" not exist

model: EEFF. Package status: ERROR

Thanks for your answers.

Regards

[former_member186338]

Hi Cristobal,

Test the simple script in UJKT (Execute simulate):

*SELECT(%MYYEAR%,"YEAR",TIME,ID=%TIME_SET%)

*XDIM_MEMBERSET TIME = TMVL(1, %MYYEAR%.01)

What is the LGX result?

Vadim

P.S. Hope that TIMEID property is properly maintained in the TIME dimension...

P.P.S. Hope that %TIME_SET% is a single base member!

In general please read

[Former Member]

Hi Vadim, Thanks for your answer.

I think that the function tmvl is working OK.

[Former Member]

There is a note 2141423 - BPC 10.0: REPLACEPARAM Script Failure.

But i cant't download it. i have the following message,

[former_member186338]

Hi Cristobal,

This note is not related to your case (and it contains only instructions).

Please test the whole script in UJKT (without commented part)... Show result.

Vadim

[Former Member]

The result:

-------------------------------------------------------------------------------------------------------------------------------------

LOG:

FILE:\ROOT\WEBFOLDERS\AN100 \ADMINAPP\EEFF\TEST.LGF

USER:BPC_USER

APPSET:AN100

APPLICATION:EEFF

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

AUDITTRAIL,CATEGORY,ENTITY,FLOW,F_ACCOUNT,MEASURES,RPTCURRENCY,TIME

#dim_memberset=2

CATEGORY:PLAN1,1 in total.

TIME:2014.01,1 in total.

REC :%VALUE%

CALCULATION BEGIN:

QUERY PROCESSING DATA

QUERY TIME : 0.00 ms. 154  RECORDS QUERIED OUT.

QUERY REFERENCE DATA

CALCULATION TIME IN TOTAL :0.00 ms.

1  RECORDS ARE GENERATED.

CALCULATION END.

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

AUDITTRAIL,CATEGORY,ENTITY,FLOW,F_ACCOUNT,MEASURES,RPTCURRENCY,TIME

#dim_memberset=2

CATEGORY:PLAN1,1 in total.

TIME:2014.01,1 in total.

REC :%VALUE%*-1

CALCULATION BEGIN:

QUERY PROCESSING DATA

QUERY TIME : 1.00 ms. 2  RECORDS QUERIED OUT.

QUERY REFERENCE DATA

CALCULATION TIME IN TOTAL :0.00 ms.

1  RECORDS ARE GENERATED.

CALCULATION END.

#dim_memberset=2

CATEGORY:PLAN1,1 in total.

TIME:2014.01,1 in total.

REC :%VALUE%

CALCULATION BEGIN:

QUERY PROCESSING DATA

QUERY TIME : 0.00 ms. 4  RECORDS QUERIED OUT.

QUERY REFERENCE DATA

CALCULATION TIME IN TOTAL :0.00 ms.

1  RECORDS ARE GENERATED.

CALCULATION END.

#dim_memberset=2

CATEGORY:PLAN1,1 in total.

TIME:2014.01,1 in total.

REC :%VALUE%

CALCULATION BEGIN:

QUERY PROCESSING DATA

QUERY TIME : 0.00 ms. 2  RECORDS QUERIED OUT.

QUERY REFERENCE DATA

CALCULATION TIME IN TOTAL :0.00 ms.

1  RECORDS ARE GENERATED.

CALCULATION END.

#dim_memberset=2

CATEGORY:PLAN1,1 in total.

TIME:2014.01,1 in total.

REC :%VALUE%

CALCULATION BEGIN:

QUERY PROCESSING DATA

QUERY TIME : 0.00 ms. 3  RECORDS QUERIED OUT.

QUERY REFERENCE DATA

CALCULATION TIME IN TOTAL :0.00 ms.

1  RECORDS ARE GENERATED.

CALCULATION END.

#dim_memberset=2

CATEGORY:PLAN1,1 in total.

TIME:2014.01,1 in total.

REC :%VALUE%

CALCULATION BEGIN:

QUERY PROCESSING DATA

QUERY TIME : 0.00 ms. 1  RECORDS QUERIED OUT.

QUERY REFERENCE DATA

CALCULATION TIME IN TOTAL :0.00 ms.

1  RECORDS ARE GENERATED.

CALCULATION END.

#dim_memberset=2

CATEGORY:PLAN1,1 in total.

TIME:2014.01,1 in total.

REC :%VALUE%

CALCULATION BEGIN:

QUERY PROCESSING DATA

QUERY TIME : 0.00 ms. 0  RECORDS QUERIED OUT.

QUERY REFERENCE DATA

CALCULATION TIME IN TOTAL :0.00 ms.

NO RECORDS GENERATED.

CALCULATION END.

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

AUDITTRAIL,CATEGORY,ENTITY,FLOW,F_ACCOUNT,MEASURES,RPTCURRENCY,TIME

#dim_memberset=2

CATEGORY:PLAN1,1 in total.

TIME:2014.01,1 in total.

REC :%VALUE%

CALCULATION BEGIN:

QUERY PROCESSING DATA

[Former Member]

LGX:

*XDIM_MEMBERSET CATEGORY = PLAN1

*XDIM_MEMBERSET TIME = 2014.01

*WHEN F_ACCOUNT

*IS BAS(A4_EBITDA)

*REC(EXPRESSION = %VALUE%, F_ACCOUNT = CF01101)

*ENDWHEN

*WHEN F_ACCOUNT.EFE

*IS CF01102

*REC(EXPRESSION = %VALUE%*-1, F_ACCOUNT = CF01102)

*IS CF01103

*REC(EXPRESSION = %VALUE%, F_ACCOUNT = CF01103)

*IS CF01104

*REC(EXPRESSION = %VALUE%, F_ACCOUNT = CF01104)

*IS CF01106

*REC(EXPRESSION = %VALUE%, F_ACCOUNT = CF01106)

*IS CF01107

*REC(EXPRESSION = %VALUE%, F_ACCOUNT = CF01107)

*IS CF01303

*REC(EXPRESSION = %VALUE%, F_ACCOUNT = CF01303)

*ENDWHEN

*WHEN F_ACCOUNT

*IS BAS(CF_CAJA_FINAL)

*WHEN TIME.MONTHNUM

*IS 1

*REC(EXPRESSION = %VALUE%, F_ACCOUNT = CF_CAJA_INICIAL, TIME = 2014.02 )

*ENDWHEN

*ENDWHEN

*COMMIT

-------------------------------------------------------------------------------------------------------------------------------------

LOG:

LOG BEGIN TIME:2015-05-29 11:16:40

FILE:\ROOT\WEBFOLDERS\AN100 \ADMINAPP\EEFF\TEST.LGF

USER:BPC_USER

APPSET:AN100

APPLICATION:EEFF

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

AUDITTRAIL,CATEGORY,ENTITY,FLOW,F_ACCOUNT,MEASURES,RPTCURRENCY,TIME

#dim_memberset=2

CATEGORY:PLAN1,1 in total.

TIME:2014.01,1 in total.

REC :%VALUE%

CALCULATION BEGIN:

QUERY PROCESSING DATA

QUERY TIME : 0.00 ms. 154  RECORDS QUERIED OUT.

QUERY REFERENCE DATA

CALCULATION TIME IN TOTAL :0.00 ms.

1  RECORDS ARE GENERATED.

CALCULATION END.

ENDWHEN ACCUMULATION: 1  RECORDS ARE GENERATED.

DATA TO WRITE BACK:

AUDITTRAIL CATEGORY ENTITY FLOW F_ACCOUNT RPTCURRENCY TIME SIGNEDDATA

INPUT PLAN1 AN F00 CF01101 CLP 2014.01 - 1921515.71

1  RECORDS HAVE BEEN WRITTEN BACK.

WRITING TIME :0.00  ms.

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

AUDITTRAIL,CATEGORY,ENTITY,FLOW,F_ACCOUNT,MEASURES,RPTCURRENCY,TIME

#dim_memberset=2

CATEGORY:PLAN1,1 in total.

TIME:2014.01,1 in total.

REC :%VALUE%*-1

CALCULATION BEGIN:

QUERY PROCESSING DATA

QUERY TIME : 0.00 ms. 2  RECORDS QUERIED OUT.

QUERY REFERENCE DATA

CALCULATION TIME IN TOTAL :0.00 ms.

1  RECORDS ARE GENERATED.

CALCULATION END.

#dim_memberset=2

CATEGORY:PLAN1,1 in total.

TIME:2014.01,1 in total.

REC :%VALUE%

CALCULATION BEGIN:

QUERY PROCESSING DATA

QUERY TIME : 0.00 ms. 4  RECORDS QUERIED OUT.

QUERY REFERENCE DATA

CALCULATION TIME IN TOTAL :0.00 ms.

1  RECORDS ARE GENERATED.

CALCULATION END.

#dim_memberset=2

CATEGORY:PLAN1,1 in total.

TIME:2014.01,1 in total.

REC :%VALUE%

CALCULATION BEGIN:

QUERY PROCESSING DATA

QUERY TIME : 0.00 ms. 2  RECORDS QUERIED OUT.

QUERY REFERENCE DATA

CALCULATION TIME IN TOTAL :0.00 ms.

1  RECORDS ARE GENERATED.

CALCULATION END.

#dim_memberset=2

CATEGORY:PLAN1,1 in total.

TIME:2014.01,1 in total.

REC :%VALUE%

CALCULATION BEGIN:

QUERY PROCESSING DATA

QUERY TIME : 1.00 ms. 3  RECORDS QUERIED OUT.

QUERY REFERENCE DATA

CALCULATION TIME IN TOTAL :0.00 ms.

1  RECORDS ARE GENERATED.

CALCULATION END.

#dim_memberset=2

CATEGORY:PLAN1,1 in total.

TIME:2014.01,1 in total.

REC :%VALUE%

CALCULATION BEGIN:

QUERY PROCESSING DATA

QUERY TIME : 0.00 ms. 1  RECORDS QUERIED OUT.

QUERY REFERENCE DATA

CALCULATION TIME IN TOTAL :0.00 ms.

1  RECORDS ARE GENERATED.

CALCULATION END.

#dim_memberset=2

CATEGORY:PLAN1,1 in total.

TIME:2014.01,1 in total.

REC :%VALUE%

CALCULATION BEGIN:

QUERY PROCESSING DATA

QUERY TIME : 0.00 ms. 0  RECORDS QUERIED OUT.

QUERY REFERENCE DATA

CALCULATION TIME IN TOTAL :0.00 ms.

NO RECORDS GENERATED.

CALCULATION END.

ENDWHEN ACCUMULATION: 5  RECORDS ARE GENERATED.

DATA TO WRITE BACK:

AUDITTRAIL CATEGORY ENTITY FLOW F_ACCOUNT RPTCURRENCY TIME SIGNEDDATA

INPUT PLAN1 AN F00 CF01102 CLP 2014.01 292953.79

INPUT PLAN1 AN F00 CF01103 CLP 2014.01 39923.01

INPUT PLAN1 AN F00 CF01104 CLP 2014.01 - 445192.95

INPUT PLAN1 AN F00 CF01106 CLP 2014.01 - 112316.27

INPUT PLAN1 AN F00 CF01107 CLP 2014.01 34277.95

5  RECORDS HAVE BEEN WRITTEN BACK.

WRITING TIME :0.00  ms.

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

AUDITTRAIL,CATEGORY,ENTITY,FLOW,F_ACCOUNT,MEASURES,RPTCURRENCY,TIME

#dim_memberset=2

CATEGORY:PLAN1,1 in total.

TIME:2014.01,1 in total.

REC :%VALUE%

CALCULATION BEGIN:

QUERY PROCESSING DATA

QUERY TIME : 0.00 ms. 8  RECORDS QUERIED OUT.

QUERY REFERENCE DATA

CALCULATION TIME IN TOTAL :0.00 ms.

1  RECORDS ARE GENERATED.

CALCULATION END.

ENDWHEN ACCUMULATION: 1  RECORDS ARE GENERATED.

DATA TO WRITE BACK:

AUDITTRAIL CATEGORY ENTITY FLOW F_ACCOUNT RPTCURRENCY TIME SIGNEDDATA

INPUT PLAN1 AN F00 CF_CAJA_INICIAL CLP 2014.02 - 2111870.19

1  RECORDS HAVE BEEN WRITTEN BACK.

WRITING TIME :0.00  ms.

SCRIPT RUNNING TIME IN TOTAL:2.00 s.

LOG END TIME:2015-05-29 11:16:42

[former_member186338]

P.S. And the script is strange - I do not understand the logic!

First:

*SELECT(%MYYEAR%,"YEAR",TIME,ID=%TIME_SET%) //%MYYEAR% - 2014

*XDIM_MEMBERSET TIME = %TIME_SET% //2014.01

...

then:

*WHEN TIME.MONTHNUM

*IS 1 //for 2014.01 - 1

*REC(EXPRESSION = %VALUE%, F_ACCOUNT = CF_CAJA_INICIAL, TIME = TMVL(1, %MYYEAR%.01)) //TMVL(1,2014.01)

...

Why not to simply:

TIME = TMVL(1,%TIME_SET%) //same TMVL(1,2014.01)???

Vadim

P.S. Never use useless COMMIT with WHEN/ENDWHEN!

[former_member186338]

No errors!!!

[Former Member]

It's strange, when i tried to use tmvl(1, TIME_SET) is collecting all registers and recording in the last period.

*XDIM_MEMBERSET CATEGORY = %CATEGORY_SET%

*XDIM_MEMBERSET TIME = %TIME_SET%

*WHEN F_ACCOUNT

  *IS BAS(A4_EBITDA)

  *REC(EXPRESSION = %VALUE%, F_ACCOUNT = CF01101)

*ENDWHEN

*WHEN F_ACCOUNT.EFE

  *IS CF01102

  *REC(EXPRESSION = %VALUE%*-1, F_ACCOUNT = CF01102)

  *IS CF01103

  *REC(EXPRESSION = %VALUE%, F_ACCOUNT = CF01103)

  *IS CF01104

  *REC(EXPRESSION = %VALUE%, F_ACCOUNT = CF01104)

  *IS CF01106

  *REC(EXPRESSION = %VALUE%, F_ACCOUNT = CF01106)

  *IS CF01107

  *REC(EXPRESSION = %VALUE%, F_ACCOUNT = CF01107)

  *IS CF01303

  *REC(EXPRESSION = %VALUE%, F_ACCOUNT = CF01303)

*ENDWHEN

*WHEN F_ACCOUNT

  *IS BAS(CF_CAJA_FINAL)

  *WHEN TIME.MONTHNUM

  *IS 1

  *REC(EXPRESSION = %VALUE%, F_ACCOUNT = CF_CAJA_INICIAL, TIME = TMVL(1, %TIME_SET%))

  *IS 2

  *REC(EXPRESSION = %VALUE%, F_ACCOUNT = CF_CAJA_INICIAL, TIME = TMVL(1, %TIME_SET%))

  *IS 3

  *REC(EXPRESSION = %VALUE%, F_ACCOUNT = CF_CAJA_INICIAL, TIME = TMVL(1, %TIME_SET%))

The log:

LOG BEGIN TIME:2015-05-29 11:22:33

FILE:\ROOT\WEBFOLDERS\AN100\ADMINAPP\EEFF\EFE.LGF

USER:CALCALDE

APPSET:AN100

APPLICATION:EEFF

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

AUDITTRAIL,CATEGORY,ENTITY,FLOW,F_ACCOUNT,MEASURES,RPTCURRENCY,TIME

#dim_memberset=2

CATEGORY:PLAN1,1 in total.

TIME:2014.01,2014.02,2014.03,2014.04,2014.05,...12 in total.

REC :%VALUE%

CALCULATION BEGIN:

QUERY PROCESSING DATA

QUERY TIME : 1.00 ms. 1911  RECORDS QUERIED OUT.

QUERY REFERENCE DATA

CALCULATION TIME IN TOTAL :0.00 ms.

12  RECORDS ARE GENERATED.

CALCULATION END.

ENDWHEN ACCUMULATION: 12  RECORDS ARE GENERATED.

DATA TO WRITE BACK:

AUDITTRAIL CATEGORY ENTITY FLOW F_ACCOUNT RPTCURRENCY TIME SIGNEDDATA

INPUT PLAN1 AN F00 CF01101 CLP 2014.01 - 1921515.71

INPUT PLAN1 AN F00 CF01101 CLP 2014.02 - 1829866.42

INPUT PLAN1 AN F00 CF01101 CLP 2014.03 - 1884017.66

INPUT PLAN1 AN F00 CF01101 CLP 2014.04 - 1360131.89

INPUT PLAN1 AN F00 CF01101 CLP 2014.05 - 1405000.60

INPUT PLAN1 AN F00 CF01101 CLP 2014.06 - 1276323.30

INPUT PLAN1 AN F00 CF01101 CLP 2014.07 - 1155357.52

INPUT PLAN1 AN F00 CF01101 CLP 2014.08 - 1219634.67

INPUT PLAN1 AN F00 CF01101 CLP 2014.09 - 1315674.94

INPUT PLAN1 AN F00 CF01101 CLP 2014.10 - 1588287.35

INPUT PLAN1 AN F00 CF01101 CLP 2014.11 - 1612243.27

INPUT PLAN1 AN F00 CF01101 CLP 2014.12 - 2007340.93

12  RECORDS HAVE BEEN WRITTEN BACK.

WRITING TIME :0.00  ms.

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

AUDITTRAIL,CATEGORY,ENTITY,FLOW,F_ACCOUNT,MEASURES,RPTCURRENCY,TIME

#dim_memberset=2

CATEGORY:PLAN1,1 in total.

TIME:2014.01,2014.02,2014.03,2014.04,2014.05,...12 in total.

REC :%VALUE%*-1

CALCULATION BEGIN:

QUERY PROCESSING DATA

QUERY TIME : 0.00 ms. 24  RECORDS QUERIED OUT.

QUERY REFERENCE DATA

CALCULATION TIME IN TOTAL :0.00 ms.

12  RECORDS ARE GENERATED.

CALCULATION END.

#dim_memberset=2

CATEGORY:PLAN1,1 in total.

TIME:2014.01,2014.02,2014.03,2014.04,2014.05,...12 in total.

REC :%VALUE%

CALCULATION BEGIN:

QUERY PROCESSING DATA

QUERY TIME : 0.00 ms. 48  RECORDS QUERIED OUT.

QUERY REFERENCE DATA

CALCULATION TIME IN TOTAL :0.00 ms.

12  RECORDS ARE GENERATED.

CALCULATION END.

#dim_memberset=2

CATEGORY:PLAN1,1 in total.

TIME:2014.01,2014.02,2014.03,2014.04,2014.05,...12 in total.

REC :%VALUE%

CALCULATION BEGIN:

QUERY PROCESSING DATA

QUERY TIME : 0.00 ms. 24  RECORDS QUERIED OUT.

QUERY REFERENCE DATA

CALCULATION TIME IN TOTAL :0.00 ms.

12  RECORDS ARE GENERATED.

CALCULATION END.

#dim_memberset=2

CATEGORY:PLAN1,1 in total.

TIME:2014.01,2014.02,2014.03,2014.04,2014.05,...12 in total.

REC :%VALUE%

CALCULATION BEGIN:

QUERY PROCESSING DATA

QUERY TIME : 1.00 ms. 36  RECORDS QUERIED OUT.

QUERY REFERENCE DATA

CALCULATION TIME IN TOTAL :0.00 ms.

12  RECORDS ARE GENERATED.

CALCULATION END.

#dim_memberset=2

CATEGORY:PLAN1,1 in total.

TIME:2014.01,2014.02,2014.03,2014.04,2014.05,...12 in total.

REC :%VALUE%

CALCULATION BEGIN:

QUERY PROCESSING DATA

QUERY TIME : 0.00 ms. 12  RECORDS QUERIED OUT.

QUERY REFERENCE DATA

CALCULATION TIME IN TOTAL :0.00 ms.

12  RECORDS ARE GENERATED.

CALCULATION END.

#dim_memberset=2

CATEGORY:PLAN1,1 in total.

TIME:2014.01,2014.02,2014.03,2014.04,2014.05,...12 in total.

REC :%VALUE%

CALCULATION BEGIN:

QUERY PROCESSING DATA

QUERY TIME : 0.00 ms. 4  RECORDS QUERIED OUT.

QUERY REFERENCE DATA

CALCULATION TIME IN TOTAL :0.00 ms.

2  RECORDS ARE GENERATED.

CALCULATION END.

ENDWHEN ACCUMULATION: 62  RECORDS ARE GENERATED.

DATA TO WRITE BACK:

AUDITTRAIL CATEGORY ENTITY FLOW F_ACCOUNT RPTCURRENCY TIME SIGNEDDATA

INPUT PLAN1 AN F00 CF01102 CLP 2014.01 292953.79

INPUT PLAN1 AN F00 CF01102 CLP 2014.02 - 190038.64

INPUT PLAN1 AN F00 CF01102 CLP 2014.03 68389.19

INPUT PLAN1 AN F00 CF01102 CLP 2014.04 - 351241.12

INPUT PLAN1 AN F00 CF01102 CLP 2014.05 - 114271.74

INPUT PLAN1 AN F00 CF01102 CLP 2014.06 - 30109.60

INPUT PLAN1 AN F00 CF01102 CLP 2014.07 72337.82

INPUT PLAN1 AN F00 CF01102 CLP 2014.08 9548.14

INPUT PLAN1 AN F00 CF01102 CLP 2014.09 34566.76

INPUT PLAN1 AN F00 CF01102 CLP 2014.10 95212.11

INPUT PLAN1 AN F00 CF01102 CLP 2014.11 - 32846.73

INPUT PLAN1 AN F00 CF01102 CLP 2014.12 246170.45

INPUT PLAN1 AN F00 CF01103 CLP 2014.01 39923.01

INPUT PLAN1 AN F00 CF01103 CLP 2014.02 - 3193.33

INPUT PLAN1 AN F00 CF01103 CLP 2014.03 74213.15

INPUT PLAN1 AN F00 CF01103 CLP 2014.04 81648.07

INPUT PLAN1 AN F00 CF01103 CLP 2014.05 81867.94

INPUT PLAN1 AN F00 CF01103 CLP 2014.06 80403.19

INPUT PLAN1 AN F00 CF01103 CLP 2014.07 80482.46

INPUT PLAN1 AN F00 CF01103 CLP 2014.08 79456.60

INPUT PLAN1 AN F00 CF01103 CLP 2014.09 82767.55

INPUT PLAN1 AN F00 CF01103 CLP 2014.10 85715.99

INPUT PLAN1 AN F00 CF01103 CLP 2014.11 87690.85

INPUT PLAN1 AN F00 CF01103 CLP 2014.12 78110.24

INPUT PLAN1 AN F00 CF01104 CLP 2014.01 - 445192.95

INPUT PLAN1 AN F00 CF01104 CLP 2014.02 - 503758.53

INPUT PLAN1 AN F00 CF01104 CLP 2014.03 - 485697.13

INPUT PLAN1 AN F00 CF01104 CLP 2014.04 - 466790.33

INPUT PLAN1 AN F00 CF01104 CLP 2014.05 - 427633.75

INPUT PLAN1 AN F00 CF01104 CLP 2014.06 - 389035.12

INPUT PLAN1 AN F00 CF01104 CLP 2014.07 - 340864.05

INPUT PLAN1 AN F00 CF01104 CLP 2014.08 - 374477.44

INPUT PLAN1 AN F00 CF01104 CLP 2014.09 - 390585.89

INPUT PLAN1 AN F00 CF01104 CLP 2014.10 - 415114.18

INPUT PLAN1 AN F00 CF01104 CLP 2014.11 - 452698.77

INPUT PLAN1 AN F00 CF01104 CLP 2014.12 - 478428.25

INPUT PLAN1 AN F00 CF01106 CLP 2014.01 - 112316.15

INPUT PLAN1 AN F00 CF01106 CLP 2014.02 49604.49

INPUT PLAN1 AN F00 CF01106 CLP 2014.03 398979.21

INPUT PLAN1 AN F00 CF01106 CLP 2014.04 - 31178.37

INPUT PLAN1 AN F00 CF01106 CLP 2014.05 198350.45

INPUT PLAN1 AN F00 CF01106 CLP 2014.06 286270.47

INPUT PLAN1 AN F00 CF01106 CLP 2014.07 434395.23

INPUT PLAN1 AN F00 CF01106 CLP 2014.08 333765.30

INPUT PLAN1 AN F00 CF01106 CLP 2014.09 354550.42

INPUT PLAN1 AN F00 CF01106 CLP 2014.10 429282.92

INPUT PLAN1 AN F00 CF01106 CLP 2014.11 288629.35

INPUT PLAN1 AN F00 CF01106 CLP 2014.12 559406.44

INPUT PLAN1 AN F00 CF01107 CLP 2014.01 34277.95

INPUT PLAN1 AN F00 CF01107 CLP 2014.02 31248.09

INPUT PLAN1 AN F00 CF01107 CLP 2014.03 33648.95

INPUT PLAN1 AN F00 CF01107 CLP 2014.04 34580.27

INPUT PLAN1 AN F00 CF01107 CLP 2014.05 36596.37

INPUT PLAN1 AN F00 CF01107 CLP 2014.06 36035.69

INPUT PLAN1 AN F00 CF01107 CLP 2014.07 36787.76

INPUT PLAN1 AN F00 CF01107 CLP 2014.08 37417.29

INPUT PLAN1 AN F00 CF01107 CLP 2014.09 36575.44

INPUT PLAN1 AN F00 CF01107 CLP 2014.10 37741.20

INPUT PLAN1 AN F00 CF01107 CLP 2014.11 37347.11

INPUT PLAN1 AN F00 CF01107 CLP 2014.12 38099.37

INPUT PLAN1 AN F00 CF01303 CLP 2014.06 239297.02

INPUT PLAN1 AN F00 CF01303 CLP 2014.12 239297.02

62  RECORDS HAVE BEEN WRITTEN BACK.

WRITING TIME :0.00  ms.

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

AUDITTRAIL,CATEGORY,ENTITY,FLOW,F_ACCOUNT,MEASURES,RPTCURRENCY,TIME

#dim_memberset=2

CATEGORY:PLAN1,1 in total.

TIME:2014.01,2014.02,2014.03,2014.04,2014.05,...12 in total.

REC :%VALUE%

CALCULATION BEGIN:

QUERY PROCESSING DATA

QUERY TIME : 0.00 ms. 8  RECORDS QUERIED OUT.

QUERY REFERENCE DATA

CALCULATION TIME IN TOTAL :0.00 ms.

1  RECORDS ARE GENERATED.

CALCULATION END.

#dim_memberset=2

CATEGORY:PLAN1,1 in total.

TIME:2014.01,2014.02,2014.03,2014.04,2014.05,...12 in total.

REC :%VALUE%

CALCULATION BEGIN:

QUERY PROCESSING DATA

QUERY TIME : 0.00 ms. 9  RECORDS QUERIED OUT.

QUERY REFERENCE DATA

CALCULATION TIME IN TOTAL :0.00 ms.

1  RECORDS ARE GENERATED.

CALCULATION END.

#dim_memberset=2

CATEGORY:PLAN1,1 in total.

TIME:2014.01,2014.02,2014.03,2014.04,2014.05,...12 in total.

REC :%VALUE%

CALCULATION BEGIN:

QUERY PROCESSING DATA

QUERY TIME : 0.00 ms. 9  RECORDS QUERIED OUT.

QUERY REFERENCE DATA

CALCULATION TIME IN TOTAL :1.00 ms.

1  RECORDS ARE GENERATED.

CALCULATION END.

ENDWHEN ACCUMULATION: 1  RECORDS ARE GENERATED.

DATA TO WRITE BACK:

AUDITTRAIL CATEGORY ENTITY FLOW F_ACCOUNT RPTCURRENCY TIME SIGNEDDATA

INPUT PLAN1 AN F00 CF_CAJA_INICIAL CLP 2015.01 - 8464228.89

1  RECORDS HAVE BEEN WRITTEN BACK.

WRITING TIME :0.00  ms.

SCRIPT RUNNING TIME IN TOTAL:3.00 s.

LOG END TIME:2015-05-29 11:22:36

Ruta del archivo: \ROOT\WEBFOLDERS\AN100\EEFF\PRIVATEPUBLICATIONS\CALCALDE\tempfiles\20150529112233\EFE.LOG

[former_member186338]

Error is here:

TIME:2014.01,2014.02,2014.03,2014.04,2014.05,...12 in total.

Single value required for TMVL!!!!!

Or you have to use FOR/NEXT

Vadim

P.S. I have already told you - PLEASE READ

You have to explain your logic!!!!

[Former Member]

apologize for my basic explanation.

i need that, that the scrpit execute one or more periods, for this reason i'm trying use when time.monthnum and the varibale %year%.01, %year%.02...

I have to move registers from (F_ACCOUNT=CF_CAJA_FINAL, TIME = 2014.01) the current period to the next period(F_ACCOUNT =CF_CAJA_INICIAL, TIME = 2014.02)

I really hope that you can understand me.

Thank you so much

Regards

[former_member186338]

"one or more periods" - you want user to be able to select any number of base time members (even for different years!) and to perform calculations with time shift to next period. Correct?

Vadim

P.S. You can restrict selection to a single year!

[former_member186338]

With FOR/NEXT:

*XDIM_MEMBERSET CATEGORY = %CATEGORY_SET%

... //2 WHEN/ENDWHEN loops...

*XDIM_MEMBERSET ACCOUNT=BAS(CF_CAJA_FINAL)

*FOR %T%=%TIME_SET%

*XDIM_MEMBERSET TIME = %T% //for each base time member selected by user

*WHEN TIME

*IS *

*REC(EXPRESSION = %VALUE%, F_ACCOUNT = CF_CAJA_INICIAL, TIME = TMVL(1, %T%))

*ENWHEN

*NEXT

Vadim

[Former Member]

Exact! The user can select any number of base time members but for only one year.

I tried to use the sentence

*REC(EXPRESSION = %VALUE%, F_ACCOUNT = CF_CAJA_INICIAL, TIME = TMVL(1, $vartime$.01)) But is not properly because the user have to write the year.

For that reason i used *SELECT(%MYYEAR%,"YEAR",TIME,ID=%TIME_SET%) to extract the year and use it in the tmvl function.

[former_member186338]

"For that reason i used *SELECT(%MYYEAR%,"YEAR",TIME,ID=%TIME_SET%) to extract the year and use it in the tmvl function." - also incorrect!

If you have multiple members in %TIME_SET% then multiple YEAR strings will be extracted generating error in TMVL. Sample:

%TIME_SET% - 2014.01,2014.02

%MYYEAR% - 2014,2014

TMVL(1,%MYYEAR%.01) - TMVL(1,2014,2014.01) - ERROR!

Use FOR/NEXT like in my post!

Vadim

[former_member186338]

Another option is to create a property in the TIME dimension like NEXTPERIOD, fill it for all base members with the ID of next period (month).

Then you can avoid FOR/NEXT:

*XDIM_MEMBERSET TIME = %TIME_SET%

*WHEN TIME

*IS *

*REC(EXPRESSION = %VALUE%, F_ACCOUNT = CF_CAJA_INICIAL, TIME = TIME.NEXTPERIOD)

*ENDWHEN

Vadim

[former_member200327]

Hi Vadim,

TMVL with multiple members shouldn't create an error. Result depends on the 1st parameter - if it's positive or negative.

Regards,

Gersh

[former_member186338]

Hi Gersh,

TMVL with multiple members shouldn't create an error. - Correct!

But in this case we have TMVL with second parameter as incomplete member:

TMVL(1,2014,2014.01)

2014 - is not a member.

Vadim

P.S. Resulting in:

"RUN_LOGIC:Member "2014" not exist

model: EEFF. Package status: ERROR"

[Former Member]

Thanks Vadim,

do you know if the sentence *REC(EXPRESSION = %VALUE%+([F_ACCOUNT].[CF_CAJA_INICIAL],[TIME].[TIME.PREV_PERIOD]), F_ACCOUNT = CF_CAJA_INICIAL) its posible?

[former_member186338]

What is "[TIME.PREV_PERIOD]"???

And the idea to sum values in REC is not good, better accumulate in target!

Sorry, but better to close this discussion and open a new one with CLEAR requirements (as it's explained here )!

Vadim