Skip to Content

Change row text dynamically

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

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

2 Answers

  • avatar image
    Former Member
    Apr 04, 2016 at 03:16 PM

    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.

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Yogesh Patil

      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.

  • Apr 06, 2016 at 05:34 AM

    Hi,

    Please post the layout of your query designer..

    Regards,

    Loed

    Add comment
    10|10000 characters needed characters exceeded

    • 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