MS SQL Server OLAP - Microsoft Project Server 2003 Portfolio Analyzer Formula

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

Microsoft Project Server 2003 Portfolio Analyzer Formula

Projectuser

2005-08-02, 1:24 pm

I am looking for a way to get a count of projects filtered by Time or
Outline Codes.

I can get a count of all projects in the database using the following
formula. Count(descendants([Project List])) However, the number of
projects does not reflect the filter or or categories that I am
applying to the view (Chart).

svetla dim

2006-01-27, 7:23 am

You can use MS Excel PivotTable with datasource - project server database
and the following tables - MSP_View_Proj_Projec
ts_Ent and according of your
project ouline codes - MSP_Cube_Enterprise_
Project_Outline1,2,3
.....

Sponsored Links