Smart View retrieve Issue

 Hi All,I know this could be an old age questions, but my client wants to see some better solution than what we currently following.

 

-requirement is that - user want to do adhoc analysis start at all level 0 then able to rollup, do slice and dice.

-Why user want to do adhoc analysis at level 0?

We have dimension like Entity, BusArea, location and cost center each of them having about 180, 200, 120 and 500 level 0 members and have a allocation dimension which  would have members like

entity.ba.lc.cc

 

Its not huge dimension but if you tried to drill down to bottom level obviously the combination rows goes into millions and Smart View can't handle that, although the data exists not more than 50000 rows (combinations)