但评论停在哪里呢?好像是一个标签。。。。
以下是查询:
SELECT
{
[Measures].[Work Item Count]
} ON COLUMNS,
{
//Filter out people who don't currently have any work items assigned to them
(
CrossJoin
(
//
// This block of code gets the top 10 users, based on how many active bugs they have.
//
TopCount(
NonEmpty(
[Work Item].[System_AssignedTo].Children,
[Measures].[Work Item Count]
),
@TopUserCount,
[Measures].[Work Item Count]
),
[Work Item].[Microsoft_VSTS_Common_Priority].[All].Children,
[Work Item].[Microsoft_VSTS_Common_Severity].[All].Children
),
[Measures].[Work Item Count]
)
} ON ROWS
FROM
(
SELECT
CrossJoin(
StrToMember("[Team Project].[Project Node GUID].&[{" + @ProjectGuid + "}]"),
StrToMember("[Work Item].[System_WorkItemType].[" + @BugName + "]"),
StrToMember("[Work Item].[System_State].&[" + @ActiveName + "]"),
StrToSet(@AreaParam),
StrToSet(@IterationParam),
StrToSet(@PriorityParam),
StrToSet(@SeverityParam)
) ON COLUMNS
FROM [Team System]
)