Scheduled effort by resource/task/week is an important metric for some reporting we need to do. Within PPM however, it seems quite difficult and/or impossible to obtain this data. I have skimmed through all existing database views and functions but wasn't able to find anything that looked usable, though I mave have missed something.
Can anyone suggest a way to do this? If there is any existing SQL or database function that I can leverage, please let me know.