'CREATE GLOBAL CUBE' issue

Hi,

I have cube with 10 measures and 20 dimensions. When I do 'CREATE GLOBAL CUBE',
using 10 measures with any 4 dimensions work fine, can create local cube, but could not success when I include 10 measures with any 6 or more dimensions.
The error msg: 'Errors in the OLAP storage engine: The process operation ended because the number of errors encountered during processing reached the defined limit of allowable errors for the operation.
Errors in the OLAP storage engine: An error occurred while processing the 'myCube' partition of the 'Fact myCube' measure group for the 'myCube' cube from the myCube database.
XML for Analysis parser: The XML for Analysis request timed out before it was completed.

Is it any limitations for 'CREATE GLOBAL CUBE'?

What am I missing?

Any suggestions or input will be appreciated.

Thanks.
We have identified many situations where local cube creation fails with this error. We have not found a way to work around these errors using CREATE GLOBAL CUBE. We have found ways to deal with these errors by using an ASSL Create Cube statement to create local cubes. Our product, CubeSlice, generates the required ASSL to create the local cube. We offer a free 30-day demo, so you can try it at no cost and see if your local cubes can be created with ASSL using all your dimensions. I'd encourage you to try the local cube creation with both a relational data source and an Analysis Server cube source. We give this option on the first tab of our Local Cube Options dialog. If you still get the error you describe when using CubeSlice, let me know, and we'll try to get it fixed.

Tim Peterson
www.cubeslice.com