The following article describes how to troubleshoot customer issues by using Analysis Manager and by using OLAP.
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
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:
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
For additional information about OLAP permissions, click the following article numbers to view the articles in the Microsoft Knowledge Base:
INF: Permissions That You Must Have to Administer an OLAP Server
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:
PSVR2002: You Cannot Build an OLAP Cube
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:
PSRV2002: Error Message: Unable to Access the Microsoft Project Portfolio Analyzer OLAP Cube