Can I get an FTE measure computed in any of the cubes?

[Geoff Cartwright]

We would like to do rudimentary resource assignments based on resource
planning only, using monthly FTEs. The view resource availability screen
allows one to select time ranges [ date1 to date2 ], time periods [ Days,
Months, Years ] and also choose the measure [ hours, FTEs ].

Can any one tell me how to get an accurate FTE measure built into a cube? I
am assuming that MDX is the answer but what fields can I use to effect the
calculation? I am assuming that the calculation would be something like (for
capacity)...
FTE_capacity = [capacity] / [{magic field for the timeperiod that I don't
know the name of}]

Well I can live in hope can't I?

 

[Jonathan Sofer]

I use this MDX for FTE. Works well as long as you don't attempt to have
summarized groupings of resources by a resource grouping or by projects.
What I mean is it only works well if you are viewing FTE at the individual
resource level. This works for any time period which is nice.

FTE = iif([Work]=0 or [Capacity]=0,null,[Work]/[Capacity])

Jonathan

 

[Geoff Cartwright]

Hi Jonathan,

Thanks