Microsoft KB Archive/818847

= How to troubleshoot customer issues by using Analysis Manager and OLAP =

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.



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 \  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

-

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

© Microsoft Corporation. All rights reserved.