How to troubleshoot customer issues by using Analysis Manager and OLAP

Article translations Article translations
Article ID: 818847 - View products that this article applies to.
This article has been archived. It is offered "as is" and will no longer be updated.
Expand all | Collapse all

On This Page

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

Properties

Article ID: 818847 - Last Review: February 27, 2014 - Revision: 3.3
APPLIES TO
  • Microsoft Project Server 2002
  • Microsoft Office Project Web Access
  • Microsoft SQL Server 2000 Service Pack 3
  • Microsoft SQL Server OLAP Services 8.0
  • Microsoft Office Project Server 2003
Keywords: 
kbnosurvey kbarchive kbbug kbhowto KB818847

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com