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