Sunday, March 11, 2012

Error in Processing Cube while ROLAP Storage

Hello,

When I process the Cube having ROLAP storage, it gives the error as below, any thoughts on this would be greatly appreciated.

Errors in the back-end database access module. ROLAP partition with the Name='Fact One' Id='Fact One' can not have aggregations at the (all, all, ... ) level. Aggregaion skipped. OLE DB error: OLE DB or ODBC error: Cannot create index on view "TESTROLAP.dbo.Agg_Fact One_0_1_1_1_1_1" because it references derived table "dbo_Fact_One" (defined by SELECT statement in FROM clause). Consider removing the reference to the derived table or not indexing the view.; 42000.

Thanks,
Nasir

Nasir wrote:

Hello,

When I process the Cube having ROLAP storage, it gives the error as below, any thoughts on this would be greatly appreciated.

Errors in the back-end database access module. ROLAP partition with the Name='Fact One' Id='Fact One' can not have aggregations at the (all, all, ... ) level. Aggregaion skipped. OLE DB error: OLE DB or ODBC error: Cannot create index on view "TESTROLAP.dbo.Agg_Fact One_0_1_1_1_1_1" because it references derived table "dbo_Fact_One" (defined by SELECT statement in FROM clause). Consider removing the reference to the derived table or not indexing the view.; 42000.

Thanks,
Nasir

Above Cube runs these two Queries while processing:

Query 1 succeeds and Query 2 fails, here are both of them:

Query 1

CREATE

VIEW [Agg_Fact One_0_1_1_1_1_1] ( [Amount_0],[_1],[TimeID_2], [COUNT_BIG_7673aff6-2445-4ef6-a4c9-7bf3d93bd42a] ) WITH SCHEMABINDING AS

(

SELECT SUM ( [dbo_Fact_One].[dbo_Fact_OneAmount0_0] )

AS [dbo_Fact_OneAmount0_0],

COUNT_BIG ( [dbo_Fact_One].[dbo_Fact_One0_1] )

AS [dbo_Fact_One0_1],[dbo_Fact_One].[dbo_Fact_OneTimeID0_2] AS [dbo_Fact_OneTimeID0_2], COUNT_BIG(*) AS [COUNT_BIG_7673aff6-2445-4ef6-a4c9-7bf3d93bd42a]

FROM

(

SELECT [Amount] AS [dbo_Fact_OneAmount0_0],1 AS [dbo_Fact_One0_1],[TimeID] AS [dbo_Fact_OneTimeID0_2]

FROM [dbo].[Fact_One]

)

AS [dbo_Fact_One]

GROUP BY [dbo_Fact_One].[dbo_Fact_OneTimeID0_2]

)

Query 2

CREATE

UNIQUE CLUSTERED INDEX [Agg_Fact One_0_1_1_1_1_1] ON [Agg_Fact One_0_1_1_1_1_1] ( [TimeID_2] )

No comments:

Post a Comment