Hi

I have a mondrian cube using MYSQL. In my table with dates (Time) I have:

mysql> SELECT idtime, desc_day FROM fact_entregamercadotime f
where desc_day = "2007-11-02" or desc_day = "2007-11-03" or
desc_day = "2007-11-04"
-> ;
+---------------------+------------+
| idtime | desc_day |
+---------------------+------------+
| 2007-11-02 00:00:00 | 2007-11-02 |
| 2007-11-03 00:00:00 | 2007-11-03 |
| 2007-11-04 00:00:00 | 2007-11-04 |
+---------------------+------------+
3 rows in set (0.00 sec)

I run in Mondrian follow MDX:

SELECT { [Time].[All Time].[2007].[Oct - Dec 2007].[Nov 2007].[2007-11-02] , [Time].[All Time].[2007].[Oct - Dec 2007].[Nov 2007].[2007-11-03] , [Time].[All Time].[2007].[Oct - Dec 2007].[Nov 2007].[2007-11-04] } ON ROWS , { [Measures].[Entrega Mercado Mil BPD] } ON COLUMNS FROM [EntregaMercado]

When I check LOG mondrian file I have:

RolapStar.Column.getCardinality: executing sql [select count(distinct `FACT_EntregaMercadoTIME`.`IDTIME`) as `c0` from `FACT_EntregaMercadoTIME` as `FACT_EntregaMercadoTIME`], 16 ms
Segment.load: executing sql [select `FACT_EntregaMercadoTIME`.`IDTIME` as `c0`, sum(`FACT_EntregaMercado`.`EntregaMercado`) as `m0` from `FACT_EntregaMercadoTIME` as `FACT_EntregaMercadoTIME`, `FACT_EntregaMercado` as `FACT_EntregaMercado` where `FACT_EntregaMercado`.`IDTIME` = `FACT_EntregaMercadoTIME`.`IDTIME` and `FACT_EntregaMercadoTIME`.`IDTIME` in ('2007-11-02 00:00:00.0', '2007-11-03 00:00:00.0', '2007-11-04 01:00:00.0') group by `FACT_EntregaMercadoTIME`.`IDTIME`], 0 ms

Note that, in last SQL, Mondrian run:

IDTIME` in ('2007-11-02 00:00:00.0', '2007-11-03 00:00:00.0', '2007-11-04 01:00:00.0')

Why Mondrian get '2007-11-04 01:00:00.0' ? (Correct is '2007-11-04 00:00:00.0').

Thanks

VVila