Hi,
We are implementing OLAP based system in which the team has decided to use ROLAP as storage structure. But we are getting error while deploying the cube. The error is
OLE DB error: OLE DB or ODBC error: Cannot create index on view "Reporting.dbo.Agg_Fact Table_27_48_48_44_44_4" because it references derived table "dbo_Fact_Table" (defined by SELECT statement in FROM clause). Consider removing the reference to the derived table or not indexing the view.; 42000.
It seems that it has created a view that uses derived table and tries to create a clustered index on that. [Indexed View]. The above view definition contains derived table but as we know that the Indexed view can’t contain derived table. What is the workaround for this problem?
Thanks a lot for any advice.
Rakesh Mishra
Hi Rakesh
I got the same problem and can't find any solution. Did you find any workaround to solve the problem
Leo
|||Hi,
I have experienced the same problem. Has this issue been resolved?
Thanks,
Bill
|||I am sorry for *bumping* this one up, but I encounter the same problem on my project, so I wonder if there is a solution for it.
I would like to add that my project works well in MOLAP and does process completly without errors, switching to rolap gives the same message as the original poster has, with some different names and numbers for the tables and index columns of course.
Thanks
Ralf
|||I have encountered this issue as well. I too wonder if there is a solution for this.
It appears to be only an issue when a particular attribute is used in an aggregation.
