TFM_UPD could not be input

[[email protected]]

Why the following TFM_UPD doesn't work as a constraint?

~TFM_UPD
TimeSlice LimType Attribute Year AllRegions Pset_PN
INVCOST~2050 2020 *(64/90) TRA_Bus_BEV01
INVCOST~2050 2020 *(64/90) TRA_Bus_PHEV01
INVCOST~2050 2020 *(64/90) TRA_Bus_HEV01
INVCOST~2050 2020 *(64/90) TRA_Mot_ELC1
INVCOST~2050 2020 *(64/90) TRA_Rai_Pas-ELC01
INVCOST~2050 2020 *(64/90) TRA_Rai_Frt-ELC01
INVCOST~2050 2020 *(64/90) TRA_Car_BEV01
INVCOST~2050 2020 *(64/90) TRA_Car_PHEV01
INVCOST~2050 2020 *(64/90) TRA_Car_HEV01


Best,
Xiao

[AKanudia]

Because Veda works with a fixed (but evolving) syntax. This will work:

~TFM_MIG
Attribute Year Year2 AllRegions Pset_PN
INVCOST 2020 2050 *0.711111111111111 TRA_Bus_BEV01

[olexandr]

Why the following TFM_UPD doesn't work as a constraint?

~TFM_UPD
TimeSlice LimType Attribute Year AllRegions Pset_PN
INVCOST~2050 2020 *(64/90) TRA_Bus_BEV01
INVCOST~2050 2020 *(64/90) TRA_Bus_PHEV01
INVCOST~2050 2020 *(64/90) TRA_Bus_HEV01
INVCOST~2050 2020 *(64/90) TRA_Mot_ELC1
INVCOST~2050 2020 *(64/90) TRA_Rai_Pas-ELC01
INVCOST~2050 2020 *(64/90) TRA_Rai_Frt-ELC01
INVCOST~2050 2020 *(64/90) TRA_Car_BEV01
INVCOST~2050 2020 *(64/90) TRA_Car_PHEV01
INVCOST~2050 2020 *(64/90) TRA_Car_HEV01


Best,
Xiao

It is because only one year dimension is supported. The best way to think of the update tables is probably as of update queries: https://support.microsoft.com/en-us/offi...e5ee1e0514

[[email protected]]

Because Veda works with a fixed (but evolving) syntax. This will work:

~TFM_MIG
Attribute Year Year2 AllRegions                 Pset_PN
INVCOST 2020 2050       *0.711111111111111 TRA_Bus_BEV01

Hi!

Sorry just a quick question, could the +1 be used in TFM_UPD table? (I mean, the TFM_UPD could only do multiply calculator?)

Best,
Xiao

[AKanudia]

TFM_UPD (and MIG) support the four basic operations: +, -, /, and *.

Note that if a value is not prefixed with an operator, then that value is used as is - without operating with the seed value. If you want to use the addition operator then you have to write '+[number] so that the field is formatted as text.

PS: To UPDate with an absolute negative value, write ~-[number].

[[email protected]]

TFM_UPD (and MIG) support the four basic operations: +, -, /, and *.

Note that if a value is not prefixed with an operator, then that value is used as is - without operating with the seed value. If you want to use the addition operator then you have to write '+[number] so that the field is formatted as text.

PS: To UPDate with an absolute negative value, write ~-[number].

Thank you!