Monday, March 26, 2012

Offline Cube Refresh

I am having problems with offline cubes. I am using AS2005 SP1 with all the 6 hotfixes installed. Everything with the cube access is fine and I can use excel to create a local .cub file. My problem comes when I try to refresh the cub file. My understanding is that using the excel spreadsheet which created the cube file hitting the refresh button while the cube is offline should refresh the cub file.

This is where my issues start. I get various messages all pointing to either an OLE DB driver crashing or the .cub file being reported as corrupt.

This doesn't happen every time once in a while with no noticable pattern has anyone else experienced the same problems with refreshing offline cubes?

If you willing to try... Please see if installing CTP of SP2 will solve your problem.

You can install it from http://www.microsoft.com/downloads/details.aspx?FamilyID=d2da6579-d49c-4b25-8f8a-79d14145500d&DisplayLang=en

If your problems still persist, contact product support and report your problems.

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.

|||Thanks for you help I have now tried installing CTP SP2 but I still have an error when updating that says that the local cub file is corrupt however it is fine to use and only gives the error at refresh. I have upgraded to XL2003 SP2|||

The last suggestion I might have for you:

Try rebuilding your local cube using CTP2.

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.

No comments:

Post a Comment