text variable creation problem

[Former Member]

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:

General:

Type of variable:Text

Processing By:Replacement Path

Reference characteristic:Fiscal year/Period

Replacement Path:

Replace variable with:variable

variable:0I_FPER

Replace with:key

use interval:from.

Keyfigures Information:(Columns)

Fiscalyear/period

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,

narasimha

[Former Member]

Hi Narasimha

Just do the following Change..

Type of variable:Text

Processing By:Replacement Path

Reference characteristic:Fiscal year/Period

Replacement Path:

Replace variable with:Infoobject

Replace with:key

use interval:from.

Then it will work.

Regards

Sree