Pentaho Server Log

gistfile1.txt

2021-03-18 00:33:56,833 DEBUG [mondrian.sql] 0: SqlMemberSource.getLevelMemberCount: executing sql [select count(*) as `c0` from (select distinct `dim_cliente`.`Cod_Regiao` as `c0` from `dim_cliente` as `dim_cliente`) as `init`]
2021-03-18 00:33:56,841 DEBUG [mondrian.sql] 0: , exec 2 ms
2021-03-18 00:33:56,842 DEBUG [mondrian.sql] 0: , exec+fetch 7 ms, 1 rows
2021-03-18 00:33:56,845 DEBUG [mondrian.sql] 1: SqlMemberSource.getMemberChildren: executing sql [select `dim_cliente`.`Cod_Regiao` as `c0`, `dim_cliente`.`Desc_Regiao` as `c1` from `dim_cliente` as `dim_cliente` group by `dim_cliente`.`Cod_Regiao`, `dim_cliente`.`Desc_Regiao` order by ISNULL(`dim_cliente`.`Cod_Regiao`) ASC, `dim_cliente`.`Cod_Regiao` ASC]
2021-03-18 00:33:56,848 DEBUG [mondrian.sql] 1: , exec 0 ms
2021-03-18 00:33:56,849 DEBUG [mondrian.sql] 1: , exec+fetch 3 ms, 5 rows
2021-03-18 00:33:56,952 DEBUG [mondrian.sql] 2: SqlStatisticsProvider.getTableCardinality: executing sql [select count(*) from `agg_ano_fat`]
2021-03-18 00:33:56,952 DEBUG [mondrian.sql] 2: , exec 0 ms
2021-03-18 00:33:56,953 DEBUG [mondrian.sql] 2: , exec+fetch 1 ms, 1 rows
2021-03-18 00:33:56,953 DEBUG [mondrian.sql] 3: AggStar.FactTable.makeNumberOfRows: executing sql [select count(*) as `c0` from `agg_ano_fat` as `agg_ano_fat`]
2021-03-18 00:33:56,954 DEBUG [mondrian.sql] 3: , exec 0 ms
2021-03-18 00:33:56,955 DEBUG [mondrian.sql] 3: , exec+fetch 2 ms, 1 rows
2021-03-18 00:34:28,468 DEBUG [mondrian.sql] 4: SqlTupleReader.readTuples [[Tempo.Calendario].[Ano]]: executing sql [select `dim_tempo`.`Numero_Ano` as `c0` from `dim_tempo` as `dim_tempo` group by `dim_tempo`.`Numero_Ano` order by ISNULL(`dim_tempo`.`Numero_Ano`) ASC, `dim_tempo`.`Numero_Ano` ASC]
2021-03-18 00:34:28,473 DEBUG [mondrian.sql] 4: , exec 4 ms
2021-03-18 00:34:28,477 DEBUG [mondrian.sql] 4: , exec+fetch 8 ms, 11 rows
2021-03-18 00:34:28,489 DEBUG [mondrian.sql] 5: SqlStatisticsProvider.getColumnCardinality: executing sql [select count(distinct `Numero_Ano`) from `dim_tempo`]
2021-03-18 00:34:28,491 DEBUG [mondrian.sql] 5: , exec 2 ms
2021-03-18 00:34:28,492 DEBUG [mondrian.sql] 5: , exec+fetch 3 ms, 1 rows
2021-03-18 00:34:28,522 DEBUG [mondrian.sql] 6: Segment.load: executing sql [select `dim_tempo`.`Numero_Ano` as `c0`, sum(`fato_presidencia`.`Faturamento`) as `m0` from `dim_tempo` as `dim_tempo`, `fato_presidencia` as `fato_presidencia` where `fato_presidencia`.`ID_Tempo` = `dim_tempo`.`id_tempo` group by `dim_tempo`.`Numero_Ano`]
2021-03-18 00:34:28,575 DEBUG [mondrian.sql] 6: , exec 52 ms
2021-03-18 00:34:28,585 DEBUG [mondrian.sql] 6: , exec+fetch 61 ms, 3 rows
2021-03-18 00:36:00,641 DEBUG [mondrian.sql] 7: SqlTupleReader.readTuples [[Fabrica].[Fabrica]]: executing sql [select `dim_fabrica`.`Cod_Fabrica` as `c0`, `dim_fabrica`.`Desc_Fabrica` as `c1` from `dim_fabrica` as `dim_fabrica` group by `dim_fabrica`.`Cod_Fabrica`, `dim_fabrica`.`Desc_Fabrica` order by ISNULL(`dim_fabrica`.`Cod_Fabrica`) ASC, `dim_fabrica`.`Cod_Fabrica` ASC]
2021-03-18 00:36:00,643 DEBUG [mondrian.sql] 7: , exec 1 ms
2021-03-18 00:36:00,644 DEBUG [mondrian.sql] 7: , exec+fetch 3 ms, 3 rows
2021-03-18 00:36:00,648 DEBUG [mondrian.sql] 8: SqlStatisticsProvider.getColumnCardinality: executing sql [select count(distinct `Cod_Fabrica`) from `dim_fabrica`]
2021-03-18 00:36:00,648 DEBUG [mondrian.sql] 8: , exec 0 ms
2021-03-18 00:36:00,648 DEBUG [mondrian.sql] 8: , exec+fetch 0 ms, 1 rows
2021-03-18 00:36:00,651 DEBUG [mondrian.sql] 9: Segment.load: executing sql [select `dim_fabrica`.`Cod_Fabrica` as `c0`, sum(`fato_presidencia`.`Faturamento`) as `m0` from `dim_fabrica` as `dim_fabrica`, `fato_presidencia` as `fato_presidencia` where `fato_presidencia`.`ID_Fabrica` = `dim_fabrica`.`id_fabrica` group by `dim_fabrica`.`Cod_Fabrica`]
2021-03-18 00:36:00,826 DEBUG [mondrian.sql] 9: , exec 174 ms
2021-03-18 00:36:00,828 DEBUG [mondrian.sql] 9: , exec+fetch 176 ms, 2 rows
2021-03-18 00:36:00,838 DEBUG [mondrian.sql] 10: Segment.load: executing sql [select `dim_tempo`.`Numero_Ano` as `c0`, `dim_fabrica`.`Cod_Fabrica` as `c1`, sum(`fato_presidencia`.`Faturamento`) as `m0` from `dim_tempo` as `dim_tempo`, `fato_presidencia` as `fato_presidencia`, `dim_fabrica` as `dim_fabrica` where `fato_presidencia`.`ID_Tempo` = `dim_tempo`.`id_tempo` and `fato_presidencia`.`ID_Fabrica` = `dim_fabrica`.`id_fabrica` group by `dim_tempo`.`Numero_Ano`, `dim_fabrica`.`Cod_Fabrica`]
2021-03-18 00:36:00,927 DEBUG [mondrian.sql] 10: , exec 89 ms
2021-03-18 00:36:00,928 DEBUG [mondrian.sql] 10: , exec+fetch 90 ms, 6 rows
2021-03-18 00:39:07,294 DEBUG [mondrian.sql] 11: SqlMemberSource.getLevelMemberCount: executing sql [select count(*) as `c0` from (select distinct `dim_cliente`.`Cod_Regiao` as `c0` from `dim_cliente` as `dim_cliente`) as `init`]
2021-03-18 00:39:07,300 DEBUG [mondrian.sql] 11: , exec 5 ms
2021-03-18 00:39:07,300 DEBUG [mondrian.sql] 11: , exec+fetch 6 ms, 1 rows
2021-03-18 00:39:07,301 DEBUG [mondrian.sql] 12: SqlMemberSource.getMemberChildren: executing sql [select `dim_cliente`.`Cod_Regiao` as `c0`, `dim_cliente`.`Desc_Regiao` as `c1` from `dim_cliente` as `dim_cliente` group by `dim_cliente`.`Cod_Regiao`, `dim_cliente`.`Desc_Regiao` order by ISNULL(`dim_cliente`.`Cod_Regiao`) ASC, `dim_cliente`.`Cod_Regiao` ASC]
2021-03-18 00:39:07,302 DEBUG [mondrian.sql] 12: , exec 0 ms
2021-03-18 00:39:07,302 DEBUG [mondrian.sql] 12: , exec+fetch 1 ms, 5 rows
2021-03-18 00:39:07,350 DEBUG [mondrian.sql] 13: SqlStatisticsProvider.getTableCardinality: executing sql [select count(*) from `agg_ano_fat`]
2021-03-18 00:39:07,352 DEBUG [mondrian.sql] 13: , exec 1 ms
2021-03-18 00:39:07,353 DEBUG [mondrian.sql] 13: , exec+fetch 3 ms, 1 rows
2021-03-18 00:39:07,353 DEBUG [mondrian.sql] 14: AggStar.FactTable.makeNumberOfRows: executing sql [select count(*) as `c0` from `agg_ano_fat` as `agg_ano_fat`]
2021-03-18 00:39:07,353 DEBUG [mondrian.sql] 14: , exec 0 ms
2021-03-18 00:39:07,353 DEBUG [mondrian.sql] 14: , exec+fetch 0 ms, 1 rows
2021-03-18 00:39:33,687 DEBUG [mondrian.sql] 15: SqlTupleReader.readTuples [[Fabrica].[Fabrica]]: executing sql [select `dim_fabrica`.`Cod_Fabrica` as `c0`, `dim_fabrica`.`Desc_Fabrica` as `c1` from `dim_fabrica` as `dim_fabrica` group by `dim_fabrica`.`Cod_Fabrica`, `dim_fabrica`.`Desc_Fabrica` order by ISNULL(`dim_fabrica`.`Cod_Fabrica`) ASC, `dim_fabrica`.`Cod_Fabrica` ASC]
2021-03-18 00:39:33,690 DEBUG [mondrian.sql] 15: , exec 1 ms
2021-03-18 00:39:33,690 DEBUG [mondrian.sql] 15: , exec+fetch 3 ms, 3 rows
2021-03-18 00:39:33,690 DEBUG [mondrian.sql] 16: SqlStatisticsProvider.getColumnCardinality: executing sql [select count(distinct `Cod_Fabrica`) from `dim_fabrica`]
2021-03-18 00:39:33,690 DEBUG [mondrian.sql] 16: , exec 0 ms
2021-03-18 00:39:33,690 DEBUG [mondrian.sql] 16: , exec+fetch 0 ms, 1 rows
2021-03-18 00:39:33,695 DEBUG [mondrian.sql] 17: Segment.load: executing sql [select sum(`fato_presidencia`.`Faturamento`) as `m0` from `fato_presidencia` as `fato_presidencia`]
2021-03-18 00:39:33,699 DEBUG [mondrian.sql] 18: Segment.load: executing sql [select `dim_fabrica`.`Cod_Fabrica` as `c0`, sum(`fato_presidencia`.`Faturamento`) as `m0` from `dim_fabrica` as `dim_fabrica`, `fato_presidencia` as `fato_presidencia` where `fato_presidencia`.`ID_Fabrica` = `dim_fabrica`.`id_fabrica` group by `dim_fabrica`.`Cod_Fabrica`]
2021-03-18 00:39:33,711 DEBUG [mondrian.sql] 17: , exec 15 ms
2021-03-18 00:39:33,712 DEBUG [mondrian.sql] 17: , exec+fetch 16 ms, 1 rows
2021-03-18 00:39:33,807 DEBUG [mondrian.sql] 18: , exec 107 ms
2021-03-18 00:39:33,807 DEBUG [mondrian.sql] 18: , exec+fetch 108 ms, 2 rows
2021-03-18 00:39:33,811 DEBUG [mondrian.sql] 19: SqlTupleReader.readTuples [[Tempo.Calendario].[Ano]]: executing sql [select `dim_tempo`.`Numero_Ano` as `c0` from `dim_tempo` as `dim_tempo` group by `dim_tempo`.`Numero_Ano` order by ISNULL(`dim_tempo`.`Numero_Ano`) ASC, `dim_tempo`.`Numero_Ano` ASC]
2021-03-18 00:39:33,815 DEBUG [mondrian.sql] 19: , exec 3 ms
2021-03-18 00:39:33,816 DEBUG [mondrian.sql] 19: , exec+fetch 5 ms, 11 rows
2021-03-18 00:39:33,820 DEBUG [mondrian.sql] 20: SqlStatisticsProvider.getColumnCardinality: executing sql [select count(distinct `Numero_Ano`) from `dim_tempo`]
2021-03-18 00:39:33,821 DEBUG [mondrian.sql] 20: , exec 2 ms
2021-03-18 00:39:33,821 DEBUG [mondrian.sql] 20: , exec+fetch 1 ms, 1 rows
2021-03-18 00:39:33,823 DEBUG [mondrian.sql] 21: Segment.load: executing sql [select `dim_tempo`.`Numero_Ano` as `c0`, `dim_fabrica`.`Cod_Fabrica` as `c1`, sum(`fato_presidencia`.`Faturamento`) as `m0` from `dim_tempo` as `dim_tempo`, `fato_presidencia` as `fato_presidencia`, `dim_fabrica` as `dim_fabrica` where `fato_presidencia`.`ID_Tempo` = `dim_tempo`.`id_tempo` and `fato_presidencia`.`ID_Fabrica` = `dim_fabrica`.`id_fabrica` group by `dim_tempo`.`Numero_Ano`, `dim_fabrica`.`Cod_Fabrica`]
2021-03-18 00:39:33,907 DEBUG [mondrian.sql] 21: , exec 83 ms
2021-03-18 00:39:33,907 DEBUG [mondrian.sql] 21: , exec+fetch 84 ms, 6 rows
2021-03-18 00:40:54,182 DEBUG [mondrian.sql] 22: SqlTupleReader.readTuples [[Fabrica].[Fabrica], [Organizacional].[Vendedor]]: executing sql [select `dim_fabrica`.`Cod_Fabrica` as `c0`, `dim_fabrica`.`Desc_Fabrica` as `c1`, `dim_organizacional`.`Cod_Diretor` as `c2`, `dim_organizacional`.`Desc_Diretor` as `c3`, `dim_organizacional`.`Cod_Gerente` as `c4`, `dim_organizacional`.`Desc_Gerente` as `c5`, `dim_organizacional`.`Cod_Vendedor` as `c6`, `dim_organizacional`.`Desc_Vendedor` as `c7` from `dim_fabrica` as `dim_fabrica`, `fato_presidencia` as `fato_presidencia`, `dim_organizacional` as `dim_organizacional` where `fato_presidencia`.`ID_Fabrica` = `dim_fabrica`.`id_fabrica` and `fato_presidencia`.`ID_Vendedor` = `dim_organizacional`.`id_vendedor` group by `dim_fabrica`.`Cod_Fabrica`, `dim_fabrica`.`Desc_Fabrica`, `dim_organizacional`.`Cod_Diretor`, `dim_organizacional`.`Desc_Diretor`, `dim_organizacional`.`Cod_Gerente`, `dim_organizacional`.`Desc_Gerente`, `dim_organizacional`.`Cod_Vendedor`, `dim_organizacional`.`Desc_Vendedor` order by ISNULL(`dim_fabrica`.`Cod_Fabrica`) ASC, `dim_fabrica`.`Cod_Fabrica` ASC, ISNULL(`dim_organizacional`.`Cod_Diretor`) ASC, `dim_organizacional`.`Cod_Diretor` ASC, ISNULL(`dim_organizacional`.`Cod_Gerente`) ASC, `dim_organizacional`.`Cod_Gerente` ASC, ISNULL(`dim_organizacional`.`Cod_Vendedor`) ASC, `dim_organizacional`.`Cod_Vendedor` ASC]
2021-03-18 00:40:54,574 DEBUG [mondrian.sql] 22: , exec 390 ms
2021-03-18 00:40:54,575 DEBUG [mondrian.sql] 22: , exec+fetch 393 ms, 19 rows
2021-03-18 00:40:54,579 DEBUG [mondrian.sql] 23: SqlStatisticsProvider.getColumnCardinality: executing sql [select count(distinct `Cod_Diretor`) from `dim_organizacional`]
2021-03-18 00:40:54,580 DEBUG [mondrian.sql] 23: , exec 4 ms
2021-03-18 00:40:54,580 DEBUG [mondrian.sql] 23: , exec+fetch 1 ms, 1 rows
2021-03-18 00:40:54,580 DEBUG [mondrian.sql] 24: SqlStatisticsProvider.getColumnCardinality: executing sql [select count(distinct `Cod_Gerente`) from `dim_organizacional`]
2021-03-18 00:40:54,580 DEBUG [mondrian.sql] 24: , exec 0 ms
2021-03-18 00:40:54,580 DEBUG [mondrian.sql] 24: , exec+fetch 0 ms, 1 rows
2021-03-18 00:40:54,580 DEBUG [mondrian.sql] 25: SqlStatisticsProvider.getColumnCardinality: executing sql [select count(distinct `Cod_Vendedor`) from `dim_organizacional`]
2021-03-18 00:40:54,580 DEBUG [mondrian.sql] 25: , exec 0 ms
2021-03-18 00:40:54,580 DEBUG [mondrian.sql] 25: , exec+fetch 0 ms, 1 rows
2021-03-18 00:40:54,580 DEBUG [mondrian.sql] 26: Segment.load: executing sql [select `dim_organizacional`.`Cod_Diretor` as `c0`, `dim_organizacional`.`Cod_Gerente` as `c1`, `dim_organizacional`.`Cod_Vendedor` as `c2`, `dim_fabrica`.`Cod_Fabrica` as `c3`, sum(`fato_presidencia`.`Faturamento`) as `m0` from `dim_organizacional` as `dim_organizacional`, `fato_presidencia` as `fato_presidencia`, `dim_fabrica` as `dim_fabrica` where `fato_presidencia`.`ID_Vendedor` = `dim_organizacional`.`id_vendedor` and `fato_presidencia`.`ID_Fabrica` = `dim_fabrica`.`id_fabrica` group by `dim_organizacional`.`Cod_Diretor`, `dim_organizacional`.`Cod_Gerente`, `dim_organizacional`.`Cod_Vendedor`, `dim_fabrica`.`Cod_Fabrica`]
2021-03-18 00:40:54,709 DEBUG [mondrian.sql] 26: , exec 126 ms
2021-03-18 00:40:54,709 DEBUG [mondrian.sql] 26: , exec+fetch 129 ms, 19 rows
2021-03-18 00:40:54,723 DEBUG [mondrian.sql] 27: Segment.load: executing sql [select `dim_tempo`.`Numero_Ano` as `c0`, `dim_organizacional`.`Cod_Diretor` as `c1`, `dim_organizacional`.`Cod_Gerente` as `c2`, `dim_organizacional`.`Cod_Vendedor` as `c3`, `dim_fabrica`.`Cod_Fabrica` as `c4`, sum(`fato_presidencia`.`Faturamento`) as `m0` from `dim_tempo` as `dim_tempo`, `fato_presidencia` as `fato_presidencia`, `dim_organizacional` as `dim_organizacional`, `dim_fabrica` as `dim_fabrica` where `fato_presidencia`.`ID_Tempo` = `dim_tempo`.`id_tempo` and `fato_presidencia`.`ID_Vendedor` = `dim_organizacional`.`id_vendedor` and `fato_presidencia`.`ID_Fabrica` = `dim_fabrica`.`id_fabrica` group by `dim_tempo`.`Numero_Ano`, `dim_organizacional`.`Cod_Diretor`, `dim_organizacional`.`Cod_Gerente`, `dim_organizacional`.`Cod_Vendedor`, `dim_fabrica`.`Cod_Fabrica`]
2021-03-18 00:40:54,893 DEBUG [mondrian.sql] 27: , exec 161 ms
2021-03-18 00:40:54,893 DEBUG [mondrian.sql] 27: , exec+fetch 170 ms, 57 rows
2021-03-18 00:48:02,939 DEBUG [mondrian.sql] 28: SqlMemberSource.getMemberChildren: executing sql [select `dim_tempo`.`Numero_Ano` as `c0` from `dim_tempo` as `dim_tempo` group by `dim_tempo`.`Numero_Ano` order by ISNULL(`dim_tempo`.`Numero_Ano`) ASC, `dim_tempo`.`Numero_Ano` ASC]
2021-03-18 00:48:02,954 DEBUG [mondrian.sql] 28: , exec 5 ms
2021-03-18 00:48:02,954 DEBUG [mondrian.sql] 28: , exec+fetch 15 ms, 11 rows
2021-03-18 00:48:42,785 DEBUG [mondrian.sql] 29: SqlMemberSource.getLevelMemberCount: executing sql [select count(*) as `c0` from (select distinct `dim_cliente`.`Cod_Regiao` as `c0` from `dim_cliente` as `dim_cliente`) as `init`]
2021-03-18 00:48:42,795 DEBUG [mondrian.sql] 29: , exec 10 ms
2021-03-18 00:48:42,795 DEBUG [mondrian.sql] 29: , exec+fetch 10 ms, 1 rows
2021-03-18 00:48:42,795 DEBUG [mondrian.sql] 30: SqlMemberSource.getMemberChildren: executing sql [select `dim_cliente`.`Cod_Regiao` as `c0`, `dim_cliente`.`Desc_Regiao` as `c1` from `dim_cliente` as `dim_cliente` group by `dim_cliente`.`Cod_Regiao`, `dim_cliente`.`Desc_Regiao` order by ISNULL(`dim_cliente`.`Cod_Regiao`) ASC, `dim_cliente`.`Cod_Regiao` ASC]
2021-03-18 00:48:42,797 DEBUG [mondrian.sql] 30: , exec 0 ms
2021-03-18 00:48:42,797 DEBUG [mondrian.sql] 30: , exec+fetch 2 ms, 5 rows
2021-03-18 00:48:42,843 DEBUG [mondrian.sql] 31: SqlStatisticsProvider.getTableCardinality: executing sql [select count(*) from `agg_ano_fat`]
2021-03-18 00:48:42,845 DEBUG [mondrian.sql] 31: , exec 1 ms
2021-03-18 00:48:42,845 DEBUG [mondrian.sql] 31: , exec+fetch 1 ms, 1 rows
2021-03-18 00:48:42,845 DEBUG [mondrian.sql] 32: AggStar.FactTable.makeNumberOfRows: executing sql [select count(*) as `c0` from `agg_ano_fat` as `agg_ano_fat`]
2021-03-18 00:48:42,846 DEBUG [mondrian.sql] 32: , exec 0 ms
2021-03-18 00:48:42,846 DEBUG [mondrian.sql] 32: , exec+fetch 1 ms, 1 rows
2021-03-18 00:48:44,424 DEBUG [mondrian.sql] 33: SqlMemberSource.getLevelMemberCount: executing sql [select count(*) as `c0` from (select distinct `dim_cliente`.`Cod_Regiao` as `c0` from `dim_cliente` as `dim_cliente`) as `init`]
2021-03-18 00:48:44,425 DEBUG [mondrian.sql] 33: , exec 0 ms
2021-03-18 00:48:44,425 DEBUG [mondrian.sql] 33: , exec+fetch 1 ms, 1 rows
2021-03-18 00:48:44,425 DEBUG [mondrian.sql] 34: SqlMemberSource.getMemberChildren: executing sql [select `dim_cliente`.`Cod_Regiao` as `c0`, `dim_cliente`.`Desc_Regiao` as `c1` from `dim_cliente` as `dim_cliente` group by `dim_cliente`.`Cod_Regiao`, `dim_cliente`.`Desc_Regiao` order by ISNULL(`dim_cliente`.`Cod_Regiao`) ASC, `dim_cliente`.`Cod_Regiao` ASC]
2021-03-18 00:48:44,426 DEBUG [mondrian.sql] 34: , exec 0 ms
2021-03-18 00:48:44,426 DEBUG [mondrian.sql] 34: , exec+fetch 1 ms, 5 rows
2021-03-18 00:48:44,473 DEBUG [mondrian.sql] 35: SqlStatisticsProvider.getTableCardinality: executing sql [select count(*) from `agg_ano_fat`]
2021-03-18 00:48:44,473 DEBUG [mondrian.sql] 35: , exec 0 ms
2021-03-18 00:48:44,473 DEBUG [mondrian.sql] 35: , exec+fetch 0 ms, 1 rows
2021-03-18 00:48:44,473 DEBUG [mondrian.sql] 36: AggStar.FactTable.makeNumberOfRows: executing sql [select count(*) as `c0` from `agg_ano_fat` as `agg_ano_fat`]
2021-03-18 00:48:44,474 DEBUG [mondrian.sql] 36: , exec 0 ms
2021-03-18 00:48:44,474 DEBUG [mondrian.sql] 36: , exec+fetch 1 ms, 1 rows
2021-03-18 00:48:44,770 DEBUG [mondrian.sql] 37: SqlMemberSource.getLevelMemberCount: executing sql [select count(*) as `c0` from (select distinct `dim_cliente`.`Cod_Regiao` as `c0` from `dim_cliente` as `dim_cliente`) as `init`]
2021-03-18 00:48:44,771 DEBUG [mondrian.sql] 37: , exec 0 ms
2021-03-18 00:48:44,771 DEBUG [mondrian.sql] 37: , exec+fetch 1 ms, 1 rows
2021-03-18 00:48:44,771 DEBUG [mondrian.sql] 38: SqlMemberSource.getMemberChildren: executing sql [select `dim_cliente`.`Cod_Regiao` as `c0`, `dim_cliente`.`Desc_Regiao` as `c1` from `dim_cliente` as `dim_cliente` group by `dim_cliente`.`Cod_Regiao`, `dim_cliente`.`Desc_Regiao` order by ISNULL(`dim_cliente`.`Cod_Regiao`) ASC, `dim_cliente`.`Cod_Regiao` ASC]
2021-03-18 00:48:44,772 DEBUG [mondrian.sql] 38: , exec 0 ms
2021-03-18 00:48:44,772 DEBUG [mondrian.sql] 38: , exec+fetch 1 ms, 5 rows
2021-03-18 00:48:44,809 DEBUG [mondrian.sql] 39: SqlStatisticsProvider.getTableCardinality: executing sql [select count(*) from `agg_ano_fat`]
2021-03-18 00:48:44,809 DEBUG [mondrian.sql] 39: , exec 0 ms
2021-03-18 00:48:44,810 DEBUG [mondrian.sql] 39: , exec+fetch 1 ms, 1 rows
2021-03-18 00:48:44,810 DEBUG [mondrian.sql] 40: AggStar.FactTable.makeNumberOfRows: executing sql [select count(*) as `c0` from `agg_ano_fat` as `agg_ano_fat`]
2021-03-18 00:48:44,810 DEBUG [mondrian.sql] 40: , exec 0 ms
2021-03-18 00:48:44,810 DEBUG [mondrian.sql] 40: , exec+fetch 0 ms, 1 rows
2021-03-18 00:48:44,913 DEBUG [mondrian.sql] 41: SqlMemberSource.getLevelMemberCount: executing sql [select count(*) as `c0` from (select distinct `dim_cliente`.`Cod_Regiao` as `c0` from `dim_cliente` as `dim_cliente`) as `init`]
2021-03-18 00:48:44,914 DEBUG [mondrian.sql] 41: , exec 0 ms
2021-03-18 00:48:44,914 DEBUG [mondrian.sql] 41: , exec+fetch 1 ms, 1 rows
2021-03-18 00:48:44,914 DEBUG [mondrian.sql] 42: SqlMemberSource.getMemberChildren: executing sql [select `dim_cliente`.`Cod_Regiao` as `c0`, `dim_cliente`.`Desc_Regiao` as `c1` from `dim_cliente` as `dim_cliente` group by `dim_cliente`.`Cod_Regiao`, `dim_cliente`.`Desc_Regiao` order by ISNULL(`dim_cliente`.`Cod_Regiao`) ASC, `dim_cliente`.`Cod_Regiao` ASC]
2021-03-18 00:48:44,915 DEBUG [mondrian.sql] 42: , exec 0 ms
2021-03-18 00:48:44,915 DEBUG [mondrian.sql] 42: , exec+fetch 1 ms, 5 rows
2021-03-18 00:48:44,973 DEBUG [mondrian.sql] 43: SqlStatisticsProvider.getTableCardinality: executing sql [select count(*) from `agg_ano_fat`]
2021-03-18 00:48:44,973 DEBUG [mondrian.sql] 43: , exec 0 ms
2021-03-18 00:48:44,974 DEBUG [mondrian.sql] 43: , exec+fetch 1 ms, 1 rows
2021-03-18 00:48:44,975 DEBUG [mondrian.sql] 44: AggStar.FactTable.makeNumberOfRows: executing sql [select count(*) as `c0` from `agg_ano_fat` as `agg_ano_fat`]
2021-03-18 00:48:44,976 DEBUG [mondrian.sql] 44: , exec 0 ms
2021-03-18 00:48:44,976 DEBUG [mondrian.sql] 44: , exec+fetch 1 ms, 1 rows
2021-03-18 00:49:39,846 DEBUG [mondrian.sql] 45: SqlTupleReader.readTuples [[Fabrica].[Fabrica], [Organizacional].[Vendedor]]: executing sql [select `dim_fabrica`.`Cod_Fabrica` as `c0`, `dim_fabrica`.`Desc_Fabrica` as `c1`, `dim_organizacional`.`Cod_Diretor` as `c2`, `dim_organizacional`.`Desc_Diretor` as `c3`, `dim_organizacional`.`Cod_Gerente` as `c4`, `dim_organizacional`.`Desc_Gerente` as `c5`, `dim_organizacional`.`Cod_Vendedor` as `c6`, `dim_organizacional`.`Desc_Vendedor` as `c7` from `dim_fabrica` as `dim_fabrica`, `fato_presidencia` as `fato_presidencia`, `dim_organizacional` as `dim_organizacional` where `fato_presidencia`.`ID_Fabrica` = `dim_fabrica`.`id_fabrica` and `fato_presidencia`.`ID_Vendedor` = `dim_organizacional`.`id_vendedor` group by `dim_fabrica`.`Cod_Fabrica`, `dim_fabrica`.`Desc_Fabrica`, `dim_organizacional`.`Cod_Diretor`, `dim_organizacional`.`Desc_Diretor`, `dim_organizacional`.`Cod_Gerente`, `dim_organizacional`.`Desc_Gerente`, `dim_organizacional`.`Cod_Vendedor`, `dim_organizacional`.`Desc_Vendedor` order by ISNULL(`dim_fabrica`.`Cod_Fabrica`) ASC, `dim_fabrica`.`Cod_Fabrica` ASC, ISNULL(`dim_organizacional`.`Cod_Diretor`) ASC, `dim_organizacional`.`Cod_Diretor` ASC, ISNULL(`dim_organizacional`.`Cod_Gerente`) ASC, `dim_organizacional`.`Cod_Gerente` ASC, ISNULL(`dim_organizacional`.`Cod_Vendedor`) ASC, `dim_organizacional`.`Cod_Vendedor` ASC]
2021-03-18 00:49:40,187 DEBUG [mondrian.sql] 45: , exec 331 ms
2021-03-18 00:49:40,188 DEBUG [mondrian.sql] 45: , exec+fetch 342 ms, 19 rows
2021-03-18 00:49:40,189 DEBUG [mondrian.sql] 46: SqlStatisticsProvider.getColumnCardinality: executing sql [select count(distinct `Cod_Diretor`) from `dim_organizacional`]
2021-03-18 00:49:40,190 DEBUG [mondrian.sql] 46: , exec 0 ms
2021-03-18 00:49:40,190 DEBUG [mondrian.sql] 46: , exec+fetch 1 ms, 1 rows
2021-03-18 00:49:40,190 DEBUG [mondrian.sql] 47: SqlStatisticsProvider.getColumnCardinality: executing sql [select count(distinct `Cod_Gerente`) from `dim_organizacional`]
2021-03-18 00:49:40,191 DEBUG [mondrian.sql] 47: , exec 0 ms
2021-03-18 00:49:40,191 DEBUG [mondrian.sql] 47: , exec+fetch 1 ms, 1 rows
2021-03-18 00:49:40,191 DEBUG [mondrian.sql] 48: SqlStatisticsProvider.getColumnCardinality: executing sql [select count(distinct `Cod_Vendedor`) from `dim_organizacional`]
2021-03-18 00:49:40,192 DEBUG [mondrian.sql] 48: , exec 0 ms
2021-03-18 00:49:40,192 DEBUG [mondrian.sql] 48: , exec+fetch 1 ms, 1 rows
2021-03-18 00:49:40,192 DEBUG [mondrian.sql] 49: SqlStatisticsProvider.getColumnCardinality: executing sql [select count(distinct `Cod_Fabrica`) from `dim_fabrica`]
2021-03-18 00:49:40,192 DEBUG [mondrian.sql] 49: , exec 0 ms
2021-03-18 00:49:40,192 DEBUG [mondrian.sql] 49: , exec+fetch 0 ms, 1 rows
2021-03-18 00:49:40,195 DEBUG [mondrian.sql] 50: Segment.load: executing sql [select sum(`fato_presidencia`.`Faturamento`) as `m0` from `fato_presidencia` as `fato_presidencia`]
2021-03-18 00:49:40,195 DEBUG [mondrian.sql] 51: Segment.load: executing sql [select `dim_organizacional`.`Cod_Diretor` as `c0`, `dim_organizacional`.`Cod_Gerente` as `c1`, `dim_organizacional`.`Cod_Vendedor` as `c2`, `dim_fabrica`.`Cod_Fabrica` as `c3`, sum(`fato_presidencia`.`Faturamento`) as `m0` from `dim_organizacional` as `dim_organizacional`, `fato_presidencia` as `fato_presidencia`, `dim_fabrica` as `dim_fabrica` where `fato_presidencia`.`ID_Vendedor` = `dim_organizacional`.`id_vendedor` and `fato_presidencia`.`ID_Fabrica` = `dim_fabrica`.`id_fabrica` group by `dim_organizacional`.`Cod_Diretor`, `dim_organizacional`.`Cod_Gerente`, `dim_organizacional`.`Cod_Vendedor`, `dim_fabrica`.`Cod_Fabrica`]
2021-03-18 00:49:40,209 DEBUG [mondrian.sql] 50: , exec 13 ms
2021-03-18 00:49:40,209 DEBUG [mondrian.sql] 50: , exec+fetch 14 ms, 1 rows
2021-03-18 00:49:40,329 DEBUG [mondrian.sql] 51: , exec 134 ms
2021-03-18 00:49:40,329 DEBUG [mondrian.sql] 51: , exec+fetch 134 ms, 19 rows
2021-03-18 00:49:40,329 DEBUG [mondrian.sql] 52: SqlTupleReader.readTuples [[Tempo.Calendario].[Ano]]: executing sql [select `dim_tempo`.`Numero_Ano` as `c0` from `dim_tempo` as `dim_tempo` group by `dim_tempo`.`Numero_Ano` order by ISNULL(`dim_tempo`.`Numero_Ano`) ASC, `dim_tempo`.`Numero_Ano` ASC]
2021-03-18 00:49:40,329 DEBUG [mondrian.sql] 52: , exec 3 ms
2021-03-18 00:49:40,329 DEBUG [mondrian.sql] 52: , exec+fetch 0 ms, 11 rows
2021-03-18 00:49:40,329 DEBUG [mondrian.sql] 53: SqlStatisticsProvider.getColumnCardinality: executing sql [select count(distinct `Numero_Ano`) from `dim_tempo`]
2021-03-18 00:49:40,329 DEBUG [mondrian.sql] 53: , exec 2 ms
2021-03-18 00:49:40,329 DEBUG [mondrian.sql] 53: , exec+fetch 0 ms, 1 rows
2021-03-18 00:49:40,346 DEBUG [mondrian.sql] 54: Segment.load: executing sql [select `dim_tempo`.`Numero_Ano` as `c0`, `dim_organizacional`.`Cod_Diretor` as `c1`, `dim_organizacional`.`Cod_Gerente` as `c2`, `dim_organizacional`.`Cod_Vendedor` as `c3`, `dim_fabrica`.`Cod_Fabrica` as `c4`, sum(`fato_presidencia`.`Faturamento`) as `m0` from `dim_tempo` as `dim_tempo`, `fato_presidencia` as `fato_presidencia`, `dim_organizacional` as `dim_organizacional`, `dim_fabrica` as `dim_fabrica` where `fato_presidencia`.`ID_Tempo` = `dim_tempo`.`id_tempo` and `fato_presidencia`.`ID_Vendedor` = `dim_organizacional`.`id_vendedor` and `fato_presidencia`.`ID_Fabrica` = `dim_fabrica`.`id_fabrica` group by `dim_tempo`.`Numero_Ano`, `dim_organizacional`.`Cod_Diretor`, `dim_organizacional`.`Cod_Gerente`, `dim_organizacional`.`Cod_Vendedor`, `dim_fabrica`.`Cod_Fabrica`]
2021-03-18 00:49:40,515 DEBUG [mondrian.sql] 54: , exec 167 ms
2021-03-18 00:49:40,517 DEBUG [mondrian.sql] 54: , exec+fetch 171 ms, 57 rows
2021-03-18 00:50:09,173 DEBUG [mondrian.sql] 55: SqlTupleReader.readTuples [[Organizacional].[Vendedor]]: executing sql [select `dim_organizacional`.`Cod_Diretor` as `c0`, `dim_organizacional`.`Desc_Diretor` as `c1`, `dim_organizacional`.`Cod_Gerente` as `c2`, `dim_organizacional`.`Desc_Gerente` as `c3`, `dim_organizacional`.`Cod_Vendedor` as `c4`, `dim_organizacional`.`Desc_Vendedor` as `c5` from `dim_organizacional` as `dim_organizacional` group by `dim_organizacional`.`Cod_Diretor`, `dim_organizacional`.`Desc_Diretor`, `dim_organizacional`.`Cod_Gerente`, `dim_organizacional`.`Desc_Gerente`, `dim_organizacional`.`Cod_Vendedor`, `dim_organizacional`.`Desc_Vendedor` order by ISNULL(`dim_organizacional`.`Cod_Diretor`) ASC, `dim_organizacional`.`Cod_Diretor` ASC, ISNULL(`dim_organizacional`.`Cod_Gerente`) ASC, `dim_organizacional`.`Cod_Gerente` ASC, ISNULL(`dim_organizacional`.`Cod_Vendedor`) ASC, `dim_organizacional`.`Cod_Vendedor` ASC]
2021-03-18 00:50:09,174 DEBUG [mondrian.sql] 55: , exec 0 ms
2021-03-18 00:50:09,175 DEBUG [mondrian.sql] 55: , exec+fetch 2 ms, 13 rows
2021-03-18 00:50:16,415 DEBUG [mondrian.sql] 56: SqlMemberSource.getLevelMemberCount: executing sql [select count(*) as `c0` from (select distinct `dim_organizacional`.`Cod_Diretor` as `c0` from `dim_organizacional` as `dim_organizacional`) as `init`]
2021-03-18 00:50:16,416 DEBUG [mondrian.sql] 56: , exec 0 ms
2021-03-18 00:50:16,416 DEBUG [mondrian.sql] 56: , exec+fetch 1 ms, 1 rows
2021-03-18 00:50:16,417 DEBUG [mondrian.sql] 57: SqlMemberSource.getMemberChildren: executing sql [select `dim_organizacional`.`Cod_Diretor` as `c0`, `dim_organizacional`.`Desc_Diretor` as `c1` from `dim_organizacional` as `dim_organizacional` group by `dim_organizacional`.`Cod_Diretor`, `dim_organizacional`.`Desc_Diretor` order by ISNULL(`dim_organizacional`.`Cod_Diretor`) ASC, `dim_organizacional`.`Cod_Diretor` ASC]
2021-03-18 00:50:16,417 DEBUG [mondrian.sql] 57: , exec 0 ms
2021-03-18 00:50:16,417 DEBUG [mondrian.sql] 57: , exec+fetch 0 ms, 4 rows
2021-03-18 00:50:16,419 DEBUG [mondrian.sql] 58: SqlMemberSource.getLevelMemberCount: executing sql [select count(*) as `c0` from (select distinct `dim_organizacional`.`Cod_Gerente` as `c0`, `dim_organizacional`.`Cod_Diretor` as `c1` from `dim_organizacional` as `dim_organizacional`) as `init`]
2021-03-18 00:50:16,419 DEBUG [mondrian.sql] 58: , exec 0 ms
2021-03-18 00:50:16,419 DEBUG [mondrian.sql] 58: , exec+fetch 0 ms, 1 rows
2021-03-18 00:50:16,435 DEBUG [mondrian.sql] 59: SqlTupleReader.readTuples [[Fabrica].[Fabrica], [Organizacional].[Vendedor]]: executing sql [select `dim_fabrica`.`Cod_Fabrica` as `c0`, `dim_fabrica`.`Desc_Fabrica` as `c1`, `dim_organizacional`.`Cod_Diretor` as `c2`, `dim_organizacional`.`Desc_Diretor` as `c3`, `dim_organizacional`.`Cod_Gerente` as `c4`, `dim_organizacional`.`Desc_Gerente` as `c5`, `dim_organizacional`.`Cod_Vendedor` as `c6`, `dim_organizacional`.`Desc_Vendedor` as `c7` from `dim_fabrica` as `dim_fabrica`, `fato_presidencia` as `fato_presidencia`, `dim_organizacional` as `dim_organizacional` where `fato_presidencia`.`ID_Fabrica` = `dim_fabrica`.`id_fabrica` and `fato_presidencia`.`ID_Vendedor` = `dim_organizacional`.`id_vendedor` and ((`dim_organizacional`.`Cod_Vendedor`, `dim_organizacional`.`Cod_Gerente`, `dim_organizacional`.`Cod_Diretor`) in (('12', '18', '18'), ('1', '13', '19'), ('2', '13', '19'))) group by `dim_fabrica`.`Cod_Fabrica`, `dim_fabrica`.`Desc_Fabrica`, `dim_organizacional`.`Cod_Diretor`, `dim_organizacional`.`Desc_Diretor`, `dim_organizacional`.`Cod_Gerente`, `dim_organizacional`.`Desc_Gerente`, `dim_organizacional`.`Cod_Vendedor`, `dim_organizacional`.`Desc_Vendedor` order by ISNULL(`dim_fabrica`.`Cod_Fabrica`) ASC, `dim_fabrica`.`Cod_Fabrica` ASC, ISNULL(`dim_organizacional`.`Cod_Diretor`) ASC, `dim_organizacional`.`Cod_Diretor` ASC, ISNULL(`dim_organizacional`.`Cod_Gerente`) ASC, `dim_organizacional`.`Cod_Gerente` ASC, ISNULL(`dim_organizacional`.`Cod_Vendedor`) ASC, `dim_organizacional`.`Cod_Vendedor` ASC]
2021-03-18 00:50:16,514 DEBUG [mondrian.sql] 59: , exec 78 ms
2021-03-18 00:50:16,516 DEBUG [mondrian.sql] 59: , exec+fetch 81 ms, 3 rows