Problem *REC(EXpression= %Value%... ) Script Logic

[former_member182305]

Hello experts,

I have poste previously for a Script Logic I am doing, the problem that came up is that 0 Value come from my Scripting.

I have the next CODE:

*XDIM_MEMBERSET CATEGORIA = Real

*XDIM_MEMBERSET MONEDA = MXN

*XDIM_MEMBERSET SOCIEDAD = 1010

*XDIM_MEMBERSET HOTEL= MTYGA, MTYZV

*XDIM_MEMBERSET ZRELACIONCTACEBE = NA_ZREL

*XDIM_MEMBERSET SUPNOM = NA_SUPRH

*XDIM_MEMBERSET ZSTAGL = NA_ES

*XDIM_MEMBERSET OP_RRHH = NA_RH

*XDIM_MEMBERSET OP_SUPUESTOS = NA_SUP

*XDIM_MEMBERSET CUENTAS=0000650000, 0000650002

*FOR %T%=%PERIODO_SET%

  *XDIM_MEMBERSET PERIODO=TMVL(-12,%T%)

*WHEN CUENTAS.IND

  *IS "HIS"

  *REC(EXPRESSION= %VALUE% *([SOCIEDAD].[NA_CCC],[CATEGORIA].[Real],[CeBe].[NA_CeBe],[CECO].[NA_CECO],[CUENTAS].[NA_ACC],[MONEDA].[MXN],[OP_RRHH].[NA_RH],[SUPNOM].[NA_SUPRH],[ZSTAGL].[NA_ES],[ZRELACIONCTACEBE].[NA_ZREL],[OP_SUPUESTOS].[0INFLACION]), PERIODO = %T%, CATEGORIA ="Sugerido")

*ENDWHEN

*NEXT

If in the Calculation I just left %VALUE% the value in the Scope will be saved in PERIODO %T% and Categoria= "Sugerido".

But when i Try to multipy by the inflation that is store as described in the code:

Sociedad= NA_CCC

CATEGORIA= REAL

CeBe= NA_CeBe

CECO= NA_CECO

CUENTAS= NA_ACC

MONEDA=MXN

......and so on

I get the value 0.

Next I post the log for the %VALUE% alone:

LGX:

*XDIM_MEMBERSET CATEGORIA = Real

*XDIM_MEMBERSET MONEDA = MXN

*XDIM_MEMBERSET SOCIEDAD = 1010

*XDIM_MEMBERSET HOTEL= MTYGA, MTYZV

*XDIM_MEMBERSET ZRELACIONCTACEBE = NA_ZREL

*XDIM_MEMBERSET SUPNOM = NA_SUPRH

*XDIM_MEMBERSET ZSTAGL = NA_ES

*XDIM_MEMBERSET OP_RRHH = NA_RH

*XDIM_MEMBERSET OP_SUPUESTOS = NA_SUP

*XDIM_MEMBERSET CUENTAS=0000650000, 0000650002

*XDIM_MEMBERSET PERIODO= 01.2016

*WHEN CUENTAS.IND

*IS HIS

*REC(EXPRESSION= %VALUE%, PERIODO = 01.2017, CATEGORIA = Sugerido)

*ENDWHEN

*XDIM_MEMBERSET PERIODO= 02.2016

*WHEN CUENTAS.IND

*IS HIS

*REC(EXPRESSION= %VALUE%, PERIODO = 02.2017, CATEGORIA = Sugerido)

*ENDWHEN

*XDIM_MEMBERSET PERIODO= 03.2016

*WHEN CUENTAS.IND

*IS HIS

*REC(EXPRESSION= %VALUE%, PERIODO = 03.2017, CATEGORIA = Sugerido)

*ENDWHEN

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

LOG:

LOG BEGIN TIME:2016-08-23 03:17:08

FILE:\ROOT\WEBFOLDERS\BPC_FIBRA_INN \ADMINAPP\OPERACIONES\TEST.LGF

USER:RBENAVIDES

APPSET:BPC_FIBRA_INN

APPLICATION:OPERACIONES

[INFO] GET_DIM_LIST(): I_APPL_ID="OPERACIONES", #dimensions=14

CATEGORIA,CEBE,CECO,CUENTAS,HOTEL,MEASURES,MONEDA,OP_RRHH,OP_SUPUESTOS,PERIODO,SOCIEDAD,SUPNOM,ZRELACIONCTACEBE,ZSTAGL

