M
MSPLearner
I have a high level requirement to send out a courtesy reminder email to
project staff every Sunday (timesheets have to be submitted by mid-night
Saturday). Some design options to extract delinquent details (staff name,
period for which time is missing etc) say
(1) Write SQL query against appropriate tables
Or
(2) Use timesheet OLAP cube (need to figure out which ones)
Dump delinquent staff names in a distribution list and send courtesy email
via Outlook (details TBD).
I lean towards option (2) because it feels like using an existing
capability, though I am not sure if all the data is available. (1) Feels like
customization.
Questions
1) Is this the best design approach?
2) Does this or similar feature exist in Project Server that could be
repurposed to meet this requirement?
Any suggestions, insights appreciated.
project staff every Sunday (timesheets have to be submitted by mid-night
Saturday). Some design options to extract delinquent details (staff name,
period for which time is missing etc) say
(1) Write SQL query against appropriate tables
Or
(2) Use timesheet OLAP cube (need to figure out which ones)
Dump delinquent staff names in a distribution list and send courtesy email
via Outlook (details TBD).
I lean towards option (2) because it feels like using an existing
capability, though I am not sure if all the data is available. (1) Feels like
customization.
Questions
1) Is this the best design approach?
2) Does this or similar feature exist in Project Server that could be
repurposed to meet this requirement?
Any suggestions, insights appreciated.