Max Units in Data analysis

[ronjon]

i'm working on custom reports for my organisation in MS Project Server
and experience difficulties with the max units we have assigned to our
resources.

example:
i have a resource who is available for 8hours per day, but due to the
type of work i can only assign him for 90% (7.2h) per day on a project,
so i set his Max Units to 90%, so far so good

Now i need a report (msp_portfolio_analyzer) where i can see (per day or
week):
the work the resource had done (Work field)
his capacity (Capacity field) - this should be 7.2h per day
his availability (before the max units) - this should be 8h per day

in the Fieldlists i can nowhere find max units or some other Field with
the availability. I tried also looking for a max units field to use in
an MDX query but can't find this anywhere.

Which field to use or is there some other way around this problem?

 

[Brian Kennemer]

Im not sure why you need Max Units. You have Capacity (7.2) What were you
going to do with Max Units?

 

[ronjon]

Im not sure why you need Max Units. You have Capacity (7.2) What were you
going to do with Max Units?

in the end i actually don't need max units but i do need to see the
Calendar Availability (capacity * 1/max unit)