EPM Solutions Services

Want to quickly locate the right EPM solutions & services, check EPM Connect.

 

http://www.epmconnect.com/

 

Microsoft Adds Project Managers Certification

New Project Manager Certification program is coming from Microsoft. For details check the link.

 

http://tinyurl.com/y66ptt

 

http://mcpmag.com/news/article.asp?EditorialsID=1084

 

Also see Microsoft at the PMI Global Congress 2006

http://www.microsoftatpmi.com/

 

OLAP Cube and Portfolio Views - Issue Resolution

Resolving issues with OLAP cube & portfolio Analyzer views sometimes becomes challenging. There are many reasons why the cube build fails or portfolio views don’t work.

 

Everyone including PM and RM, especially executives like to view the portfolio of their projects and organization. OLAP cube or view failure in MS Project Server might stop these management people from making important project and organization level decision.

 

Some of the outstanding cube & views issues are listed below

 

·         Error message when you try to build an OLAP cube in Project Server 2003 or in Project Server 2002: "The cube scheduled to be built on Date Time failed."

http://support.microsoft.com/kb/912259

 

·         Error message when you try to build an OLAP cube in Project Server 2003: "This key is already associated with an element of this collection"

http://support.microsoft.com/kb/910819

 

·         How to troubleshoot issues with Online Analytical Processing (OLAP) cubes when you work with Microsoft Project Server

http://support.microsoft.com/kb/822220

 

·         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

http://support.microsoft.com/kb/324836

 

·         OLAP cube generation may not be successful in Microsoft Project Web Access

http://support.microsoft.com/kb/324838

 

·         "An OLAP cube was successfully built but with errors" error message when you try to generate an OLAP cube from Project Server 2002 (applies to PS 2003 as well)

http://support.microsoft.com/kb/817782

 

·         Besides these KB articles, also check this article. In short, avoid special characters in your project server environment.

Allowed Characters in Project Server

EPM Job2 MS Project Server Administrator

Job Title:          MS Project Server Administrator

Position Type:   Temp to Hire

Location:          Massachusetts (MA)                           

Salary:              Negotiable

Experience:       3 year

 

Job Description:      

BS Computer Science or equivalent

 

First point-of-contact for questions on Microsoft Project Professional Server 2003 and Web Access

Experience with all of the advanced features

Assist in creating new projects from within the PMO and other departments

Provide guidance on industry best practice & ISO Standards

Schedule Portfolio Analyzer OLAP Cube Builds

Create new reports and graphs, custom fields, outline codes, views, and templates as necessary

Troubleshoot network and connectivity

Be experienced in the installation of Project Professional & Web Access

Ability to modify the custom SQL queries,

Transact SQL preferred

 

Job Requirements:

Required

·                                 MS Project Server 2003 EPM

·                                 MS Project Professional

·                                 Project Web Access Administration

·                                 OLAP Cube

·                                 Views: Project Center, Resource Center, Portfolio Views

·                                 Enterprise Resource Management

·                                 Enterprise Global Template management

·                                 Custom Fields / Outline Codes

SQL 2000, Queries

·                                  

Optional

·                                 Programming skills

·                                 Active Directory

·                                 Time Entry Systems

·                                 Sharepoint

·                                 Excel

·                                 Mentoring

 

Contact Email:  Send Your Resume

Contact Instructions: Please send your resumes & salary requirements ASAP.

Start Date:    ASAP