Skip to Content
avatar image
Former Member

Ignore fiscal year variant in Fiscal year in BEX

Hi All,

I want to ignore fiscal year variant in fiscal year in BEX report.

As i want to show as Text, I don't want to change as key in display as.

Please help.

rgds,

Rathina

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • Jun 16, 2017 at 09:39 AM

    add fisc variant in your report and set display as hidden, normally no variant will be shown in the fiscal year

    Add comment
    10|10000 characters needed characters exceeded

  • Jun 16, 2017 at 09:39 AM

    To remove compounding object fiscal year variant you can do following,

    1> First drag Fiscal Year Variant info object in "Rows" sections in BEx query and display > Click of info object > Select "Display As = No Display Option" in property.

    2> Now drag fiscal year in "Rows" section and select the display as you want.

    Hope it helps!

    Thanks,

    Bhavin Vyas

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi,

      I tried as you have mentioned. Still it is showing fiscal year as " Apr - March, 4 special periods 2017".

      rgds,

      Rathina

  • avatar image
    Former Member
    Jun 16, 2017 at 10:16 AM

    Hi,

    I tried as you have mentioned. Still it is showing fiscal year as " Apr - March, 4 special periods 2017".

    rgds,

    Rathina

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi Bhavin,

      As per the above document, the GL Account is defined as Key.

      If i define fiscal year as key, it is working fine. But, i want to display fiscal year as Text.

      It is not working.

      rgds,

      Rathina

  • avatar image
    Former Member
    Jun 16, 2017 at 10:55 AM

    Hi ,

    As per the above document, the GL Account is defined as Key.

    If i define fiscal year as key, it is working fine. But, i want to display fiscal year as Text.

    It is not working.

    rgds,

    Rathina

    Add comment
    10|10000 characters needed characters exceeded