BI Variable (Year)

[Former Member]

Hi,

i have BI variable with an actual year (VAR1). in addition i need a second variable (VAR2) which derives the value of var1 and adds 1.

example

var1 = 2008

var2 = 2008 +1 = 2009

can anybody help?

Thanks in advance.

Mike

[former_member205352 · Accepted solution]

Offset Var1 by 1.

You need not create second variable.

In RKF or selection

when you restrict the characteristic :

right click -> specify variable offsets-> give 1--->ok

Hope this helps.

[Former Member]

Hi,

You need to describe your requirement more clearly. Do you need the second year value in a query or a planning function? For query, you can use offset with the first variable. If its a planning function (formula) you are coding, you can use the TMVL statement.

Edited by: Mayank Gupta

[Former Member]

Hi Mayank,

ok i try to explain it more detailed,

in my scenario i have a planing layout:

example:

product

[Former Member]

Dear Mayank,

ok i try to explain it more detailed,

in my scenario i have a planing layout:such as the folowing example_

product costs 2008 costs 2009 costs 2010

P1 400 300 100

P2 150 170 210

P3 300 100 75

The important part is, before the user is able to enters any data, he enters variable var1 which is the start year for planing. according to the year he entered to additional years appear for planing.

in the example above the user entered var1 = 2008 as a resulte the years 2008 , 2008 +1 , 2008 +2 are shown in the layout.

In case he entered 2005: the years 2055 , 2005 +1, 2005 +2 would be displayed in the layoout.

hiope i explianed my problem better.

thanks for your help

Mike

[Former Member]

When you are creating your input query, restrict the first column using var1, second column using var11 (apply offset 1 to var1) and third column using var12.

[Former Member]

Normally this kind of requirements you don't need two variables use variable offset option.