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