Distinct results sum in Saiku Analytics

[yoburtu]

Hello,

I am visualizing data with an OLAP cube in the Saiku Analytics viewer and it gives me inconsistent results.

If I remove the list for years and months I get a different total value than if I shed it for years, months and days.

I attach two results in pdf in which the differences of the totals are seen in September and November of 2016 and in February and June of 2017.

This is the mondrian query for sum for months:

WITH
SET [~ROWS] AS
    Hierarchize({{[Fecha.Por Año].[Año].Members}, {[Fecha.Por Año].[Mes].Members}})
SELECT
NON EMPTY {[Measures].[Solicitudes Firmadas]} ON COLUMNS,
NON EMPTY [~ROWS] ON ROWS
FROM [OLAP_Portafirmas_Solicitudes_Firmadas]

This is the mondrian query for sum for months and days:

WITH
SET [~ROWS] AS
    Hierarchize({{[Fecha.Por Año].[Año].Members}, {[Fecha.Por Año].[Mes].Members}, {[Fecha.Por Año].[Día].Members}})
SELECT
NON EMPTY {[Measures].[Solicitudes Firmadas]} ON COLUMNS,
NON EMPTY [~ROWS] ON ROWS
FROM [OLAP_Portafirmas_Solicitudes_Firmadas]

How can this be possible? Where can the fault be?

Best regards.