Skip to Content
Former Member
Jun 15, 2011 at 05:59 AM

text variable creation problem


Hi All,

I have to create text variable which should replace with value at runtime .

for example "fiscal year/period" i have taken variable as " Period /Fiscal year (Interval Entry ,Required)(0I_FPER)".while defining new text variable for selection i have given following values in variable wizard:


Type of variable:Text

Processing By:Replacement Path

Reference characteristic:Fiscal year/Period

Replacement Path:

Replace variable with:variable


Replace with:key

use interval:from.

Keyfigures Information:(Columns)


company code

Selection:Amount(defining text variable next to the amount )

when i run query by specifying interval as 001.2010-003.2010 in the output for text varaible it is displaying001.2010 for all months.I am getting output as:

In columns: 001.2010 002.2010 003.2010

Actual outpout Amount 001.2010 Amount001.2010 Amount001.2010

Expected output Amount001.2010 Amount002.2010 Amount003.2010

Please guide me how to get monthsfor there respective periods.Is the error due to choosing variable Period /Fiscal year (Interval Entry ,Required)(0I_FPER)?

Please let me know how to solve this.

Thanks& regards,