Skip to Content
0
Former Member
May 21, 2011 at 01:23 AM

Legal Consolidation: Entity structure question

97 Views

Hi Experts,

Just want to ask if technical Entities are required in order for Legal Consolidation to work in SAP BPC 7.5 NW SP6? I'm using both R-Type (Currencies) and G-Type dimension (Conso Groups). In my first structure, I only have the following set up in my Entity and Groups dimension:

Entity Dimension:

ID		EVDESCRIPTION		PARENTH1	CURRENCY	INTCO	FX_TYPE	ELIM
ALL_COMP	All Company					
COMPT1		Company Group 1		ALL_COMP				
COMP1		Company 1		COMPT1	        USD		I_COMP1		Y
COMP2		Company 2		COMPT1	        USD		I_COMP2		Y
COMPT2		Company Group 2		ALL_COMP				
COMP3		Company 3		COMPT2	        USD		I_COMP3		Y
COMP4		Company 4		COMPT2	        USD		I_COMP4		Y

Groups Dimension:

ID		EVDESCRIPTION	CURRENCY_TYPE	ENTITY	GROUP_CURRENCY	PARENT_GROUP	STORE_ENTITY	STORE_GROUP_CURR	CONSO_TYPE	DATASRC_LEVEL	STAGE_ONLY	
GCOMPT1	Company Group 1	        G			USD							Y			A			
GCOMPT2	Company Group 2	        G			USD							Y			A			
NON_GROUP	Non Group	

In this set up, my Consolidation results in error "RUN_LOGIC:Accounts and entities do not match data in application OWNERSHIP". But if I change my set up to the following(with technical Entities), I don't get the error:

Entity Dimension:

ID		EVDESCRIPTION		PARENTH1	CURRENCY	INTCO	FX_TYPE		ELIM
ALL_COMP	All Company					
COMPT1		Company Group 1		ALL_COMP				
COMP1		Company 1		COMPT1		USD			I_COMP1		
COMP2		Company 2		COMPT1		USD			I_COMP2		
COMPT2		Company Group 2		ALL_COMP				
COMP3		Company 3		COMPT2		USD			I_COMP3		
COMP4		Company 4		COMPT2		USD			I_COMP4		
ECOMPT1	        Company Group 1				USD					Y
ECOMPT2	        Company Group 2				USD					Y

Groups Dimension:

ID		EVDESCRIPTION	CURRENCY_TYPE	ENTITY		GROUP_CURRENCY	PARENT_GROUP	STORE_ENTITY	STORE_GROUP_CURR	CONSO_TYPE	DATASRC_LEVEL	STAGE_ONLY	
GCOMPT1	Company Group 1	        G		ECOMPT1	USD					Y		Y			A			
GCOMPT2	Company Group 2	        G		ECOMPT2	USD					Y		Y			A			
NON_GROUP	Non Group

Am I just missing some properties or set up in my first that's why I'm getting the error or do I really need to create technical Entities for consolidation to work??

Thanks,

Marvin