How does DS_ResourceDemand handle completed projects and is it real time?
The DS_ResourceDemand view and other resource demand views are real time. Changes in the data are immediately reflected in reports. The only exception is the DS_DemandAndCapacityStatic (or DS_tblDemandAndCapacity) which is updated only once a day for performance reasons.
Also, completed assignments are not counted into resource demand.