Matrix Consolidation and Legal Consolidation within same BCS data basis
I am working in the SEM-BCS area for years but came across a customer requirement where I am greatful for some expert input.
At the moment my customer is running legal consolidation (Company as Cons Unit). In future integrated management consolidation (Matrix Consolidation) will be required.
I would like to implement matrix consolidation within the same BCS data model (data basis) within a new separate consolidation area.
Meaning legal consolidation would run in Consolidation Area "L", while Matrix Consolidation is intended to run within Consolidation Area "M".
The reason why we want to stay within the same BCS data model (data basis) is, that the customer has a pretty much integrated BCS solution. Change of data model and total cube would mean big effort for reimplementation.
While prototyping the solution I faced some issues within the new Consolidation Area "M" for matrix consolidation while trying to define "Cons Unit Combinations".
Cons Unit combinations have not been saved correctly within the backend tables (CU combinations SIDs, Permitted Cons Unit combinations).
Finally causing a dump within the consolidation monitor at extraction of the org.hierarchy.
Based on this trouble I just wonder if somebody can give me some input based on own experience or from communication with SAP development whether a scenario with "Legal Consolidation" and "Matrix Consolidaton" within one BCS data bases is possible.
Does it work at all?
Are there any limitations that should be considered?
Thanks for sharing experiences.