#dim_memberset=11

CATEGORIA:Real,1 in total.

MONEDA:MXN,1 in total.

SOCIEDAD:1010,1 in total.

HOTEL:MTYGA,MTYZV,2 in total.

ZRELACIONCTACEBE:NA_ZREL,1 in total.

SUPNOM:NA_SUPRH,1 in total.

ZSTAGL:NA_ES,1 in total.

OP_RRHH:NA_RH,1 in total.

OP_SUPUESTOS:NA_SUP,1 in total.

CUENTAS:0000650000,0000650002,2 in total.

PERIODO:01.2016,1 in total.

REC :%VALUE%

CALCULATION BEGIN:

QUERY PROCESSING DATA

QUERY TIME : 4.00 ms. 7  RECORDS QUERIED OUT.

QUERY REFERENCE DATA

CALCULATION TIME IN TOTAL :0.00 ms.

7  RECORDS ARE GENERATED.

CALCULATION END.

ENDWHEN ACCUMULATION: 7  RECORDS ARE GENERATED.

DATA TO WRITE BACK:

CATEGORIA CEBE CECO CUENTAS HOTEL MONEDA OP_RRHH OP_SUPUESTOS PERIODO SOCIEDAD SUPNOM ZRELACIONCTACEBE ZSTAGL SIGNEDDATA

Sugerido 10TYGA1201 10TYGA1201 0000650000 MTYGA MXN NA_RH NA_SUP 01.2017 1010 NA_SUPRH NA_ZREL NA_ES 525.88

Sugerido 10TYGA1201 10TYGA1201 0000650002 MTYGA MXN NA_RH NA_SUP 01.2017 1010 NA_SUPRH NA_ZREL NA_ES 7714.54

Sugerido 10TYGA4150 10TYGA4150 0000650002 MTYGA MXN NA_RH NA_SUP 01.2017 1010 NA_SUPRH NA_ZREL NA_ES 895.02

Sugerido 10TYZV1201 10TYZV1201 0000650002 MTYZV MXN NA_RH NA_SUP 01.2017 1010 NA_SUPRH NA_ZREL NA_ES 7141.24

Sugerido 10TYZV4050 10TYZV4050 0000650002 MTYZV MXN NA_RH NA_SUP 01.2017 1010 NA_SUPRH NA_ZREL NA_ES 6572.94

Sugerido 10TYZV4150 10TYZV4150 0000650002 MTYZV MXN NA_RH NA_SUP 01.2017 1010 NA_SUPRH NA_ZREL NA_ES 2841.18

Sugerido 10TYZV4250 10TYZV4250 0000650002 MTYZV MXN NA_RH NA_SUP 01.2017 1010 NA_SUPRH NA_ZREL NA_ES 730.60

7  RECORDS HAVE BEEN WRITTEN BACK.

WRITING TIME :1.00  ms.

[INFO] GET_DIM_LIST(): I_APPL_ID="OPERACIONES", #dimensions=14

CATEGORIA,CEBE,CECO,CUENTAS,HOTEL,MEASURES,MONEDA,OP_RRHH,OP_SUPUESTOS,PERIODO,SOCIEDAD,SUPNOM,ZRELACIONCTACEBE,ZSTAGL

#dim_memberset=11

CATEGORIA:Real,1 in total.

MONEDA:MXN,1 in total.

SOCIEDAD:1010,1 in total.

HOTEL:MTYGA,MTYZV,2 in total.

ZRELACIONCTACEBE:NA_ZREL,1 in total.

SUPNOM:NA_SUPRH,1 in total.

ZSTAGL:NA_ES,1 in total.

OP_RRHH:NA_RH,1 in total.

OP_SUPUESTOS:NA_SUP,1 in total.

CUENTAS:0000650000,0000650002,2 in total.

PERIODO:02.2016,1 in total.

REC :%VALUE%

CALCULATION BEGIN:

QUERY PROCESSING DATA

QUERY TIME : 4.00 ms. 7  RECORDS QUERIED OUT.

QUERY REFERENCE DATA

CALCULATION TIME IN TOTAL :0.00 ms.

7  RECORDS ARE GENERATED.

CALCULATION END.

ENDWHEN ACCUMULATION: 7  RECORDS ARE GENERATED.

