You receive an "Unable to access the Microsoft Project Portfolio Analyzer OLAP Cube" error message when you try to create or view a Portfolio Analyzer View

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

On This Page

SYMPTOMS

If you try to create or to interactively view a Portfolio Analyzer View, you may receive an error message.

In Microsoft Project Server 2002, you may receive an error message that is similar to the following error message:
Unable to access the Microsoft Project Portfolio Analyzer OLAP Cube.

Possible Cause: The cube has not yet been built, or it is currently being generated, or you do not have permissions to access the cube.
In Microsoft Office Project Server 2003, you may receive an error message that is similar to the following error message:
Unable to access the Microsoft Office Project Portfolio Analyzer OLAP cube. The cube may not exist, or you may not have permissions to access the cube.

CAUSE

This behavior may occur if one or more of the following conditions are true:
  • You do not have permissions to the cube in Analysis Manager.
  • The Office Web Components tool is not connected to the OLAP cube.
  • The Portfolio Analyzer tries to connect to an OLAP Cube that no longer exists.
  • You do not have permissions to the OLAP cube.
  • The Access data sources across domains option for the security zone to which the Project sever belongs is disabled.
  • You use Microsoft SQL Server Analysis Services. However, the Microsoft SQL Server 2005 Analysis Services 9.0 OLE DB Provider is not installed in the Project Server box.

RESOLUTION

To resolve this issue, use one or more of the following methods, as appropriate for your situation.

Note If your Portfolio Analyzer View tries to connect to an OLAP Cube that no longer exists, you must delete that particular Portfolio Analyzer View, and then re-create it.

Method 1: Add the Windows User Account to the cube in Analysis Manager

Note The Windows User Account contains individuals who create the Portfolio Analyzer View, but who need permissions to connect to the Analysis Manager and to the OLAP cube.
  1. On the server that has Analysis Services installed, click Start, point to Microsoft SQL Server, point to Analysis Services, and then click Analysis Management.
  2. In the left pane, locate your Analysis Services server, and then expand the server.
  3. Right-click the cube, and then click Manage Roles.

    Tip You can find the name of the cube on the Updates to Resource Tables and OLAP Cube page in Microsoft Project Web Access.
  4. Click New, and then type a name in the Role name box. Change the Enforce on option from Client to Server.
  5. On the Membership tab, click Add.
  6. Select user accounts and groups, click Add, and then click OK.
  7. On the Cubes tab, click Check All, and then click OK.
  8. Click Close, and then click Exit on the Console menu.

Method 2: Install Service Pack 3 for SQL Server 2000 and SQL Server 2000 Analysis Services

To work around this issue, install SQL Analysis Service Pack 3 (SP3). If you have Project Server on a distributed configuration, where Project Server and SQL Analysis Services are on different computers, you must apply SP3 to update your Decision Support Object for SQL Analysis on your Project Server computer. To do this, follow these steps:
  1. Download SQL Server 2000 SP3 and SQL Analysis SP3. To do this, visit the following Microsoft Web site:
    http://www.microsoft.com/downloads/details.aspx?FamilyID=90dcd52c-0488-4e46-afbf-acace5369fa3
  2. Download the Sql2kasp3.exe and Sql2ksp3.exe files.
  3. Double-click the Sql2ksp3.exe file, and then follow the instructions on the screen.
  4. In the Installation Folder dialog box, accept the c:\Sql2ksp3 folder, and then click Finish.
  5. Click Yes to create the new folder.
  6. Open the c:\Sql2ksp3 folder.
  7. Double-click the MSOLAP and Install folder to install SP3 for SQL Analysis Services, and then double-click Setup.exe to install SQL Analysis SP3.
  8. Open the c:\Sql2ksp3\X86\Setup folder, and then double-click Setupsql.exe to install SQL Server 2000 SP3.
Note To determine whether SQL Server SP3 and SQL Analysis SP3 are installed, click Microsoft SQL Server 2000 and Microsoft SQL Server 2000 Analysis Services in the Add or Remove Programs tool, and then click Support Information. The matching versions are 8.00.760.

Note If you are running SQL Server 2005 Analysis Services, make sure that Microsoft SQL Server 2005 Service Pack 1 (SP1) is installed.

Method 3: Reinstall Office Web Components

Project Server 2002

Note Because there are several versions of Microsoft Windows, the following steps may be different on your computer. If they are, see your product documentation to complete these steps.
  1. In Windows Explorer, locate the following folder:
    C:\Program Files\Common Files\Microsoft Shared\Web Components\10
  2. Right-click OWC10.DLL, and then click Rename.
  3. Type OWC10.OLD.
  4. Insert your Office XP CD-ROM into your computer's CD-ROM or DVD-ROM drive while you hold down the SHIFT key.
  5. On the desktop, double-click My Computer.
  6. Right-click the CD-ROM, and then click Search.
  7. In the File name box, type OWC10.msi, and then click Search Now.
  8. Double-click the file in Search Results, and then follow the instructions to install Office Web Components.
Note The OWC .msi file is also located on the Project Server. On the server, you can file the .msi file that is located in the Program Files\Microsoft Project Server\IIS Virtual Root\Download\1033 folder.

Project Server 2003

Note Because there are several versions of Microsoft Windows, the following steps may be different on your computer. If they are, see your product documentation to complete these steps.
  1. In Windows Explorer, locate the following folder:
    C:\Program Files\Common Files\Microsoft Shared\Web Components\11
  2. Right-click OWC11.DLL, and then click Rename.
  3. Type OWC11.OLD.
  4. Insert your Microsoft Office Project Professional 2003 CD-ROM into your computer's CD-ROM or DVD-ROM drive while you hold down the SHIFT key.
  5. On the desktop, double-click My Computer.
  6. Right-click the CD-ROM, and then click Search.
  7. In the File name box, type OWC11.msi, and then click Search Now.
  8. Double-click the file in Search Results, and then follow the instructions to install Office Web Components.

Method 4: Add a group that has Full Control permissions to the OLAP cube

Add an Olap_Admins group that has Full Control permissions to the Drive:\Program files\Microsoft Analysis Services\Bin folder. On the actual cube that is generated, add the Everyone group, and then give this group Read access.

Method 5: Enable the "Access data sources across domains" option for the security zone to which the Project server belongs

  1. Click Start, click Run, type inetcpl.cpl, and then press ENTER.
  2. Click the Security tab, and then click the security zone to which the Project sever belongs.
  3. Click Custom Level to open the Security Settings dialog box.
  4. In the Settings list, click Enable for the Access data sources across domains option.
Note In Internet Explorer 7, the default security settings for trusted sites was changed. The Access data sources across domains option was disabled. Use Method 5 to set this option to enable trusted sites or to prompt for trusted sites in Internet Explorer 7.

If you used SQL Server 2005 to build the cube, install Microsoft SQL Server 2005 Analysis Services 9.0 OLE DB Provider on the Project Server box.

Note Project Server 2002 is incompatible with SQL Server 2005 Analysis Services.

Properties

Article ID: 324836 - Last Review: February 28, 2014 - Revision: 11.0
APPLIES TO
  • Microsoft Office Project Server 2003
  • Microsoft Project Server 2002
  • Microsoft Office Project Web Access
  • Windows Internet Explorer 7
Keywords: 
kbnosurvey kbarchive kberrmsg kbprb KB324836

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