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