mondrian3 set by aggregate

20 Views Asked by At

Good morning,

i'm trying to implement a set with aggregate function but the following query return null for test [Measures].[tt]

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]

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

it works fine (i create a clone of dimension periodi), it's like calling the set as the same of dimension using in descendant funcion create conflict

the set works fine, so the result of measure tt is not null

0

There are 0 best solutions below