Mondrian3中用Aggregate创建集后Measure返回Null问题求助

我在Mondrian3里尝试用Aggregate函数实现一个集，但下面的MDX查询中，测试度量[Measures].[tt]返回Null。

WITH
MEMBER [Periodi].[ROLLING2024] AS
    Aggregate(Filter([Periodi].Members,
[Periodi].CurrentMember.properties('KEY') = "CNV.48"
OR [Periodi].CurrentMember.properties('KEY') = "CNV.47"
OR [Periodi].CurrentMember.properties('KEY') = "CNV.49"))
SET
[~ COLUMNS_Rolling] AS
    {[Periodi].[ROLLING2024]}
MEMBER [Measures].[tt] AS
    --Sum(Descendants([Periodo].CurrentMember,[Periodo].[Giro Visita]), ValidMeasure([Measures].[FFL.DTRATTANTI]))
    Sum(Descendants([Periodi].CurrentMember,[Periodi].[Giro Visita]), ValidMeasure([Measures].[FFL.DTRATTANTI]))
SET
[~ ROWS_Prodotti_Prodotti] AS
    {([Prodotti].[(All)].Members)}
SELECT
    CrossJoin([~ COLUMNS_Rolling],
    {[Measures].[tt]}) ON
    COLUMNS,
    Order([~ ROWS_Prodotti_Prodotti],
    [Prodotti].CURRENTMEMBER.ORDERKEY,
    ASC) ON
    ROWS
FROM
    [DatixStruttura]

如果把度量定义改成如下注释掉的版本（基于克隆维度[Periodo]），查询就能正常运行：

MEMBER [Measures].[tt] AS Sum(Descendants([Periodo].CurrentMember,[Periodo].[Giro Visita]), ValidMeasure([Measures].[FFL.DTRATTANTI]))

我推测问题出在Descendants函数中使用了与集相同的维度[Periodi]，导致冲突；且该集本身运行正常，不会导致度量返回Null。

内容的提问来源于stack exchange，提问作者j.beretta