Consolidation feature feasible in my scenario???

Hi,
The situation is that we are implementing Financial intelligence. our account kff structure is
1. Entity (balancing qualifier)
2. Operating unit
3. Cost centre (cost centre qualifier)
4. Natural account (natural account qualifier)

Now as the balancing qualifier is set at entity, financial intelligence shows all dashboard and reports on entity level. But our reporting requirment is to view financial intelligence on operating unit level. Now first i tried to create a secondary ledger and defined mapping rules but it didnt work because primary ledger can not be mapped to secondary ledger due to different balancing qualifier segment.
Now my last option was to use consolidation feature. But when i ran transfer entries it created unbalanced journal in parent ledger (which was expected).