Error creating OLAP cube in Project Server 2003

[Patrizio]

In the Portfolio Analyzer views, many resources appears without any data
about scheduled work and availability (both are = 0 hours), although they
have been scheduled and the project has been published (looking at the
Resource Assignments sheet in PWA I can see the right scheduled work).
This is a great problem because all the executive's reports aren't updated
with availability and usage data about enterprise resources.
Looking at the PWA "Update resource tables and OLAP cube" page, the
following error appears (after updating resource availability data and
creating the OLAP cube):
<<
Current Cube Status
The cube was built on 11/04/2005 at 17.07 with errors. The errors will not
prevent use of the cube.The Event Log reports the following related message:
<<
Component: MSP Resource Availablity Refresh and OLAP Cube Creation Component
(ProjOLAP)
File: PROJOLAPProcess
Line: 0

Both Project Server and Professional versions are 2003 SP1. Date range for
projects and resource availability is set from 01/01/2003 to 12/31/2005.

Project data has been migrated from Project Server 2002 to 2003 database
structure. Data about resource work and availability seems to disappear in
OLAP views while republishing project assignments or publishing a new
assignment.

 

[Gary L. Chefetz [MVP]]

Patrzio:

The most common cause of this is the use of non alpha-numeric characters
such as /-!@#$%^& etc. in Enterprise Outline Code field names and values,
and sometimes, Project Names.