OLAP Filter Time Phased Data Using Enterprise Project Code

V

vandermt

Hi,
We are using Project Server 2007.

We are trying to create a pie chart to display work. The chart would show
certain projects for a selected month.

We created a custom project field called PROGRAM and a custom project field
called Project Type 1. Both field contain lookup tables.

Next we went to Cube Configuration and added the custom project fields to
the Project Cube. We ran the OLAP job.

The custom fields are only showing in the Project Non Timephased Project Cube.

Is their a way to get the custom project field to show in the
MSP_Portfolio_Analyzer Cube so we can display our pie chart for a selected
month.

Thanks
 
T

Tao of Project

Hi,
We are using Project Server 2007.

We are trying to create a pie chart to display work. The chart would show
certain projects for a selected month.

We created a custom project field called PROGRAM and a custom project field
called Project Type 1. Both field contain lookup tables.

Next we went to Cube Configuration and added the custom project fields to
the Project Cube. We ran the OLAP job.

The custom fields are only showing in the Project Non Timephased Project Cube.

Is their a way to get the custom project field to show in the
MSP_Portfolio_Analyzer Cube so we can display our pie chart for a selected
month.

Thanks
Click to expand...

Portfolio cube is a virtual cube. It relies on assignment cube. You
have to add the field to assignment cube in order for it to show
 
V

vandermt

Perfect
Thanks very much

Tao of Project said:
Portfolio cube is a virtual cube. It relies on assignment cube. You
have to add the field to assignment cube in order for it to show
Click to expand...
 
Top