Hitachi Vantara Pentaho Community Forums
Results 1 to 4 of 4

Thread: Duplicate rows in saiku

  1. #1
    Join Date
    Jul 2016

    Default Duplicate rows in saiku


    I have a mysql table similar than this:

    id i_horas s_fecha
    1 34 20160712
    2 8 20160712
    3 24 20160713
    4 2 20160713
    5 13 20160714

    And I did this schema:

    <Schema name="Timesheet_Test">
    <Cube name="timesheet_test" visible="true" cache="true" enabled="true">
    <Table name="timesheet">
    <Dimension type="StandardDimension" visible="true" highCardinality="false" name="Fecha">
    <Hierarchy name="Fecha" visible="true" hasAll="true">
    <Level name="Fecha" visible="true" column="s_fecha" ordinalColumn="s_fecha" type="String" uniqueMembers="true" levelType="Regular" hideMemberIf="Never">
    <SQL dialect="generic">
    <Measure name="timesheet" column="i_horas" datatype="Numeric" aggregator="sum" visible="true">

    Using Saiku, when I try a new query to obtain an aggregate table with the total hours per year, I have a result with duplicated years, like this:

    Fecha timesheet
    2016 81
    2016 81
    2016 81
    2016 81

    I would like to have only one row per year. What am I doing wrong?

    Thanks in advance,


  2. #2


    Hi ,
    I have the same problem , have u find some solution , if yes please let me know.


  3. #3


    Hi again ;
    i find a temporary solution not good but it work, the idea is to create an hierarchy to each column in your schema workbench for example :

    dim_date you create H1_DATE Hierarchy contains the hight level Fecha , and after that the orhers.
    I u want to have a group by just for months , u must to create another Hierarchy H2_DATE contains Month label as hight_level.

    H1_DATE :

    H2_DATE :

    It works perfeclly for me, i u have any question tell me.

    Have a nice day

  4. #4


    Remove from your schema this part [column="s_fecha" ordinalColumn="s_fecha"]
    Remove it and try it.



Tags for this Thread

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.