mdx:使用mdx将行合并为单行

Question

​

​

从附加的屏幕截图中，我们如何使用mdx查询将这5行分组到单个行中，而不使用第二列？

预期为单行，其中GD、FR、PR、NC和NT值为4

WITH
MEMBER Gd as iif([DimMetricNumeratorFrequency].[Label].currentmember is  [DimMetricNumeratorFrequency].   
[Label].&[GD],
[Measures].[Patient Key Distinct Count], null)
MEMBER fr as iif([DimMetricNumeratorFrequency].[Label].currentmember is  [DimMetricNumeratorFrequency]. 
[Label].&[FR],
[Measures].[Patient Key Distinct Count], null)
MEMBER pr as iif([DimMetricNumeratorFrequency].[Label].currentmember is  [DimMetricNumeratorFrequency].
[Label].&[PR],
[Measures].[Patient Key Distinct Count], null)
MEMBER nt as iif([DimMetricNumeratorFrequency].[Label].currentmember is  [DimMetricNumeratorFrequency].
[Label].&[NT],
[Measures].[Patient Key Distinct Count], null)
MEMBER nc as iif([DimMetricNumeratorFrequency].[Label].currentmember is  [DimMetricNumeratorFrequency].
[Label].&[NC],
[Measures].[Patient Key Distinct Count], null)


select {Gd, fr, pr, nt, nc} on 0,
([DimMetricNumeratorFrequency].[Metric Id].[Metric Id],[DimMetricNumeratorFrequency].[Label].  
[Label])      
on  1
from [StrategyCompanionDWCube]

Answer 1

你为什么不简单地说

select [DimMetricNumeratorFrequency].[Label].[Label]
       on 0,
       { [Measures].[Patient Key Distinct Count] }    
       on  1
from [StrategyCompanionDWCube]

MDX不要求度量值在列上。