Skip to Content
0

advice regarding changing the Fiscal Year

Sep 07, 2017 at 09:16 AM

35

avatar image
Former Member

Hi Bpc Friends

I would like to have some advices regarding the implications of changing the FY.

At the moment our fiscal year run from May to Apr but we would like to change it to run from Aug to Jul so we will face the scenario to have a fiscal year of 15 months in the middle of the changing process.

Our application is YTD but we need to have periodic reports. This means we need a more complex formula for YTD to Periodic to be able to use May as first month for some years and August as first month for other years. is that possible?

Thanks

Michele

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Vadim Kalinin Sep 07, 2017 at 10:02 AM
0

A lot of issues have to be solved. Please, create a copy of the environment and start testing.

Some general rules for the TIME dimension:

1. All members has to be a part of 3 level structure: YEAR-QUARTER-MONTH - for hidden hierarchies to work correctly.

2. First month of each Year need to have the following properties: PERIOD: JAN; MONTHNUM: 1; BASE_PERIOD: 001 - to get proper results for measures formulas.

3. Second month of each Year need to have the following properties: PERIOD: FEB; MONTHNUM: 2; BASE_PERIOD: 002 etc...

4. Last month of each Year has to have the following properties: PERIOD: DEC; MONTHNUM: (may be 12 or...); BASE_PERIOD: xxx - for Balance carry forward rule to work properly.

5. First Quarter of the Year: PERIOD: Q1 - to get proper results for measures formulas.

5. YEAR property has to be the same as YEAR level parent.

6. TIMEID has to be set on base members - MONTH level to have proper sorting order for TMVL

A lot of tests have to be done: currency conversion, consolidation, various scripts etc...

Show 1 Share
10 |10000 characters needed characters left characters exceeded
Former Member

thanks Vadim

0