Project Server 2003: Unable to build OLAP cube.

[David Clement]

When attempting to build the OLAP cube I receive the following error.
"The cube scheduled to be built on 10/28/2005 at 2:57 PM failed.

(-2147467259) [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not
exist or access denied."

In analysis server, I receive several errors referrring to the same
underlying issue when the attempting to build the cube manually via Analysys
Manager. Here are a few of the error details.

A member with key '1097' was found in the fact table but was not found in
the set of leaf members of dimension 'Resource Resource Department'.;
Time:11/9/2005 10:50:07 AM

A member with key 'Q2' was found in the fact table but was not found in the
level 'Quarter' of the dimension 'Time'.; Time:11/9/2005 10:52:07 AM

A member with key 'Donna Foley' was found in the fact table but was not
found in the level 'Resource Name' of the dimension 'Resource List'.;
Time:11/9/2005 10:52:07 AM

A member with key 'Q3' was found in the fact table but was not found in the
level 'Quarter' of the dimension 'Time'.; Time:11/9/2005 10:52:07 AM

Any assistance is greatly appreciated.

David Clement
City of Tampa
(e-mail address removed)

 

[Marc Soester]

Hi David,

I am not sure if this is going to help, but this is what I do when I come
accross this problem (may not be the cleanest way

Assuming that you can actually access your Analysis Server from PWA, I would
go into "Manage Enterprise features" and rename the "Cube name" (e.g.
ProjectServerCube).
Then try to rebuild the cube. What actually happens is that a new Cube
Database is build with this new name. This usually rectifies the problem. Now
the nasty bit.
Assuming that the cube has successfully build, you will need to change all
of your portfolio Report settings in your views you generated to the new cube
name.

Additionally you will also need to generate the Database Roles in Analysis
Server again. After that you should be up and running again.
Hope this helps