How is an OLAP Cube Built Every Hour from Missing User?

[Andy S]

We are running Project Server 2007, SP1. The OLAP cube was originally
scheduled to be built every hour by employee Rick (in other hours,
every hour, an OLAP cube is built with Rick listed as the owner in the
PWA queue). This is running along fine, however, Rick is about the
leave the company. I have gone into PWA and built cubes myself, with
the same hourly refresh rate...however, once the next hour occurs, the
cubes are again being built with Rick as the owner. How do I remove
him as owner of the hourly cube builds?

Thanks!

 

[Ben Howard]

The cubes are built by the account that owns the SSP , so 1st job would be to
change this account. Ideally it wouldn't be a general user account, but
rather a specific one that "owns" the SSP. Whilst you are at it you might
want to also check the owner of the WSS farm, it is also likely to be Rick,
as are the owners of the PWA instances.... There is a whole section on
Technet for planning project server accounts.

 

[andysager]

How do I find who owns the SSP? Everyplace I am looking shows a
service account, and not Rick's name. Yet the cube continues to build
every hour with Rick as the owner.

 

[andysager]

I even checked the logs located at:

C:\Program Files\Common Files\Microsoft Shared\web server extensions
\12\LOGS

and all the cube items show the service account. Rick's name is no
where to be found. So my question remains: Where is the Project
Server Queue pulling the owner field from?