MDX：如何获取行数

Question

如何在新列中获取行数，请点击上面的图像。在此输入图像描述

 WITH MEMBER DimName AS [DimHealthPlan].[Health Plan Key].CurrentMember.Member_Caption 
      MEMBER DimKey AS [DimHealthPlan].[Health Plan Key].CurrentMember.Member_Key 
      MEMBER [Measures].[Test]  AS ([Measures].[DrPatientKeyCnt] + [Measures].[NrPatientKeyCnt])
      MEMBER RowCount AS COUNT(NONEMPTY([DimHealthPlan].[Health Plan Key].[Health Plan Key]))
SELECT  {[Measures].DimKey ,
         [Measures].DimName,
         [Measures].[HealthPlanPatientCnt],
         [Measures].[CareProviderPatientCnt],
         [Measures].[PCPPatientCnt], 
         [Measures].[Test],
         RowCount} ON COLUMNS ,
NonEmpty([DimHealthPlan].[Health Plan Key].MEMBERS) ON ROWS 
FROM [PopulationReportCube]

- Deepthi

---

你想让它显示1、2、3...，其中第一行为1，最后一行为n吗？ - whytheq

我需要总行数，而不是序列。假设结果包含20行，我需要每一行都是20,20,20.....在RowCount中。 - Deepthi

Answer 1

尝试一下这个-它们应该都会显示6：

MEMBER RowCount AS 
   COUNT(NONEMPTY([DimHealthPlan].[Health Plan Key].MEMBERS))

但如果您想要非常动态的内容，那么您需要探索Axis函数:

https://msdn.microsoft.com/en-us/library/ms145531.aspx

它可以像这样实现:

WITH
SET [Rows] AS 
   {Axis(1)}
MEMBER [Number of rows] AS 
   [Rows].Count 
...
...

- whytheq

---

请问您能否查看附加的图像以获取结果集？ - Deepthi

在结果集中只获取到了2条记录。因此，行数为2,2。 - Deepthi