Variable with dynamic period range determination in TVARVC table

[former_member616778]

Dear Experts,

I would like to create a variant from standard program RMCBS039 with a dynamic period range.

capture-variant-with-dynamic-period-determination.png

I would like

• the lower value to be : CURRENT MONTH - 13
• the upper value to be : CURRENT MONTH

I have already created a variable in TVARVC but I have to adjust the period range every month which is far from ideal.

capture-tvarvc.png

Is there any solution in TVARVC table?

Best regards,

Shérif

[FredericGirod]

As it is not a date, you cannot play with dynamic date.

So you have to create a periodic job to change the value of the TVARVC table.

[former_member616778]

Thank you Frédéric, I will set up the periodic job.

Shérif

[Sandra_Rossi]

To make the original question more readable, I post it again with images embedded:

Dear Experts,

I would like to create a variant from standard program RMCBS039 with a dynamic period range.

I would like

• the lower value to be : CURRENT MONTH - 13
• the upper value to be : CURRENT MONTH

I have already created a variable in TVARVC but I have to adjust the period range every month which is far from ideal.

Is there any solution in TVARVC table?

Best regards,

Shérif