DATA TO WRITE BACK:

CATEGORIA CEBE CECO CUENTAS HOTEL MONEDA OP_RRHH OP_SUPUESTOS PERIODO SOCIEDAD SUPNOM ZRELACIONCTACEBE ZSTAGL SIGNEDDATA

Sugerido 10TYGA1201 10TYGA1201 0000650002 MTYGA MXN NA_RH NA_SUP 02.2017 1010 NA_SUPRH NA_ZREL NA_ES 10153.24

Sugerido 10TYGA4050 10TYGA4050 0000650002 MTYGA MXN NA_RH NA_SUP 02.2017 1010 NA_SUPRH NA_ZREL NA_ES 3258.52

Sugerido 10TYGA4150 10TYGA4150 0000650002 MTYGA MXN NA_RH NA_SUP 02.2017 1010 NA_SUPRH NA_ZREL NA_ES 5567.14

Sugerido 10TYZV1201 10TYZV1201 0000650002 MTYZV MXN NA_RH NA_SUP 02.2017 1010 NA_SUPRH NA_ZREL NA_ES 9182.98

Sugerido 10TYZV4050 10TYZV4050 0000650002 MTYZV MXN NA_RH NA_SUP 02.2017 1010 NA_SUPRH NA_ZREL NA_ES 10820.14

Sugerido 10TYZV4150 10TYZV4150 0000650002 MTYZV MXN NA_RH NA_SUP 02.2017 1010 NA_SUPRH NA_ZREL NA_ES 5910.48

Sugerido 10TYZV4250 10TYZV4250 0000650002 MTYZV MXN NA_RH NA_SUP 02.2017 1010 NA_SUPRH NA_ZREL NA_ES 2569.86

7  RECORDS HAVE BEEN WRITTEN BACK.

WRITING TIME :0.00  ms.

[INFO] GET_DIM_LIST(): I_APPL_ID="OPERACIONES", #dimensions=14

CATEGORIA,CEBE,CECO,CUENTAS,HOTEL,MEASURES,MONEDA,OP_RRHH,OP_SUPUESTOS,PERIODO,SOCIEDAD,SUPNOM,ZRELACIONCTACEBE,ZSTAGL

#dim_memberset=11

CATEGORIA:Real,1 in total.

MONEDA:MXN,1 in total.

SOCIEDAD:1010,1 in total.

HOTEL:MTYGA,MTYZV,2 in total.

ZRELACIONCTACEBE:NA_ZREL,1 in total.

SUPNOM:NA_SUPRH,1 in total.

ZSTAGL:NA_ES,1 in total.

OP_RRHH:NA_RH,1 in total.

OP_SUPUESTOS:NA_SUP,1 in total.

CUENTAS:0000650000,0000650002,2 in total.

PERIODO:03.2016,1 in total.

REC :%VALUE%

CALCULATION BEGIN:

QUERY PROCESSING DATA

QUERY TIME : 3.00 ms. 9  RECORDS QUERIED OUT.

QUERY REFERENCE DATA

CALCULATION TIME IN TOTAL :1.00 ms.

9  RECORDS ARE GENERATED.

CALCULATION END.

ENDWHEN ACCUMULATION: 9  RECORDS ARE GENERATED.

DATA TO WRITE BACK:

CATEGORIA CEBE CECO CUENTAS HOTEL MONEDA OP_RRHH OP_SUPUESTOS PERIODO SOCIEDAD SUPNOM ZRELACIONCTACEBE ZSTAGL SIGNEDDATA

Sugerido 10TYGA1201 10TYGA1201 0000650000 MTYGA MXN NA_RH NA_SUP 03.2017 1010 NA_SUPRH NA_ZREL NA_ES 228.42

Sugerido 10TYGA1201 10TYGA1201 0000650002 MTYGA MXN NA_RH NA_SUP 03.2017 1010 NA_SUPRH NA_ZREL NA_ES 9896.74

Sugerido 10TYGA4050 10TYGA4050 0000650002 MTYGA MXN NA_RH NA_SUP 03.2017 1010 NA_SUPRH NA_ZREL NA_ES 3690.60

Sugerido 10TYGA4150 10TYGA4150 0000650002 MTYGA MXN NA_RH NA_SUP 03.2017 1010 NA_SUPRH NA_ZREL NA_ES 5227.02

