MaxUnits in OLAP

[SharkTracker]

I need to have MaxUnits in the MSP_Portfolio_Analyzer cube so I can calc
FTE's (Full Time equivalent) . I attempted to creat an enterprise field which
is equal to [maxunits]. since this is a formula you can not use it in this
cube.

Any ideas how I can get max units into this cube?

 

[Barbara - Austria]

Hi SharkTracker,

there is a field "capacity" in the cube. It is on resource level and you can
create a calculated field using this measure.

Does that help?

Barbara

 

[SharkTracker]

Thanks for responding but I use capacity in the calc. the formula I want to
use is work/capacity * maxUnits. This will give me the fte for that resource.
--
Sharktracker

Hi SharkTracker,

there is a field "capacity" in the cube. It is on resource level and you can
create a calculated field using this measure.

Does that help?

Barbara

I need to have MaxUnits in the MSP_Portfolio_Analyzer cube so I can calc
FTE's (Full Time equivalent) . I attempted to creat an enterprise field which
is equal to [maxunits]. since this is a formula you can not use it in this
cube.

Any ideas how I can get max units into this cube?