Hitachi Vantara Pentaho Community Forums
Results 1 to 1 of 1

Thread: Distinct results sum in Saiku Analytics

  1. #1
    Join Date
    Apr 2017
    Posts
    4

    Default Distinct results sum in Saiku Analytics

    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:

    Code:
    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:

    Code:
    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.
    Attached Images Attached Images

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

Copyright © 2005 - 2019 Hitachi Vantara Corporation. All Rights Reserved.