Error during browsing the cube

Hi,

I have migrated the anaysis service 2000 cubes to 2005.

In the database i have two cubes say A and B and one virtual cube say C.While migrating the virtual cube C got migrated as a real cube with two linked measure groups for the cubes A and B. I have not processed the cube B.But i have processed the cube A.It succeded and i could browse it once .But when i tried browsing the virual cube C (which migrated as real cube with linked measure group) is not available for browsing .This is because i didnt process the cube B whose measure is also present in C.

But the problem is when i tried to browse cube A which i could browse earlier is giving me error when i try to browse it again.

The error which i found is somethinf like this:Error in the OLAP storage engine:The version of the linked measure group with the name of 'A',on the remote instance has changed.Repeat the operation the resolve the issue.

Please help me to solve this issue ASAP.

Thanks in advance

Regards

Latha

Hi Latha. I have received the same error in the same situation from the SQL Manager when writing my own MDX query. I try the query again (as suggested) and it works. You should try a simple MDX query from SQL Manager and see if the same scenario occurs.

Hope this helps.

PGoldy

|||

Hi,

Since it is a migration from AS 2000 to AS 2005 .

I dont want to make any changes in the query and my AS 2000 cube works fine.

Please tell me, is the error because of the unprocessed cube 'C'(virtual cube migrated with linked measures).

Is it enough if i process the cube C along with Cube A?

Regards

Latha

|||

Hi Latha. Yes, processing the cubes should take care of the error you received.

PGoldy

error creating offline cubes

Hi,
i want to create offline cubes in excel 2003 and receive
following error message:
Microsoft OLE DB Provider for Analysis Services:
Data source provider error.
The olap-database was created with SSABI 1.2, for example
with one dimension, one measure and one cube.
environment:
Win2000 Server
SQL Server 2000, SP3a, Analysis S. 2000 SP3a
Excel 2003
thanks for help,
markusI get the same error using MS Analysis Server on one of my data cubes.
(Others work). No other explanation. Very frustrating.
Jim
"markus krenn" <markus.krenn@.kis.co.at> wrote in message
news:8074337.0401140004.2a43461d@.posting.google.com...
> Hi,
> i want to create offline cubes in excel 2003 and receive
> following error message:
> Microsoft OLE DB Provider for Analysis Services:
> Data source provider error.
> The olap-database was created with SSABI 1.2, for example
> with one dimension, one measure and one cube.
> environment:
> Win2000 Server
> SQL Server 2000, SP3a, Analysis S. 2000 SP3a
> Excel 2003
> thanks for help,
> markus|||Hi Jim/ Markus,
I have the same error as you guys are having! Have you found a solution
to this error yet?
Thanks,
Natalie
Jim Fox wrote:[vbcol=seagreen]
> *I get the same error using MS Analysis Server on one of my data
> cubes.
> (Others work). No other explanation. Very frustrating.
> Jim
>
> "markus krenn" <markus.krenn@.kis.co.at> wrote in message
> news:8074337.0401140004.2a43461d@.posting.google.com...
Natalie
---
Posted via http://www.mcse.ms
---
View this thread: http://www.mcse.ms/message281094.html