Hi There,

Is the create cube statement supported in SQL 2005 for creation of local
cubes? All I can find is sytnax for CREATE GLOBAL CUBE. The examples provided
on MSDN is

CREATE GLOBAL CUBE [LocalReseller]
Storage 'C:\LocalAWReseller2.cub'
FROM [Adventure Works]
(
MEASURE [Adventure Works].[Reseller Sales Amount],
DIMENSION [Adventure Works].[Reseller],
DIMENSION [Adventure Works].[Date]
(
LEVEL [Fiscal Year],
LEVEL [Month],
MEMBER [Date].[Fiscal].[Fiscal Year].&[2005]
)
)

however this results in the following error message;

Executing the query ...
Errors in the OLAP storage engine: An error occurred while the 'Reseller'
attribute of the 'Reseller' dimension from the 'LocalReseller' database was
being processed.
Execution complete


Any advise on how to work out what is going wrong here?

Mark

I've the same problem I was trying to create a local cube using both
management studio and .NET application modified for SQL 2005. For Management
Studio the same error, for application unknown error in exception handler. I
only could create local cubes from databases that was upgraded from SSAS
2000.

Janusz Kolbuszewski