Skip to Content

Consolidating data of entities with different Fiscal years

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


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


Any advice would be appreciated

Add comment
10|10000 characters needed characters exceeded

0 Answers