我想修改TeamFoundationServer内置的MS Agile模板报告以排除周末。
例如,以下是剩余工作报告的dsWorkItemHistory数据集:
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)
)
我对MDX完全不熟悉。任何关于定制返回数据以排除周末的指示都是值得赞赏的。