Portfolio Analyzer - Important Question

[Rami]

Hi

As you know, you can drop filter fields to filter the data. For example
suppose I have a chart that shows the availability/work for the resources.
The resources are the category fields. And I need to filter by project, so
the project is the filter field.

The strange thing is when I filter by the project by selecting only certain
project, all resource on the category field are selected and they are not
filtered. This bothers the clients a lot as they expect to see the resources
that are only related to this project.

Can anyone help me in this hot issue? Is this a bug or normal behavior? This
is not logical!!!

Thanks in advance
Rami

 

[Dale Howard [MVP]]

Rami --

I created a custom Portfolio Analyzer view by doing the following:

1. Drag the Projects dimension to the Filter Fields drop area
2. Drag the Resources dimension to the Row Fields drop area
3. Drag the Work total field to the Total Fields drop area
4. Drag the Time dimension to the Column fields drop area
5. Save this new Portfolio Analyzer view

When I apply this View and select only one project from the Projects pick
list, in the Pivot Table I see only the resources assigned to tasks in that
project. If I click the Resources pick list, I see that the checkboxes for
all resources are selected, but this does not matter because the Pivot Table
shows only the resources in the project. So, the View is functioning
correctly on my Project Server instance. Is this the behavior you are
seeing, or do you see something different? Let us know.

 

[Rami]

Dear Dale

Thanks for your great efforts in this group.

What about the Chart? Does it have the same behavior?

 

[LTS-PSO]

Hi

We are inexperienced Portfolio Analyzer users and have a similar problem
when setting up filters for certain projects and/or resources and/or time
periods. When the original 'view' is revisited the filtering has changed to
include other projects/resources/time periods. We don't understand why and we
need to retain the original filtering. It bothers our clients too! Would be
grateful for any assistance.

 

[Dale Howard [MVP]]

Rami --

The PivotChart is drawn from the PivotTable information. Hope this helps.

 

[Alika Victor]

- PivotTable Field List appears with Measures & Dimensions
- Dimensions are "grayed" out and unable to add any of them to the Pivot
Table to any of the following
+ Data Area
+ Row Area
+ Column Area
+ Filter Area
+ Detail Area
- When I go to Browse the Data on Analysis Services I noticed that many of
the Dimension come up with a "Have a Zero Count and will need to assign a
count automatically" message "Do you want to proceed" YES or NO

Can anyone tell me why this is occurring. Until I solve this problem, I can
build a View that is worth anything for analysis purposes