Adding Resource Allocation as column in Portfolio Analyzer

[FaisalM]

How to add a column in Portfolio Analyzer (OLAP cube) named 'Resource
Allocation' which will be calculated based on 'work / Availability' values?

Allocation = Work / Availability

Thanks

 

[Dale Howard [MVP]]

FaisalM --

Create the custom Portfolio Analyzer view with the Resource dimension in the
Row Fields drop area and the Time dimension in the Column fields drop area.
Click the Create Calculated Total button on the PivotTable toolbar and
create your formula as [Measures].[Work] / [Measures].Availability. While
in the Commands and Options dialog, be sure to click the Format tab and
select Percent as the Number Format value. Hope this helps.

 

[FaisalM]

Thanks
Faisal

FaisalM --

Create the custom Portfolio Analyzer view with the Resource dimension in the
Row Fields drop area and the Time dimension in the Column fields drop area.
Click the Create Calculated Total button on the PivotTable toolbar and
create your formula as [Measures].[Work] / [Measures].Availability. While
in the Commands and Options dialog, be sure to click the Format tab and
select Percent as the Number Format value. Hope this helps.

How to add a column in Portfolio Analyzer (OLAP cube) named 'Resource
Allocation' which will be calculated based on 'work / Availability'
values?

Allocation = Work / Availability

Thanks