Sugerido 10TYZV1201 10TYZV1201 0000650002 MTYZV MXN NA_RH NA_SUP 03.2017 1010 NA_SUPRH NA_ZREL NA_ES 7410.70

Sugerido 10TYZV4050 10TYZV4050 0000650002 MTYZV MXN NA_RH NA_SUP 03.2017 1010 NA_SUPRH NA_ZREL NA_ES 9895.40

Sugerido 10TYZV4150 10TYZV4150 0000650002 MTYZV MXN NA_RH NA_SUP 03.2017 1010 NA_SUPRH NA_ZREL NA_ES 4111.82

Sugerido 10TYZV4250 10TYZV4250 0000650002 MTYZV MXN NA_RH NA_SUP 03.2017 1010 NA_SUPRH NA_ZREL NA_ES 2138.00

Sugerido 10TYZV4450 10TYZV4450 0000650002 MTYZV MXN NA_RH NA_SUP 03.2017 1010 NA_SUPRH NA_ZREL NA_ES 839.66

9  RECORDS HAVE BEEN WRITTEN BACK.

WRITING TIME :1.00  ms.

SCRIPT RUNNING TIME IN TOTAL:15.00 s.

LOG END TIME:2016-08-23 03:17:22

The values displayed.

But when I use the first code i get all 0.00:

LGX:

*XDIM_MEMBERSET CATEGORIA = Real

*XDIM_MEMBERSET MONEDA = MXN

*XDIM_MEMBERSET SOCIEDAD = 1010

*XDIM_MEMBERSET HOTEL= MTYGA, MTYZV

*XDIM_MEMBERSET ZRELACIONCTACEBE = NA_ZREL

*XDIM_MEMBERSET SUPNOM = NA_SUPRH

*XDIM_MEMBERSET ZSTAGL = NA_ES

*XDIM_MEMBERSET OP_RRHH = NA_RH

*XDIM_MEMBERSET OP_SUPUESTOS = NA_SUP

*XDIM_MEMBERSET CUENTAS=0000650000, 0000650002

*XDIM_MEMBERSET PERIODO= 01.2016

*WHEN CUENTAS.IND

*IS HIS

*REC(EXPRESSION= %VALUE% * ([SOCIEDAD].[NA_CCC],[CATEGORIA].[Real],[CeBe].[NA_CeBe],[CECO].[NA_CECO],[CUENTAS].[NA_ACC],[MONEDA].[MXN],[OP_RRHH].[NA_RH],[SUPNOM].[NA_SUPRH],[ZSTAGL].[NA_ES],[ZRELACIONCTACEBE].[NA_ZREL],[OP_SUPUESTOS].[0INFLACION]), PERIODO = 01.2017, CATEGORIA = Sugerido)

*ENDWHEN

*XDIM_MEMBERSET PERIODO= 02.2016

*WHEN CUENTAS.IND

*IS HIS

*REC(EXPRESSION= %VALUE% * ([SOCIEDAD].[NA_CCC],[CATEGORIA].[Real],[CeBe].[NA_CeBe],[CECO].[NA_CECO],[CUENTAS].[NA_ACC],[MONEDA].[MXN],[OP_RRHH].[NA_RH],[SUPNOM].[NA_SUPRH],[ZSTAGL].[NA_ES],[ZRELACIONCTACEBE].[NA_ZREL],[OP_SUPUESTOS].[0INFLACION]), PERIODO = 02.2017, CATEGORIA = Sugerido)

*ENDWHEN

*XDIM_MEMBERSET PERIODO= 03.2016

*WHEN CUENTAS.IND

*IS HIS

*REC(EXPRESSION= %VALUE% * ([SOCIEDAD].[NA_CCC],[CATEGORIA].[Real],[CeBe].[NA_CeBe],[CECO].[NA_CECO],[CUENTAS].[NA_ACC],[MONEDA].[MXN],[OP_RRHH].[NA_RH],[SUPNOM].[NA_SUPRH],[ZSTAGL].[NA_ES],[ZRELACIONCTACEBE].[NA_ZREL],[OP_SUPUESTOS].[0INFLACION]), PERIODO = 03.2017, CATEGORIA = Sugerido)

*ENDWHEN

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

LOG:

LOG BEGIN TIME:2016-08-23 03:20:58

