Field mappings - MSP_PORTFOLIO_ANALYZER cube

[Sanjeev]

Is there a documentation available that maps fields available in the cube
MSP_PORTFOLIO_ANALYZER cube in Project Server 2003 and Project Server 2007
versions?

 

[NZ Projects]

MSFT caertainly havn't produced one, so unless someone else has the answer is
no.

 

[Ben Howard]

I'm not sure I understand the question? In PS2007, there are 13 cubes built,
one of which mimics the single cube in 2003 (MSP_PORTFOLIO_ANALYZER). The
other 12 cubes are all new. The SDK contains a file called
OLAPCubeSchemas.xls which details all 13 cubes, their names, dimensions and
measures.

 

[Marc Soester [MVP]]

Hi Sanjeev,

The cube building process has changed quite a bit in Project Server 2007. In
2003 only Project outline codes where able to be used as dimensions. Project
Server 2007 has extended this functionality dramatically. Have a read through
this article. This will make it clear on what and how the OLAP Cubes are
build:
http://msdn2.microsoft.com/en-us/library/ms447495.aspx#pj12_EnterpriseCF_OLAPCubes

As Bens post suggests, there are now 14 cubes whereby one (
"MSP_Portfolio_Analyser") represents the cube from the 2003 Version.
Hope this helps