Skip to Content
avatar image
Former Member

How to show only Fiscal year from Fiscal Year/period in BEx report

Hi All,

I want show only fiscal year from fiscal year/period in BEX report.

For example: to show only 2017 instead of 006.2017.

Could anyone please help me?

rgds,

Rathina

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Jun 01, 2017 at 06:45 AM

    Do you have fiscal year in your time dimension? Use it in query in case you are populating data for it.

    Thanks,

    Bhavin Vyas

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi Bhavin,

      Yes. i have fiscal year in our time dimension. It stores in Key.

      But i want to store the FY in Text, to pass the value to SAP Lumira.

      rgds,

      Rathina

  • avatar image
    Former Member
    Jun 01, 2017 at 09:39 AM

    Hi Bhavin,

    Yes. i have Fiscal year in our dimennsion. It stores in Key.But i want to show in text.

    SAP Lumira accepts value from text .

    rgds,

    Rathina

    Add comment
    10|10000 characters needed characters exceeded