Échec de la construction du Cube OLAP dans PWA

Transcription de l'article 324838 : 14 Septembre, 2004

 

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

   Add Account to OLAP Administrators Group

   Run the PSComplus.exe Utility

   Migrate Analysis Services Repository to SQL Server Database

 MORE INFORMATION

 APPLIES TO

 

SYMPTOMS

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

 Back to the top

 

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.

 

 Back to the top

 

RESOLUTION

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

 Back to the top

 

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.

 

 Back to the top

 

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.

 Back to the top

 

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.

 

 Back to the top

 

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 (http://support.microsoft.com/kb/321336/) PSRV2002: Database requirements for Microsoft Project Server

325843 (http://support.microsoft.com/kb/325843/) User accounts and permissions needed to install and configure Project Server and related components