Article ID: 818847
Article Last Modified on 2/5/2007
APPLIES TO
- Microsoft Project Server 2002
- Microsoft Office Project Web Access
- Microsoft SQL Server 2000 Service Pack 3
- Microsoft SQL Server OLAP Services
- Microsoft Office Project Server 2003
SUMMARY
The following article describes how to troubleshoot customer issues by using Analysis Manager and by using OLAP.
MORE INFORMATION
Requirements
Microsoft Project 2002
The customer must have the following software installed to correctly troubleshoot issues by using Analysis Manager and OLAP:
- Analysis Manager
- Microsoft Office XP Service Pack 1 (SP1)
- Microsoft Office XP must be installed on the computer to build the Analysis View
Note You do not have to have Office XP installed to see the view but you will be limited in what you can do.
Microsoft Office Project 2003
The customer must have the following software installed to correctly troubleshoot issues by using SQL Analysis Manager and OLAP:
- Analysis Manager
OLAP Requirements
The customer must have a Microsoft Windows User Account that is part of the OLAP Administrators Group or the Administrators Group.
This account must be entered in Microsoft Project Server COM+ Settings tool (Pscomplus.exe). The Microsoft Project Server COM+ Settings tool provides the name of a user account that is impersonated by a COM+ program to make it possible for Project Server to connect to the Analysis Services and Microsoft SharePoint Team Services-based computer for OLAP access, SharePoint Team Services administration, and SharePoint Team Services database access. Note that the name of a user account is in the DomainName
\UserName
format.
For additional information about OLAP permissions, click the following article numbers to view the articles in the Microsoft Knowledge Base:
231951 INF: Permissions That You Must Have to Administer an OLAP Server
325843 PSVR2002: User Accounts and Permissions Needed to Install and Configure Microsoft Project Server and Related Components
Issue: Cannot Generate Cube
To troubleshoot this issue, see the following Knowledge Base articles:
814139 PSVR2002: You Cannot Build an OLAP Cube
324838 PSRV2002: OLAP Cube Generation Is Unsuccessful in Microsoft Project Web Access
Allow time for the Cube to generate. This may take longer than you expect depending on how much data has to be processed.
Issue: Cannot Access Analyzer View
If the view is not appearing correctly, or the customer cannot access the view, see the following Knowledge Base article to troubleshoot this issue:
324836 PSRV2002: Error Message: Unable to Access the Microsoft Project Portfolio Analyzer OLAP Cube
Additional query words: PSVR2002
Keywords: kbbug kbhowto KB818847