OLAP Cube Build for MSP 2003

M

Matt Quinn

I have a Project 2003 installation with an existing OLAP
cube. When I attempt an "Update Now" with the "Yes, I want
to update resource availability information and build an
OLAP cube" it fails with the following message.


The cube scheduled to be built on 10/21/2003 at 3:02 PM
failed. (-2147217900) The query has been canceled because
the estimated cost of this query (15) exceeds the
configured threshold of 5.

Can someone help on this problem?

Thanks,

Matt Quinn
 
D

David Gage - Project MVP

That sounds like it could be a SQL Server issue as I have not seen this
problem before with Project Server. Do you have a Database Admin you can
ask to see if there are any special controls on SQL Server?
 
M

Matt Quinn

It is working now. There was a governor setting for OLAP
with an estimated query cost set to 5. It set it to 0, no
limit to resolve this problem.

Thanks for your help,

Matt Quinn
MCSE, HP ASE
(913) 344-3829 voice
 
Top