Financial reporting with multiple dimensions

Hi guys,

We are trying to configure the system to have a financial reporting with multiple levels, for example Division, Region , and Department.  For example the inventory accounts, they wants to see the details  from the Warehouse trough company level,  between this two levels there is more like division, region and department.

They wants to roll up : Warehouse >Department>Region>Division>Company

I was thinking to use of Cat Codes at a BU level, but with that approach a just can group the warehouses , I need to group the accounts

I was thinking to use Cat Codes at an account level, but that will grow up exponentially the COA and the GL class