Microsoft KB Archive/324838

= OLAP cube generation may not be successful in Microsoft Project Web Access =

Article ID: 324838

Article Last Modified on 2/1/2007

-

APPLIES TO


 * Microsoft Office Project Professional 2003
 * Microsoft Office Project Server 2003
 * Microsoft Project 2002 Professional Edition
 * Microsoft Project Server 2002
 * Microsoft Office Project Web Access

-



This article was previously published under Q324838



SYMPTOMS
When you try to generate an OLAP cube in Microsoft Project Server Web Access, the cube-generation process may not be successful.



CAUSE
This issue may occur if Analysis Services is not completely configured for Microsoft Project Server. This is the case if one or more of the following conditions are true:
 * You are not a member of the OLAP Administrators group.
 * You have not run the PSComplus.exe utility.
 * You have not migrated the Analysis Services repository to a Microsoft SQL Server database.



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.
 * 1) 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   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.



MORE INFORMATION
For more information about Microsoft Project Server Setup, see the Installation Guide, which you can access from Microsoft Project Server Setup. Or, directly open the Pjsvr10.chm file, which is located in the Docs folder on the Microsoft Project Server CD-ROM.

For additional information about Microsoft Project Server Setup, click the following article numbers to view the articles in the Microsoft Knowledge Base:

321336 PSRV2002: Database requirements for Microsoft Project Server

325843 User accounts and permissions needed to install and configure Project Server and related components

Additional query words: PSVR2002

Keywords: kbprb KB324838

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.