I'm having a problem with the amount of time it's taking to process our cubes. Here is the situation:
We have 8 cubes: 4 demand cubes and 4 sales cubes. There are 2 virtual cubes: 1 demand and 1 sales.
All of the demensions are shared demensions.
Proccessing of all the cubes took < 5 hours to complete. I then deleted one of the shared demensions and recreated it with 2 heirachies. I then added the new demension to all the cubes and rebuilt the design storage. Now, the cubes are taking about 12 hours to complete.
I cannot figure out why proccessing time has increased so dramaticly. Can anybody point me in the right direction as to where to start looking to figure this problem out?