[PS2007] - OLAP Questions

[godrid]

Hi,

1) I just notice that the project count measures is not available in MSP
Portfolio Analyzer cube. I intend to create a data analysis view to display
the number of active projects in a reporting period.

2) I also notice that calculated project custom fields are not available for
selection as a dimension. Is there any way I could add in the dimension?

3) From MSDN, it mentions that multivalue field cannot be included in the
cubes because of a limitation in Analysis Services 2000 but does it applies
to Analysis Services 2005? If so, is there any resolution for this?

Regards
Godrid

 

[Paul Conroy]

Hi,

1) I just notice that the project count measures is not available in MSP
Portfolio Analyzer cube. I intend to create a data analysis view to display
the number of active projects in a reporting period.

Create a calculated column or MDX query.

 

[godrid]

Hi Paul,

Thanks for the prompt reply.

1) Can I have the formula to compute the project count?
2) & 3) I have read an article supposing for project 2002 that I could add
in new dimension (including calculated custom field) by extending the OLAP
cube. Is it a viable solution for Project 2007 server? Is so, does the steps
to extend OLAP cube the same as in Project 2002 or 2003?

Regards
Godrid

 

[Paul Conroy]

1) Can I have the formula to compute the project count?

Sure, simply add a calculated column or MDX Expression.

2) & 3) I have read an article supposing for project 2002 that I could add
in new dimension (including calculated custom field) by extending the OLAP
cube. Is it a viable solution for Project 2007 server? Is so, does the steps
to extend OLAP cube the same as in Project 2002 or 2003?

You can use MDX to extend the cube. This isn't the same process as in 2003
and earlier.

 

[godrid]

Hi Paul,

Let me rephrase my questions,

1) I have some experience with calculated column and MDX expression but
still could not figure out how I could deduce the project count information?
What is the expression or formula I should apply?

2) & 3) If I am not wrong, the MDX expression is only able to create total
field in OLAP cube but not dimension field. Let me explain what I plan to
achieve here, I have a project custom field "Project Schedule Indicator" that
shows "On Schedule" or "Behind Schedule" based on calculation. I would like
to create a data analysis view to show the number of project that is on
schedule and behind schedule. Is it possible to achieve this using OLAP?

Regards
Godrid

 

[Gary L. Chefetz [MVP]]

Godrid:

Unless you've got other requirements that you aren't mentioning, I think it
might be easier to create this in the Project Center using a custom field to
generate the count by grouping.

--

Gary L. Chefetz, MVP
MSProjectExperts
For Project Server Consulting: http://www.msprojectexperts.com
For Project Server FAQS: http://www.projectserverexperts.com

 

[godrid]

Hi Gary,

The management would like to see barchart or piechart view that is available
in OLAP. I know that SSRS is the alternative method to achieve this but would
just like to explore alternative method before committing time to work on it.

Thanks and Best Regards
Godrid