FILE:\ROOT\WEBFOLDERS\BPC_FIBRA_INN \ADMINAPP\OPERACIONES\TEST.LGF

USER:RBENAVIDES

APPSET:BPC_FIBRA_INN

APPLICATION:OPERACIONES

[INFO] GET_DIM_LIST(): I_APPL_ID="OPERACIONES", #dimensions=14

CATEGORIA,CEBE,CECO,CUENTAS,HOTEL,MEASURES,MONEDA,OP_RRHH,OP_SUPUESTOS,PERIODO,SOCIEDAD,SUPNOM,ZRELACIONCTACEBE,ZSTAGL

#dim_memberset=11

CATEGORIA:Real,1 in total.

MONEDA:MXN,1 in total.

SOCIEDAD:1010,1 in total.

HOTEL:MTYGA,MTYZV,2 in total.

ZRELACIONCTACEBE:NA_ZREL,1 in total.

SUPNOM:NA_SUPRH,1 in total.

ZSTAGL:NA_ES,1 in total.

OP_RRHH:NA_RH,1 in total.

OP_SUPUESTOS:NA_SUP,1 in total.

CUENTAS:0000650000,0000650002,2 in total.

PERIODO:01.2016,1 in total.

REC :%VALUE% * ([SOCIEDAD].[NA_CCC],[CATEGORIA].[Real],[CeBe].[NA_CeBe],[CECO].[NA_CECO],[CUENTAS].[NA_ACC],[MONEDA].[MXN],[OP_RRHH].[NA_RH],[SUPNOM].[NA_SUPRH],[ZSTAGL].[NA_ES],[ZRELACIONCTACEBE].[NA_ZREL],[OP_SUPUESTOS].[0INFLACION])

CALCULATION BEGIN:

QUERY PROCESSING DATA

QUERY TIME : 5.00 ms. 7  RECORDS QUERIED OUT.

QUERY REFERENCE DATA

QUERY TIME : 0.00 ms. 0  RECORDS QUERIED OUT.

CALCULATION TIME IN TOTAL :0.00 ms.

7  RECORDS ARE GENERATED.

CALCULATION END.

ENDWHEN ACCUMULATION: 7  RECORDS ARE GENERATED.

DATA TO WRITE BACK:

CATEGORIA CEBE CECO CUENTAS HOTEL MONEDA OP_RRHH OP_SUPUESTOS PERIODO SOCIEDAD SUPNOM ZRELACIONCTACEBE ZSTAGL SIGNEDDATA

Sugerido 10TYGA1201 10TYGA1201 0000650000 MTYGA MXN NA_RH NA_SUP 01.2017 1010 NA_SUPRH NA_ZREL NA_ES 0.00

Sugerido 10TYGA1201 10TYGA1201 0000650002 MTYGA MXN NA_RH NA_SUP 01.2017 1010 NA_SUPRH NA_ZREL NA_ES 0.00

Sugerido 10TYGA4150 10TYGA4150 0000650002 MTYGA MXN NA_RH NA_SUP 01.2017 1010 NA_SUPRH NA_ZREL NA_ES 0.00

Sugerido 10TYZV1201 10TYZV1201 0000650002 MTYZV MXN NA_RH NA_SUP 01.2017 1010 NA_SUPRH NA_ZREL NA_ES 0.00

Sugerido 10TYZV4050 10TYZV4050 0000650002 MTYZV MXN NA_RH NA_SUP 01.2017 1010 NA_SUPRH NA_ZREL NA_ES 0.00

Sugerido 10TYZV4150 10TYZV4150 0000650002 MTYZV MXN NA_RH NA_SUP 01.2017 1010 NA_SUPRH NA_ZREL NA_ES 0.00

Sugerido 10TYZV4250 10TYZV4250 0000650002 MTYZV MXN NA_RH NA_SUP 01.2017 1010 NA_SUPRH NA_ZREL NA_ES 0.00

7  RECORDS HAVE BEEN WRITTEN BACK.

WRITING TIME :1.00  ms.

[INFO] GET_DIM_LIST(): I_APPL_ID="OPERACIONES", #dimensions=14

CATEGORIA,CEBE,CECO,CUENTAS,HOTEL,MEASURES,MONEDA,OP_RRHH,OP_SUPUESTOS,PERIODO,SOCIEDAD,SUPNOM,ZRELACIONCTACEBE,ZSTAGL

