Currency Conversion for shortened Financial Year

time.txtHi,

I wonder if anyone can throw out some pointers on this one.

We are required to change our financial year from from Oct-->Sep to Apr-->Mar to fall in line with our holding company. This means we need to have a "short" year from Oct 2017 to Mar 2018 to bridge the gap

So we have revised our TIME Dimension to reflect this.

The odd thing is that Currency Conversion now does not work for Periods in the "short" year. Seeing the TIME Dimension is the only thing that has changed, the problem is most likely there.

Other things:

  • Currency Conversion still works on prior Periods.
  • I have removed the TIMEID Property and processed the Dimension. I have then replaced it and re-processed.
  • I have uploaded a CSV/TXT of the TIME Dimension.

System:

  • SAP BPC 10.1 on BW 7.51 on HANA

Any hints would be welcome.

Kind Regards

Nick

time.txt (17.9 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • May 11, 2017 at 08:12 AM

    With SAP Landscape Transformation 2.0 (licensed product) driven solution one can handle fiscal year conversion. Also for shortened fiscal year introduction you can use SAP service for a impact analysis and guide to implement.

    Add comment
    10|10000 characters needed characters exceeded

  • May 11, 2017 at 08:53 AM

    Thanks, Manish

    This is specific to BPC on NW. Not really ERP (in my case). So, at this point, it's just the reporting component and specifically how I need to configure the TIME Dimension to cater for the short year, plus the issue we are experiencing with Currency Conversion.

    I hope I am understanding you correctly.

    Kind Regards

    Nick

    Add comment
    10|10000 characters needed characters exceeded

  • May 11, 2017 at 08:16 PM

    From my experience, BPC doesn't respond very well when changing the time dimension..

    What selections are passing onto the data manager package?

    Have you considered running your consolidation and then changing the time dimension after it's finished?

    Add comment
    10|10000 characters needed characters exceeded

    • Hi Lucas,

      Thanks for the reply. (Sorry for the delay in responding - other issues).

      I do know the TIME Dimension in NW is a lot more fiddly than in the MS version.

      The selections are CATEGORY, PCENTRE and TIME. (We're not changing too much here. It normally runs out of preset Package Links.)

      We can't really do that. We run translation packages on a very regular basis. (If I understand you correctly).

      Kind Regards

      Nick

  • May 11, 2017 at 08:34 PM

    The properties of time dimension has to be set according to fiscal year:

    Mar has to be DEC and month number 12.

    And it has to be done for all months of all years.

    Add comment
    10|10000 characters needed characters exceeded

    • In general I think it's not possible to successfully combine different fiscal years with a single time dimension.

      BPC logic assumes that first month of the year has PERIOD - JAN (hard-coded in standard measure) and last month of the year - DEC (in some calculations).

Skip to Content