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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.