MDX:如何获取行数

Question

如何获取新列中的行数，请点击上图。 enter image description here

 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]

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 
...
...