Friday, February 24, 2012

Local cube issue-help

Hello everyone,

When I create local cube using 'Create global cube', if the cube is small, it works fine, but if the cube not small(4 mil fact, 10 measures and 20 dimensions ), I could not get result.
the error msg:
"Errors in the OLAP storage engine: An error occurred while processing the 'Monthly Revenue' partition of the 'Fact Monthly Revenue' measure group for the 'monthly_revenue' cube from the monthly_revenue database.

XML for Analysis parser: The XML for Analysis request timed out before it was completed."

I am struggling to solve this issue a while, but no clue what's wrong here.

Any one could kindly give me a suggestion?

Thanks in advance.

Local cube creation in AS2005 works much better with ASSL then with CREATE GLOBAL CUBE. At the present time we are not supporting CREATE GLOBAL CUBE for AS2005 in our local cube generating product, CubeSlice, because we could not adequately handle the errors we saw and could not give the local cube creation options we wanted to provide. Creating local cubes in AS2005 with ASSL works very well and gives a very high level of control over the local cube that is created.

No comments:

Post a Comment