OLAP cube generation may not be successful in Microsoft Project Web Access (324838)

RESOLUTION

To resolve this issue, use one or more of the following methods, depending on your situation.

Add Account to OLAP Administrators Group

1. On the computer where Analysis Services is installed, click Start, point to Programs, point to Administrative Tools, and then click Computer Management.
2. In the left pane, expand Local Users and Groups under System Tools.
3. In the Groups folder, double-click OLAP Administrator Group, and then click Add.
4. Select the user accounts or groups that you want, click Add, and then click OK two times.
5. Close the Computer Management console.

Run the PSComplus.exe Utility

1. Locate the Microsoft Project Server\Bin\1033 folder, and then double-click PSCOMPlus.exe.
2. Under Analysis Services (OLAP) Access Identity, type the Windows account in the User Name box.
3. In the Password box, type the password for this account.
4. Under Sharepoint Team Services Administration Identity and Sharepoint Team Service Database Access Identity, click to clear the Process this identity update check boxes.
   
   -or-
   
   Under Sharepoint Team Services Administration Identity and Sharepoint Team Service Database Access Identity, type the user name and passwords for the appropriate accounts.
5. Click Create\Update COM+ Apps, and then click OK.

Note For the Microsoft Office Project 2003 version of PSComplus.exe, the Sharepoint Team Service from Microsoft Database Access Identity is not needed and will not be available.

Migrate Analysis Services Repository to SQL Server Database

Note If you choose not to migrate the repository, you have to add the OLAP Administrators group, or the Windows user account that is a member of the OLAP Administrators group, to the list of users and groups that have Full Control permissions for the Program Files\Microsoft Analysis Services\Bin folder so that the cube can be built.

1. Click Start, point to Programs, point to Microsoft SQL Server, point to Analysis Services, and then click Analysis Manager.
2. In the left pane, locate your Analysis Server computer.
3. Right-click your Analysis Server computer, and then click Migrate Repository.
4. In the Migrate Repository Wizard, click Analysis Services native format, and then click Next.
5. In the SQL Server box, type the name of your Microsoft SQL Server 2000 computer, and then click Next.
6. Select the authentication type to connect to the computer running SQL Server. Enter the login ID and password in the appropriate boxes (if they are needed here). Click Next.
7. In the Databases box, point to the arrow, and then click ProjectServer.
8. Click Finish, and then click OK.
9. Click Start, point to Programs, point to Microsoft SQL Server, and then click Enterprise Manager.
10. In the left pane, locate and then expand the computer running SQL Server.
11. Under Security, right-click Logins, and then click New Login.
12. On the General tab, type the account name in the form of Domain\User name in the Name box.
13. Under Defaults, point to the arrow in the Database box, and then click ProjectServer.
14. Click the Database Access tab, click to select the ProjectServer check box, and then click db_owner.
15. Click OK, and then click Exit on the Console menu.