title: How to modify Team Foundation Server reports to exclude weekends?
body: <p>I would like to modify the Team Foundation Server built-in MS Agile template reports to exclude weekends.</p>
  
  <p>For example, here is the dsWorkItemHistory dataset for the Remaining Work report:</p>
  
  <pre><code>WITH
  MEMBER [Measures].[Date Key] AS
      [Date].[Date].CurrentMember.UniqueName
  
  SELECT
    {
      [Measures].[Date Key],
      [Measures].[Cumulative Count]
    } ON COLUMNS,
    (
      [Work Item].[System_State].[System_State],
      (StrToMember(@StartDateParam):StrToMember(@EndDateParam))
    )
    ON ROWS
  FROM [Team System]
  WHERE
  (
    STRTOMEMBER("[Team Project].[Team Project].["+@Project+"]"),
    STRTOSET(@IterationParam),
    STRTOSET(@AreaParam),
    STRTOSET(@WorkItemTypeParam)
  )
  </code></pre>
  
  <p>I am totally unfamiliar with MDX. Any pointers toward customizing the data returned to exclude weekends is appreciated.</p>