Skip to Content
0

Consolidating data of entities with different Fiscal years

Feb 15, 2017 at 07:09 PM

64

avatar image

Hi Experts

We are doing a consolidation project BPC 10.1 NW classic. The client has a mix of SAP and Non- SAP entities. The Trial balance for Non-SAP entities are being loaded via flat file into BPC.

The SAP entities are on calendar year Jan-Dec, however, some of the non-SAP entities are using Fiscal year Apr-Mar.

What is the best way to handle this?

Should there be additional Time hierarchy, e.g. ParentH2 to handle this difference in fiscal years

or

Should there be separate Time dimension IDs/ Hierarchy with the for the data with Jan to Dec Fiscal year e.g.

ID Description

2016.001 Jan 2016

as well as one for the other fiscal years of Oct- Sep and Apr- March

E_2016.01 Oct 2016

E_2016.01 Nov 15

etc

Any advice would be appreciated

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

0 Answers