Cube processing

I'm having a problem with a cube processing. When i process it with no aggregation design its ok, now i'm trying to process it with 5% of aggragation and it just took so long and after 12 hours it has not completed and analyses manager doesn't respond. Any suggestions?

Your aggregations are probably big, so they probably do not fit in memory and Anaysis Server starts swapping data to disc in order to complete aggregations building.

You should partition your data (Ent. Edition feature), in this case aggregations should be smaller, they would fit in memory and you should see faster processing times.

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.