Change row text dynamically

[sunil_hirgude2]

Hello Experts,

I need to change row text fiscal period/year wise using BEx query designer in my report.

I tried to use replacement path variable to resolve but can't woked in my case.

Kindly provide me solution.

Regards,

Yogesh

[Loed]

Hi,

Please post the layout of your query designer..

Regards,

Loed

[sunil_hirgude2]

Hi Loed,

Please check below image..

Here I used a text variable processed by replacement path

[Former Member]

Hello,

Create a text variable with the type of customer exit.

In CMOD exit, write the code for that by reading the input fiscal year/period.

Regards,

Priya M

[Loed]

Hi,

Can you show the filter inside your 3 SELECTIONS in your image? Also, please post the setting of FISC_PERIOD_AVB_TXT..

I think the problem here is how you configured your FISC_PERIOD_AVB_TXT variable..The 2 options work differently..

Regards,

Loed

[sunil_hirgude2]

Hi Priya,

I did customer exit too...but not worked..

[sunil_hirgude2]

Hi Loed,

I don't think so selections are affected to the text variables.

Please check below screen shots having FISC_PERIOD_AVB_TXT variable settings-

[Loed]

Hi,

If you chose INFOOBJECT, you MUST have a local filter for PERIOD in your 3 selections..If you chose variable, then that's the time you are not required to have a LOCAL filter for fiscal period..For sure you don't have a local filter for your PERIOD, right? Then that's where the issue lies..

Regards.

Loed

[Former Member]

Hi,

you can use the standard text variable 0T_FPERT/0T_FPER of fiscal year/period

simply click on text variable option in key figure and choose this variable.

note: fiscal year /period should be filled via variable /section screen.

[sunil_hirgude2]

Hi Jyothi,

Thanks to reply...

As per your suggestion I used above variable but row texts not changed dynamically.

Row text shows only from value text.

e.g. If report input is 007.2015 to 012.2015 then all rows shows only 007.2015 in output.

Actually in report I need to show row texts like below-

Oct 2014 Actual

Oct 2015 Budget

Oct 2015 Actual

Nov 2014 Actual

Nov 2015 Budget

Nov 2015 Actual

.

.

.

I used 3 selections under fiscal year/period.

Please suggest me any solution.

Regards,

Yogesh

[Former Member]

Hi,

you are displaying each period in a separate column, how about restricting each column with fiscal period using off set value?

Note: user input is only a single value here

[sunil_hirgude2]

Hi Jyothi,

Please can you explain in detail what exactly need to do?

[Former Member]

Hi,

column 1 (ex:0ct 2014 actual) --> drag and drop  keyfigure -->restrict it with fiscperiod (single value)

              --> use the same text variable which i mentioned in first thread

column2 (ex:nov 2014 actual) -->drag and drop keyfigure -->restrict it with above fiscperiod -->right click set off set as +1, use the same text variable

similarly for nov -->use fiscperid offset as +2.