Welcome to OGeek Q&A Community for programmer and developer-Open, Learning and Share
Welcome To Ask or Share your Answers For Others

Categories

0 votes
204 views
in Technique[技术] by (71.8m points)

ssas - MDX: I need column count based on the total rows

enter image description here

Here we have total 14 rows, I need one more column (RowCount-Column name) every-cell contains 14 (reputation) means total row counts.

below is the query

WITH MEMBER DimName  AS [DimClinic].[Provider Key].CurrentMember.Member_Caption
     MEMBER DimKey   AS [DimClinic].[Provider Key].CurrentMember.Member_Key 

SELECT {[Measures].DimKey  ,
        [Measures].DimName ,
        [Measures].[DrPatientKeyCnt]} ON COLUMNS ,
NonEmpty([DimClinic].[Provider Key].[Provider Key])ON ROWS 
FROM [PopulationReportCube] 
See Question&Answers more detail:os

与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…
Welcome To Ask or Share your Answers For Others

1 Reply

0 votes
by (71.8m points)
WITH 
  MEMBER DimName AS 
    [DimClinic].[Provider Key].CurrentMember.Member_Caption 
  MEMBER DimKey AS 
    [DimClinic].[Provider Key].CurrentMember.Member_Key 
  MEMBER RowCount AS 
    Count
    (
      NonEmpty
      (
        [DimClinic].[Provider Key].[Provider Key]
       ,[Measures].[DrPatientKeyCnt]
      )
    ) 
SELECT 
  {
    [Measures].DimKey
   ,[Measures].DimName
   ,[Measures].[DrPatientKeyCnt]
   ,[Measures].[RowCount]
  } ON COLUMNS
 ,NonEmpty([DimClinic].[Provider Key].[Provider Key]) ON ROWS
FROM [PopulationReportCube];

与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…
OGeek|极客中国-欢迎来到极客的世界,一个免费开放的程序员编程交流平台!开放,进步,分享!让技术改变生活,让极客改变未来! Welcome to OGeek Q&A Community for programmer and developer-Open, Learning and Share
Click Here to Ask a Question

...