While generating a consolidated report through Management Reporter, we are unable to drill down at the Account Level/Transaction Level with the combination of Main Account and Financial Dimensions irrespective of the entity which forms part of consolidation.
However, when we export the report to excel together with the option of All Units, we are able to get the drill down of Main Account and Financial Dimensions at the individual entity level at the Account Level drill down. At the consolidated level, when we select a drill down on the Financial Level, we get a report on all entities individually with the item of description (for e.g. Sales).
While this is useful to some clients, there should also be an option to get the same level drill down at the consolidated level which we can get at the individual entity level.

Thanks!