ERROR EXECUTING XMLA WHILE IMPLEMENTING PROJECT REAL BI

Hi all,

I didnot find any other forum to post this problem. I am facing an problem while trying to implement the PROJECT REAL BI.

I was trying to implement the PROJECT REAL but facing an error. After attaching the mdf : REAL_Source_Sample_V6 and REAL_Warehouse_Sample_V6 when I try to execute the XMLA Script “REAL Warehouse Sample V6 MT.xmla” i am getting an error "Object Reference not set to an instance of object ( ConnectionDlg)". Can you tell me why this error comes. I am using SQL SERVER 2005 SP 2. You can ping me at girija45701@.yahoo.com...

Thanks in advance...

In Sql Server Management Studio

01. Select tools --> Options

02. Select File Extension under text editor on the left side panel.

03. In the right side panel Add XMLA in the Extension box and select XMLA Query Editor from the drop down list.

04. Click on the 'Add' button.

05. Close and restart Sql Server Management Studio.

By mapping the extension to an editor, the SSMS will know which Engine/parser to use.

regards.

Error creating Indexes in ROLAP based OLAP in Analysis Server 2005

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.

Error creating Indexes in ROLAP based OLAP in Analysis Server 2005

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.

Error creating Indexes in ROLAP based OLAP in Analysis Server 2005

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.

Error creating Indexes in ROLAP based OLAP in Analysis Server 2005

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.