#dim_memberset=11

CATEGORIA:Real,1 in total.

MONEDA:MXN,1 in total.

SOCIEDAD:1010,1 in total.

HOTEL:MTYGA,MTYZV,2 in total.

ZRELACIONCTACEBE:NA_ZREL,1 in total.

SUPNOM:NA_SUPRH,1 in total.

ZSTAGL:NA_ES,1 in total.

OP_RRHH:NA_RH,1 in total.

OP_SUPUESTOS:NA_SUP,1 in total.

CUENTAS:0000650000,0000650002,2 in total.

PERIODO:02.2016,1 in total.

REC :%VALUE% * ([SOCIEDAD].[NA_CCC],[CATEGORIA].[Real],[CeBe].[NA_CeBe],[CECO].[NA_CECO],[CUENTAS].[NA_ACC],[MONEDA].[MXN],[OP_RRHH].[NA_RH],[SUPNOM].[NA_SUPRH],[ZSTAGL].[NA_ES],[ZRELACIONCTACEBE].[NA_ZREL],[OP_SUPUESTOS].[0INFLACION])

CALCULATION BEGIN:

QUERY PROCESSING DATA

QUERY TIME : 4.00 ms. 7  RECORDS QUERIED OUT.

QUERY REFERENCE DATA

QUERY TIME : 0.00 ms. 0  RECORDS QUERIED OUT.

CALCULATION TIME IN TOTAL :0.00 ms.

7  RECORDS ARE GENERATED.

CALCULATION END.

ENDWHEN ACCUMULATION: 7  RECORDS ARE GENERATED.

DATA TO WRITE BACK:

CATEGORIA CEBE CECO CUENTAS HOTEL MONEDA OP_RRHH OP_SUPUESTOS PERIODO SOCIEDAD SUPNOM ZRELACIONCTACEBE ZSTAGL SIGNEDDATA

Sugerido 10TYGA1201 10TYGA1201 0000650002 MTYGA MXN NA_RH NA_SUP 02.2017 1010 NA_SUPRH NA_ZREL NA_ES 0.00

Sugerido 10TYGA4050 10TYGA4050 0000650002 MTYGA MXN NA_RH NA_SUP 02.2017 1010 NA_SUPRH NA_ZREL NA_ES 0.00

Sugerido 10TYGA4150 10TYGA4150 0000650002 MTYGA MXN NA_RH NA_SUP 02.2017 1010 NA_SUPRH NA_ZREL NA_ES 0.00

Sugerido 10TYZV1201 10TYZV1201 0000650002 MTYZV MXN NA_RH NA_SUP 02.2017 1010 NA_SUPRH NA_ZREL NA_ES 0.00

Sugerido 10TYZV4050 10TYZV4050 0000650002 MTYZV MXN NA_RH NA_SUP 02.2017 1010 NA_SUPRH NA_ZREL NA_ES 0.00

Sugerido 10TYZV4150 10TYZV4150 0000650002 MTYZV MXN NA_RH NA_SUP 02.2017 1010 NA_SUPRH NA_ZREL NA_ES 0.00

Sugerido 10TYZV4250 10TYZV4250 0000650002 MTYZV MXN NA_RH NA_SUP 02.2017 1010 NA_SUPRH NA_ZREL NA_ES 0.00

7  RECORDS HAVE BEEN WRITTEN BACK.

WRITING TIME :1.00  ms.

[INFO] GET_DIM_LIST(): I_APPL_ID="OPERACIONES", #dimensions=14

CATEGORIA,CEBE,CECO,CUENTAS,HOTEL,MEASURES,MONEDA,OP_RRHH,OP_SUPUESTOS,PERIODO,SOCIEDAD,SUPNOM,ZRELACIONCTACEBE,ZSTAGL

#dim_memberset=11

CATEGORIA:Real,1 in total.

MONEDA:MXN,1 in total.

SOCIEDAD:1010,1 in total.

HOTEL:MTYGA,MTYZV,2 in total.

ZRELACIONCTACEBE:NA_ZREL,1 in total.

SUPNOM:NA_SUPRH,1 in total.

ZSTAGL:NA_ES,1 in total.

OP_RRHH:NA_RH,1 in total.

OP_SUPUESTOS:NA_SUP,1 in total.

