The difference in the project team effort when using the view is due to the TaskAssignment.IncludeInRD flag set on the task assignment (Include in resource demand checkbox selected on the task assignment):

  • The CognosDemandAndCapacity view ignores flag TaskAssignment.IncludeInRD so it may have a higher effort value

wheras

  • The DS_ResourceDemand  view only includes effort from assignments with TaskAssignment.IncludeInRD = 1