T
TroyS
I want to get the same data that is shown in PWA - Availability
However, i need to perform some calculations (is person < 75% Available
based on currently scheduled items) and return a dataset. I need to be able
to supply data parameters to select a range of dates, weeks, months.
I plan on doing this within SQL Server Reporting.... the above i've got laid
out
However, i'm having difficulty where in the schema to find TimePeriods (as
defined in Managed Periods) associated with Availability.....?
I see that the MSP Cube Res Avail Fact table has availability by day for a
resource but i don't see anywhere else where Availability by day can be
associated with Time Periods (...not task start/finish dates)
I'm also getting Assignment (ie Work) data from the MSP_CUBE_ASSN_FACT
table.
I guess i'll have to add another select stmt to do a lookup on the Time
Period table to find where the individual date falls within in order to
return a time period...
any other idea would be welcomed
thx
However, i need to perform some calculations (is person < 75% Available
based on currently scheduled items) and return a dataset. I need to be able
to supply data parameters to select a range of dates, weeks, months.
I plan on doing this within SQL Server Reporting.... the above i've got laid
out
However, i'm having difficulty where in the schema to find TimePeriods (as
defined in Managed Periods) associated with Availability.....?
I see that the MSP Cube Res Avail Fact table has availability by day for a
resource but i don't see anywhere else where Availability by day can be
associated with Time Periods (...not task start/finish dates)
I'm also getting Assignment (ie Work) data from the MSP_CUBE_ASSN_FACT
table.
I guess i'll have to add another select stmt to do a lookup on the Time
Period table to find where the individual date falls within in order to
return a time period...
any other idea would be welcomed
thx