70-281 Planning, Deploying, and Managing an Enterprise Project Management Solution Practice Tests

Demo Question 4.

You are the administrator of the Microsoft Enterprise Project Management solution for EliteCertify.com. You install Microsoft Office Project Server 2003. You install Analysis Services with the latest service pack on its own server. You configure Microsoft Office Project Server to use the new Analysis Services server. You schedule Portfolio Analyzer cube creation to run each Saturday night. On the following Monday, executives receive the error message shown in the exhibit when they attempt to view Portfolio Analyzer reports by using Microsoft Office Project Web Access. You check Project Web Access. You see the message that the cube was successfully built on Saturday. You search the client machines and find owc11.dll in the c:\program files\common files\Microsoft Shared\Web Components\11 directory. You must ensure executives can view cube data in the Portfolio Analyzer. What should you do?

A. Reinstall the service pack for Analysis Services on the OLAP server.
B. Build the cube manually from within Project Web Access.
C. Create a domain or local group. Add the executives to this group. Create an Analysis Services role for this group. Give this role access to the MSP_PORTFOLIO_ANALYZER cube.
D. Create a domain or local group. Add the executives to this group. Create an Analysis Services role for this group. Give this role access to the MSP_ASSN_FACT cube.


Display Answer

Answer: C

Explanation: Analysis Services cube role problems can occur when a Project Web Access user attempts to open a Portfolio Analyzer view. This problem is caused by either: The OLAPAdministrator account is not a member of the Cube Role OR the current Windows account on the client attempting to access is not added to the Cube Role. To solve the problem add the Windows account of the client to the Cube role if the current Windows account on the client attempting to access Portfolio Analyzer is not added to the Cube Role. In the scenario of the question, the role should be created for the executives and this role should be given access to the MSP_PORTFOLIO_ANALYZER cube. Reference: Microsoft Training and Certification: Microsoft Official Curriculum: Planning, Deploying, and Managing an Enterprise Project Management solution; Delivery Guide, Course Number 2732A, Module 13: Troubleshooting Project Server 2003, p. 16