CUENTAS:0000650000,0000650002,2 in total.

PERIODO:03.2016,1 in total.

REC :%VALUE% * ([SOCIEDAD].[NA_CCC],[CATEGORIA].[Real],[CeBe].[NA_CeBe],[CECO].[NA_CECO],[CUENTAS].[NA_ACC],[MONEDA].[MXN],[OP_RRHH].[NA_RH],[SUPNOM].[NA_SUPRH],[ZSTAGL].[NA_ES],[ZRELACIONCTACEBE].[NA_ZREL],[OP_SUPUESTOS].[0INFLACION])

CALCULATION BEGIN:

QUERY PROCESSING DATA

QUERY TIME : 5.00 ms. 9  RECORDS QUERIED OUT.

QUERY REFERENCE DATA

QUERY TIME : 0.00 ms. 0  RECORDS QUERIED OUT.

CALCULATION TIME IN TOTAL :0.00 ms.

9  RECORDS ARE GENERATED.

CALCULATION END.

ENDWHEN ACCUMULATION: 9  RECORDS ARE GENERATED.

DATA TO WRITE BACK:

CATEGORIA CEBE CECO CUENTAS HOTEL MONEDA OP_RRHH OP_SUPUESTOS PERIODO SOCIEDAD SUPNOM ZRELACIONCTACEBE ZSTAGL SIGNEDDATA

Sugerido 10TYGA1201 10TYGA1201 0000650000 MTYGA MXN NA_RH NA_SUP 03.2017 1010 NA_SUPRH NA_ZREL NA_ES 0.00

Sugerido 10TYGA1201 10TYGA1201 0000650002 MTYGA MXN NA_RH NA_SUP 03.2017 1010 NA_SUPRH NA_ZREL NA_ES 0.00

Sugerido 10TYGA4050 10TYGA4050 0000650002 MTYGA MXN NA_RH NA_SUP 03.2017 1010 NA_SUPRH NA_ZREL NA_ES 0.00

Sugerido 10TYGA4150 10TYGA4150 0000650002 MTYGA MXN NA_RH NA_SUP 03.2017 1010 NA_SUPRH NA_ZREL NA_ES 0.00

Sugerido 10TYZV1201 10TYZV1201 0000650002 MTYZV MXN NA_RH NA_SUP 03.2017 1010 NA_SUPRH NA_ZREL NA_ES 0.00

Sugerido 10TYZV4050 10TYZV4050 0000650002 MTYZV MXN NA_RH NA_SUP 03.2017 1010 NA_SUPRH NA_ZREL NA_ES 0.00

Sugerido 10TYZV4150 10TYZV4150 0000650002 MTYZV MXN NA_RH NA_SUP 03.2017 1010 NA_SUPRH NA_ZREL NA_ES 0.00

Sugerido 10TYZV4250 10TYZV4250 0000650002 MTYZV MXN NA_RH NA_SUP 03.2017 1010 NA_SUPRH NA_ZREL NA_ES 0.00

Sugerido 10TYZV4450 10TYZV4450 0000650002 MTYZV MXN NA_RH NA_SUP 03.2017 1010 NA_SUPRH NA_ZREL NA_ES 0.00

9  RECORDS HAVE BEEN WRITTEN BACK.

WRITING TIME :1.00  ms.

SCRIPT RUNNING TIME IN TOTAL:18.00 s.

LOG END TIME:2016-08-23 03:21:15

What am I doing Wrong to achieve the Math?

Regards.

[former_member186338 · Accepted solution]

Are you sure that you have Inflation for PERIODO=TMVL(-12,%T%)????

May be:

*REC(EXPRESSION= %VALUE% *([PERIODO].[%T%],[SOCIEDAD].[NA_CCC],[CATEGORIA].[Real],[CeBe].[NA_CeBe],[CECO].[NA_CECO],[CUENTAS].[NA_ACC],[MONEDA].[MXN],[OP_RRHH].[NA_RH],[SUPNOM].[NA_SUPRH],[ZSTAGL].[NA_ES],[ZRELACIONCTACEBE].[NA_ZREL],[OP_SUPUESTOS].[0INFLACION]), PERIODO = %T%, CATEGORIA ="Sugerido")

[former_member186338 · Accepted solution]

P.S. And please check other dimensions to match Inflation with data!

