Help with filtering a view

[Joanna]

I'm new to MS Office Project, and I'm working on some views in MS Office
Project Web Access 2003. Currently, I have a view with Project Name,
Milestone, Start, Finish, 3 Enterprise Project Date Fields, Owner, and
Project Status (Enterprise Project Outline Code5). This view is of the
project type "Project Center".

I need to only display Active projects (based on Project Status), and I need
to only display the Milestones (Milestone = Yes). However, in the Filter
section of the Specify Views page, the only fields in the dropdown available
for filtering are the Enterprise Project Outline Code fields 1-30, which
allows me to filter on status but not Milestone. Is there a way for me to be
able to filter on Milestone = Yes?

Thanks so much.

 

[Dale Howard [MVP]]

Joanna --

You are totally misunderstanding the data contained in a Project Center
view. The system displays only a single line of information about every
project, with different sets of columns by selecting different Project
Center views. Nowhere do you ever see Milestones in a Project Center view,
thus, there is no way to filter on project Milestones. Whoever is asking
you to create this View does not understand the data available in this View.
Explain to them that Milestones are only visible when you click the name of
a project in the Project Center page to display a detailed Project view.
For detailed Project views, you can certainly add a Filter to a custom View.
Hope this helps.

 

[Joanna]

Thanks so much for your reply. I now understand the ideas behind the Project
and Project Center views.

Is there a way via the Portfolio Analyzer view to display Milestone data
across projects? Or is this only available within a project in the Project
view?

 

[Dale Howard [MVP]]

Joanna --

Milestone data is only available in the detailed Project view in PWA. You
can make it available in a Data Analysis view by extending the OLAP cube to
include task data. Oops! There I go again, talking about extending the
OLAP cube! Hope this helps.

 

[Joanna]

That's what I was expecting you'd say.

It seems like almost everything that they want involves extending the OLAP
cube. (Although, I suppose if it were simple, they would have just created
the views themselves.)

Thanks again for your help. I really appreciate it.