how to create the required view of Data Analysis.

[Sam]

I am creating first test view for Data Analsis .

I want to choose any project from all projects in the drop down and
resources will display for those project which i select and then those
resources work , actual work and percentage of work done in the that view.

kindly tell me which fields I will drag from PivotTable field list and drop
on which
Row and Column for this type of required view.

Drop Filter Fields Here
Drop Column Fields Here


Drop Row Fields Here

 

[Dale Howard [MVP]]

Sam --

Using the MSP_Portfolio_Analyzer cube, do the following:

1. Drag the Project List dimension to the Row Fields drop area.
2. Drag the Resource List dimension to the Row Fields drop area, just to
the right of the Project List dimension.
3. Drag the Work field to the Total Fields drop area.
4. Drag the Actual Work field to the Total fields drop area.

There is no default % Work Complete total field available in the Project
Server system, so you need to create a custom total field for this purpose
by completing the following steps:

1. In the PivotTable, click the Calculated Totals and Fields pick list
button and select the Create Calculated Total item on the list.
2. In the Commands and Options dialog, enter the name Pct Work Comp for the
new column.
3. In the dialog, build the following formula:

[Measures].[Actual Work] / [Measures].[Work]

4. In the dialog, click the Format tab.
5. On the Format page of the dialog, click the Number pick list at the
bottom and select the Percent item.
6. Close the Commands and Options dialog.

Be sure to include the new View in at least one Category or else no one will
be able to see this View in PWA. Hope this helps.