By the way ZRELACIONCTACEBE ZSTAGL - strange names for BPC dimensions - with "Z"

[former_member182305 · Accepted solution]

Thank you for the post Vadim,

I was checking and just realized that Inflation is in 12.YEAR,

Im trying to figure out now hot to writ it. I was trying next:

*FOR %T%=%PERIODO_SET%

  *XDIM_MEMBERSET PERIODO=TMVL(-12,%T%)

*WHEN CUENTAS.IND

  *IS "HIS"

*SELECT(%YR%,"[YEAR]",PERIODO,"[ID]='%PERIODO_SET%'") //%YR% will get a year from %TIME_SET

  *REC(EXPRESSION= %VALUE%*([PERIODO].[12.%YR%],[SOCIEDAD].[NA_CCC],[CATEGORIA].[Real],[CeBe].[NA_CeBe],[CECO].[NA_CECO],[CUENTAS].[NA_ACC],[MONEDA].[MXN],[OP_RRHH].[NA_RH],[SUPNOM].[NA_SUPRH],[ZSTAGL].[NA_ES],[ZRELACIONCTACEBE].[NA_ZREL],[OP_SUPUESTOS].[0INFLACION]), PERIODO = %T%, CATEGORIA = "Sugerido")

*ENDWHEN

*NEXT

Based on a Thread that you respond.

how would be the right way to set 12.%YR%??

Regards.

[former_member182305 · Accepted solution]

The "Z" are because are BW Characteristics and the BW asked me to keep the name.

[former_member186338 · Accepted solution]

*SELECT(%YR%,"[YEAR]",PERIODO,"[ID]='%PERIODO_SET%'") //%YR% will get a year from %TIME_SET

has to be at the beginning of the script!

And it will get number of years - incorrect!

Correct:

*SELECT(%YRS%,"[YEAR]",PERIODO,"[ID]='%PERIODO_SET%'")

*SELECT(%MNTH1%,"[ID]",PERIODO,"[YEAR]='%YRS%' AND [PERIOD]='JAN'")

*SELECT(%YR%,"[YEAR]",PERIODO,"[ID]='%MNTH1%'")

Assuming that %PERIODO_SET% has members from single year only!!!

[former_member186338 · Accepted solution]

"BW asked me to keep the name" - strange people! In BPC we always use meaningful dimension names without Z

[former_member186338 · Accepted solution]

Full script:

*SELECT(%YRS%,"[YEAR]",PERIODO,"[ID]='%PERIODO_SET%'")

*SELECT(%MNTH1%,"[ID]",PERIODO,"[YEAR]='%YRS%' AND [PERIOD]='JAN'")

*SELECT(%YR%,"[YEAR]",PERIODO,"[ID]='%MNTH1%'")

*XDIM_MEMBERSET CATEGORIA = Real

*XDIM_MEMBERSET MONEDA = MXN

*XDIM_MEMBERSET SOCIEDAD = 1010

*XDIM_MEMBERSET HOTEL= MTYGA, MTYZV

*XDIM_MEMBERSET ZRELACIONCTACEBE = NA_ZREL

*XDIM_MEMBERSET SUPNOM = NA_SUPRH

*XDIM_MEMBERSET ZSTAGL = NA_ES

*XDIM_MEMBERSET OP_RRHH = NA_RH

*XDIM_MEMBERSET OP_SUPUESTOS = NA_SUP

*XDIM_MEMBERSET CUENTAS=0000650000, 0000650002

*FOR %T%=%PERIODO_SET%

*XDIM_MEMBERSET PERIODO=TMVL(-12,%T%)

*WHEN CUENTAS.IND

*IS "HIS"

*REC(EXPRESSION= %VALUE%*([PERIODO].[12.%YR%],[SOCIEDAD].[NA_CCC],[CATEGORIA].[Real],[CeBe].[NA_CeBe],[CECO].[NA_CECO],[CUENTAS].[NA_ACC],[MONEDA].[MXN],[OP_RRHH].[NA_RH],[SUPNOM].[NA_SUPRH],[ZSTAGL].[NA_ES],[ZRELACIONCTACEBE].[NA_ZREL],[OP_SUPUESTOS].[0INFLACION]), PERIODO = %T%, CATEGORIA = "Sugerido")

*ENDWHEN

*NEXT

[former_member182305 · Accepted solution]

thank you very much .