mdx计算度量值与度量值

Question

我想知道您是否可以向我解释为什么这两个mdx语句产生不同的结果，以及我如何更改计算的度量以使其正确。我假设计算出的度量不正确地使用了sum函数。

SELECT    
{ 
[Measures].[PPPH]
} 
ON COLUMNS,  
{
[Matter].[Parent Matter Lawyer - Responsible].&[qnas]
}
ON ROWS  
FROM [Expert Hypercube] 
WHERE   
(  
[Date].[Fiscal].[Month].&[201702], 
[Relative Period].[Relative Period].&[YTD]
) 

对比

with 
member measures.[PPPHx] as 
  sum({{linkmember([Timekeeper].[Person].currentmember,[Matter].[Parent Matter Lawyer - Responsible])}},measures.[PPPH])
select
{
measures.[PPPHx]
} on columns, 
{
[Timekeeper].[Person].&[qnas]
} on rows
from [Expert Hypercube]
where
(
[Date].[Fiscal].[Month].&[201702], 
[Relative Period].[Relative Period].&[YTD]
)

Answer 1

现在还不清楚为什么要使用和函数。LinkMember函数返回一个成员，不需要像集合一样用{...}来覆盖它。您还需要使用All成员，因为它返回Timekeeper.Person.CurrentMember + LinkMember(Timekeeper.Person.CurrentMember，Matter.Parent Matter Lawyer Responsible)。

With 
Member [Measures].[PPPHx] as 
(
    LinkMember([Timekeeper].[Person].CurrentMember,[Matter].[Parent Matter Lawyer - Responsible]),
    [Timekeeper].[Person].[All],
    [Measures].[PPPH]
)

请参阅Richard Lees's article about it。