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

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top