I would like to do consolidation both at SBU(profit center) & Stream level (profit center) and this consolidation is for management purpose(monthly). Apart from above we need to design legal consolidation(enitity) wise. Ownership structure is avilable for both SBU and revenue stream wise.
Can i accommodate above 3 scenarious in single legal model. If yes, how to maintain profit center info in legal model( i mean in same entity dim or separate dim) as well how to maintain profit center, cost center relationship in dimensions.