2026-07-30 17:52:34,741 DEBUG [mondrian.sql] 822: SqlMemberSource.getLevelMemberCount: executing sql [ select count(*) as "c0" from (select distinct "customer"."country" as "c0" from "customer" as "customer") as "init"] 2026-07-30 17:52:34,790 DEBUG [mondrian.sql] 822: , exec 34 ms 2026-07-30 17:52:34,790 DEBUG [mondrian.sql] 822: , exec+fetch 34 ms, 1 rows 2026-07-30 17:52:34,791 DEBUG [mondrian.sql] 823: SqlTupleReader.readTuples [[Customers].[Country]]: executing sql [ select "customer"."country" as "c0" from "customer" as "customer" group by "customer"."country" order by CASE WHEN "customer"."country" IS NULL THEN 1 ELSE 0 END, "customer"."country" ASC] 2026-07-30 17:52:34,796 DEBUG [mondrian.sql] 823: , exec 4 ms 2026-07-30 17:52:34,796 DEBUG [mondrian.sql] 823: , exec+fetch 5 ms, 3 rows 2026-07-30 17:52:34,796 DEBUG [mondrian.sql] 824: SqlMemberSource.getMemberChildren: executing sql [ select "customer"."country" as "c0" from "customer" as "customer" group by "customer"."country" order by CASE WHEN "customer"."country" IS NULL THEN 1 ELSE 0 END, "customer"."country" ASC] 2026-07-30 17:52:34,800 DEBUG [mondrian.sql] 824: , exec 3 ms 2026-07-30 17:52:34,800 DEBUG [mondrian.sql] 824: , exec+fetch 4 ms, 3 rows 2026-07-30 17:52:34,801 DEBUG [mondrian.sql] 825: SqlTupleReader.readTuples [[Time].[Year]]: executing sql [ select "time_by_day"."the_year" as "c0" from "time_by_day" as "time_by_day" group by "time_by_day"."the_year" order by CASE WHEN "time_by_day"."the_year" IS NULL THEN 1 ELSE 0 END, "time_by_day"."the_year" ASC] 2026-07-30 17:52:34,801 DEBUG [mondrian.sql] 825: , exec 0 ms 2026-07-30 17:52:34,801 DEBUG [mondrian.sql] 825: , exec+fetch 0 ms, 2 rows 2026-07-30 17:52:34,804 DEBUG [mondrian.sql] 826: SqlTupleReader.readTuples [[Time].[Year]]: executing sql [ select "time_by_day"."the_year" as "c0" from "time_by_day" as "time_by_day" group by "time_by_day"."the_year" order by CASE WHEN "time_by_day"."the_year" IS NULL THEN 1 ELSE 0 END, "time_by_day"."the_year" ASC] 2026-07-30 17:52:34,804 DEBUG [mondrian.sql] 826: , exec 0 ms 2026-07-30 17:52:34,804 DEBUG [mondrian.sql] 826: , exec+fetch 0 ms, 2 rows 2026-07-30 17:52:34,810 DEBUG [mondrian.sql] 827: SqlTupleReader.readTuples [[Time].[Year]]: executing sql [ select "time_by_day"."the_year" as "c0" from "time_by_day" as "time_by_day" group by "time_by_day"."the_year" order by CASE WHEN "time_by_day"."the_year" IS NULL THEN 1 ELSE 0 END, "time_by_day"."the_year" ASC] 2026-07-30 17:52:34,810 DEBUG [mondrian.sql] 827: , exec 0 ms 2026-07-30 17:52:34,810 DEBUG [mondrian.sql] 827: , exec+fetch 0 ms, 2 rows 2026-07-30 17:52:34,810 DEBUG [mondrian.sql] 828: SqlTupleReader.readTuples [[Time].[Year]]: executing sql [ select "time_by_day"."the_year" as "c0" from "time_by_day" as "time_by_day" group by "time_by_day"."the_year" order by CASE WHEN "time_by_day"."the_year" IS NULL THEN 1 ELSE 0 END, "time_by_day"."the_year" ASC] 2026-07-30 17:52:34,811 DEBUG [mondrian.sql] 828: , exec 0 ms 2026-07-30 17:52:34,811 DEBUG [mondrian.sql] 828: , exec+fetch 1 ms, 2 rows 2026-07-30 17:52:34,817 DEBUG [mondrian.sql] 829: SqlTupleReader.readTuples [[Time].[Year]]: executing sql [ select "time_by_day"."the_year" as "c0" from "time_by_day" as "time_by_day" group by "time_by_day"."the_year" order by CASE WHEN "time_by_day"."the_year" IS NULL THEN 1 ELSE 0 END, "time_by_day"."the_year" ASC] 2026-07-30 17:52:34,817 DEBUG [mondrian.sql] 829: , exec 0 ms 2026-07-30 17:52:34,818 DEBUG [mondrian.sql] 829: , exec+fetch 1 ms, 2 rows 2026-07-30 17:52:34,818 DEBUG [mondrian.sql] 830: SqlTupleReader.readTuples [[Time].[Year]]: executing sql [ select "time_by_day"."the_year" as "c0" from "time_by_day" as "time_by_day" group by "time_by_day"."the_year" order by CASE WHEN "time_by_day"."the_year" IS NULL THEN 1 ELSE 0 END, "time_by_day"."the_year" ASC] 2026-07-30 17:52:34,818 DEBUG [mondrian.sql] 830: , exec 0 ms 2026-07-30 17:52:34,819 DEBUG [mondrian.sql] 830: , exec+fetch 0 ms, 2 rows 2026-07-30 17:52:34,823 DEBUG [mondrian.sql] 831: SqlMemberSource.getLevelMemberCount: executing sql [ select count(*) as "c0" from (select distinct "time_by_day"."quarter" as "c0", "time_by_day"."the_year" as "c1" from "time_by_day" as "time_by_day") as "init"] 2026-07-30 17:52:34,824 DEBUG [mondrian.sql] 831: , exec 1 ms 2026-07-30 17:52:34,824 DEBUG [mondrian.sql] 831: , exec+fetch 1 ms, 1 rows 2026-07-30 17:52:34,824 DEBUG [mondrian.sql] 832: SqlTupleReader.readTuples [[Time].[Quarter]]: executing sql [ select "time_by_day"."the_year" as "c0", "time_by_day"."quarter" as "c1" from "time_by_day" as "time_by_day" group by "time_by_day"."the_year", "time_by_day"."quarter" order by CASE WHEN "time_by_day"."the_year" IS NULL THEN 1 ELSE 0 END, "time_by_day"."the_year" ASC, CASE WHEN "time_by_day"."quarter" IS NULL THEN 1 ELSE 0 END, "time_by_day"."quarter" ASC] 2026-07-30 17:52:34,825 DEBUG [mondrian.sql] 832: , exec 0 ms 2026-07-30 17:52:34,826 DEBUG [mondrian.sql] 832: , exec+fetch 2 ms, 8 rows 2026-07-30 17:52:34,847 DEBUG [mondrian.sql] 833: SqlStatisticsProvider.getTableCardinality: executing sql [select count(*) from "agg_c_10_sales_fact_1997"] 2026-07-30 17:52:34,847 DEBUG [mondrian.sql] 833: , exec 0 ms 2026-07-30 17:52:34,847 DEBUG [mondrian.sql] 833: , exec+fetch 0 ms, 1 rows 2026-07-30 17:52:34,847 DEBUG [mondrian.sql] 834: AggStar.FactTable.makeNumberOfRows: executing sql [ select count(*) as "c0" from "agg_c_10_sales_fact_1997" as "agg_c_10_sales_fact_1997"] 2026-07-30 17:52:34,847 DEBUG [mondrian.sql] 834: , exec 0 ms 2026-07-30 17:52:34,847 DEBUG [mondrian.sql] 834: , exec+fetch 0 ms, 1 rows 2026-07-30 17:52:34,888 DEBUG [mondrian.sql] 835: SqlStatisticsProvider.getTableCardinality: executing sql [select count(*) from "agg_c_14_sales_fact_1997"] 2026-07-30 17:52:34,888 DEBUG [mondrian.sql] 835: , exec 0 ms 2026-07-30 17:52:34,889 DEBUG [mondrian.sql] 835: , exec+fetch 1 ms, 1 rows 2026-07-30 17:52:34,889 DEBUG [mondrian.sql] 836: AggStar.FactTable.makeNumberOfRows: executing sql [ select count(*) as "c0" from "agg_c_14_sales_fact_1997" as "agg_c_14_sales_fact_1997"] 2026-07-30 17:52:34,889 DEBUG [mondrian.sql] 836: , exec 0 ms 2026-07-30 17:52:34,889 DEBUG [mondrian.sql] 836: , exec+fetch 0 ms, 1 rows 2026-07-30 17:52:34,902 DEBUG [mondrian.sql] 837: SqlStatisticsProvider.getTableCardinality: executing sql [select count(*) from "agg_g_ms_pcat_sales_fact_1997"] 2026-07-30 17:52:34,903 DEBUG [mondrian.sql] 837: , exec 0 ms 2026-07-30 17:52:34,903 DEBUG [mondrian.sql] 837: , exec+fetch 1 ms, 1 rows 2026-07-30 17:52:34,903 DEBUG [mondrian.sql] 838: AggStar.FactTable.makeNumberOfRows: executing sql [ select count(*) as "c0" from "agg_g_ms_pcat_sales_fact_1997" as "agg_g_ms_pcat_sales_fact_1997"] 2026-07-30 17:52:34,903 DEBUG [mondrian.sql] 838: , exec 0 ms 2026-07-30 17:52:34,903 DEBUG [mondrian.sql] 838: , exec+fetch 0 ms, 1 rows 2026-07-30 17:52:34,917 DEBUG [mondrian.sql] 839: SqlStatisticsProvider.getTableCardinality: executing sql [select count(*) from "agg_l_03_sales_fact_1997"] 2026-07-30 17:52:34,918 DEBUG [mondrian.sql] 839: , exec 0 ms 2026-07-30 17:52:34,918 DEBUG [mondrian.sql] 839: , exec+fetch 1 ms, 1 rows 2026-07-30 17:52:34,918 DEBUG [mondrian.sql] 840: AggStar.FactTable.makeNumberOfRows: executing sql [ select count(*) as "c0" from "agg_l_03_sales_fact_1997" as "agg_l_03_sales_fact_1997"] 2026-07-30 17:52:34,918 DEBUG [mondrian.sql] 840: , exec 0 ms 2026-07-30 17:52:34,918 DEBUG [mondrian.sql] 840: , exec+fetch 0 ms, 1 rows 2026-07-30 17:52:34,933 DEBUG [mondrian.sql] 841: SqlStatisticsProvider.getTableCardinality: executing sql [select count(*) from "agg_l_04_sales_fact_1997"] 2026-07-30 17:52:34,933 DEBUG [mondrian.sql] 841: , exec 0 ms 2026-07-30 17:52:34,933 DEBUG [mondrian.sql] 841: , exec+fetch 0 ms, 1 rows 2026-07-30 17:52:34,933 DEBUG [mondrian.sql] 842: AggStar.FactTable.makeNumberOfRows: executing sql [ select count(*) as "c0" from "agg_l_04_sales_fact_1997" as "agg_l_04_sales_fact_1997"] 2026-07-30 17:52:34,933 DEBUG [mondrian.sql] 842: , exec 0 ms 2026-07-30 17:52:34,933 DEBUG [mondrian.sql] 842: , exec+fetch 0 ms, 1 rows 2026-07-30 17:52:34,946 DEBUG [mondrian.sql] 843: SqlStatisticsProvider.getTableCardinality: executing sql [select count(*) from "agg_l_05_sales_fact_1997"] 2026-07-30 17:52:34,947 DEBUG [mondrian.sql] 843: , exec 0 ms 2026-07-30 17:52:34,947 DEBUG [mondrian.sql] 843: , exec+fetch 1 ms, 1 rows 2026-07-30 17:52:34,947 DEBUG [mondrian.sql] 844: AggStar.FactTable.makeNumberOfRows: executing sql [ select count(*) as "c0" from "agg_l_05_sales_fact_1997" as "agg_l_05_sales_fact_1997"] 2026-07-30 17:52:34,947 DEBUG [mondrian.sql] 844: , exec 0 ms 2026-07-30 17:52:34,947 DEBUG [mondrian.sql] 844: , exec+fetch 0 ms, 1 rows 2026-07-30 17:52:34,961 DEBUG [mondrian.sql] 845: SqlStatisticsProvider.getTableCardinality: executing sql [select count(*) from "agg_lc_06_sales_fact_1997"] 2026-07-30 17:52:34,962 DEBUG [mondrian.sql] 845: , exec 0 ms 2026-07-30 17:52:34,962 DEBUG [mondrian.sql] 845: , exec+fetch 1 ms, 1 rows 2026-07-30 17:52:34,962 DEBUG [mondrian.sql] 846: AggStar.FactTable.makeNumberOfRows: executing sql [ select count(*) as "c0" from "agg_lc_06_sales_fact_1997" as "agg_lc_06_sales_fact_1997"] 2026-07-30 17:52:34,962 DEBUG [mondrian.sql] 846: , exec 0 ms 2026-07-30 17:52:34,962 DEBUG [mondrian.sql] 846: , exec+fetch 0 ms, 1 rows 2026-07-30 17:52:34,976 DEBUG [mondrian.sql] 847: SqlStatisticsProvider.getTableCardinality: executing sql [select count(*) from "agg_ll_01_sales_fact_1997"] 2026-07-30 17:52:34,977 DEBUG [mondrian.sql] 847: , exec 0 ms 2026-07-30 17:52:34,977 DEBUG [mondrian.sql] 847: , exec+fetch 1 ms, 1 rows 2026-07-30 17:52:34,977 DEBUG [mondrian.sql] 848: AggStar.FactTable.makeNumberOfRows: executing sql [ select count(*) as "c0" from "agg_ll_01_sales_fact_1997" as "agg_ll_01_sales_fact_1997"] 2026-07-30 17:52:34,977 DEBUG [mondrian.sql] 848: , exec 0 ms 2026-07-30 17:52:34,977 DEBUG [mondrian.sql] 848: , exec+fetch 0 ms, 1 rows 2026-07-30 17:52:34,989 DEBUG [mondrian.sql] 849: SqlStatisticsProvider.getTableCardinality: executing sql [select count(*) from "agg_pl_01_sales_fact_1997"] 2026-07-30 17:52:34,989 DEBUG [mondrian.sql] 849: , exec 0 ms 2026-07-30 17:52:34,989 DEBUG [mondrian.sql] 849: , exec+fetch 0 ms, 1 rows 2026-07-30 17:52:34,989 DEBUG [mondrian.sql] 850: AggStar.FactTable.makeNumberOfRows: executing sql [ select count(*) as "c0" from "agg_pl_01_sales_fact_1997" as "agg_pl_01_sales_fact_1997"] 2026-07-30 17:52:34,989 DEBUG [mondrian.sql] 850: , exec 0 ms 2026-07-30 17:52:34,989 DEBUG [mondrian.sql] 850: , exec+fetch 0 ms, 1 rows 2026-07-30 17:52:40,627 DEBUG [mondrian.sql] 851: SqlMemberSource.getLevelMemberCount: executing sql [ select count(*) as "c0" from (select distinct "customer"."country" as "c0" from "customer" as "customer") as "init"] 2026-07-30 17:52:40,648 DEBUG [mondrian.sql] 851: , exec 20 ms 2026-07-30 17:52:40,648 DEBUG [mondrian.sql] 851: , exec+fetch 21 ms, 1 rows 2026-07-30 17:52:40,648 DEBUG [mondrian.sql] 852: SqlTupleReader.readTuples [[Customers].[Country]]: executing sql [ select "customer"."country" as "c0" from "customer" as "customer" group by "customer"."country" order by CASE WHEN "customer"."country" IS NULL THEN 1 ELSE 0 END, "customer"."country" ASC] 2026-07-30 17:52:40,652 DEBUG [mondrian.sql] 852: , exec 3 ms 2026-07-30 17:52:40,652 DEBUG [mondrian.sql] 852: , exec+fetch 4 ms, 3 rows 2026-07-30 17:52:40,652 DEBUG [mondrian.sql] 853: SqlMemberSource.getMemberChildren: executing sql [ select "customer"."country" as "c0" from "customer" as "customer" group by "customer"."country" order by CASE WHEN "customer"."country" IS NULL THEN 1 ELSE 0 END, "customer"."country" ASC] 2026-07-30 17:52:40,656 DEBUG [mondrian.sql] 853: , exec 4 ms 2026-07-30 17:52:40,657 DEBUG [mondrian.sql] 853: , exec+fetch 5 ms, 3 rows 2026-07-30 17:52:40,657 DEBUG [mondrian.sql] 854: SqlTupleReader.readTuples [[Time].[Year]]: executing sql [ select "time_by_day"."the_year" as "c0" from "time_by_day" as "time_by_day" group by "time_by_day"."the_year" order by CASE WHEN "time_by_day"."the_year" IS NULL THEN 1 ELSE 0 END, "time_by_day"."the_year" ASC] 2026-07-30 17:52:40,657 DEBUG [mondrian.sql] 854: , exec 0 ms 2026-07-30 17:52:40,658 DEBUG [mondrian.sql] 854: , exec+fetch 1 ms, 2 rows 2026-07-30 17:52:40,659 DEBUG [mondrian.sql] 855: SqlTupleReader.readTuples [[Time].[Year]]: executing sql [ select "time_by_day"."the_year" as "c0" from "time_by_day" as "time_by_day" group by "time_by_day"."the_year" order by CASE WHEN "time_by_day"."the_year" IS NULL THEN 1 ELSE 0 END, "time_by_day"."the_year" ASC] 2026-07-30 17:52:40,659 DEBUG [mondrian.sql] 855: , exec 0 ms 2026-07-30 17:52:40,659 DEBUG [mondrian.sql] 855: , exec+fetch 0 ms, 2 rows 2026-07-30 17:52:40,663 DEBUG [mondrian.sql] 856: SqlTupleReader.readTuples [[Time].[Year]]: executing sql [ select "time_by_day"."the_year" as "c0" from "time_by_day" as "time_by_day" group by "time_by_day"."the_year" order by CASE WHEN "time_by_day"."the_year" IS NULL THEN 1 ELSE 0 END, "time_by_day"."the_year" ASC] 2026-07-30 17:52:40,664 DEBUG [mondrian.sql] 856: , exec 0 ms 2026-07-30 17:52:40,664 DEBUG [mondrian.sql] 856: , exec+fetch 1 ms, 2 rows 2026-07-30 17:52:40,664 DEBUG [mondrian.sql] 857: SqlTupleReader.readTuples [[Time].[Year]]: executing sql [ select "time_by_day"."the_year" as "c0" from "time_by_day" as "time_by_day" group by "time_by_day"."the_year" order by CASE WHEN "time_by_day"."the_year" IS NULL THEN 1 ELSE 0 END, "time_by_day"."the_year" ASC] 2026-07-30 17:52:40,664 DEBUG [mondrian.sql] 857: , exec 0 ms 2026-07-30 17:52:40,664 DEBUG [mondrian.sql] 857: , exec+fetch 0 ms, 2 rows 2026-07-30 17:52:40,671 DEBUG [mondrian.sql] 858: SqlTupleReader.readTuples [[Time].[Year]]: executing sql [ select "time_by_day"."the_year" as "c0" from "time_by_day" as "time_by_day" group by "time_by_day"."the_year" order by CASE WHEN "time_by_day"."the_year" IS NULL THEN 1 ELSE 0 END, "time_by_day"."the_year" ASC] 2026-07-30 17:52:40,671 DEBUG [mondrian.sql] 858: , exec 0 ms 2026-07-30 17:52:40,671 DEBUG [mondrian.sql] 858: , exec+fetch 0 ms, 2 rows 2026-07-30 17:52:40,671 DEBUG [mondrian.sql] 859: SqlTupleReader.readTuples [[Time].[Year]]: executing sql [ select "time_by_day"."the_year" as "c0" from "time_by_day" as "time_by_day" group by "time_by_day"."the_year" order by CASE WHEN "time_by_day"."the_year" IS NULL THEN 1 ELSE 0 END, "time_by_day"."the_year" ASC] 2026-07-30 17:52:40,672 DEBUG [mondrian.sql] 859: , exec 0 ms 2026-07-30 17:52:40,672 DEBUG [mondrian.sql] 859: , exec+fetch 1 ms, 2 rows 2026-07-30 17:52:40,676 DEBUG [mondrian.sql] 860: SqlMemberSource.getLevelMemberCount: executing sql [ select count(*) as "c0" from (select distinct "time_by_day"."quarter" as "c0", "time_by_day"."the_year" as "c1" from "time_by_day" as "time_by_day") as "init"] 2026-07-30 17:52:40,677 DEBUG [mondrian.sql] 860: , exec 1 ms 2026-07-30 17:52:40,677 DEBUG [mondrian.sql] 860: , exec+fetch 1 ms, 1 rows 2026-07-30 17:52:40,677 DEBUG [mondrian.sql] 861: SqlTupleReader.readTuples [[Time].[Quarter]]: executing sql [ select "time_by_day"."the_year" as "c0", "time_by_day"."quarter" as "c1" from "time_by_day" as "time_by_day" group by "time_by_day"."the_year", "time_by_day"."quarter" order by CASE WHEN "time_by_day"."the_year" IS NULL THEN 1 ELSE 0 END, "time_by_day"."the_year" ASC, CASE WHEN "time_by_day"."quarter" IS NULL THEN 1 ELSE 0 END, "time_by_day"."quarter" ASC] 2026-07-30 17:52:40,678 DEBUG [mondrian.sql] 861: , exec 0 ms 2026-07-30 17:52:40,678 DEBUG [mondrian.sql] 861: , exec+fetch 1 ms, 8 rows 2026-07-30 17:52:40,694 DEBUG [mondrian.sql] 862: SqlStatisticsProvider.getTableCardinality: executing sql [select count(*) from "agg_c_10_sales_fact_1997"] 2026-07-30 17:52:40,694 DEBUG [mondrian.sql] 862: , exec 0 ms 2026-07-30 17:52:40,694 DEBUG [mondrian.sql] 862: , exec+fetch 0 ms, 1 rows 2026-07-30 17:52:40,694 DEBUG [mondrian.sql] 863: AggStar.FactTable.makeNumberOfRows: executing sql [ select count(*) as "c0" from "agg_c_10_sales_fact_1997" as "agg_c_10_sales_fact_1997"] 2026-07-30 17:52:40,695 DEBUG [mondrian.sql] 863: , exec 0 ms 2026-07-30 17:52:40,695 DEBUG [mondrian.sql] 863: , exec+fetch 1 ms, 1 rows 2026-07-30 17:52:40,707 DEBUG [mondrian.sql] 864: SqlStatisticsProvider.getTableCardinality: executing sql [select count(*) from "agg_c_14_sales_fact_1997"] 2026-07-30 17:52:40,707 DEBUG [mondrian.sql] 864: , exec 0 ms 2026-07-30 17:52:40,707 DEBUG [mondrian.sql] 864: , exec+fetch 0 ms, 1 rows 2026-07-30 17:52:40,707 DEBUG [mondrian.sql] 865: AggStar.FactTable.makeNumberOfRows: executing sql [ select count(*) as "c0" from "agg_c_14_sales_fact_1997" as "agg_c_14_sales_fact_1997"] 2026-07-30 17:52:40,707 DEBUG [mondrian.sql] 865: , exec 0 ms 2026-07-30 17:52:40,707 DEBUG [mondrian.sql] 865: , exec+fetch 0 ms, 1 rows 2026-07-30 17:52:40,723 DEBUG [mondrian.sql] 866: SqlStatisticsProvider.getTableCardinality: executing sql [select count(*) from "agg_g_ms_pcat_sales_fact_1997"] 2026-07-30 17:52:40,723 DEBUG [mondrian.sql] 866: , exec 0 ms 2026-07-30 17:52:40,723 DEBUG [mondrian.sql] 866: , exec+fetch 0 ms, 1 rows 2026-07-30 17:52:40,724 DEBUG [mondrian.sql] 867: AggStar.FactTable.makeNumberOfRows: executing sql [ select count(*) as "c0" from "agg_g_ms_pcat_sales_fact_1997" as "agg_g_ms_pcat_sales_fact_1997"] 2026-07-30 17:52:40,724 DEBUG [mondrian.sql] 867: , exec 0 ms 2026-07-30 17:52:40,724 DEBUG [mondrian.sql] 867: , exec+fetch 0 ms, 1 rows 2026-07-30 17:52:40,739 DEBUG [mondrian.sql] 868: SqlStatisticsProvider.getTableCardinality: executing sql [select count(*) from "agg_l_03_sales_fact_1997"] 2026-07-30 17:52:40,739 DEBUG [mondrian.sql] 868: , exec 0 ms 2026-07-30 17:52:40,739 DEBUG [mondrian.sql] 868: , exec+fetch 0 ms, 1 rows 2026-07-30 17:52:40,739 DEBUG [mondrian.sql] 869: AggStar.FactTable.makeNumberOfRows: executing sql [ select count(*) as "c0" from "agg_l_03_sales_fact_1997" as "agg_l_03_sales_fact_1997"] 2026-07-30 17:52:40,740 DEBUG [mondrian.sql] 869: , exec 0 ms 2026-07-30 17:52:40,740 DEBUG [mondrian.sql] 869: , exec+fetch 1 ms, 1 rows 2026-07-30 17:52:40,756 DEBUG [mondrian.sql] 870: SqlStatisticsProvider.getTableCardinality: executing sql [select count(*) from "agg_l_04_sales_fact_1997"] 2026-07-30 17:52:40,756 DEBUG [mondrian.sql] 870: , exec 0 ms 2026-07-30 17:52:40,756 DEBUG [mondrian.sql] 870: , exec+fetch 0 ms, 1 rows 2026-07-30 17:52:40,756 DEBUG [mondrian.sql] 871: AggStar.FactTable.makeNumberOfRows: executing sql [ select count(*) as "c0" from "agg_l_04_sales_fact_1997" as "agg_l_04_sales_fact_1997"] 2026-07-30 17:52:40,756 DEBUG [mondrian.sql] 871: , exec 0 ms 2026-07-30 17:52:40,756 DEBUG [mondrian.sql] 871: , exec+fetch 0 ms, 1 rows 2026-07-30 17:52:40,771 DEBUG [mondrian.sql] 872: SqlStatisticsProvider.getTableCardinality: executing sql [select count(*) from "agg_l_05_sales_fact_1997"] 2026-07-30 17:52:40,771 DEBUG [mondrian.sql] 872: , exec 0 ms 2026-07-30 17:52:40,771 DEBUG [mondrian.sql] 872: , exec+fetch 0 ms, 1 rows 2026-07-30 17:52:40,771 DEBUG [mondrian.sql] 873: AggStar.FactTable.makeNumberOfRows: executing sql [ select count(*) as "c0" from "agg_l_05_sales_fact_1997" as "agg_l_05_sales_fact_1997"] 2026-07-30 17:52:40,772 DEBUG [mondrian.sql] 873: , exec 0 ms 2026-07-30 17:52:40,772 DEBUG [mondrian.sql] 873: , exec+fetch 0 ms, 1 rows 2026-07-30 17:52:40,786 DEBUG [mondrian.sql] 874: SqlStatisticsProvider.getTableCardinality: executing sql [select count(*) from "agg_lc_06_sales_fact_1997"] 2026-07-30 17:52:40,786 DEBUG [mondrian.sql] 874: , exec 0 ms 2026-07-30 17:52:40,786 DEBUG [mondrian.sql] 874: , exec+fetch 0 ms, 1 rows 2026-07-30 17:52:40,786 DEBUG [mondrian.sql] 875: AggStar.FactTable.makeNumberOfRows: executing sql [ select count(*) as "c0" from "agg_lc_06_sales_fact_1997" as "agg_lc_06_sales_fact_1997"] 2026-07-30 17:52:40,786 DEBUG [mondrian.sql] 875: , exec 0 ms 2026-07-30 17:52:40,786 DEBUG [mondrian.sql] 875: , exec+fetch 0 ms, 1 rows 2026-07-30 17:52:40,798 DEBUG [mondrian.sql] 876: SqlStatisticsProvider.getTableCardinality: executing sql [select count(*) from "agg_ll_01_sales_fact_1997"] 2026-07-30 17:52:40,798 DEBUG [mondrian.sql] 876: , exec 0 ms 2026-07-30 17:52:40,798 DEBUG [mondrian.sql] 876: , exec+fetch 0 ms, 1 rows 2026-07-30 17:52:40,798 DEBUG [mondrian.sql] 877: AggStar.FactTable.makeNumberOfRows: executing sql [ select count(*) as "c0" from "agg_ll_01_sales_fact_1997" as "agg_ll_01_sales_fact_1997"] 2026-07-30 17:52:40,798 DEBUG [mondrian.sql] 877: , exec 0 ms 2026-07-30 17:52:40,798 DEBUG [mondrian.sql] 877: , exec+fetch 0 ms, 1 rows 2026-07-30 17:52:40,810 DEBUG [mondrian.sql] 878: SqlStatisticsProvider.getTableCardinality: executing sql [select count(*) from "agg_pl_01_sales_fact_1997"] 2026-07-30 17:52:40,810 DEBUG [mondrian.sql] 878: , exec 0 ms 2026-07-30 17:52:40,810 DEBUG [mondrian.sql] 878: , exec+fetch 0 ms, 1 rows 2026-07-30 17:52:40,810 DEBUG [mondrian.sql] 879: AggStar.FactTable.makeNumberOfRows: executing sql [ select count(*) as "c0" from "agg_pl_01_sales_fact_1997" as "agg_pl_01_sales_fact_1997"] 2026-07-30 17:52:40,810 DEBUG [mondrian.sql] 879: , exec 0 ms 2026-07-30 17:52:40,810 DEBUG [mondrian.sql] 879: , exec+fetch 0 ms, 1 rows 2026-07-30 17:52:40,839 DEBUG [mondrian.sql] 880: SqlMemberSource.getLevelMemberCount: executing sql [ select count(*) as "c0" from (select distinct "customer"."country" as "c0" from "customer" as "customer") as "init"] 2026-07-30 17:52:40,860 DEBUG [mondrian.sql] 880: , exec 21 ms 2026-07-30 17:52:40,861 DEBUG [mondrian.sql] 880: , exec+fetch 22 ms, 1 rows 2026-07-30 17:52:40,861 DEBUG [mondrian.sql] 881: SqlTupleReader.readTuples [[Customers].[Country]]: executing sql [ select "customer"."country" as "c0" from "customer" as "customer" group by "customer"."country" order by CASE WHEN "customer"."country" IS NULL THEN 1 ELSE 0 END, "customer"."country" ASC] 2026-07-30 17:52:40,865 DEBUG [mondrian.sql] 881: , exec 3 ms 2026-07-30 17:52:40,865 DEBUG [mondrian.sql] 881: , exec+fetch 4 ms, 3 rows 2026-07-30 17:52:40,865 DEBUG [mondrian.sql] 882: SqlMemberSource.getMemberChildren: executing sql [ select "customer"."country" as "c0" from "customer" as "customer" group by "customer"."country" order by CASE WHEN "customer"."country" IS NULL THEN 1 ELSE 0 END, "customer"."country" ASC] 2026-07-30 17:52:40,869 DEBUG [mondrian.sql] 882: , exec 3 ms 2026-07-30 17:52:40,869 DEBUG [mondrian.sql] 882: , exec+fetch 4 ms, 3 rows 2026-07-30 17:52:40,869 DEBUG [mondrian.sql] 883: SqlTupleReader.readTuples [[Time].[Year]]: executing sql [ select "time_by_day"."the_year" as "c0" from "time_by_day" as "time_by_day" group by "time_by_day"."the_year" order by CASE WHEN "time_by_day"."the_year" IS NULL THEN 1 ELSE 0 END, "time_by_day"."the_year" ASC] 2026-07-30 17:52:40,870 DEBUG [mondrian.sql] 883: , exec 0 ms 2026-07-30 17:52:40,870 DEBUG [mondrian.sql] 883: , exec+fetch 1 ms, 2 rows 2026-07-30 17:52:40,871 DEBUG [mondrian.sql] 884: SqlTupleReader.readTuples [[Time].[Year]]: executing sql [ select "time_by_day"."the_year" as "c0" from "time_by_day" as "time_by_day" group by "time_by_day"."the_year" order by CASE WHEN "time_by_day"."the_year" IS NULL THEN 1 ELSE 0 END, "time_by_day"."the_year" ASC] 2026-07-30 17:52:40,871 DEBUG [mondrian.sql] 884: , exec 0 ms 2026-07-30 17:52:40,871 DEBUG [mondrian.sql] 884: , exec+fetch 0 ms, 2 rows 2026-07-30 17:52:40,875 DEBUG [mondrian.sql] 885: SqlTupleReader.readTuples [[Time].[Year]]: executing sql [ select "time_by_day"."the_year" as "c0" from "time_by_day" as "time_by_day" group by "time_by_day"."the_year" order by CASE WHEN "time_by_day"."the_year" IS NULL THEN 1 ELSE 0 END, "time_by_day"."the_year" ASC] 2026-07-30 17:52:40,876 DEBUG [mondrian.sql] 885: , exec 0 ms 2026-07-30 17:52:40,876 DEBUG [mondrian.sql] 885: , exec+fetch 1 ms, 2 rows 2026-07-30 17:52:40,876 DEBUG [mondrian.sql] 886: SqlTupleReader.readTuples [[Time].[Year]]: executing sql [ select "time_by_day"."the_year" as "c0" from "time_by_day" as "time_by_day" group by "time_by_day"."the_year" order by CASE WHEN "time_by_day"."the_year" IS NULL THEN 1 ELSE 0 END, "time_by_day"."the_year" ASC] 2026-07-30 17:52:40,876 DEBUG [mondrian.sql] 886: , exec 0 ms 2026-07-30 17:52:40,876 DEBUG [mondrian.sql] 886: , exec+fetch 0 ms, 2 rows 2026-07-30 17:52:40,882 DEBUG [mondrian.sql] 887: SqlTupleReader.readTuples [[Time].[Year]]: executing sql [ select "time_by_day"."the_year" as "c0" from "time_by_day" as "time_by_day" group by "time_by_day"."the_year" order by CASE WHEN "time_by_day"."the_year" IS NULL THEN 1 ELSE 0 END, "time_by_day"."the_year" ASC] 2026-07-30 17:52:40,882 DEBUG [mondrian.sql] 887: , exec 0 ms 2026-07-30 17:52:40,882 DEBUG [mondrian.sql] 887: , exec+fetch 0 ms, 2 rows 2026-07-30 17:52:40,883 DEBUG [mondrian.sql] 888: SqlTupleReader.readTuples [[Time].[Year]]: executing sql [ select "time_by_day"."the_year" as "c0" from "time_by_day" as "time_by_day" group by "time_by_day"."the_year" order by CASE WHEN "time_by_day"."the_year" IS NULL THEN 1 ELSE 0 END, "time_by_day"."the_year" ASC] 2026-07-30 17:52:40,883 DEBUG [mondrian.sql] 888: , exec 0 ms 2026-07-30 17:52:40,883 DEBUG [mondrian.sql] 888: , exec+fetch 0 ms, 2 rows 2026-07-30 17:52:40,886 DEBUG [mondrian.sql] 889: SqlMemberSource.getLevelMemberCount: executing sql [ select count(*) as "c0" from (select distinct "time_by_day"."quarter" as "c0", "time_by_day"."the_year" as "c1" from "time_by_day" as "time_by_day") as "init"] 2026-07-30 17:52:40,888 DEBUG [mondrian.sql] 889: , exec 1 ms 2026-07-30 17:52:40,888 DEBUG [mondrian.sql] 889: , exec+fetch 2 ms, 1 rows 2026-07-30 17:52:40,888 DEBUG [mondrian.sql] 890: SqlTupleReader.readTuples [[Time].[Quarter]]: executing sql [ select "time_by_day"."the_year" as "c0", "time_by_day"."quarter" as "c1" from "time_by_day" as "time_by_day" group by "time_by_day"."the_year", "time_by_day"."quarter" order by CASE WHEN "time_by_day"."the_year" IS NULL THEN 1 ELSE 0 END, "time_by_day"."the_year" ASC, CASE WHEN "time_by_day"."quarter" IS NULL THEN 1 ELSE 0 END, "time_by_day"."quarter" ASC] 2026-07-30 17:52:40,888 DEBUG [mondrian.sql] 890: , exec 0 ms 2026-07-30 17:52:40,888 DEBUG [mondrian.sql] 890: , exec+fetch 0 ms, 8 rows 2026-07-30 17:52:40,891 DEBUG [mondrian.sql] 891: SqlStatisticsProvider.getTableCardinality: executing sql [select count(*) from "agg_c_10_sales_fact_1997"] 2026-07-30 17:52:40,891 DEBUG [mondrian.sql] 891: , exec 0 ms 2026-07-30 17:52:40,891 DEBUG [mondrian.sql] 891: , exec+fetch 0 ms, 1 rows 2026-07-30 17:52:40,891 DEBUG [mondrian.sql] 892: AggStar.FactTable.makeNumberOfRows: executing sql [ select count(*) as "c0" from "agg_c_10_sales_fact_1997" as "agg_c_10_sales_fact_1997"] 2026-07-30 17:52:40,891 DEBUG [mondrian.sql] 892: , exec 0 ms 2026-07-30 17:52:40,891 DEBUG [mondrian.sql] 892: , exec+fetch 0 ms, 1 rows 2026-07-30 17:52:40,892 DEBUG [mondrian.sql] 893: SqlStatisticsProvider.getTableCardinality: executing sql [select count(*) from "agg_c_14_sales_fact_1997"] 2026-07-30 17:52:40,892 DEBUG [mondrian.sql] 893: , exec 0 ms 2026-07-30 17:52:40,892 DEBUG [mondrian.sql] 893: , exec+fetch 0 ms, 1 rows 2026-07-30 17:52:40,892 DEBUG [mondrian.sql] 894: AggStar.FactTable.makeNumberOfRows: executing sql [ select count(*) as "c0" from "agg_c_14_sales_fact_1997" as "agg_c_14_sales_fact_1997"] 2026-07-30 17:52:40,892 DEBUG [mondrian.sql] 894: , exec 0 ms 2026-07-30 17:52:40,892 DEBUG [mondrian.sql] 894: , exec+fetch 0 ms, 1 rows 2026-07-30 17:52:40,895 DEBUG [mondrian.sql] 895: SqlStatisticsProvider.getTableCardinality: executing sql [select count(*) from "agg_g_ms_pcat_sales_fact_1997"] 2026-07-30 17:52:40,895 DEBUG [mondrian.sql] 895: , exec 0 ms 2026-07-30 17:52:40,895 DEBUG [mondrian.sql] 895: , exec+fetch 0 ms, 1 rows 2026-07-30 17:52:40,895 DEBUG [mondrian.sql] 896: AggStar.FactTable.makeNumberOfRows: executing sql [ select count(*) as "c0" from "agg_g_ms_pcat_sales_fact_1997" as "agg_g_ms_pcat_sales_fact_1997"] 2026-07-30 17:52:40,895 DEBUG [mondrian.sql] 896: , exec 0 ms 2026-07-30 17:52:40,895 DEBUG [mondrian.sql] 896: , exec+fetch 0 ms, 1 rows 2026-07-30 17:52:40,896 DEBUG [mondrian.sql] 897: SqlStatisticsProvider.getTableCardinality: executing sql [select count(*) from "agg_l_03_sales_fact_1997"] 2026-07-30 17:52:40,897 DEBUG [mondrian.sql] 897: , exec 0 ms 2026-07-30 17:52:40,897 DEBUG [mondrian.sql] 897: , exec+fetch 1 ms, 1 rows 2026-07-30 17:52:40,897 DEBUG [mondrian.sql] 898: AggStar.FactTable.makeNumberOfRows: executing sql [ select count(*) as "c0" from "agg_l_03_sales_fact_1997" as "agg_l_03_sales_fact_1997"] 2026-07-30 17:52:40,897 DEBUG [mondrian.sql] 898: , exec 0 ms 2026-07-30 17:52:40,897 DEBUG [mondrian.sql] 898: , exec+fetch 0 ms, 1 rows 2026-07-30 17:52:40,898 DEBUG [mondrian.sql] 899: SqlStatisticsProvider.getTableCardinality: executing sql [select count(*) from "agg_l_04_sales_fact_1997"] 2026-07-30 17:52:40,898 DEBUG [mondrian.sql] 899: , exec 0 ms 2026-07-30 17:52:40,899 DEBUG [mondrian.sql] 899: , exec+fetch 0 ms, 1 rows 2026-07-30 17:52:40,899 DEBUG [mondrian.sql] 900: AggStar.FactTable.makeNumberOfRows: executing sql [ select count(*) as "c0" from "agg_l_04_sales_fact_1997" as "agg_l_04_sales_fact_1997"] 2026-07-30 17:52:40,899 DEBUG [mondrian.sql] 900: , exec 0 ms 2026-07-30 17:52:40,899 DEBUG [mondrian.sql] 900: , exec+fetch 0 ms, 1 rows 2026-07-30 17:52:40,899 DEBUG [mondrian.sql] 901: SqlStatisticsProvider.getTableCardinality: executing sql [select count(*) from "agg_l_05_sales_fact_1997"] 2026-07-30 17:52:40,900 DEBUG [mondrian.sql] 901: , exec 0 ms 2026-07-30 17:52:40,900 DEBUG [mondrian.sql] 901: , exec+fetch 1 ms, 1 rows 2026-07-30 17:52:40,900 DEBUG [mondrian.sql] 902: AggStar.FactTable.makeNumberOfRows: executing sql [ select count(*) as "c0" from "agg_l_05_sales_fact_1997" as "agg_l_05_sales_fact_1997"] 2026-07-30 17:52:40,900 DEBUG [mondrian.sql] 902: , exec 0 ms 2026-07-30 17:52:40,900 DEBUG [mondrian.sql] 902: , exec+fetch 0 ms, 1 rows 2026-07-30 17:52:40,901 DEBUG [mondrian.sql] 903: SqlStatisticsProvider.getTableCardinality: executing sql [select count(*) from "agg_lc_06_sales_fact_1997"] 2026-07-30 17:52:40,901 DEBUG [mondrian.sql] 903: , exec 0 ms 2026-07-30 17:52:40,901 DEBUG [mondrian.sql] 903: , exec+fetch 0 ms, 1 rows 2026-07-30 17:52:40,901 DEBUG [mondrian.sql] 904: AggStar.FactTable.makeNumberOfRows: executing sql [ select count(*) as "c0" from "agg_lc_06_sales_fact_1997" as "agg_lc_06_sales_fact_1997"] 2026-07-30 17:52:40,902 DEBUG [mondrian.sql] 904: , exec 0 ms 2026-07-30 17:52:40,902 DEBUG [mondrian.sql] 904: , exec+fetch 1 ms, 1 rows 2026-07-30 17:52:40,902 DEBUG [mondrian.sql] 905: SqlStatisticsProvider.getTableCardinality: executing sql [select count(*) from "agg_ll_01_sales_fact_1997"] 2026-07-30 17:52:40,903 DEBUG [mondrian.sql] 905: , exec 0 ms 2026-07-30 17:52:40,903 DEBUG [mondrian.sql] 905: , exec+fetch 1 ms, 1 rows 2026-07-30 17:52:40,903 DEBUG [mondrian.sql] 906: AggStar.FactTable.makeNumberOfRows: executing sql [ select count(*) as "c0" from "agg_ll_01_sales_fact_1997" as "agg_ll_01_sales_fact_1997"] 2026-07-30 17:52:40,903 DEBUG [mondrian.sql] 906: , exec 0 ms 2026-07-30 17:52:40,903 DEBUG [mondrian.sql] 906: , exec+fetch 0 ms, 1 rows 2026-07-30 17:52:40,904 DEBUG [mondrian.sql] 907: SqlStatisticsProvider.getTableCardinality: executing sql [select count(*) from "agg_pl_01_sales_fact_1997"] 2026-07-30 17:52:40,904 DEBUG [mondrian.sql] 907: , exec 0 ms 2026-07-30 17:52:40,904 DEBUG [mondrian.sql] 907: , exec+fetch 0 ms, 1 rows 2026-07-30 17:52:40,904 DEBUG [mondrian.sql] 908: AggStar.FactTable.makeNumberOfRows: executing sql [ select count(*) as "c0" from "agg_pl_01_sales_fact_1997" as "agg_pl_01_sales_fact_1997"] 2026-07-30 17:52:40,904 DEBUG [mondrian.sql] 908: , exec 0 ms 2026-07-30 17:52:40,904 DEBUG [mondrian.sql] 908: , exec+fetch 0 ms, 1 rows 2026-07-30 17:57:13,890 DEBUG [mondrian.sql] 909: SqlMemberSource.getLevelMemberCount: executing sql [ select count(*) as "c0" from (select distinct "customer"."country" as "c0" from "customer" as "customer") as "init"] 2026-07-30 17:57:13,913 DEBUG [mondrian.sql] 909: , exec 22 ms 2026-07-30 17:57:13,913 DEBUG [mondrian.sql] 909: , exec+fetch 22 ms, 1 rows 2026-07-30 17:57:13,913 DEBUG [mondrian.sql] 910: SqlTupleReader.readTuples [[Customers].[Country]]: executing sql [ select "customer"."country" as "c0" from "customer" as "customer" group by "customer"."country" order by CASE WHEN "customer"."country" IS NULL THEN 1 ELSE 0 END, "customer"."country" ASC] 2026-07-30 17:57:13,921 DEBUG [mondrian.sql] 910: , exec 7 ms 2026-07-30 17:57:13,921 DEBUG [mondrian.sql] 910: , exec+fetch 8 ms, 3 rows 2026-07-30 17:57:13,921 DEBUG [mondrian.sql] 911: SqlMemberSource.getMemberChildren: executing sql [ select "customer"."country" as "c0" from "customer" as "customer" group by "customer"."country" order by CASE WHEN "customer"."country" IS NULL THEN 1 ELSE 0 END, "customer"."country" ASC] 2026-07-30 17:57:13,926 DEBUG [mondrian.sql] 911: , exec 4 ms 2026-07-30 17:57:13,926 DEBUG [mondrian.sql] 911: , exec+fetch 5 ms, 3 rows 2026-07-30 17:57:13,927 DEBUG [mondrian.sql] 912: SqlTupleReader.readTuples [[Time].[Year]]: executing sql [ select "time_by_day"."the_year" as "c0" from "time_by_day" as "time_by_day" group by "time_by_day"."the_year" order by CASE WHEN "time_by_day"."the_year" IS NULL THEN 1 ELSE 0 END, "time_by_day"."the_year" ASC] 2026-07-30 17:57:13,927 DEBUG [mondrian.sql] 912: , exec 0 ms 2026-07-30 17:57:13,928 DEBUG [mondrian.sql] 912: , exec+fetch 1 ms, 2 rows 2026-07-30 17:57:13,929 DEBUG [mondrian.sql] 913: SqlTupleReader.readTuples [[Time].[Year]]: executing sql [ select "time_by_day"."the_year" as "c0" from "time_by_day" as "time_by_day" group by "time_by_day"."the_year" order by CASE WHEN "time_by_day"."the_year" IS NULL THEN 1 ELSE 0 END, "time_by_day"."the_year" ASC] 2026-07-30 17:57:13,929 DEBUG [mondrian.sql] 913: , exec 0 ms 2026-07-30 17:57:13,929 DEBUG [mondrian.sql] 913: , exec+fetch 0 ms, 2 rows 2026-07-30 17:57:13,933 DEBUG [mondrian.sql] 914: SqlTupleReader.readTuples [[Time].[Year]]: executing sql [ select "time_by_day"."the_year" as "c0" from "time_by_day" as "time_by_day" group by "time_by_day"."the_year" order by CASE WHEN "time_by_day"."the_year" IS NULL THEN 1 ELSE 0 END, "time_by_day"."the_year" ASC] 2026-07-30 17:57:13,933 DEBUG [mondrian.sql] 914: , exec 0 ms 2026-07-30 17:57:13,933 DEBUG [mondrian.sql] 914: , exec+fetch 0 ms, 2 rows 2026-07-30 17:57:13,933 DEBUG [mondrian.sql] 915: SqlTupleReader.readTuples [[Time].[Year]]: executing sql [ select "time_by_day"."the_year" as "c0" from "time_by_day" as "time_by_day" group by "time_by_day"."the_year" order by CASE WHEN "time_by_day"."the_year" IS NULL THEN 1 ELSE 0 END, "time_by_day"."the_year" ASC] 2026-07-30 17:57:13,934 DEBUG [mondrian.sql] 915: , exec 0 ms 2026-07-30 17:57:13,934 DEBUG [mondrian.sql] 915: , exec+fetch 1 ms, 2 rows 2026-07-30 17:57:13,940 DEBUG [mondrian.sql] 916: SqlTupleReader.readTuples [[Time].[Year]]: executing sql [ select "time_by_day"."the_year" as "c0" from "time_by_day" as "time_by_day" group by "time_by_day"."the_year" order by CASE WHEN "time_by_day"."the_year" IS NULL THEN 1 ELSE 0 END, "time_by_day"."the_year" ASC] 2026-07-30 17:57:13,940 DEBUG [mondrian.sql] 916: , exec 0 ms 2026-07-30 17:57:13,940 DEBUG [mondrian.sql] 916: , exec+fetch 0 ms, 2 rows 2026-07-30 17:57:13,941 DEBUG [mondrian.sql] 917: SqlTupleReader.readTuples [[Time].[Year]]: executing sql [ select "time_by_day"."the_year" as "c0" from "time_by_day" as "time_by_day" group by "time_by_day"."the_year" order by CASE WHEN "time_by_day"."the_year" IS NULL THEN 1 ELSE 0 END, "time_by_day"."the_year" ASC] 2026-07-30 17:57:13,941 DEBUG [mondrian.sql] 917: , exec 0 ms 2026-07-30 17:57:13,941 DEBUG [mondrian.sql] 917: , exec+fetch 0 ms, 2 rows 2026-07-30 17:57:13,944 DEBUG [mondrian.sql] 918: SqlMemberSource.getLevelMemberCount: executing sql [ select count(*) as "c0" from (select distinct "time_by_day"."quarter" as "c0", "time_by_day"."the_year" as "c1" from "time_by_day" as "time_by_day") as "init"] 2026-07-30 17:57:13,946 DEBUG [mondrian.sql] 918: , exec 1 ms 2026-07-30 17:57:13,946 DEBUG [mondrian.sql] 918: , exec+fetch 1 ms, 1 rows 2026-07-30 17:57:13,946 DEBUG [mondrian.sql] 919: SqlTupleReader.readTuples [[Time].[Quarter]]: executing sql [ select "time_by_day"."the_year" as "c0", "time_by_day"."quarter" as "c1" from "time_by_day" as "time_by_day" group by "time_by_day"."the_year", "time_by_day"."quarter" order by CASE WHEN "time_by_day"."the_year" IS NULL THEN 1 ELSE 0 END, "time_by_day"."the_year" ASC, CASE WHEN "time_by_day"."quarter" IS NULL THEN 1 ELSE 0 END, "time_by_day"."quarter" ASC] 2026-07-30 17:57:13,947 DEBUG [mondrian.sql] 919: , exec 0 ms 2026-07-30 17:57:13,947 DEBUG [mondrian.sql] 919: , exec+fetch 1 ms, 8 rows 2026-07-30 17:57:13,949 DEBUG [mondrian.sql] 920: SqlStatisticsProvider.getTableCardinality: executing sql [select count(*) from "agg_c_10_sales_fact_1997"] 2026-07-30 17:57:13,950 DEBUG [mondrian.sql] 920: , exec 0 ms 2026-07-30 17:57:13,950 DEBUG [mondrian.sql] 920: , exec+fetch 1 ms, 1 rows 2026-07-30 17:57:13,950 DEBUG [mondrian.sql] 921: AggStar.FactTable.makeNumberOfRows: executing sql [ select count(*) as "c0" from "agg_c_10_sales_fact_1997" as "agg_c_10_sales_fact_1997"] 2026-07-30 17:57:13,950 DEBUG [mondrian.sql] 921: , exec 0 ms 2026-07-30 17:57:13,950 DEBUG [mondrian.sql] 921: , exec+fetch 0 ms, 1 rows 2026-07-30 17:57:13,951 DEBUG [mondrian.sql] 922: SqlStatisticsProvider.getTableCardinality: executing sql [select count(*) from "agg_c_14_sales_fact_1997"] 2026-07-30 17:57:13,951 DEBUG [mondrian.sql] 922: , exec 0 ms 2026-07-30 17:57:13,951 DEBUG [mondrian.sql] 922: , exec+fetch 0 ms, 1 rows 2026-07-30 17:57:13,951 DEBUG [mondrian.sql] 923: AggStar.FactTable.makeNumberOfRows: executing sql [ select count(*) as "c0" from "agg_c_14_sales_fact_1997" as "agg_c_14_sales_fact_1997"] 2026-07-30 17:57:13,951 DEBUG [mondrian.sql] 923: , exec 0 ms 2026-07-30 17:57:13,951 DEBUG [mondrian.sql] 923: , exec+fetch 0 ms, 1 rows 2026-07-30 17:57:13,953 DEBUG [mondrian.sql] 924: SqlStatisticsProvider.getTableCardinality: executing sql [select count(*) from "agg_g_ms_pcat_sales_fact_1997"] 2026-07-30 17:57:13,953 DEBUG [mondrian.sql] 924: , exec 0 ms 2026-07-30 17:57:13,953 DEBUG [mondrian.sql] 924: , exec+fetch 0 ms, 1 rows 2026-07-30 17:57:13,954 DEBUG [mondrian.sql] 925: AggStar.FactTable.makeNumberOfRows: executing sql [ select count(*) as "c0" from "agg_g_ms_pcat_sales_fact_1997" as "agg_g_ms_pcat_sales_fact_1997"] 2026-07-30 17:57:13,954 DEBUG [mondrian.sql] 925: , exec 0 ms 2026-07-30 17:57:13,954 DEBUG [mondrian.sql] 925: , exec+fetch 0 ms, 1 rows 2026-07-30 17:57:13,955 DEBUG [mondrian.sql] 926: SqlStatisticsProvider.getTableCardinality: executing sql [select count(*) from "agg_l_03_sales_fact_1997"] 2026-07-30 17:57:13,955 DEBUG [mondrian.sql] 926: , exec 0 ms 2026-07-30 17:57:13,955 DEBUG [mondrian.sql] 926: , exec+fetch 0 ms, 1 rows 2026-07-30 17:57:13,955 DEBUG [mondrian.sql] 927: AggStar.FactTable.makeNumberOfRows: executing sql [ select count(*) as "c0" from "agg_l_03_sales_fact_1997" as "agg_l_03_sales_fact_1997"] 2026-07-30 17:57:13,955 DEBUG [mondrian.sql] 927: , exec 0 ms 2026-07-30 17:57:13,955 DEBUG [mondrian.sql] 927: , exec+fetch 0 ms, 1 rows 2026-07-30 17:57:13,957 DEBUG [mondrian.sql] 928: SqlStatisticsProvider.getTableCardinality: executing sql [select count(*) from "agg_l_04_sales_fact_1997"] 2026-07-30 17:57:13,958 DEBUG [mondrian.sql] 928: , exec 0 ms 2026-07-30 17:57:13,958 DEBUG [mondrian.sql] 928: , exec+fetch 1 ms, 1 rows 2026-07-30 17:57:13,958 DEBUG [mondrian.sql] 929: AggStar.FactTable.makeNumberOfRows: executing sql [ select count(*) as "c0" from "agg_l_04_sales_fact_1997" as "agg_l_04_sales_fact_1997"] 2026-07-30 17:57:13,958 DEBUG [mondrian.sql] 929: , exec 0 ms 2026-07-30 17:57:13,958 DEBUG [mondrian.sql] 929: , exec+fetch 0 ms, 1 rows 2026-07-30 17:57:13,959 DEBUG [mondrian.sql] 930: SqlStatisticsProvider.getTableCardinality: executing sql [select count(*) from "agg_l_05_sales_fact_1997"] 2026-07-30 17:57:13,959 DEBUG [mondrian.sql] 930: , exec 0 ms 2026-07-30 17:57:13,959 DEBUG [mondrian.sql] 930: , exec+fetch 0 ms, 1 rows 2026-07-30 17:57:13,959 DEBUG [mondrian.sql] 931: AggStar.FactTable.makeNumberOfRows: executing sql [ select count(*) as "c0" from "agg_l_05_sales_fact_1997" as "agg_l_05_sales_fact_1997"] 2026-07-30 17:57:13,960 DEBUG [mondrian.sql] 931: , exec 0 ms 2026-07-30 17:57:13,960 DEBUG [mondrian.sql] 931: , exec+fetch 1 ms, 1 rows 2026-07-30 17:57:13,961 DEBUG [mondrian.sql] 932: SqlStatisticsProvider.getTableCardinality: executing sql [select count(*) from "agg_lc_06_sales_fact_1997"] 2026-07-30 17:57:13,962 DEBUG [mondrian.sql] 932: , exec 0 ms 2026-07-30 17:57:13,962 DEBUG [mondrian.sql] 932: , exec+fetch 1 ms, 1 rows 2026-07-30 17:57:13,962 DEBUG [mondrian.sql] 933: AggStar.FactTable.makeNumberOfRows: executing sql [ select count(*) as "c0" from "agg_lc_06_sales_fact_1997" as "agg_lc_06_sales_fact_1997"] 2026-07-30 17:57:13,962 DEBUG [mondrian.sql] 933: , exec 0 ms 2026-07-30 17:57:13,962 DEBUG [mondrian.sql] 933: , exec+fetch 0 ms, 1 rows 2026-07-30 17:57:13,963 DEBUG [mondrian.sql] 934: SqlStatisticsProvider.getTableCardinality: executing sql [select count(*) from "agg_ll_01_sales_fact_1997"] 2026-07-30 17:57:13,963 DEBUG [mondrian.sql] 934: , exec 0 ms 2026-07-30 17:57:13,963 DEBUG [mondrian.sql] 934: , exec+fetch 0 ms, 1 rows 2026-07-30 17:57:13,963 DEBUG [mondrian.sql] 935: AggStar.FactTable.makeNumberOfRows: executing sql [ select count(*) as "c0" from "agg_ll_01_sales_fact_1997" as "agg_ll_01_sales_fact_1997"] 2026-07-30 17:57:13,963 DEBUG [mondrian.sql] 935: , exec 0 ms 2026-07-30 17:57:13,963 DEBUG [mondrian.sql] 935: , exec+fetch 0 ms, 1 rows 2026-07-30 17:57:13,964 DEBUG [mondrian.sql] 936: SqlStatisticsProvider.getTableCardinality: executing sql [select count(*) from "agg_pl_01_sales_fact_1997"] 2026-07-30 17:57:13,964 DEBUG [mondrian.sql] 936: , exec 0 ms 2026-07-30 17:57:13,964 DEBUG [mondrian.sql] 936: , exec+fetch 0 ms, 1 rows 2026-07-30 17:57:13,965 DEBUG [mondrian.sql] 937: AggStar.FactTable.makeNumberOfRows: executing sql [ select count(*) as "c0" from "agg_pl_01_sales_fact_1997" as "agg_pl_01_sales_fact_1997"] 2026-07-30 17:57:13,965 DEBUG [mondrian.sql] 937: , exec 0 ms 2026-07-30 17:57:13,965 DEBUG [mondrian.sql] 937: , exec+fetch 0 ms, 1 rows 2026-07-30 17:57:23,495 DEBUG [mondrian.sql] 938: SqlMemberSource.getLevelMemberCount: executing sql [ select count(*) as "c0" from (select distinct "customer"."country" as "c0" from "customer" as "customer") as "init"] 2026-07-30 17:57:23,516 DEBUG [mondrian.sql] 938: , exec 21 ms 2026-07-30 17:57:23,516 DEBUG [mondrian.sql] 938: , exec+fetch 21 ms, 1 rows 2026-07-30 17:57:23,517 DEBUG [mondrian.sql] 939: SqlTupleReader.readTuples [[Customers].[Country]]: executing sql [ select "customer"."country" as "c0" from "customer" as "customer" group by "customer"."country" order by CASE WHEN "customer"."country" IS NULL THEN 1 ELSE 0 END, "customer"."country" ASC] 2026-07-30 17:57:23,522 DEBUG [mondrian.sql] 939: , exec 4 ms 2026-07-30 17:57:23,522 DEBUG [mondrian.sql] 939: , exec+fetch 5 ms, 3 rows 2026-07-30 17:57:23,522 DEBUG [mondrian.sql] 940: SqlMemberSource.getMemberChildren: executing sql [ select "customer"."country" as "c0" from "customer" as "customer" group by "customer"."country" order by CASE WHEN "customer"."country" IS NULL THEN 1 ELSE 0 END, "customer"."country" ASC] 2026-07-30 17:57:23,526 DEBUG [mondrian.sql] 940: , exec 4 ms 2026-07-30 17:57:23,526 DEBUG [mondrian.sql] 940: , exec+fetch 4 ms, 3 rows 2026-07-30 17:57:23,527 DEBUG [mondrian.sql] 941: SqlTupleReader.readTuples [[Time].[Year]]: executing sql [ select "time_by_day"."the_year" as "c0" from "time_by_day" as "time_by_day" group by "time_by_day"."the_year" order by CASE WHEN "time_by_day"."the_year" IS NULL THEN 1 ELSE 0 END, "time_by_day"."the_year" ASC] 2026-07-30 17:57:23,527 DEBUG [mondrian.sql] 941: , exec 0 ms 2026-07-30 17:57:23,527 DEBUG [mondrian.sql] 941: , exec+fetch 0 ms, 2 rows 2026-07-30 17:57:23,528 DEBUG [mondrian.sql] 942: SqlTupleReader.readTuples [[Time].[Year]]: executing sql [ select "time_by_day"."the_year" as "c0" from "time_by_day" as "time_by_day" group by "time_by_day"."the_year" order by CASE WHEN "time_by_day"."the_year" IS NULL THEN 1 ELSE 0 END, "time_by_day"."the_year" ASC] 2026-07-30 17:57:23,529 DEBUG [mondrian.sql] 942: , exec 0 ms 2026-07-30 17:57:23,529 DEBUG [mondrian.sql] 942: , exec+fetch 1 ms, 2 rows 2026-07-30 17:57:23,532 DEBUG [mondrian.sql] 943: SqlTupleReader.readTuples [[Time].[Year]]: executing sql [ select "time_by_day"."the_year" as "c0" from "time_by_day" as "time_by_day" group by "time_by_day"."the_year" order by CASE WHEN "time_by_day"."the_year" IS NULL THEN 1 ELSE 0 END, "time_by_day"."the_year" ASC] 2026-07-30 17:57:23,533 DEBUG [mondrian.sql] 943: , exec 0 ms 2026-07-30 17:57:23,533 DEBUG [mondrian.sql] 943: , exec+fetch 1 ms, 2 rows 2026-07-30 17:57:23,533 DEBUG [mondrian.sql] 944: SqlTupleReader.readTuples [[Time].[Year]]: executing sql [ select "time_by_day"."the_year" as "c0" from "time_by_day" as "time_by_day" group by "time_by_day"."the_year" order by CASE WHEN "time_by_day"."the_year" IS NULL THEN 1 ELSE 0 END, "time_by_day"."the_year" ASC] 2026-07-30 17:57:23,533 DEBUG [mondrian.sql] 944: , exec 0 ms 2026-07-30 17:57:23,533 DEBUG [mondrian.sql] 944: , exec+fetch 0 ms, 2 rows 2026-07-30 17:57:23,538 DEBUG [mondrian.sql] 945: SqlTupleReader.readTuples [[Time].[Year]]: executing sql [ select "time_by_day"."the_year" as "c0" from "time_by_day" as "time_by_day" group by "time_by_day"."the_year" order by CASE WHEN "time_by_day"."the_year" IS NULL THEN 1 ELSE 0 END, "time_by_day"."the_year" ASC] 2026-07-30 17:57:23,538 DEBUG [mondrian.sql] 945: , exec 0 ms 2026-07-30 17:57:23,539 DEBUG [mondrian.sql] 945: , exec+fetch 1 ms, 2 rows 2026-07-30 17:57:23,539 DEBUG [mondrian.sql] 946: SqlTupleReader.readTuples [[Time].[Year]]: executing sql [ select "time_by_day"."the_year" as "c0" from "time_by_day" as "time_by_day" group by "time_by_day"."the_year" order by CASE WHEN "time_by_day"."the_year" IS NULL THEN 1 ELSE 0 END, "time_by_day"."the_year" ASC] 2026-07-30 17:57:23,539 DEBUG [mondrian.sql] 946: , exec 0 ms 2026-07-30 17:57:23,539 DEBUG [mondrian.sql] 946: , exec+fetch 0 ms, 2 rows 2026-07-30 17:57:23,543 DEBUG [mondrian.sql] 947: SqlMemberSource.getLevelMemberCount: executing sql [ select count(*) as "c0" from (select distinct "time_by_day"."quarter" as "c0", "time_by_day"."the_year" as "c1" from "time_by_day" as "time_by_day") as "init"] 2026-07-30 17:57:23,544 DEBUG [mondrian.sql] 947: , exec 1 ms 2026-07-30 17:57:23,545 DEBUG [mondrian.sql] 947: , exec+fetch 2 ms, 1 rows 2026-07-30 17:57:23,545 DEBUG [mondrian.sql] 948: SqlTupleReader.readTuples [[Time].[Quarter]]: executing sql [ select "time_by_day"."the_year" as "c0", "time_by_day"."quarter" as "c1" from "time_by_day" as "time_by_day" group by "time_by_day"."the_year", "time_by_day"."quarter" order by CASE WHEN "time_by_day"."the_year" IS NULL THEN 1 ELSE 0 END, "time_by_day"."the_year" ASC, CASE WHEN "time_by_day"."quarter" IS NULL THEN 1 ELSE 0 END, "time_by_day"."quarter" ASC] 2026-07-30 17:57:23,545 DEBUG [mondrian.sql] 948: , exec 0 ms 2026-07-30 17:57:23,545 DEBUG [mondrian.sql] 948: , exec+fetch 0 ms, 8 rows 2026-07-30 17:57:23,547 DEBUG [mondrian.sql] 949: SqlStatisticsProvider.getTableCardinality: executing sql [select count(*) from "agg_c_10_sales_fact_1997"] 2026-07-30 17:57:23,548 DEBUG [mondrian.sql] 949: , exec 0 ms 2026-07-30 17:57:23,548 DEBUG [mondrian.sql] 949: , exec+fetch 0 ms, 1 rows 2026-07-30 17:57:23,548 DEBUG [mondrian.sql] 950: AggStar.FactTable.makeNumberOfRows: executing sql [ select count(*) as "c0" from "agg_c_10_sales_fact_1997" as "agg_c_10_sales_fact_1997"] 2026-07-30 17:57:23,548 DEBUG [mondrian.sql] 950: , exec 0 ms 2026-07-30 17:57:23,548 DEBUG [mondrian.sql] 950: , exec+fetch 0 ms, 1 rows 2026-07-30 17:57:23,549 DEBUG [mondrian.sql] 951: SqlStatisticsProvider.getTableCardinality: executing sql [select count(*) from "agg_c_14_sales_fact_1997"] 2026-07-30 17:57:23,549 DEBUG [mondrian.sql] 951: , exec 0 ms 2026-07-30 17:57:23,549 DEBUG [mondrian.sql] 951: , exec+fetch 0 ms, 1 rows 2026-07-30 17:57:23,549 DEBUG [mondrian.sql] 952: AggStar.FactTable.makeNumberOfRows: executing sql [ select count(*) as "c0" from "agg_c_14_sales_fact_1997" as "agg_c_14_sales_fact_1997"] 2026-07-30 17:57:23,549 DEBUG [mondrian.sql] 952: , exec 0 ms 2026-07-30 17:57:23,549 DEBUG [mondrian.sql] 952: , exec+fetch 0 ms, 1 rows 2026-07-30 17:57:23,551 DEBUG [mondrian.sql] 953: SqlStatisticsProvider.getTableCardinality: executing sql [select count(*) from "agg_g_ms_pcat_sales_fact_1997"] 2026-07-30 17:57:23,551 DEBUG [mondrian.sql] 953: , exec 0 ms 2026-07-30 17:57:23,551 DEBUG [mondrian.sql] 953: , exec+fetch 0 ms, 1 rows 2026-07-30 17:57:23,551 DEBUG [mondrian.sql] 954: AggStar.FactTable.makeNumberOfRows: executing sql [ select count(*) as "c0" from "agg_g_ms_pcat_sales_fact_1997" as "agg_g_ms_pcat_sales_fact_1997"] 2026-07-30 17:57:23,551 DEBUG [mondrian.sql] 954: , exec 0 ms 2026-07-30 17:57:23,551 DEBUG [mondrian.sql] 954: , exec+fetch 0 ms, 1 rows 2026-07-30 17:57:23,552 DEBUG [mondrian.sql] 955: SqlStatisticsProvider.getTableCardinality: executing sql [select count(*) from "agg_l_03_sales_fact_1997"] 2026-07-30 17:57:23,553 DEBUG [mondrian.sql] 955: , exec 0 ms 2026-07-30 17:57:23,553 DEBUG [mondrian.sql] 955: , exec+fetch 1 ms, 1 rows 2026-07-30 17:57:23,553 DEBUG [mondrian.sql] 956: AggStar.FactTable.makeNumberOfRows: executing sql [ select count(*) as "c0" from "agg_l_03_sales_fact_1997" as "agg_l_03_sales_fact_1997"] 2026-07-30 17:57:23,553 DEBUG [mondrian.sql] 956: , exec 0 ms 2026-07-30 17:57:23,553 DEBUG [mondrian.sql] 956: , exec+fetch 0 ms, 1 rows 2026-07-30 17:57:23,555 DEBUG [mondrian.sql] 957: SqlStatisticsProvider.getTableCardinality: executing sql [select count(*) from "agg_l_04_sales_fact_1997"] 2026-07-30 17:57:23,556 DEBUG [mondrian.sql] 957: , exec 0 ms 2026-07-30 17:57:23,556 DEBUG [mondrian.sql] 957: , exec+fetch 1 ms, 1 rows 2026-07-30 17:57:23,556 DEBUG [mondrian.sql] 958: AggStar.FactTable.makeNumberOfRows: executing sql [ select count(*) as "c0" from "agg_l_04_sales_fact_1997" as "agg_l_04_sales_fact_1997"] 2026-07-30 17:57:23,556 DEBUG [mondrian.sql] 958: , exec 0 ms 2026-07-30 17:57:23,556 DEBUG [mondrian.sql] 958: , exec+fetch 0 ms, 1 rows 2026-07-30 17:57:23,557 DEBUG [mondrian.sql] 959: SqlStatisticsProvider.getTableCardinality: executing sql [select count(*) from "agg_l_05_sales_fact_1997"] 2026-07-30 17:57:23,557 DEBUG [mondrian.sql] 959: , exec 0 ms 2026-07-30 17:57:23,557 DEBUG [mondrian.sql] 959: , exec+fetch 0 ms, 1 rows 2026-07-30 17:57:23,557 DEBUG [mondrian.sql] 960: AggStar.FactTable.makeNumberOfRows: executing sql [ select count(*) as "c0" from "agg_l_05_sales_fact_1997" as "agg_l_05_sales_fact_1997"] 2026-07-30 17:57:23,557 DEBUG [mondrian.sql] 960: , exec 0 ms 2026-07-30 17:57:23,557 DEBUG [mondrian.sql] 960: , exec+fetch 0 ms, 1 rows 2026-07-30 17:57:23,559 DEBUG [mondrian.sql] 961: SqlStatisticsProvider.getTableCardinality: executing sql [select count(*) from "agg_lc_06_sales_fact_1997"] 2026-07-30 17:57:23,559 DEBUG [mondrian.sql] 961: , exec 0 ms 2026-07-30 17:57:23,559 DEBUG [mondrian.sql] 961: , exec+fetch 0 ms, 1 rows 2026-07-30 17:57:23,559 DEBUG [mondrian.sql] 962: AggStar.FactTable.makeNumberOfRows: executing sql [ select count(*) as "c0" from "agg_lc_06_sales_fact_1997" as "agg_lc_06_sales_fact_1997"] 2026-07-30 17:57:23,559 DEBUG [mondrian.sql] 962: , exec 0 ms 2026-07-30 17:57:23,559 DEBUG [mondrian.sql] 962: , exec+fetch 0 ms, 1 rows 2026-07-30 17:57:23,560 DEBUG [mondrian.sql] 963: SqlStatisticsProvider.getTableCardinality: executing sql [select count(*) from "agg_ll_01_sales_fact_1997"] 2026-07-30 17:57:23,560 DEBUG [mondrian.sql] 963: , exec 0 ms 2026-07-30 17:57:23,560 DEBUG [mondrian.sql] 963: , exec+fetch 0 ms, 1 rows 2026-07-30 17:57:23,560 DEBUG [mondrian.sql] 964: AggStar.FactTable.makeNumberOfRows: executing sql [ select count(*) as "c0" from "agg_ll_01_sales_fact_1997" as "agg_ll_01_sales_fact_1997"] 2026-07-30 17:57:23,561 DEBUG [mondrian.sql] 964: , exec 0 ms 2026-07-30 17:57:23,561 DEBUG [mondrian.sql] 964: , exec+fetch 1 ms, 1 rows 2026-07-30 17:57:23,562 DEBUG [mondrian.sql] 965: SqlStatisticsProvider.getTableCardinality: executing sql [select count(*) from "agg_pl_01_sales_fact_1997"] 2026-07-30 17:57:23,562 DEBUG [mondrian.sql] 965: , exec 0 ms 2026-07-30 17:57:23,562 DEBUG [mondrian.sql] 965: , exec+fetch 0 ms, 1 rows 2026-07-30 17:57:23,562 DEBUG [mondrian.sql] 966: AggStar.FactTable.makeNumberOfRows: executing sql [ select count(*) as "c0" from "agg_pl_01_sales_fact_1997" as "agg_pl_01_sales_fact_1997"] 2026-07-30 17:57:23,562 DEBUG [mondrian.sql] 966: , exec 0 ms 2026-07-30 17:57:23,562 DEBUG [mondrian.sql] 966: , exec+fetch 0 ms, 1 rows 2026-07-30 17:57:24,914 DEBUG [mondrian.sql] 967: SqlMemberSource.getLevelMemberCount: executing sql [ select count(*) as "c0" from (select distinct "store"."store_name" as "c0" from "store" as "store") as "init"] 2026-07-30 17:57:24,915 DEBUG [mondrian.sql] 967: , exec 0 ms 2026-07-30 17:57:24,915 DEBUG [mondrian.sql] 967: , exec+fetch 1 ms, 1 rows 2026-07-30 17:57:24,915 DEBUG [mondrian.sql] 968: SqlMemberSource.getLevelMemberCount: executing sql [ select count(*) as "c0" from (select distinct "store"."store_sqft" as "c0" from "store" as "store") as "init"] 2026-07-30 17:57:24,915 DEBUG [mondrian.sql] 968: , exec 0 ms 2026-07-30 17:57:24,916 DEBUG [mondrian.sql] 968: , exec+fetch 1 ms, 1 rows 2026-07-30 17:57:24,916 DEBUG [mondrian.sql] 969: SqlMemberSource.getLevelMemberCount: executing sql [ select count(*) as "c0" from (select distinct "store"."store_type" as "c0" from "store" as "store") as "init"] 2026-07-30 17:57:24,916 DEBUG [mondrian.sql] 969: , exec 0 ms 2026-07-30 17:57:24,916 DEBUG [mondrian.sql] 969: , exec+fetch 0 ms, 1 rows 2026-07-30 17:57:24,916 DEBUG [mondrian.sql] 970: SqlMemberSource.getLevelMemberCount: executing sql [ select count(*) as "c0" from (select distinct "time_by_day"."month_of_year" as "c0", "time_by_day"."quarter" as "c1", "time_by_day"."the_year" as "c2" from "time_by_day" as "time_by_day") as "init"] 2026-07-30 17:57:24,917 DEBUG [mondrian.sql] 970: , exec 1 ms 2026-07-30 17:57:24,918 DEBUG [mondrian.sql] 970: , exec+fetch 2 ms, 1 rows 2026-07-30 17:57:24,918 DEBUG [mondrian.sql] 971: SqlMemberSource.getLevelMemberCount: executing sql [ select count(*) as "c0" from (select distinct "product"."product_name" as "c0" from "product" as "product") as "init"] 2026-07-30 17:57:24,932 DEBUG [mondrian.sql] 971: , exec 14 ms 2026-07-30 17:57:24,932 DEBUG [mondrian.sql] 971: , exec+fetch 14 ms, 1 rows 2026-07-30 17:57:24,933 DEBUG [mondrian.sql] 972: SqlMemberSource.getLevelMemberCount: executing sql [ select count(*) as "c0" from (select distinct "promotion"."media_type" as "c0" from "promotion" as "promotion") as "init"] 2026-07-30 17:57:24,940 DEBUG [mondrian.sql] 972: , exec 7 ms 2026-07-30 17:57:24,940 DEBUG [mondrian.sql] 972: , exec+fetch 7 ms, 1 rows 2026-07-30 17:57:24,940 DEBUG [mondrian.sql] 973: SqlMemberSource.getLevelMemberCount: executing sql [ select count(*) as "c0" from (select distinct "promotion"."promotion_name" as "c0" from "promotion" as "promotion") as "init"] 2026-07-30 17:57:24,946 DEBUG [mondrian.sql] 973: , exec 5 ms 2026-07-30 17:57:24,946 DEBUG [mondrian.sql] 973: , exec+fetch 6 ms, 1 rows 2026-07-30 17:57:24,946 DEBUG [mondrian.sql] 974: SqlMemberSource.getLevelMemberCount: executing sql [ select count(*) as "c0" from (select distinct "customer"."customer_id" as "c0" from "customer" as "customer") as "init"] 2026-07-30 17:57:24,969 DEBUG [mondrian.sql] 974: , exec 22 ms 2026-07-30 17:57:24,969 DEBUG [mondrian.sql] 974: , exec+fetch 23 ms, 1 rows 2026-07-30 17:57:24,969 DEBUG [mondrian.sql] 975: SqlMemberSource.getLevelMemberCount: executing sql [ select count(*) as "c0" from (select distinct "customer"."education" as "c0" from "customer" as "customer") as "init"] 2026-07-30 17:57:24,995 DEBUG [mondrian.sql] 975: , exec 25 ms 2026-07-30 17:57:24,995 DEBUG [mondrian.sql] 975: , exec+fetch 26 ms, 1 rows 2026-07-30 17:57:24,995 DEBUG [mondrian.sql] 976: SqlMemberSource.getLevelMemberCount: executing sql [ select count(*) as "c0" from (select distinct "customer"."gender" as "c0" from "customer" as "customer") as "init"] 2026-07-30 17:57:25,013 DEBUG [mondrian.sql] 976: , exec 18 ms 2026-07-30 17:57:25,014 DEBUG [mondrian.sql] 976: , exec+fetch 19 ms, 1 rows 2026-07-30 17:57:25,014 DEBUG [mondrian.sql] 977: SqlMemberSource.getLevelMemberCount: executing sql [ select count(*) as "c0" from (select distinct "customer"."yearly_income" as "c0" from "customer" as "customer") as "init"] 2026-07-30 17:57:25,040 DEBUG [mondrian.sql] 977: , exec 25 ms 2026-07-30 17:57:25,040 DEBUG [mondrian.sql] 977: , exec+fetch 26 ms, 1 rows 2026-07-30 17:57:25,068 DEBUG [mondrian.sql] 978: SqlMemberSource.getLevelMemberCount: executing sql [ select count(*) as "c0" from (select distinct "store"."store_country" as "c0" from "store" as "store") as "init"] 2026-07-30 17:57:25,069 DEBUG [mondrian.sql] 978: , exec 0 ms 2026-07-30 17:57:25,069 DEBUG [mondrian.sql] 978: , exec+fetch 0 ms, 1 rows 2026-07-30 17:57:25,069 DEBUG [mondrian.sql] 979: SqlMemberSource.getLevelMemberCount: executing sql [ select count(*) as "c0" from (select distinct "store"."store_state" as "c0" from "store" as "store") as "init"] 2026-07-30 17:57:25,070 DEBUG [mondrian.sql] 979: , exec 0 ms 2026-07-30 17:57:25,070 DEBUG [mondrian.sql] 979: , exec+fetch 1 ms, 1 rows 2026-07-30 17:57:25,070 DEBUG [mondrian.sql] 980: SqlMemberSource.getLevelMemberCount: executing sql [ select count(*) as "c0" from (select distinct "store"."store_city" as "c0", "store"."store_state" as "c1" from "store" as "store") as "init"] 2026-07-30 17:57:25,070 DEBUG [mondrian.sql] 980: , exec 0 ms 2026-07-30 17:57:25,070 DEBUG [mondrian.sql] 980: , exec+fetch 0 ms, 1 rows 2026-07-30 17:57:25,072 DEBUG [mondrian.sql] 981: SqlMemberSource.getLevelMemberCount: executing sql [ select count(*) as "c0" from (select distinct "time_by_day"."the_year" as "c0" from "time_by_day" as "time_by_day") as "init"] 2026-07-30 17:57:25,073 DEBUG [mondrian.sql] 981: , exec 0 ms 2026-07-30 17:57:25,073 DEBUG [mondrian.sql] 981: , exec+fetch 1 ms, 1 rows 2026-07-30 17:57:25,073 DEBUG [mondrian.sql] 982: SqlMemberSource.getLevelMemberCount: executing sql [ select count(*) as "c0" from (select distinct "time_by_day"."week_of_year" as "c0", "time_by_day"."the_year" as "c1" from "time_by_day" as "time_by_day") as "init"] 2026-07-30 17:57:25,073 DEBUG [mondrian.sql] 982: , exec 0 ms 2026-07-30 17:57:25,073 DEBUG [mondrian.sql] 982: , exec+fetch 0 ms, 1 rows 2026-07-30 17:57:25,074 DEBUG [mondrian.sql] 983: SqlMemberSource.getLevelMemberCount: executing sql [ select count(*) as "c0" from (select distinct "time_by_day"."day_of_month" as "c0", "time_by_day"."week_of_year" as "c1", "time_by_day"."the_year" as "c2" from "time_by_day" as "time_by_day") as "init"] 2026-07-30 17:57:25,075 DEBUG [mondrian.sql] 983: , exec 0 ms 2026-07-30 17:57:25,075 DEBUG [mondrian.sql] 983: , exec+fetch 1 ms, 1 rows 2026-07-30 17:57:25,075 DEBUG [mondrian.sql] 984: SqlMemberSource.getLevelMemberCount: executing sql [ select count(*) as "c0" from (select distinct "product_class"."product_family" as "c0" from "product" as "product", "product_class" as "product_class" where "product"."product_class_id" = "product_class"."product_class_id") as "init"] 2026-07-30 17:57:25,079 DEBUG [mondrian.sql] 984: , exec 3 ms 2026-07-30 17:57:25,079 DEBUG [mondrian.sql] 984: , exec+fetch 4 ms, 1 rows 2026-07-30 17:57:25,079 DEBUG [mondrian.sql] 985: SqlMemberSource.getLevelMemberCount: executing sql [ select count(*) as "c0" from (select distinct "product_class"."product_department" as "c0", "product_class"."product_family" as "c1" from "product" as "product", "product_class" as "product_class" where "product"."product_class_id" = "product_class"."product_class_id") as "init"] 2026-07-30 17:57:25,084 DEBUG [mondrian.sql] 985: , exec 4 ms 2026-07-30 17:57:25,084 DEBUG [mondrian.sql] 985: , exec+fetch 5 ms, 1 rows 2026-07-30 17:57:25,084 DEBUG [mondrian.sql] 986: SqlMemberSource.getLevelMemberCount: executing sql [ select count(*) as "c0" from (select distinct "product_class"."product_category" as "c0", "product_class"."product_department" as "c1", "product_class"."product_family" as "c2" from "product" as "product", "product_class" as "product_class" where "product"."product_class_id" = "product_class"."product_class_id") as "init"] 2026-07-30 17:57:25,089 DEBUG [mondrian.sql] 986: , exec 5 ms 2026-07-30 17:57:25,089 DEBUG [mondrian.sql] 986: , exec+fetch 5 ms, 1 rows 2026-07-30 17:57:25,089 DEBUG [mondrian.sql] 987: SqlMemberSource.getLevelMemberCount: executing sql [ select count(*) as "c0" from (select distinct "product_class"."product_subcategory" as "c0", "product_class"."product_category" as "c1", "product_class"."product_department" as "c2", "product_class"."product_family" as "c3" from "product" as "product", "product_class" as "product_class" where "product"."product_class_id" = "product_class"."product_class_id") as "init"] 2026-07-30 17:57:25,094 DEBUG [mondrian.sql] 987: , exec 5 ms 2026-07-30 17:57:25,094 DEBUG [mondrian.sql] 987: , exec+fetch 5 ms, 1 rows 2026-07-30 17:57:25,094 DEBUG [mondrian.sql] 988: SqlMemberSource.getLevelMemberCount: executing sql [ select count(*) as "c0" from (select distinct "product"."brand_name" as "c0", "product_class"."product_subcategory" as "c1", "product_class"."product_category" as "c2", "product_class"."product_department" as "c3", "product_class"."product_family" as "c4" from "product" as "product", "product_class" as "product_class" where "product"."product_class_id" = "product_class"."product_class_id") as "init"] 2026-07-30 17:57:25,101 DEBUG [mondrian.sql] 988: , exec 6 ms 2026-07-30 17:57:25,101 DEBUG [mondrian.sql] 988: , exec+fetch 7 ms, 1 rows 2026-07-30 17:57:25,102 DEBUG [mondrian.sql] 989: SqlMemberSource.getLevelMemberCount: executing sql [ select count(*) as "c0" from (select distinct "product_class"."product_family" as "c0" from "product" as "product", "product_class" as "product_class" where "product"."product_class_id" = "product_class"."product_class_id") as "init"] 2026-07-30 17:57:25,105 DEBUG [mondrian.sql] 989: , exec 3 ms 2026-07-30 17:57:25,105 DEBUG [mondrian.sql] 989: , exec+fetch 3 ms, 1 rows 2026-07-30 17:57:25,105 DEBUG [mondrian.sql] 990: SqlMemberSource.getLevelMemberCount: executing sql [ select count(*) as "c0" from (select distinct "product_class"."product_department" as "c0" from "product" as "product", "product_class" as "product_class" where "product"."product_class_id" = "product_class"."product_class_id") as "init"] 2026-07-30 17:57:25,109 DEBUG [mondrian.sql] 990: , exec 3 ms 2026-07-30 17:57:25,109 DEBUG [mondrian.sql] 990: , exec+fetch 4 ms, 1 rows 2026-07-30 17:57:25,110 DEBUG [mondrian.sql] 991: SqlMemberSource.getLevelMemberCount: executing sql [ select count(*) as "c0" from (select distinct "product_class"."product_category" as "c0" from "product" as "product", "product_class" as "product_class" where "product"."product_class_id" = "product_class"."product_class_id") as "init"] 2026-07-30 17:57:25,117 DEBUG [mondrian.sql] 991: , exec 7 ms 2026-07-30 17:57:25,117 DEBUG [mondrian.sql] 991: , exec+fetch 7 ms, 1 rows 2026-07-30 17:57:25,118 DEBUG [mondrian.sql] 992: SqlMemberSource.getLevelMemberCount: executing sql [ select count(*) as "c0" from (select distinct "product_class"."product_subcategory" as "c0" from "product" as "product", "product_class" as "product_class" where "product"."product_class_id" = "product_class"."product_class_id") as "init"] 2026-07-30 17:57:25,126 DEBUG [mondrian.sql] 992: , exec 7 ms 2026-07-30 17:57:25,126 DEBUG [mondrian.sql] 992: , exec+fetch 8 ms, 1 rows 2026-07-30 17:57:25,127 DEBUG [mondrian.sql] 993: SqlMemberSource.getLevelMemberCount: executing sql [ select count(*) as "c0" from (select distinct "product"."brand_name" as "c0" from "product" as "product") as "init"] 2026-07-30 17:57:25,128 DEBUG [mondrian.sql] 993: , exec 1 ms 2026-07-30 17:57:25,128 DEBUG [mondrian.sql] 993: , exec+fetch 1 ms, 1 rows 2026-07-30 17:57:25,128 DEBUG [mondrian.sql] 994: SqlMemberSource.getLevelMemberCount: executing sql [ select count(*) as "c0" from (select distinct "product"."product_name" as "c0" from "product" as "product") as "init"] 2026-07-30 17:57:25,142 DEBUG [mondrian.sql] 994: , exec 13 ms 2026-07-30 17:57:25,142 DEBUG [mondrian.sql] 994: , exec+fetch 14 ms, 1 rows 2026-07-30 17:57:25,144 DEBUG [mondrian.sql] 995: SqlMemberSource.getLevelMemberCount: executing sql [ select count(*) as "c0" from (select distinct "customer"."state_province" as "c0" from "customer" as "customer") as "init"] 2026-07-30 17:57:25,164 DEBUG [mondrian.sql] 995: , exec 20 ms 2026-07-30 17:57:25,165 DEBUG [mondrian.sql] 995: , exec+fetch 21 ms, 1 rows 2026-07-30 17:57:25,165 DEBUG [mondrian.sql] 996: SqlMemberSource.getLevelMemberCount: executing sql [ select count(*) as "c0" from (select distinct "customer"."city" as "c0", "customer"."state_province" as "c1" from "customer" as "customer") as "init"] 2026-07-30 17:57:25,202 DEBUG [mondrian.sql] 996: , exec 37 ms 2026-07-30 17:57:25,202 DEBUG [mondrian.sql] 996: , exec+fetch 37 ms, 1 rows 2026-07-30 17:57:28,536 DEBUG [mondrian.sql] 997: SqlStatisticsProvider.getColumnCardinality: executing sql [select count(distinct "the_year") from "time_by_day"] 2026-07-30 17:57:28,537 DEBUG [mondrian.sql] 997: , exec 0 ms 2026-07-30 17:57:28,537 DEBUG [mondrian.sql] 997: , exec+fetch 1 ms, 1 rows 2026-07-30 17:57:28,537 DEBUG [mondrian.sql] 998: SqlStatisticsProvider.getColumnCardinality: executing sql [select count(distinct "the_year") from "time_by_day"] 2026-07-30 17:57:28,539 DEBUG [mondrian.sql] 998: , exec 0 ms 2026-07-30 17:57:28,539 DEBUG [mondrian.sql] 998: , exec+fetch 1 ms, 1 rows 2026-07-30 17:57:28,542 DEBUG [mondrian.sql] 999: Segment.load: executing sql [ select "agg_c_10_sales_fact_1997"."the_year" as "c0", sum("agg_c_10_sales_fact_1997"."unit_sales") as "m0" from "agg_c_10_sales_fact_1997" as "agg_c_10_sales_fact_1997" group by "agg_c_10_sales_fact_1997"."the_year"] 2026-07-30 17:57:28,543 DEBUG [mondrian.sql] 999: , exec 0 ms 2026-07-30 17:57:28,544 DEBUG [mondrian.sql] 999: , exec+fetch 2 ms, 1 rows 2026-07-30 17:57:30,337 DEBUG [mondrian.sql] 1000: SqlTupleReader.readTuples [[Time.Weekly].[Year]]: executing sql [ select "time_by_day"."the_year" as "c0" from "time_by_day" as "time_by_day" group by "time_by_day"."the_year" order by CASE WHEN "time_by_day"."the_year" IS NULL THEN 1 ELSE 0 END, "time_by_day"."the_year" ASC] 2026-07-30 17:57:30,337 DEBUG [mondrian.sql] 1000: , exec 0 ms 2026-07-30 17:57:30,337 DEBUG [mondrian.sql] 1000: , exec+fetch 0 ms, 2 rows 2026-07-30 17:57:30,338 DEBUG [mondrian.sql] 1001: SqlMemberSource.getMemberChildren: executing sql [ select "time_by_day"."the_year" as "c0" from "time_by_day" as "time_by_day" group by "time_by_day"."the_year" order by CASE WHEN "time_by_day"."the_year" IS NULL THEN 1 ELSE 0 END, "time_by_day"."the_year" ASC] 2026-07-30 17:57:30,338 DEBUG [mondrian.sql] 1001: , exec 0 ms 2026-07-30 17:57:30,338 DEBUG [mondrian.sql] 1001: , exec+fetch 0 ms, 2 rows 2026-07-30 17:57:36,983 DEBUG [mondrian.sql] 1002: SqlTupleReader.readTuples [[Time.Weekly].[Week]]: executing sql [ select "time_by_day"."the_year" as "c0", "time_by_day"."week_of_year" as "c1" from "time_by_day" as "time_by_day" group by "time_by_day"."the_year", "time_by_day"."week_of_year" order by CASE WHEN "time_by_day"."the_year" IS NULL THEN 1 ELSE 0 END, "time_by_day"."the_year" ASC, CASE WHEN "time_by_day"."week_of_year" IS NULL THEN 1 ELSE 0 END, "time_by_day"."week_of_year" ASC] 2026-07-30 17:57:36,984 DEBUG [mondrian.sql] 1002: , exec 0 ms 2026-07-30 17:57:36,984 DEBUG [mondrian.sql] 1002: , exec+fetch 1 ms, 104 rows 2026-07-30 17:57:44,252 DEBUG [mondrian.sql] 1003: SqlMemberSource.getLevelMemberCount: executing sql [ select count(*) as "c0" from (select distinct "customer"."country" as "c0" from "customer" as "customer") as "init"] 2026-07-30 17:57:44,273 DEBUG [mondrian.sql] 1003: , exec 20 ms 2026-07-30 17:57:44,273 DEBUG [mondrian.sql] 1003: , exec+fetch 21 ms, 1 rows 2026-07-30 17:57:44,273 DEBUG [mondrian.sql] 1004: SqlTupleReader.readTuples [[Customers].[Country]]: executing sql [ select "customer"."country" as "c0" from "customer" as "customer" group by "customer"."country" order by CASE WHEN "customer"."country" IS NULL THEN 1 ELSE 0 END, "customer"."country" ASC] 2026-07-30 17:57:44,277 DEBUG [mondrian.sql] 1004: , exec 4 ms 2026-07-30 17:57:44,278 DEBUG [mondrian.sql] 1004: , exec+fetch 5 ms, 3 rows 2026-07-30 17:57:44,278 DEBUG [mondrian.sql] 1005: SqlMemberSource.getMemberChildren: executing sql [ select "customer"."country" as "c0" from "customer" as "customer" group by "customer"."country" order by CASE WHEN "customer"."country" IS NULL THEN 1 ELSE 0 END, "customer"."country" ASC] 2026-07-30 17:57:44,282 DEBUG [mondrian.sql] 1005: , exec 4 ms 2026-07-30 17:57:44,282 DEBUG [mondrian.sql] 1005: , exec+fetch 4 ms, 3 rows 2026-07-30 17:57:44,283 DEBUG [mondrian.sql] 1006: SqlTupleReader.readTuples [[Time].[Year]]: executing sql [ select "time_by_day"."the_year" as "c0" from "time_by_day" as "time_by_day" group by "time_by_day"."the_year" order by CASE WHEN "time_by_day"."the_year" IS NULL THEN 1 ELSE 0 END, "time_by_day"."the_year" ASC] 2026-07-30 17:57:44,283 DEBUG [mondrian.sql] 1006: , exec 0 ms 2026-07-30 17:57:44,284 DEBUG [mondrian.sql] 1006: , exec+fetch 1 ms, 2 rows 2026-07-30 17:57:44,285 DEBUG [mondrian.sql] 1007: SqlTupleReader.readTuples [[Time].[Year]]: executing sql [ select "time_by_day"."the_year" as "c0" from "time_by_day" as "time_by_day" group by "time_by_day"."the_year" order by CASE WHEN "time_by_day"."the_year" IS NULL THEN 1 ELSE 0 END, "time_by_day"."the_year" ASC] 2026-07-30 17:57:44,285 DEBUG [mondrian.sql] 1007: , exec 0 ms 2026-07-30 17:57:44,285 DEBUG [mondrian.sql] 1007: , exec+fetch 0 ms, 2 rows 2026-07-30 17:57:44,288 DEBUG [mondrian.sql] 1008: SqlTupleReader.readTuples [[Time].[Year]]: executing sql [ select "time_by_day"."the_year" as "c0" from "time_by_day" as "time_by_day" group by "time_by_day"."the_year" order by CASE WHEN "time_by_day"."the_year" IS NULL THEN 1 ELSE 0 END, "time_by_day"."the_year" ASC] 2026-07-30 17:57:44,289 DEBUG [mondrian.sql] 1008: , exec 0 ms 2026-07-30 17:57:44,289 DEBUG [mondrian.sql] 1008: , exec+fetch 0 ms, 2 rows 2026-07-30 17:57:44,289 DEBUG [mondrian.sql] 1009: SqlTupleReader.readTuples [[Time].[Year]]: executing sql [ select "time_by_day"."the_year" as "c0" from "time_by_day" as "time_by_day" group by "time_by_day"."the_year" order by CASE WHEN "time_by_day"."the_year" IS NULL THEN 1 ELSE 0 END, "time_by_day"."the_year" ASC] 2026-07-30 17:57:44,289 DEBUG [mondrian.sql] 1009: , exec 0 ms 2026-07-30 17:57:44,289 DEBUG [mondrian.sql] 1009: , exec+fetch 0 ms, 2 rows 2026-07-30 17:57:44,295 DEBUG [mondrian.sql] 1010: SqlTupleReader.readTuples [[Time].[Year]]: executing sql [ select "time_by_day"."the_year" as "c0" from "time_by_day" as "time_by_day" group by "time_by_day"."the_year" order by CASE WHEN "time_by_day"."the_year" IS NULL THEN 1 ELSE 0 END, "time_by_day"."the_year" ASC] 2026-07-30 17:57:44,295 DEBUG [mondrian.sql] 1010: , exec 0 ms 2026-07-30 17:57:44,295 DEBUG [mondrian.sql] 1010: , exec+fetch 0 ms, 2 rows 2026-07-30 17:57:44,295 DEBUG [mondrian.sql] 1011: SqlTupleReader.readTuples [[Time].[Year]]: executing sql [ select "time_by_day"."the_year" as "c0" from "time_by_day" as "time_by_day" group by "time_by_day"."the_year" order by CASE WHEN "time_by_day"."the_year" IS NULL THEN 1 ELSE 0 END, "time_by_day"."the_year" ASC] 2026-07-30 17:57:44,296 DEBUG [mondrian.sql] 1011: , exec 0 ms 2026-07-30 17:57:44,296 DEBUG [mondrian.sql] 1011: , exec+fetch 1 ms, 2 rows 2026-07-30 17:57:44,299 DEBUG [mondrian.sql] 1012: SqlMemberSource.getLevelMemberCount: executing sql [ select count(*) as "c0" from (select distinct "time_by_day"."quarter" as "c0", "time_by_day"."the_year" as "c1" from "time_by_day" as "time_by_day") as "init"] 2026-07-30 17:57:44,300 DEBUG [mondrian.sql] 1012: , exec 1 ms 2026-07-30 17:57:44,300 DEBUG [mondrian.sql] 1012: , exec+fetch 1 ms, 1 rows 2026-07-30 17:57:44,300 DEBUG [mondrian.sql] 1013: SqlTupleReader.readTuples [[Time].[Quarter]]: executing sql [ select "time_by_day"."the_year" as "c0", "time_by_day"."quarter" as "c1" from "time_by_day" as "time_by_day" group by "time_by_day"."the_year", "time_by_day"."quarter" order by CASE WHEN "time_by_day"."the_year" IS NULL THEN 1 ELSE 0 END, "time_by_day"."the_year" ASC, CASE WHEN "time_by_day"."quarter" IS NULL THEN 1 ELSE 0 END, "time_by_day"."quarter" ASC] 2026-07-30 17:57:44,301 DEBUG [mondrian.sql] 1013: , exec 0 ms 2026-07-30 17:57:44,301 DEBUG [mondrian.sql] 1013: , exec+fetch 1 ms, 8 rows 2026-07-30 17:57:44,303 DEBUG [mondrian.sql] 1014: SqlStatisticsProvider.getTableCardinality: executing sql [select count(*) from "agg_c_10_sales_fact_1997"] 2026-07-30 17:57:44,303 DEBUG [mondrian.sql] 1014: , exec 0 ms 2026-07-30 17:57:44,303 DEBUG [mondrian.sql] 1014: , exec+fetch 0 ms, 1 rows 2026-07-30 17:57:44,303 DEBUG [mondrian.sql] 1015: AggStar.FactTable.makeNumberOfRows: executing sql [ select count(*) as "c0" from "agg_c_10_sales_fact_1997" as "agg_c_10_sales_fact_1997"] 2026-07-30 17:57:44,304 DEBUG [mondrian.sql] 1015: , exec 0 ms 2026-07-30 17:57:44,304 DEBUG [mondrian.sql] 1015: , exec+fetch 1 ms, 1 rows 2026-07-30 17:57:44,304 DEBUG [mondrian.sql] 1016: SqlStatisticsProvider.getTableCardinality: executing sql [select count(*) from "agg_c_14_sales_fact_1997"] 2026-07-30 17:57:44,304 DEBUG [mondrian.sql] 1016: , exec 0 ms 2026-07-30 17:57:44,304 DEBUG [mondrian.sql] 1016: , exec+fetch 0 ms, 1 rows 2026-07-30 17:57:44,305 DEBUG [mondrian.sql] 1017: AggStar.FactTable.makeNumberOfRows: executing sql [ select count(*) as "c0" from "agg_c_14_sales_fact_1997" as "agg_c_14_sales_fact_1997"] 2026-07-30 17:57:44,305 DEBUG [mondrian.sql] 1017: , exec 0 ms 2026-07-30 17:57:44,305 DEBUG [mondrian.sql] 1017: , exec+fetch 0 ms, 1 rows 2026-07-30 17:57:44,306 DEBUG [mondrian.sql] 1018: SqlStatisticsProvider.getTableCardinality: executing sql [select count(*) from "agg_g_ms_pcat_sales_fact_1997"] 2026-07-30 17:57:44,307 DEBUG [mondrian.sql] 1018: , exec 0 ms 2026-07-30 17:57:44,307 DEBUG [mondrian.sql] 1018: , exec+fetch 0 ms, 1 rows 2026-07-30 17:57:44,307 DEBUG [mondrian.sql] 1019: AggStar.FactTable.makeNumberOfRows: executing sql [ select count(*) as "c0" from "agg_g_ms_pcat_sales_fact_1997" as "agg_g_ms_pcat_sales_fact_1997"] 2026-07-30 17:57:44,307 DEBUG [mondrian.sql] 1019: , exec 0 ms 2026-07-30 17:57:44,307 DEBUG [mondrian.sql] 1019: , exec+fetch 0 ms, 1 rows 2026-07-30 17:57:44,308 DEBUG [mondrian.sql] 1020: SqlStatisticsProvider.getTableCardinality: executing sql [select count(*) from "agg_l_03_sales_fact_1997"] 2026-07-30 17:57:44,308 DEBUG [mondrian.sql] 1020: , exec 0 ms 2026-07-30 17:57:44,308 DEBUG [mondrian.sql] 1020: , exec+fetch 0 ms, 1 rows 2026-07-30 17:57:44,308 DEBUG [mondrian.sql] 1021: AggStar.FactTable.makeNumberOfRows: executing sql [ select count(*) as "c0" from "agg_l_03_sales_fact_1997" as "agg_l_03_sales_fact_1997"] 2026-07-30 17:57:44,308 DEBUG [mondrian.sql] 1021: , exec 0 ms 2026-07-30 17:57:44,308 DEBUG [mondrian.sql] 1021: , exec+fetch 0 ms, 1 rows 2026-07-30 17:57:44,310 DEBUG [mondrian.sql] 1022: SqlStatisticsProvider.getTableCardinality: executing sql [select count(*) from "agg_l_04_sales_fact_1997"] 2026-07-30 17:57:44,310 DEBUG [mondrian.sql] 1022: , exec 0 ms 2026-07-30 17:57:44,310 DEBUG [mondrian.sql] 1022: , exec+fetch 0 ms, 1 rows 2026-07-30 17:57:44,310 DEBUG [mondrian.sql] 1023: AggStar.FactTable.makeNumberOfRows: executing sql [ select count(*) as "c0" from "agg_l_04_sales_fact_1997" as "agg_l_04_sales_fact_1997"] 2026-07-30 17:57:44,310 DEBUG [mondrian.sql] 1023: , exec 0 ms 2026-07-30 17:57:44,310 DEBUG [mondrian.sql] 1023: , exec+fetch 0 ms, 1 rows 2026-07-30 17:57:44,311 DEBUG [mondrian.sql] 1024: SqlStatisticsProvider.getTableCardinality: executing sql [select count(*) from "agg_l_05_sales_fact_1997"] 2026-07-30 17:57:44,311 DEBUG [mondrian.sql] 1024: , exec 0 ms 2026-07-30 17:57:44,311 DEBUG [mondrian.sql] 1024: , exec+fetch 0 ms, 1 rows 2026-07-30 17:57:44,311 DEBUG [mondrian.sql] 1025: AggStar.FactTable.makeNumberOfRows: executing sql [ select count(*) as "c0" from "agg_l_05_sales_fact_1997" as "agg_l_05_sales_fact_1997"] 2026-07-30 17:57:44,311 DEBUG [mondrian.sql] 1025: , exec 0 ms 2026-07-30 17:57:44,311 DEBUG [mondrian.sql] 1025: , exec+fetch 0 ms, 1 rows 2026-07-30 17:57:44,313 DEBUG [mondrian.sql] 1026: SqlStatisticsProvider.getTableCardinality: executing sql [select count(*) from "agg_lc_06_sales_fact_1997"] 2026-07-30 17:57:44,313 DEBUG [mondrian.sql] 1026: , exec 0 ms 2026-07-30 17:57:44,313 DEBUG [mondrian.sql] 1026: , exec+fetch 0 ms, 1 rows 2026-07-30 17:57:44,313 DEBUG [mondrian.sql] 1027: AggStar.FactTable.makeNumberOfRows: executing sql [ select count(*) as "c0" from "agg_lc_06_sales_fact_1997" as "agg_lc_06_sales_fact_1997"] 2026-07-30 17:57:44,313 DEBUG [mondrian.sql] 1027: , exec 0 ms 2026-07-30 17:57:44,313 DEBUG [mondrian.sql] 1027: , exec+fetch 0 ms, 1 rows 2026-07-30 17:57:44,314 DEBUG [mondrian.sql] 1028: SqlStatisticsProvider.getTableCardinality: executing sql [select count(*) from "agg_ll_01_sales_fact_1997"] 2026-07-30 17:57:44,314 DEBUG [mondrian.sql] 1028: , exec 0 ms 2026-07-30 17:57:44,314 DEBUG [mondrian.sql] 1028: , exec+fetch 0 ms, 1 rows 2026-07-30 17:57:44,314 DEBUG [mondrian.sql] 1029: AggStar.FactTable.makeNumberOfRows: executing sql [ select count(*) as "c0" from "agg_ll_01_sales_fact_1997" as "agg_ll_01_sales_fact_1997"] 2026-07-30 17:57:44,314 DEBUG [mondrian.sql] 1029: , exec 0 ms 2026-07-30 17:57:44,314 DEBUG [mondrian.sql] 1029: , exec+fetch 0 ms, 1 rows 2026-07-30 17:57:44,315 DEBUG [mondrian.sql] 1030: SqlStatisticsProvider.getTableCardinality: executing sql [select count(*) from "agg_pl_01_sales_fact_1997"] 2026-07-30 17:57:44,315 DEBUG [mondrian.sql] 1030: , exec 0 ms 2026-07-30 17:57:44,315 DEBUG [mondrian.sql] 1030: , exec+fetch 0 ms, 1 rows 2026-07-30 17:57:44,315 DEBUG [mondrian.sql] 1031: AggStar.FactTable.makeNumberOfRows: executing sql [ select count(*) as "c0" from "agg_pl_01_sales_fact_1997" as "agg_pl_01_sales_fact_1997"] 2026-07-30 17:57:44,315 DEBUG [mondrian.sql] 1031: , exec 0 ms 2026-07-30 17:57:44,315 DEBUG [mondrian.sql] 1031: , exec+fetch 0 ms, 1 rows 2026-07-30 17:57:47,346 DEBUG [mondrian.sql] 1032: SqlTupleReader.readTuples [[Product].[Product Family]]: executing sql [ select "product_class"."product_family" as "c0" from "product" as "product", "product_class" as "product_class" where "product"."product_class_id" = "product_class"."product_class_id" group by "product_class"."product_family" order by CASE WHEN "product_class"."product_family" IS NULL THEN 1 ELSE 0 END, "product_class"."product_family" ASC] 2026-07-30 17:57:47,348 DEBUG [mondrian.sql] 1032: , exec 1 ms 2026-07-30 17:57:47,348 DEBUG [mondrian.sql] 1032: , exec+fetch 2 ms, 3 rows 2026-07-30 17:57:47,348 DEBUG [mondrian.sql] 1033: SqlMemberSource.getMemberChildren: executing sql [ select "product_class"."product_family" as "c0" from "product" as "product", "product_class" as "product_class" where "product"."product_class_id" = "product_class"."product_class_id" group by "product_class"."product_family" order by CASE WHEN "product_class"."product_family" IS NULL THEN 1 ELSE 0 END, "product_class"."product_family" ASC] 2026-07-30 17:57:47,350 DEBUG [mondrian.sql] 1033: , exec 1 ms 2026-07-30 17:57:47,350 DEBUG [mondrian.sql] 1033: , exec+fetch 1 ms, 3 rows 2026-07-30 17:57:47,350 DEBUG [mondrian.sql] 1034: SqlStatisticsProvider.getColumnCardinality: executing sql [select count(distinct "the_year") from "time_by_day"] 2026-07-30 17:57:47,351 DEBUG [mondrian.sql] 1034: , exec 0 ms 2026-07-30 17:57:47,351 DEBUG [mondrian.sql] 1034: , exec+fetch 1 ms, 1 rows 2026-07-30 17:57:47,351 DEBUG [mondrian.sql] 1035: SqlStatisticsProvider.getColumnCardinality: executing sql [select count(distinct "product_family") from "product_class"] 2026-07-30 17:57:47,351 DEBUG [mondrian.sql] 1035: , exec 0 ms 2026-07-30 17:57:47,351 DEBUG [mondrian.sql] 1035: , exec+fetch 0 ms, 1 rows 2026-07-30 17:57:47,363 DEBUG [mondrian.sql] 1036: Segment.load: executing sql [ select "agg_c_10_sales_fact_1997"."the_year" as "c0", sum("agg_c_10_sales_fact_1997"."unit_sales") as "m0" from "agg_c_10_sales_fact_1997" as "agg_c_10_sales_fact_1997" where "agg_c_10_sales_fact_1997"."the_year" = 1997 group by "agg_c_10_sales_fact_1997"."the_year"] 2026-07-30 17:57:47,363 DEBUG [mondrian.sql] 1037: Segment.load: executing sql [ select "agg_g_ms_pcat_sales_fact_1997"."the_year" as "c0", "agg_g_ms_pcat_sales_fact_1997"."product_family" as "c1", sum("agg_g_ms_pcat_sales_fact_1997"."unit_sales") as "m0" from "agg_g_ms_pcat_sales_fact_1997" as "agg_g_ms_pcat_sales_fact_1997" where "agg_g_ms_pcat_sales_fact_1997"."the_year" = 1997 group by "agg_g_ms_pcat_sales_fact_1997"."the_year", "agg_g_ms_pcat_sales_fact_1997"."product_family"] 2026-07-30 17:57:47,364 DEBUG [mondrian.sql] 1036: , exec 1 ms 2026-07-30 17:57:47,365 DEBUG [mondrian.sql] 1036: , exec+fetch 1 ms, 1 rows 2026-07-30 17:57:47,374 DEBUG [mondrian.sql] 1037: , exec 10 ms 2026-07-30 17:57:47,375 DEBUG [mondrian.sql] 1037: , exec+fetch 11 ms, 3 rows 2026-07-30 17:57:47,376 DEBUG [mondrian.sql] 1038: SqlTupleReader.readTuples [[Store].[Store Country]]: executing sql [ select "store"."store_country" as "c0" from "store" as "store" group by "store"."store_country" order by CASE WHEN "store"."store_country" IS NULL THEN 1 ELSE 0 END, "store"."store_country" ASC] 2026-07-30 17:57:47,376 DEBUG [mondrian.sql] 1038: , exec 0 ms 2026-07-30 17:57:47,376 DEBUG [mondrian.sql] 1038: , exec+fetch 0 ms, 3 rows 2026-07-30 17:57:47,376 DEBUG [mondrian.sql] 1039: SqlMemberSource.getMemberChildren: executing sql [ select "store"."store_country" as "c0" from "store" as "store" group by "store"."store_country" order by CASE WHEN "store"."store_country" IS NULL THEN 1 ELSE 0 END, "store"."store_country" ASC] 2026-07-30 17:57:47,377 DEBUG [mondrian.sql] 1039: , exec 0 ms 2026-07-30 17:57:47,377 DEBUG [mondrian.sql] 1039: , exec+fetch 1 ms, 3 rows 2026-07-30 17:57:47,377 DEBUG [mondrian.sql] 1040: SqlStatisticsProvider.getColumnCardinality: executing sql [select count(distinct "store_country") from "store"] 2026-07-30 17:57:47,377 DEBUG [mondrian.sql] 1040: , exec 0 ms 2026-07-30 17:57:47,377 DEBUG [mondrian.sql] 1040: , exec+fetch 0 ms, 1 rows 2026-07-30 17:57:47,379 DEBUG [mondrian.sql] 1041: Segment.load: executing sql [ select "store"."store_country" as "c0", "agg_c_14_sales_fact_1997"."the_year" as "c1", sum("agg_c_14_sales_fact_1997"."unit_sales") as "m0" from "store" as "store", "agg_c_14_sales_fact_1997" as "agg_c_14_sales_fact_1997" where "agg_c_14_sales_fact_1997"."store_id" = "store"."store_id" and "agg_c_14_sales_fact_1997"."the_year" = 1997 group by "store"."store_country", "agg_c_14_sales_fact_1997"."the_year"] 2026-07-30 17:57:47,436 DEBUG [mondrian.sql] 1041: , exec 57 ms 2026-07-30 17:57:47,437 DEBUG [mondrian.sql] 1041: , exec+fetch 58 ms, 1 rows 2026-07-30 17:57:47,440 DEBUG [mondrian.sql] 1042: Segment.load: executing sql [ select "store"."store_country" as "c0", "agg_c_14_sales_fact_1997"."the_year" as "c1", "product_class"."product_family" as "c2", sum("agg_c_14_sales_fact_1997"."unit_sales") as "m0" from "store" as "store", "agg_c_14_sales_fact_1997" as "agg_c_14_sales_fact_1997", "product_class" as "product_class", "product" as "product" where "agg_c_14_sales_fact_1997"."store_id" = "store"."store_id" and "store"."store_country" = 'USA' and "agg_c_14_sales_fact_1997"."the_year" = 1997 and "agg_c_14_sales_fact_1997"."product_id" = "product"."product_id" and "product"."product_class_id" = "product_class"."product_class_id" group by "store"."store_country", "agg_c_14_sales_fact_1997"."the_year", "product_class"."product_family"] 2026-07-30 17:57:51,439 DEBUG [mondrian.sql] 1042: , exec 3998 ms 2026-07-30 17:57:51,439 DEBUG [mondrian.sql] 1042: , exec+fetch 3999 ms, 3 rows 2026-07-30 17:57:51,443 DEBUG [mondrian.sql] 1043: SqlTupleReader.readTuples [[Product].[Product Department]]: executing sql [ select "product_class"."product_family" as "c0", "product_class"."product_department" as "c1" from "product" as "product", "product_class" as "product_class" where "product"."product_class_id" = "product_class"."product_class_id" group by "product_class"."product_family", "product_class"."product_department" order by CASE WHEN "product_class"."product_family" IS NULL THEN 1 ELSE 0 END, "product_class"."product_family" ASC, CASE WHEN "product_class"."product_department" IS NULL THEN 1 ELSE 0 END, "product_class"."product_department" ASC] 2026-07-30 17:57:51,445 DEBUG [mondrian.sql] 1043: , exec 2 ms 2026-07-30 17:57:51,445 DEBUG [mondrian.sql] 1043: , exec+fetch 2 ms, 23 rows 2026-07-30 17:57:51,446 DEBUG [mondrian.sql] 1044: SqlMemberSource.getMemberChildren: executing sql [ select "product_class"."product_department" as "c0" from "product" as "product", "product_class" as "product_class" where "product"."product_class_id" = "product_class"."product_class_id" and ("product_class"."product_family" = 'Non-Consumable') group by "product_class"."product_department" order by CASE WHEN "product_class"."product_department" IS NULL THEN 1 ELSE 0 END, "product_class"."product_department" ASC] 2026-07-30 17:57:51,447 DEBUG [mondrian.sql] 1044: , exec 1 ms 2026-07-30 17:57:51,447 DEBUG [mondrian.sql] 1044: , exec+fetch 1 ms, 5 rows 2026-07-30 17:57:51,448 DEBUG [mondrian.sql] 1045: SqlTupleReader.readTuples [[Store].[Store State]]: executing sql [ select "store"."store_country" as "c0", "store"."store_state" as "c1" from "store" as "store" group by "store"."store_country", "store"."store_state" order by CASE WHEN "store"."store_country" IS NULL THEN 1 ELSE 0 END, "store"."store_country" ASC, CASE WHEN "store"."store_state" IS NULL THEN 1 ELSE 0 END, "store"."store_state" ASC] 2026-07-30 17:57:51,448 DEBUG [mondrian.sql] 1045: , exec 0 ms 2026-07-30 17:57:51,448 DEBUG [mondrian.sql] 1045: , exec+fetch 0 ms, 10 rows 2026-07-30 17:57:51,448 DEBUG [mondrian.sql] 1046: SqlMemberSource.getMemberChildren: executing sql [ select "store"."store_state" as "c0" from "store" as "store" where ("store"."store_country" = 'USA') group by "store"."store_state" order by CASE WHEN "store"."store_state" IS NULL THEN 1 ELSE 0 END, "store"."store_state" ASC] 2026-07-30 17:57:51,449 DEBUG [mondrian.sql] 1046: , exec 0 ms 2026-07-30 17:57:51,449 DEBUG [mondrian.sql] 1046: , exec+fetch 1 ms, 3 rows 2026-07-30 17:58:17,725 DEBUG [mondrian.sql] 1047: SqlMemberSource.getLevelMemberCount: executing sql [ select count(*) as "c0" from (select distinct "customer"."country" as "c0" from "customer" as "customer") as "init"] 2026-07-30 17:58:17,744 DEBUG [mondrian.sql] 1047: , exec 18 ms 2026-07-30 17:58:17,744 DEBUG [mondrian.sql] 1047: , exec+fetch 18 ms, 1 rows 2026-07-30 17:58:17,744 DEBUG [mondrian.sql] 1048: SqlTupleReader.readTuples [[Customers].[Country]]: executing sql [ select "customer"."country" as "c0" from "customer" as "customer" group by "customer"."country" order by CASE WHEN "customer"."country" IS NULL THEN 1 ELSE 0 END, "customer"."country" ASC] 2026-07-30 17:58:17,747 DEBUG [mondrian.sql] 1048: , exec 2 ms 2026-07-30 17:58:17,747 DEBUG [mondrian.sql] 1048: , exec+fetch 3 ms, 3 rows 2026-07-30 17:58:17,747 DEBUG [mondrian.sql] 1049: SqlMemberSource.getMemberChildren: executing sql [ select "customer"."country" as "c0" from "customer" as "customer" group by "customer"."country" order by CASE WHEN "customer"."country" IS NULL THEN 1 ELSE 0 END, "customer"."country" ASC] 2026-07-30 17:58:17,750 DEBUG [mondrian.sql] 1049: , exec 2 ms 2026-07-30 17:58:17,750 DEBUG [mondrian.sql] 1049: , exec+fetch 2 ms, 3 rows 2026-07-30 17:58:17,751 DEBUG [mondrian.sql] 1050: SqlTupleReader.readTuples [[Time].[Year]]: executing sql [ select "time_by_day"."the_year" as "c0" from "time_by_day" as "time_by_day" group by "time_by_day"."the_year" order by CASE WHEN "time_by_day"."the_year" IS NULL THEN 1 ELSE 0 END, "time_by_day"."the_year" ASC] 2026-07-30 17:58:17,751 DEBUG [mondrian.sql] 1050: , exec 0 ms 2026-07-30 17:58:17,751 DEBUG [mondrian.sql] 1050: , exec+fetch 0 ms, 2 rows 2026-07-30 17:58:17,752 DEBUG [mondrian.sql] 1051: SqlTupleReader.readTuples [[Time].[Year]]: executing sql [ select "time_by_day"."the_year" as "c0" from "time_by_day" as "time_by_day" group by "time_by_day"."the_year" order by CASE WHEN "time_by_day"."the_year" IS NULL THEN 1 ELSE 0 END, "time_by_day"."the_year" ASC] 2026-07-30 17:58:17,752 DEBUG [mondrian.sql] 1051: , exec 0 ms 2026-07-30 17:58:17,752 DEBUG [mondrian.sql] 1051: , exec+fetch 0 ms, 2 rows 2026-07-30 17:58:17,755 DEBUG [mondrian.sql] 1052: SqlTupleReader.readTuples [[Time].[Year]]: executing sql [ select "time_by_day"."the_year" as "c0" from "time_by_day" as "time_by_day" group by "time_by_day"."the_year" order by CASE WHEN "time_by_day"."the_year" IS NULL THEN 1 ELSE 0 END, "time_by_day"."the_year" ASC] 2026-07-30 17:58:17,755 DEBUG [mondrian.sql] 1052: , exec 0 ms 2026-07-30 17:58:17,755 DEBUG [mondrian.sql] 1052: , exec+fetch 0 ms, 2 rows 2026-07-30 17:58:17,755 DEBUG [mondrian.sql] 1053: SqlTupleReader.readTuples [[Time].[Year]]: executing sql [ select "time_by_day"."the_year" as "c0" from "time_by_day" as "time_by_day" group by "time_by_day"."the_year" order by CASE WHEN "time_by_day"."the_year" IS NULL THEN 1 ELSE 0 END, "time_by_day"."the_year" ASC] 2026-07-30 17:58:17,755 DEBUG [mondrian.sql] 1053: , exec 0 ms 2026-07-30 17:58:17,756 DEBUG [mondrian.sql] 1053: , exec+fetch 1 ms, 2 rows 2026-07-30 17:58:17,759 DEBUG [mondrian.sql] 1054: SqlTupleReader.readTuples [[Time].[Year]]: executing sql [ select "time_by_day"."the_year" as "c0" from "time_by_day" as "time_by_day" group by "time_by_day"."the_year" order by CASE WHEN "time_by_day"."the_year" IS NULL THEN 1 ELSE 0 END, "time_by_day"."the_year" ASC] 2026-07-30 17:58:17,759 DEBUG [mondrian.sql] 1054: , exec 0 ms 2026-07-30 17:58:17,759 DEBUG [mondrian.sql] 1054: , exec+fetch 0 ms, 2 rows 2026-07-30 17:58:17,759 DEBUG [mondrian.sql] 1055: SqlTupleReader.readTuples [[Time].[Year]]: executing sql [ select "time_by_day"."the_year" as "c0" from "time_by_day" as "time_by_day" group by "time_by_day"."the_year" order by CASE WHEN "time_by_day"."the_year" IS NULL THEN 1 ELSE 0 END, "time_by_day"."the_year" ASC] 2026-07-30 17:58:17,760 DEBUG [mondrian.sql] 1055: , exec 0 ms 2026-07-30 17:58:17,760 DEBUG [mondrian.sql] 1055: , exec+fetch 1 ms, 2 rows 2026-07-30 17:58:17,762 DEBUG [mondrian.sql] 1056: SqlMemberSource.getLevelMemberCount: executing sql [ select count(*) as "c0" from (select distinct "time_by_day"."quarter" as "c0", "time_by_day"."the_year" as "c1" from "time_by_day" as "time_by_day") as "init"] 2026-07-30 17:58:17,763 DEBUG [mondrian.sql] 1056: , exec 1 ms 2026-07-30 17:58:17,763 DEBUG [mondrian.sql] 1056: , exec+fetch 1 ms, 1 rows 2026-07-30 17:58:17,763 DEBUG [mondrian.sql] 1057: SqlTupleReader.readTuples [[Time].[Quarter]]: executing sql [ select "time_by_day"."the_year" as "c0", "time_by_day"."quarter" as "c1" from "time_by_day" as "time_by_day" group by "time_by_day"."the_year", "time_by_day"."quarter" order by CASE WHEN "time_by_day"."the_year" IS NULL THEN 1 ELSE 0 END, "time_by_day"."the_year" ASC, CASE WHEN "time_by_day"."quarter" IS NULL THEN 1 ELSE 0 END, "time_by_day"."quarter" ASC] 2026-07-30 17:58:17,764 DEBUG [mondrian.sql] 1057: , exec 0 ms 2026-07-30 17:58:17,764 DEBUG [mondrian.sql] 1057: , exec+fetch 1 ms, 8 rows 2026-07-30 17:58:17,774 DEBUG [mondrian.sql] 1058: SqlStatisticsProvider.getTableCardinality: executing sql [select count(*) from "agg_c_10_sales_fact_1997"] 2026-07-30 17:58:17,774 DEBUG [mondrian.sql] 1058: , exec 0 ms 2026-07-30 17:58:17,774 DEBUG [mondrian.sql] 1058: , exec+fetch 0 ms, 1 rows 2026-07-30 17:58:17,774 DEBUG [mondrian.sql] 1059: AggStar.FactTable.makeNumberOfRows: executing sql [ select count(*) as "c0" from "agg_c_10_sales_fact_1997" as "agg_c_10_sales_fact_1997"] 2026-07-30 17:58:17,775 DEBUG [mondrian.sql] 1059: , exec 0 ms 2026-07-30 17:58:17,775 DEBUG [mondrian.sql] 1059: , exec+fetch 0 ms, 1 rows 2026-07-30 17:58:17,784 DEBUG [mondrian.sql] 1060: SqlStatisticsProvider.getTableCardinality: executing sql [select count(*) from "agg_c_14_sales_fact_1997"] 2026-07-30 17:58:17,784 DEBUG [mondrian.sql] 1060: , exec 0 ms 2026-07-30 17:58:17,784 DEBUG [mondrian.sql] 1060: , exec+fetch 0 ms, 1 rows 2026-07-30 17:58:17,784 DEBUG [mondrian.sql] 1061: AggStar.FactTable.makeNumberOfRows: executing sql [ select count(*) as "c0" from "agg_c_14_sales_fact_1997" as "agg_c_14_sales_fact_1997"] 2026-07-30 17:58:17,784 DEBUG [mondrian.sql] 1061: , exec 0 ms 2026-07-30 17:58:17,784 DEBUG [mondrian.sql] 1061: , exec+fetch 0 ms, 1 rows 2026-07-30 17:58:17,794 DEBUG [mondrian.sql] 1062: SqlStatisticsProvider.getTableCardinality: executing sql [select count(*) from "agg_g_ms_pcat_sales_fact_1997"] 2026-07-30 17:58:17,794 DEBUG [mondrian.sql] 1062: , exec 0 ms 2026-07-30 17:58:17,794 DEBUG [mondrian.sql] 1062: , exec+fetch 0 ms, 1 rows 2026-07-30 17:58:17,794 DEBUG [mondrian.sql] 1063: AggStar.FactTable.makeNumberOfRows: executing sql [ select count(*) as "c0" from "agg_g_ms_pcat_sales_fact_1997" as "agg_g_ms_pcat_sales_fact_1997"] 2026-07-30 17:58:17,794 DEBUG [mondrian.sql] 1063: , exec 0 ms 2026-07-30 17:58:17,794 DEBUG [mondrian.sql] 1063: , exec+fetch 0 ms, 1 rows 2026-07-30 17:58:17,804 DEBUG [mondrian.sql] 1064: SqlStatisticsProvider.getTableCardinality: executing sql [select count(*) from "agg_l_03_sales_fact_1997"] 2026-07-30 17:58:17,804 DEBUG [mondrian.sql] 1064: , exec 0 ms 2026-07-30 17:58:17,804 DEBUG [mondrian.sql] 1064: , exec+fetch 0 ms, 1 rows 2026-07-30 17:58:17,804 DEBUG [mondrian.sql] 1065: AggStar.FactTable.makeNumberOfRows: executing sql [ select count(*) as "c0" from "agg_l_03_sales_fact_1997" as "agg_l_03_sales_fact_1997"] 2026-07-30 17:58:17,804 DEBUG [mondrian.sql] 1065: , exec 0 ms 2026-07-30 17:58:17,804 DEBUG [mondrian.sql] 1065: , exec+fetch 0 ms, 1 rows 2026-07-30 17:58:17,813 DEBUG [mondrian.sql] 1066: SqlStatisticsProvider.getTableCardinality: executing sql [select count(*) from "agg_l_04_sales_fact_1997"] 2026-07-30 17:58:17,813 DEBUG [mondrian.sql] 1066: , exec 0 ms 2026-07-30 17:58:17,813 DEBUG [mondrian.sql] 1066: , exec+fetch 0 ms, 1 rows 2026-07-30 17:58:17,813 DEBUG [mondrian.sql] 1067: AggStar.FactTable.makeNumberOfRows: executing sql [ select count(*) as "c0" from "agg_l_04_sales_fact_1997" as "agg_l_04_sales_fact_1997"] 2026-07-30 17:58:17,813 DEBUG [mondrian.sql] 1067: , exec 0 ms 2026-07-30 17:58:17,813 DEBUG [mondrian.sql] 1067: , exec+fetch 0 ms, 1 rows 2026-07-30 17:58:17,822 DEBUG [mondrian.sql] 1068: SqlStatisticsProvider.getTableCardinality: executing sql [select count(*) from "agg_l_05_sales_fact_1997"] 2026-07-30 17:58:17,822 DEBUG [mondrian.sql] 1068: , exec 0 ms 2026-07-30 17:58:17,822 DEBUG [mondrian.sql] 1068: , exec+fetch 0 ms, 1 rows 2026-07-30 17:58:17,822 DEBUG [mondrian.sql] 1069: AggStar.FactTable.makeNumberOfRows: executing sql [ select count(*) as "c0" from "agg_l_05_sales_fact_1997" as "agg_l_05_sales_fact_1997"] 2026-07-30 17:58:17,822 DEBUG [mondrian.sql] 1069: , exec 0 ms 2026-07-30 17:58:17,822 DEBUG [mondrian.sql] 1069: , exec+fetch 0 ms, 1 rows 2026-07-30 17:58:17,832 DEBUG [mondrian.sql] 1070: SqlStatisticsProvider.getTableCardinality: executing sql [select count(*) from "agg_lc_06_sales_fact_1997"] 2026-07-30 17:58:17,833 DEBUG [mondrian.sql] 1070: , exec 0 ms 2026-07-30 17:58:17,833 DEBUG [mondrian.sql] 1070: , exec+fetch 0 ms, 1 rows 2026-07-30 17:58:17,833 DEBUG [mondrian.sql] 1071: AggStar.FactTable.makeNumberOfRows: executing sql [ select count(*) as "c0" from "agg_lc_06_sales_fact_1997" as "agg_lc_06_sales_fact_1997"] 2026-07-30 17:58:17,833 DEBUG [mondrian.sql] 1071: , exec 0 ms 2026-07-30 17:58:17,833 DEBUG [mondrian.sql] 1071: , exec+fetch 0 ms, 1 rows 2026-07-30 17:58:17,842 DEBUG [mondrian.sql] 1072: SqlStatisticsProvider.getTableCardinality: executing sql [select count(*) from "agg_ll_01_sales_fact_1997"] 2026-07-30 17:58:17,843 DEBUG [mondrian.sql] 1072: , exec 0 ms 2026-07-30 17:58:17,843 DEBUG [mondrian.sql] 1072: , exec+fetch 1 ms, 1 rows 2026-07-30 17:58:17,843 DEBUG [mondrian.sql] 1073: AggStar.FactTable.makeNumberOfRows: executing sql [ select count(*) as "c0" from "agg_ll_01_sales_fact_1997" as "agg_ll_01_sales_fact_1997"] 2026-07-30 17:58:17,843 DEBUG [mondrian.sql] 1073: , exec 0 ms 2026-07-30 17:58:17,843 DEBUG [mondrian.sql] 1073: , exec+fetch 0 ms, 1 rows 2026-07-30 17:58:17,852 DEBUG [mondrian.sql] 1074: SqlStatisticsProvider.getTableCardinality: executing sql [select count(*) from "agg_pl_01_sales_fact_1997"] 2026-07-30 17:58:17,852 DEBUG [mondrian.sql] 1074: , exec 0 ms 2026-07-30 17:58:17,852 DEBUG [mondrian.sql] 1074: , exec+fetch 0 ms, 1 rows 2026-07-30 17:58:17,852 DEBUG [mondrian.sql] 1075: AggStar.FactTable.makeNumberOfRows: executing sql [ select count(*) as "c0" from "agg_pl_01_sales_fact_1997" as "agg_pl_01_sales_fact_1997"] 2026-07-30 17:58:17,852 DEBUG [mondrian.sql] 1075: , exec 0 ms 2026-07-30 17:58:17,852 DEBUG [mondrian.sql] 1075: , exec+fetch 0 ms, 1 rows 2026-07-30 17:58:17,873 DEBUG [mondrian.sql] 1076: SqlMemberSource.getLevelMemberCount: executing sql [ select count(*) as "c0" from (select distinct "customer"."country" as "c0" from "customer" as "customer") as "init"] 2026-07-30 17:58:17,892 DEBUG [mondrian.sql] 1076: , exec 19 ms 2026-07-30 17:58:17,892 DEBUG [mondrian.sql] 1076: , exec+fetch 19 ms, 1 rows 2026-07-30 17:58:17,892 DEBUG [mondrian.sql] 1077: SqlTupleReader.readTuples [[Customers].[Country]]: executing sql [ select "customer"."country" as "c0" from "customer" as "customer" group by "customer"."country" order by CASE WHEN "customer"."country" IS NULL THEN 1 ELSE 0 END, "customer"."country" ASC] 2026-07-30 17:58:17,895 DEBUG [mondrian.sql] 1077: , exec 2 ms 2026-07-30 17:58:17,895 DEBUG [mondrian.sql] 1077: , exec+fetch 3 ms, 3 rows 2026-07-30 17:58:17,896 DEBUG [mondrian.sql] 1078: SqlMemberSource.getMemberChildren: executing sql [ select "customer"."country" as "c0" from "customer" as "customer" group by "customer"."country" order by CASE WHEN "customer"."country" IS NULL THEN 1 ELSE 0 END, "customer"."country" ASC] 2026-07-30 17:58:17,898 DEBUG [mondrian.sql] 1078: , exec 2 ms 2026-07-30 17:58:17,899 DEBUG [mondrian.sql] 1078: , exec+fetch 3 ms, 3 rows 2026-07-30 17:58:17,899 DEBUG [mondrian.sql] 1079: SqlTupleReader.readTuples [[Time].[Year]]: executing sql [ select "time_by_day"."the_year" as "c0" from "time_by_day" as "time_by_day" group by "time_by_day"."the_year" order by CASE WHEN "time_by_day"."the_year" IS NULL THEN 1 ELSE 0 END, "time_by_day"."the_year" ASC] 2026-07-30 17:58:17,899 DEBUG [mondrian.sql] 1079: , exec 0 ms 2026-07-30 17:58:17,899 DEBUG [mondrian.sql] 1079: , exec+fetch 0 ms, 2 rows 2026-07-30 17:58:17,900 DEBUG [mondrian.sql] 1080: SqlTupleReader.readTuples [[Time].[Year]]: executing sql [ select "time_by_day"."the_year" as "c0" from "time_by_day" as "time_by_day" group by "time_by_day"."the_year" order by CASE WHEN "time_by_day"."the_year" IS NULL THEN 1 ELSE 0 END, "time_by_day"."the_year" ASC] 2026-07-30 17:58:17,900 DEBUG [mondrian.sql] 1080: , exec 0 ms 2026-07-30 17:58:17,900 DEBUG [mondrian.sql] 1080: , exec+fetch 0 ms, 2 rows 2026-07-30 17:58:17,903 DEBUG [mondrian.sql] 1081: SqlTupleReader.readTuples [[Time].[Year]]: executing sql [ select "time_by_day"."the_year" as "c0" from "time_by_day" as "time_by_day" group by "time_by_day"."the_year" order by CASE WHEN "time_by_day"."the_year" IS NULL THEN 1 ELSE 0 END, "time_by_day"."the_year" ASC] 2026-07-30 17:58:17,903 DEBUG [mondrian.sql] 1081: , exec 0 ms 2026-07-30 17:58:17,903 DEBUG [mondrian.sql] 1081: , exec+fetch 0 ms, 2 rows 2026-07-30 17:58:17,903 DEBUG [mondrian.sql] 1082: SqlTupleReader.readTuples [[Time].[Year]]: executing sql [ select "time_by_day"."the_year" as "c0" from "time_by_day" as "time_by_day" group by "time_by_day"."the_year" order by CASE WHEN "time_by_day"."the_year" IS NULL THEN 1 ELSE 0 END, "time_by_day"."the_year" ASC] 2026-07-30 17:58:17,903 DEBUG [mondrian.sql] 1082: , exec 0 ms 2026-07-30 17:58:17,903 DEBUG [mondrian.sql] 1082: , exec+fetch 0 ms, 2 rows 2026-07-30 17:58:17,907 DEBUG [mondrian.sql] 1083: SqlTupleReader.readTuples [[Time].[Year]]: executing sql [ select "time_by_day"."the_year" as "c0" from "time_by_day" as "time_by_day" group by "time_by_day"."the_year" order by CASE WHEN "time_by_day"."the_year" IS NULL THEN 1 ELSE 0 END, "time_by_day"."the_year" ASC] 2026-07-30 17:58:17,907 DEBUG [mondrian.sql] 1083: , exec 0 ms 2026-07-30 17:58:17,907 DEBUG [mondrian.sql] 1083: , exec+fetch 0 ms, 2 rows 2026-07-30 17:58:17,907 DEBUG [mondrian.sql] 1084: SqlTupleReader.readTuples [[Time].[Year]]: executing sql [ select "time_by_day"."the_year" as "c0" from "time_by_day" as "time_by_day" group by "time_by_day"."the_year" order by CASE WHEN "time_by_day"."the_year" IS NULL THEN 1 ELSE 0 END, "time_by_day"."the_year" ASC] 2026-07-30 17:58:17,907 DEBUG [mondrian.sql] 1084: , exec 0 ms 2026-07-30 17:58:17,907 DEBUG [mondrian.sql] 1084: , exec+fetch 0 ms, 2 rows 2026-07-30 17:58:17,909 DEBUG [mondrian.sql] 1085: SqlMemberSource.getLevelMemberCount: executing sql [ select count(*) as "c0" from (select distinct "time_by_day"."quarter" as "c0", "time_by_day"."the_year" as "c1" from "time_by_day" as "time_by_day") as "init"] 2026-07-30 17:58:17,911 DEBUG [mondrian.sql] 1085: , exec 1 ms 2026-07-30 17:58:17,911 DEBUG [mondrian.sql] 1085: , exec+fetch 2 ms, 1 rows 2026-07-30 17:58:17,911 DEBUG [mondrian.sql] 1086: SqlTupleReader.readTuples [[Time].[Quarter]]: executing sql [ select "time_by_day"."the_year" as "c0", "time_by_day"."quarter" as "c1" from "time_by_day" as "time_by_day" group by "time_by_day"."the_year", "time_by_day"."quarter" order by CASE WHEN "time_by_day"."the_year" IS NULL THEN 1 ELSE 0 END, "time_by_day"."the_year" ASC, CASE WHEN "time_by_day"."quarter" IS NULL THEN 1 ELSE 0 END, "time_by_day"."quarter" ASC] 2026-07-30 17:58:17,911 DEBUG [mondrian.sql] 1086: , exec 0 ms 2026-07-30 17:58:17,911 DEBUG [mondrian.sql] 1086: , exec+fetch 0 ms, 8 rows 2026-07-30 17:58:17,913 DEBUG [mondrian.sql] 1087: SqlStatisticsProvider.getTableCardinality: executing sql [select count(*) from "agg_c_10_sales_fact_1997"] 2026-07-30 17:58:17,913 DEBUG [mondrian.sql] 1087: , exec 0 ms 2026-07-30 17:58:17,913 DEBUG [mondrian.sql] 1087: , exec+fetch 0 ms, 1 rows 2026-07-30 17:58:17,913 DEBUG [mondrian.sql] 1088: AggStar.FactTable.makeNumberOfRows: executing sql [ select count(*) as "c0" from "agg_c_10_sales_fact_1997" as "agg_c_10_sales_fact_1997"] 2026-07-30 17:58:17,913 DEBUG [mondrian.sql] 1088: , exec 0 ms 2026-07-30 17:58:17,913 DEBUG [mondrian.sql] 1088: , exec+fetch 0 ms, 1 rows 2026-07-30 17:58:17,914 DEBUG [mondrian.sql] 1089: SqlStatisticsProvider.getTableCardinality: executing sql [select count(*) from "agg_c_14_sales_fact_1997"] 2026-07-30 17:58:17,914 DEBUG [mondrian.sql] 1089: , exec 0 ms 2026-07-30 17:58:17,914 DEBUG [mondrian.sql] 1089: , exec+fetch 0 ms, 1 rows 2026-07-30 17:58:17,914 DEBUG [mondrian.sql] 1090: AggStar.FactTable.makeNumberOfRows: executing sql [ select count(*) as "c0" from "agg_c_14_sales_fact_1997" as "agg_c_14_sales_fact_1997"] 2026-07-30 17:58:17,914 DEBUG [mondrian.sql] 1090: , exec 0 ms 2026-07-30 17:58:17,914 DEBUG [mondrian.sql] 1090: , exec+fetch 0 ms, 1 rows 2026-07-30 17:58:17,915 DEBUG [mondrian.sql] 1091: SqlStatisticsProvider.getTableCardinality: executing sql [select count(*) from "agg_g_ms_pcat_sales_fact_1997"] 2026-07-30 17:58:17,915 DEBUG [mondrian.sql] 1091: , exec 0 ms 2026-07-30 17:58:17,915 DEBUG [mondrian.sql] 1091: , exec+fetch 0 ms, 1 rows 2026-07-30 17:58:17,915 DEBUG [mondrian.sql] 1092: AggStar.FactTable.makeNumberOfRows: executing sql [ select count(*) as "c0" from "agg_g_ms_pcat_sales_fact_1997" as "agg_g_ms_pcat_sales_fact_1997"] 2026-07-30 17:58:17,915 DEBUG [mondrian.sql] 1092: , exec 0 ms 2026-07-30 17:58:17,915 DEBUG [mondrian.sql] 1092: , exec+fetch 0 ms, 1 rows 2026-07-30 17:58:17,916 DEBUG [mondrian.sql] 1093: SqlStatisticsProvider.getTableCardinality: executing sql [select count(*) from "agg_l_03_sales_fact_1997"] 2026-07-30 17:58:17,916 DEBUG [mondrian.sql] 1093: , exec 0 ms 2026-07-30 17:58:17,916 DEBUG [mondrian.sql] 1093: , exec+fetch 0 ms, 1 rows 2026-07-30 17:58:17,916 DEBUG [mondrian.sql] 1094: AggStar.FactTable.makeNumberOfRows: executing sql [ select count(*) as "c0" from "agg_l_03_sales_fact_1997" as "agg_l_03_sales_fact_1997"] 2026-07-30 17:58:17,916 DEBUG [mondrian.sql] 1094: , exec 0 ms 2026-07-30 17:58:17,916 DEBUG [mondrian.sql] 1094: , exec+fetch 0 ms, 1 rows 2026-07-30 17:58:17,917 DEBUG [mondrian.sql] 1095: SqlStatisticsProvider.getTableCardinality: executing sql [select count(*) from "agg_l_04_sales_fact_1997"] 2026-07-30 17:58:17,917 DEBUG [mondrian.sql] 1095: , exec 0 ms 2026-07-30 17:58:17,917 DEBUG [mondrian.sql] 1095: , exec+fetch 0 ms, 1 rows 2026-07-30 17:58:17,917 DEBUG [mondrian.sql] 1096: AggStar.FactTable.makeNumberOfRows: executing sql [ select count(*) as "c0" from "agg_l_04_sales_fact_1997" as "agg_l_04_sales_fact_1997"] 2026-07-30 17:58:17,917 DEBUG [mondrian.sql] 1096: , exec 0 ms 2026-07-30 17:58:17,917 DEBUG [mondrian.sql] 1096: , exec+fetch 0 ms, 1 rows 2026-07-30 17:58:17,917 DEBUG [mondrian.sql] 1097: SqlStatisticsProvider.getTableCardinality: executing sql [select count(*) from "agg_l_05_sales_fact_1997"] 2026-07-30 17:58:17,918 DEBUG [mondrian.sql] 1097: , exec 0 ms 2026-07-30 17:58:17,918 DEBUG [mondrian.sql] 1097: , exec+fetch 1 ms, 1 rows 2026-07-30 17:58:17,918 DEBUG [mondrian.sql] 1098: AggStar.FactTable.makeNumberOfRows: executing sql [ select count(*) as "c0" from "agg_l_05_sales_fact_1997" as "agg_l_05_sales_fact_1997"] 2026-07-30 17:58:17,918 DEBUG [mondrian.sql] 1098: , exec 0 ms 2026-07-30 17:58:17,918 DEBUG [mondrian.sql] 1098: , exec+fetch 0 ms, 1 rows 2026-07-30 17:58:17,918 DEBUG [mondrian.sql] 1099: SqlStatisticsProvider.getTableCardinality: executing sql [select count(*) from "agg_lc_06_sales_fact_1997"] 2026-07-30 17:58:17,919 DEBUG [mondrian.sql] 1099: , exec 0 ms 2026-07-30 17:58:17,919 DEBUG [mondrian.sql] 1099: , exec+fetch 0 ms, 1 rows 2026-07-30 17:58:17,919 DEBUG [mondrian.sql] 1100: AggStar.FactTable.makeNumberOfRows: executing sql [ select count(*) as "c0" from "agg_lc_06_sales_fact_1997" as "agg_lc_06_sales_fact_1997"] 2026-07-30 17:58:17,919 DEBUG [mondrian.sql] 1100: , exec 0 ms 2026-07-30 17:58:17,919 DEBUG [mondrian.sql] 1100: , exec+fetch 0 ms, 1 rows 2026-07-30 17:58:17,919 DEBUG [mondrian.sql] 1101: SqlStatisticsProvider.getTableCardinality: executing sql [select count(*) from "agg_ll_01_sales_fact_1997"] 2026-07-30 17:58:17,919 DEBUG [mondrian.sql] 1101: , exec 0 ms 2026-07-30 17:58:17,920 DEBUG [mondrian.sql] 1101: , exec+fetch 1 ms, 1 rows 2026-07-30 17:58:17,920 DEBUG [mondrian.sql] 1102: AggStar.FactTable.makeNumberOfRows: executing sql [ select count(*) as "c0" from "agg_ll_01_sales_fact_1997" as "agg_ll_01_sales_fact_1997"] 2026-07-30 17:58:17,920 DEBUG [mondrian.sql] 1102: , exec 0 ms 2026-07-30 17:58:17,920 DEBUG [mondrian.sql] 1102: , exec+fetch 0 ms, 1 rows 2026-07-30 17:58:17,920 DEBUG [mondrian.sql] 1103: SqlStatisticsProvider.getTableCardinality: executing sql [select count(*) from "agg_pl_01_sales_fact_1997"] 2026-07-30 17:58:17,920 DEBUG [mondrian.sql] 1103: , exec 0 ms 2026-07-30 17:58:17,920 DEBUG [mondrian.sql] 1103: , exec+fetch 0 ms, 1 rows 2026-07-30 17:58:17,920 DEBUG [mondrian.sql] 1104: AggStar.FactTable.makeNumberOfRows: executing sql [ select count(*) as "c0" from "agg_pl_01_sales_fact_1997" as "agg_pl_01_sales_fact_1997"] 2026-07-30 17:58:17,921 DEBUG [mondrian.sql] 1104: , exec 0 ms 2026-07-30 17:58:17,921 DEBUG [mondrian.sql] 1104: , exec+fetch 1 ms, 1 rows 2026-07-30 17:58:19,807 DEBUG [mondrian.sql] 1105: SqlMemberSource.getLevelMemberCount: executing sql [ select count(*) as "c0" from (select distinct "customer"."country" as "c0" from "customer" as "customer") as "init"] 2026-07-30 17:58:19,825 DEBUG [mondrian.sql] 1105: , exec 18 ms 2026-07-30 17:58:19,825 DEBUG [mondrian.sql] 1105: , exec+fetch 18 ms, 1 rows 2026-07-30 17:58:19,826 DEBUG [mondrian.sql] 1106: SqlTupleReader.readTuples [[Customers].[Country]]: executing sql [ select "customer"."country" as "c0" from "customer" as "customer" group by "customer"."country" order by CASE WHEN "customer"."country" IS NULL THEN 1 ELSE 0 END, "customer"."country" ASC] 2026-07-30 17:58:19,830 DEBUG [mondrian.sql] 1106: , exec 3 ms 2026-07-30 17:58:19,830 DEBUG [mondrian.sql] 1106: , exec+fetch 4 ms, 3 rows 2026-07-30 17:58:19,830 DEBUG [mondrian.sql] 1107: SqlMemberSource.getMemberChildren: executing sql [ select "customer"."country" as "c0" from "customer" as "customer" group by "customer"."country" order by CASE WHEN "customer"."country" IS NULL THEN 1 ELSE 0 END, "customer"."country" ASC] 2026-07-30 17:58:19,833 DEBUG [mondrian.sql] 1107: , exec 2 ms 2026-07-30 17:58:19,833 DEBUG [mondrian.sql] 1107: , exec+fetch 3 ms, 3 rows 2026-07-30 17:58:19,834 DEBUG [mondrian.sql] 1108: SqlTupleReader.readTuples [[Time].[Year]]: executing sql [ select "time_by_day"."the_year" as "c0" from "time_by_day" as "time_by_day" group by "time_by_day"."the_year" order by CASE WHEN "time_by_day"."the_year" IS NULL THEN 1 ELSE 0 END, "time_by_day"."the_year" ASC] 2026-07-30 17:58:19,834 DEBUG [mondrian.sql] 1108: , exec 0 ms 2026-07-30 17:58:19,834 DEBUG [mondrian.sql] 1108: , exec+fetch 0 ms, 2 rows 2026-07-30 17:58:19,835 DEBUG [mondrian.sql] 1109: SqlTupleReader.readTuples [[Time].[Year]]: executing sql [ select "time_by_day"."the_year" as "c0" from "time_by_day" as "time_by_day" group by "time_by_day"."the_year" order by CASE WHEN "time_by_day"."the_year" IS NULL THEN 1 ELSE 0 END, "time_by_day"."the_year" ASC] 2026-07-30 17:58:19,835 DEBUG [mondrian.sql] 1109: , exec 0 ms 2026-07-30 17:58:19,835 DEBUG [mondrian.sql] 1109: , exec+fetch 0 ms, 2 rows 2026-07-30 17:58:19,837 DEBUG [mondrian.sql] 1110: SqlTupleReader.readTuples [[Time].[Year]]: executing sql [ select "time_by_day"."the_year" as "c0" from "time_by_day" as "time_by_day" group by "time_by_day"."the_year" order by CASE WHEN "time_by_day"."the_year" IS NULL THEN 1 ELSE 0 END, "time_by_day"."the_year" ASC] 2026-07-30 17:58:19,838 DEBUG [mondrian.sql] 1110: , exec 0 ms 2026-07-30 17:58:19,838 DEBUG [mondrian.sql] 1110: , exec+fetch 1 ms, 2 rows 2026-07-30 17:58:19,838 DEBUG [mondrian.sql] 1111: SqlTupleReader.readTuples [[Time].[Year]]: executing sql [ select "time_by_day"."the_year" as "c0" from "time_by_day" as "time_by_day" group by "time_by_day"."the_year" order by CASE WHEN "time_by_day"."the_year" IS NULL THEN 1 ELSE 0 END, "time_by_day"."the_year" ASC] 2026-07-30 17:58:19,838 DEBUG [mondrian.sql] 1111: , exec 0 ms 2026-07-30 17:58:19,838 DEBUG [mondrian.sql] 1111: , exec+fetch 0 ms, 2 rows 2026-07-30 17:58:19,841 DEBUG [mondrian.sql] 1112: SqlTupleReader.readTuples [[Time].[Year]]: executing sql [ select "time_by_day"."the_year" as "c0" from "time_by_day" as "time_by_day" group by "time_by_day"."the_year" order by CASE WHEN "time_by_day"."the_year" IS NULL THEN 1 ELSE 0 END, "time_by_day"."the_year" ASC] 2026-07-30 17:58:19,841 DEBUG [mondrian.sql] 1112: , exec 0 ms 2026-07-30 17:58:19,841 DEBUG [mondrian.sql] 1112: , exec+fetch 0 ms, 2 rows 2026-07-30 17:58:19,842 DEBUG [mondrian.sql] 1113: SqlTupleReader.readTuples [[Time].[Year]]: executing sql [ select "time_by_day"."the_year" as "c0" from "time_by_day" as "time_by_day" group by "time_by_day"."the_year" order by CASE WHEN "time_by_day"."the_year" IS NULL THEN 1 ELSE 0 END, "time_by_day"."the_year" ASC] 2026-07-30 17:58:19,842 DEBUG [mondrian.sql] 1113: , exec 0 ms 2026-07-30 17:58:19,842 DEBUG [mondrian.sql] 1113: , exec+fetch 0 ms, 2 rows 2026-07-30 17:58:19,844 DEBUG [mondrian.sql] 1114: SqlMemberSource.getLevelMemberCount: executing sql [ select count(*) as "c0" from (select distinct "time_by_day"."quarter" as "c0", "time_by_day"."the_year" as "c1" from "time_by_day" as "time_by_day") as "init"] 2026-07-30 17:58:19,845 DEBUG [mondrian.sql] 1114: , exec 1 ms 2026-07-30 17:58:19,845 DEBUG [mondrian.sql] 1114: , exec+fetch 1 ms, 1 rows 2026-07-30 17:58:19,845 DEBUG [mondrian.sql] 1115: SqlTupleReader.readTuples [[Time].[Quarter]]: executing sql [ select "time_by_day"."the_year" as "c0", "time_by_day"."quarter" as "c1" from "time_by_day" as "time_by_day" group by "time_by_day"."the_year", "time_by_day"."quarter" order by CASE WHEN "time_by_day"."the_year" IS NULL THEN 1 ELSE 0 END, "time_by_day"."the_year" ASC, CASE WHEN "time_by_day"."quarter" IS NULL THEN 1 ELSE 0 END, "time_by_day"."quarter" ASC] 2026-07-30 17:58:19,845 DEBUG [mondrian.sql] 1115: , exec 0 ms 2026-07-30 17:58:19,845 DEBUG [mondrian.sql] 1115: , exec+fetch 0 ms, 8 rows 2026-07-30 17:58:19,847 DEBUG [mondrian.sql] 1116: SqlStatisticsProvider.getTableCardinality: executing sql [select count(*) from "agg_c_10_sales_fact_1997"] 2026-07-30 17:58:19,847 DEBUG [mondrian.sql] 1116: , exec 0 ms 2026-07-30 17:58:19,847 DEBUG [mondrian.sql] 1116: , exec+fetch 0 ms, 1 rows 2026-07-30 17:58:19,847 DEBUG [mondrian.sql] 1117: AggStar.FactTable.makeNumberOfRows: executing sql [ select count(*) as "c0" from "agg_c_10_sales_fact_1997" as "agg_c_10_sales_fact_1997"] 2026-07-30 17:58:19,847 DEBUG [mondrian.sql] 1117: , exec 0 ms 2026-07-30 17:58:19,847 DEBUG [mondrian.sql] 1117: , exec+fetch 0 ms, 1 rows 2026-07-30 17:58:19,847 DEBUG [mondrian.sql] 1118: SqlStatisticsProvider.getTableCardinality: executing sql [select count(*) from "agg_c_14_sales_fact_1997"] 2026-07-30 17:58:19,847 DEBUG [mondrian.sql] 1118: , exec 0 ms 2026-07-30 17:58:19,848 DEBUG [mondrian.sql] 1118: , exec+fetch 1 ms, 1 rows 2026-07-30 17:58:19,848 DEBUG [mondrian.sql] 1119: AggStar.FactTable.makeNumberOfRows: executing sql [ select count(*) as "c0" from "agg_c_14_sales_fact_1997" as "agg_c_14_sales_fact_1997"] 2026-07-30 17:58:19,848 DEBUG [mondrian.sql] 1119: , exec 0 ms 2026-07-30 17:58:19,848 DEBUG [mondrian.sql] 1119: , exec+fetch 0 ms, 1 rows 2026-07-30 17:58:19,849 DEBUG [mondrian.sql] 1120: SqlStatisticsProvider.getTableCardinality: executing sql [select count(*) from "agg_g_ms_pcat_sales_fact_1997"] 2026-07-30 17:58:19,849 DEBUG [mondrian.sql] 1120: , exec 0 ms 2026-07-30 17:58:19,849 DEBUG [mondrian.sql] 1120: , exec+fetch 0 ms, 1 rows 2026-07-30 17:58:19,849 DEBUG [mondrian.sql] 1121: AggStar.FactTable.makeNumberOfRows: executing sql [ select count(*) as "c0" from "agg_g_ms_pcat_sales_fact_1997" as "agg_g_ms_pcat_sales_fact_1997"] 2026-07-30 17:58:19,849 DEBUG [mondrian.sql] 1121: , exec 0 ms 2026-07-30 17:58:19,849 DEBUG [mondrian.sql] 1121: , exec+fetch 0 ms, 1 rows 2026-07-30 17:58:19,849 DEBUG [mondrian.sql] 1122: SqlStatisticsProvider.getTableCardinality: executing sql [select count(*) from "agg_l_03_sales_fact_1997"] 2026-07-30 17:58:19,849 DEBUG [mondrian.sql] 1122: , exec 0 ms 2026-07-30 17:58:19,850 DEBUG [mondrian.sql] 1122: , exec+fetch 1 ms, 1 rows 2026-07-30 17:58:19,850 DEBUG [mondrian.sql] 1123: AggStar.FactTable.makeNumberOfRows: executing sql [ select count(*) as "c0" from "agg_l_03_sales_fact_1997" as "agg_l_03_sales_fact_1997"] 2026-07-30 17:58:19,850 DEBUG [mondrian.sql] 1123: , exec 0 ms 2026-07-30 17:58:19,850 DEBUG [mondrian.sql] 1123: , exec+fetch 0 ms, 1 rows 2026-07-30 17:58:19,850 DEBUG [mondrian.sql] 1124: SqlStatisticsProvider.getTableCardinality: executing sql [select count(*) from "agg_l_04_sales_fact_1997"] 2026-07-30 17:58:19,850 DEBUG [mondrian.sql] 1124: , exec 0 ms 2026-07-30 17:58:19,850 DEBUG [mondrian.sql] 1124: , exec+fetch 0 ms, 1 rows 2026-07-30 17:58:19,850 DEBUG [mondrian.sql] 1125: AggStar.FactTable.makeNumberOfRows: executing sql [ select count(*) as "c0" from "agg_l_04_sales_fact_1997" as "agg_l_04_sales_fact_1997"] 2026-07-30 17:58:19,851 DEBUG [mondrian.sql] 1125: , exec 0 ms 2026-07-30 17:58:19,851 DEBUG [mondrian.sql] 1125: , exec+fetch 1 ms, 1 rows 2026-07-30 17:58:19,851 DEBUG [mondrian.sql] 1126: SqlStatisticsProvider.getTableCardinality: executing sql [select count(*) from "agg_l_05_sales_fact_1997"] 2026-07-30 17:58:19,851 DEBUG [mondrian.sql] 1126: , exec 0 ms 2026-07-30 17:58:19,851 DEBUG [mondrian.sql] 1126: , exec+fetch 0 ms, 1 rows 2026-07-30 17:58:19,851 DEBUG [mondrian.sql] 1127: AggStar.FactTable.makeNumberOfRows: executing sql [ select count(*) as "c0" from "agg_l_05_sales_fact_1997" as "agg_l_05_sales_fact_1997"] 2026-07-30 17:58:19,851 DEBUG [mondrian.sql] 1127: , exec 0 ms 2026-07-30 17:58:19,851 DEBUG [mondrian.sql] 1127: , exec+fetch 0 ms, 1 rows 2026-07-30 17:58:19,852 DEBUG [mondrian.sql] 1128: SqlStatisticsProvider.getTableCardinality: executing sql [select count(*) from "agg_lc_06_sales_fact_1997"] 2026-07-30 17:58:19,852 DEBUG [mondrian.sql] 1128: , exec 0 ms 2026-07-30 17:58:19,852 DEBUG [mondrian.sql] 1128: , exec+fetch 0 ms, 1 rows 2026-07-30 17:58:19,852 DEBUG [mondrian.sql] 1129: AggStar.FactTable.makeNumberOfRows: executing sql [ select count(*) as "c0" from "agg_lc_06_sales_fact_1997" as "agg_lc_06_sales_fact_1997"] 2026-07-30 17:58:19,852 DEBUG [mondrian.sql] 1129: , exec 0 ms 2026-07-30 17:58:19,852 DEBUG [mondrian.sql] 1129: , exec+fetch 0 ms, 1 rows 2026-07-30 17:58:19,852 DEBUG [mondrian.sql] 1130: SqlStatisticsProvider.getTableCardinality: executing sql [select count(*) from "agg_ll_01_sales_fact_1997"] 2026-07-30 17:58:19,853 DEBUG [mondrian.sql] 1130: , exec 0 ms 2026-07-30 17:58:19,853 DEBUG [mondrian.sql] 1130: , exec+fetch 0 ms, 1 rows 2026-07-30 17:58:19,853 DEBUG [mondrian.sql] 1131: AggStar.FactTable.makeNumberOfRows: executing sql [ select count(*) as "c0" from "agg_ll_01_sales_fact_1997" as "agg_ll_01_sales_fact_1997"] 2026-07-30 17:58:19,853 DEBUG [mondrian.sql] 1131: , exec 0 ms 2026-07-30 17:58:19,853 DEBUG [mondrian.sql] 1131: , exec+fetch 0 ms, 1 rows 2026-07-30 17:58:19,853 DEBUG [mondrian.sql] 1132: SqlStatisticsProvider.getTableCardinality: executing sql [select count(*) from "agg_pl_01_sales_fact_1997"] 2026-07-30 17:58:19,853 DEBUG [mondrian.sql] 1132: , exec 0 ms 2026-07-30 17:58:19,853 DEBUG [mondrian.sql] 1132: , exec+fetch 0 ms, 1 rows 2026-07-30 17:58:19,853 DEBUG [mondrian.sql] 1133: AggStar.FactTable.makeNumberOfRows: executing sql [ select count(*) as "c0" from "agg_pl_01_sales_fact_1997" as "agg_pl_01_sales_fact_1997"] 2026-07-30 17:58:19,853 DEBUG [mondrian.sql] 1133: , exec 0 ms 2026-07-30 17:58:19,853 DEBUG [mondrian.sql] 1133: , exec+fetch 0 ms, 1 rows 2026-07-30 17:58:21,244 DEBUG [mondrian.sql] 1134: SqlMemberSource.getLevelMemberCount: executing sql [ select count(*) as "c0" from (select distinct "store"."store_name" as "c0" from "store" as "store") as "init"] 2026-07-30 17:58:21,245 DEBUG [mondrian.sql] 1134: , exec 0 ms 2026-07-30 17:58:21,245 DEBUG [mondrian.sql] 1134: , exec+fetch 1 ms, 1 rows 2026-07-30 17:58:21,245 DEBUG [mondrian.sql] 1135: SqlMemberSource.getLevelMemberCount: executing sql [ select count(*) as "c0" from (select distinct "store"."store_sqft" as "c0" from "store" as "store") as "init"] 2026-07-30 17:58:21,245 DEBUG [mondrian.sql] 1135: , exec 0 ms 2026-07-30 17:58:21,245 DEBUG [mondrian.sql] 1135: , exec+fetch 0 ms, 1 rows 2026-07-30 17:58:21,245 DEBUG [mondrian.sql] 1136: SqlMemberSource.getLevelMemberCount: executing sql [ select count(*) as "c0" from (select distinct "store"."store_type" as "c0" from "store" as "store") as "init"] 2026-07-30 17:58:21,246 DEBUG [mondrian.sql] 1136: , exec 0 ms 2026-07-30 17:58:21,246 DEBUG [mondrian.sql] 1136: , exec+fetch 1 ms, 1 rows 2026-07-30 17:58:21,246 DEBUG [mondrian.sql] 1137: SqlMemberSource.getLevelMemberCount: executing sql [ select count(*) as "c0" from (select distinct "time_by_day"."month_of_year" as "c0", "time_by_day"."quarter" as "c1", "time_by_day"."the_year" as "c2" from "time_by_day" as "time_by_day") as "init"] 2026-07-30 17:58:21,247 DEBUG [mondrian.sql] 1137: , exec 0 ms 2026-07-30 17:58:21,247 DEBUG [mondrian.sql] 1137: , exec+fetch 1 ms, 1 rows 2026-07-30 17:58:21,247 DEBUG [mondrian.sql] 1138: SqlMemberSource.getLevelMemberCount: executing sql [ select count(*) as "c0" from (select distinct "product"."product_name" as "c0" from "product" as "product") as "init"] 2026-07-30 17:58:21,254 DEBUG [mondrian.sql] 1138: , exec 6 ms 2026-07-30 17:58:21,254 DEBUG [mondrian.sql] 1138: , exec+fetch 7 ms, 1 rows 2026-07-30 17:58:21,254 DEBUG [mondrian.sql] 1139: SqlMemberSource.getLevelMemberCount: executing sql [ select count(*) as "c0" from (select distinct "promotion"."media_type" as "c0" from "promotion" as "promotion") as "init"] 2026-07-30 17:58:21,257 DEBUG [mondrian.sql] 1139: , exec 3 ms 2026-07-30 17:58:21,257 DEBUG [mondrian.sql] 1139: , exec+fetch 3 ms, 1 rows 2026-07-30 17:58:21,257 DEBUG [mondrian.sql] 1140: SqlMemberSource.getLevelMemberCount: executing sql [ select count(*) as "c0" from (select distinct "promotion"."promotion_name" as "c0" from "promotion" as "promotion") as "init"] 2026-07-30 17:58:21,261 DEBUG [mondrian.sql] 1140: , exec 3 ms 2026-07-30 17:58:21,261 DEBUG [mondrian.sql] 1140: , exec+fetch 4 ms, 1 rows 2026-07-30 17:58:21,261 DEBUG [mondrian.sql] 1141: SqlMemberSource.getLevelMemberCount: executing sql [ select count(*) as "c0" from (select distinct "customer"."customer_id" as "c0" from "customer" as "customer") as "init"] 2026-07-30 17:58:21,279 DEBUG [mondrian.sql] 1141: , exec 17 ms 2026-07-30 17:58:21,279 DEBUG [mondrian.sql] 1141: , exec+fetch 18 ms, 1 rows 2026-07-30 17:58:21,279 DEBUG [mondrian.sql] 1142: SqlMemberSource.getLevelMemberCount: executing sql [ select count(*) as "c0" from (select distinct "customer"."education" as "c0" from "customer" as "customer") as "init"] 2026-07-30 17:58:21,302 DEBUG [mondrian.sql] 1142: , exec 22 ms 2026-07-30 17:58:21,302 DEBUG [mondrian.sql] 1142: , exec+fetch 23 ms, 1 rows 2026-07-30 17:58:21,302 DEBUG [mondrian.sql] 1143: SqlMemberSource.getLevelMemberCount: executing sql [ select count(*) as "c0" from (select distinct "customer"."gender" as "c0" from "customer" as "customer") as "init"] 2026-07-30 17:58:21,320 DEBUG [mondrian.sql] 1143: , exec 17 ms 2026-07-30 17:58:21,320 DEBUG [mondrian.sql] 1143: , exec+fetch 18 ms, 1 rows 2026-07-30 17:58:21,320 DEBUG [mondrian.sql] 1144: SqlMemberSource.getLevelMemberCount: executing sql [ select count(*) as "c0" from (select distinct "customer"."yearly_income" as "c0" from "customer" as "customer") as "init"] 2026-07-30 17:58:21,342 DEBUG [mondrian.sql] 1144: , exec 22 ms 2026-07-30 17:58:21,343 DEBUG [mondrian.sql] 1144: , exec+fetch 23 ms, 1 rows 2026-07-30 17:58:21,365 DEBUG [mondrian.sql] 1145: SqlMemberSource.getLevelMemberCount: executing sql [ select count(*) as "c0" from (select distinct "store"."store_country" as "c0" from "store" as "store") as "init"] 2026-07-30 17:58:21,366 DEBUG [mondrian.sql] 1145: , exec 0 ms 2026-07-30 17:58:21,366 DEBUG [mondrian.sql] 1145: , exec+fetch 1 ms, 1 rows 2026-07-30 17:58:21,366 DEBUG [mondrian.sql] 1146: SqlMemberSource.getLevelMemberCount: executing sql [ select count(*) as "c0" from (select distinct "store"."store_state" as "c0" from "store" as "store") as "init"] 2026-07-30 17:58:21,366 DEBUG [mondrian.sql] 1146: , exec 0 ms 2026-07-30 17:58:21,366 DEBUG [mondrian.sql] 1146: , exec+fetch 0 ms, 1 rows 2026-07-30 17:58:21,366 DEBUG [mondrian.sql] 1147: SqlMemberSource.getLevelMemberCount: executing sql [ select count(*) as "c0" from (select distinct "store"."store_city" as "c0", "store"."store_state" as "c1" from "store" as "store") as "init"] 2026-07-30 17:58:21,367 DEBUG [mondrian.sql] 1147: , exec 0 ms 2026-07-30 17:58:21,367 DEBUG [mondrian.sql] 1147: , exec+fetch 1 ms, 1 rows 2026-07-30 17:58:21,368 DEBUG [mondrian.sql] 1148: SqlMemberSource.getLevelMemberCount: executing sql [ select count(*) as "c0" from (select distinct "time_by_day"."the_year" as "c0" from "time_by_day" as "time_by_day") as "init"] 2026-07-30 17:58:21,368 DEBUG [mondrian.sql] 1148: , exec 0 ms 2026-07-30 17:58:21,368 DEBUG [mondrian.sql] 1148: , exec+fetch 0 ms, 1 rows 2026-07-30 17:58:21,368 DEBUG [mondrian.sql] 1149: SqlMemberSource.getLevelMemberCount: executing sql [ select count(*) as "c0" from (select distinct "time_by_day"."week_of_year" as "c0", "time_by_day"."the_year" as "c1" from "time_by_day" as "time_by_day") as "init"] 2026-07-30 17:58:21,369 DEBUG [mondrian.sql] 1149: , exec 0 ms 2026-07-30 17:58:21,369 DEBUG [mondrian.sql] 1149: , exec+fetch 1 ms, 1 rows 2026-07-30 17:58:21,369 DEBUG [mondrian.sql] 1150: SqlMemberSource.getLevelMemberCount: executing sql [ select count(*) as "c0" from (select distinct "time_by_day"."day_of_month" as "c0", "time_by_day"."week_of_year" as "c1", "time_by_day"."the_year" as "c2" from "time_by_day" as "time_by_day") as "init"] 2026-07-30 17:58:21,370 DEBUG [mondrian.sql] 1150: , exec 0 ms 2026-07-30 17:58:21,370 DEBUG [mondrian.sql] 1150: , exec+fetch 1 ms, 1 rows 2026-07-30 17:58:21,370 DEBUG [mondrian.sql] 1151: SqlMemberSource.getLevelMemberCount: executing sql [ select count(*) as "c0" from (select distinct "product_class"."product_family" as "c0" from "product" as "product", "product_class" as "product_class" where "product"."product_class_id" = "product_class"."product_class_id") as "init"] 2026-07-30 17:58:21,373 DEBUG [mondrian.sql] 1151: , exec 3 ms 2026-07-30 17:58:21,374 DEBUG [mondrian.sql] 1151: , exec+fetch 4 ms, 1 rows 2026-07-30 17:58:21,374 DEBUG [mondrian.sql] 1152: SqlMemberSource.getLevelMemberCount: executing sql [ select count(*) as "c0" from (select distinct "product_class"."product_department" as "c0", "product_class"."product_family" as "c1" from "product" as "product", "product_class" as "product_class" where "product"."product_class_id" = "product_class"."product_class_id") as "init"] 2026-07-30 17:58:21,377 DEBUG [mondrian.sql] 1152: , exec 3 ms 2026-07-30 17:58:21,377 DEBUG [mondrian.sql] 1152: , exec+fetch 3 ms, 1 rows 2026-07-30 17:58:21,377 DEBUG [mondrian.sql] 1153: SqlMemberSource.getLevelMemberCount: executing sql [ select count(*) as "c0" from (select distinct "product_class"."product_category" as "c0", "product_class"."product_department" as "c1", "product_class"."product_family" as "c2" from "product" as "product", "product_class" as "product_class" where "product"."product_class_id" = "product_class"."product_class_id") as "init"] 2026-07-30 17:58:21,381 DEBUG [mondrian.sql] 1153: , exec 3 ms 2026-07-30 17:58:21,381 DEBUG [mondrian.sql] 1153: , exec+fetch 4 ms, 1 rows 2026-07-30 17:58:21,381 DEBUG [mondrian.sql] 1154: SqlMemberSource.getLevelMemberCount: executing sql [ select count(*) as "c0" from (select distinct "product_class"."product_subcategory" as "c0", "product_class"."product_category" as "c1", "product_class"."product_department" as "c2", "product_class"."product_family" as "c3" from "product" as "product", "product_class" as "product_class" where "product"."product_class_id" = "product_class"."product_class_id") as "init"] 2026-07-30 17:58:21,385 DEBUG [mondrian.sql] 1154: , exec 3 ms 2026-07-30 17:58:21,385 DEBUG [mondrian.sql] 1154: , exec+fetch 4 ms, 1 rows 2026-07-30 17:58:21,385 DEBUG [mondrian.sql] 1155: SqlMemberSource.getLevelMemberCount: executing sql [ select count(*) as "c0" from (select distinct "product"."brand_name" as "c0", "product_class"."product_subcategory" as "c1", "product_class"."product_category" as "c2", "product_class"."product_department" as "c3", "product_class"."product_family" as "c4" from "product" as "product", "product_class" as "product_class" where "product"."product_class_id" = "product_class"."product_class_id") as "init"] 2026-07-30 17:58:21,390 DEBUG [mondrian.sql] 1155: , exec 4 ms 2026-07-30 17:58:21,390 DEBUG [mondrian.sql] 1155: , exec+fetch 5 ms, 1 rows 2026-07-30 17:58:21,391 DEBUG [mondrian.sql] 1156: SqlMemberSource.getLevelMemberCount: executing sql [ select count(*) as "c0" from (select distinct "product_class"."product_family" as "c0" from "product" as "product", "product_class" as "product_class" where "product"."product_class_id" = "product_class"."product_class_id") as "init"] 2026-07-30 17:58:21,393 DEBUG [mondrian.sql] 1156: , exec 2 ms 2026-07-30 17:58:21,393 DEBUG [mondrian.sql] 1156: , exec+fetch 2 ms, 1 rows 2026-07-30 17:58:21,394 DEBUG [mondrian.sql] 1157: SqlMemberSource.getLevelMemberCount: executing sql [ select count(*) as "c0" from (select distinct "product_class"."product_department" as "c0" from "product" as "product", "product_class" as "product_class" where "product"."product_class_id" = "product_class"."product_class_id") as "init"] 2026-07-30 17:58:21,397 DEBUG [mondrian.sql] 1157: , exec 2 ms 2026-07-30 17:58:21,397 DEBUG [mondrian.sql] 1157: , exec+fetch 3 ms, 1 rows 2026-07-30 17:58:21,397 DEBUG [mondrian.sql] 1158: SqlMemberSource.getLevelMemberCount: executing sql [ select count(*) as "c0" from (select distinct "product_class"."product_category" as "c0" from "product" as "product", "product_class" as "product_class" where "product"."product_class_id" = "product_class"."product_class_id") as "init"] 2026-07-30 17:58:21,400 DEBUG [mondrian.sql] 1158: , exec 3 ms 2026-07-30 17:58:21,400 DEBUG [mondrian.sql] 1158: , exec+fetch 3 ms, 1 rows 2026-07-30 17:58:21,401 DEBUG [mondrian.sql] 1159: SqlMemberSource.getLevelMemberCount: executing sql [ select count(*) as "c0" from (select distinct "product_class"."product_subcategory" as "c0" from "product" as "product", "product_class" as "product_class" where "product"."product_class_id" = "product_class"."product_class_id") as "init"] 2026-07-30 17:58:21,404 DEBUG [mondrian.sql] 1159: , exec 3 ms 2026-07-30 17:58:21,404 DEBUG [mondrian.sql] 1159: , exec+fetch 3 ms, 1 rows 2026-07-30 17:58:21,404 DEBUG [mondrian.sql] 1160: SqlMemberSource.getLevelMemberCount: executing sql [ select count(*) as "c0" from (select distinct "product"."brand_name" as "c0" from "product" as "product") as "init"] 2026-07-30 17:58:21,405 DEBUG [mondrian.sql] 1160: , exec 0 ms 2026-07-30 17:58:21,405 DEBUG [mondrian.sql] 1160: , exec+fetch 1 ms, 1 rows 2026-07-30 17:58:21,405 DEBUG [mondrian.sql] 1161: SqlMemberSource.getLevelMemberCount: executing sql [ select count(*) as "c0" from (select distinct "product"."product_name" as "c0" from "product" as "product") as "init"] 2026-07-30 17:58:21,412 DEBUG [mondrian.sql] 1161: , exec 6 ms 2026-07-30 17:58:21,412 DEBUG [mondrian.sql] 1161: , exec+fetch 7 ms, 1 rows 2026-07-30 17:58:21,412 DEBUG [mondrian.sql] 1162: SqlMemberSource.getLevelMemberCount: executing sql [ select count(*) as "c0" from (select distinct "customer"."state_province" as "c0" from "customer" as "customer") as "init"] 2026-07-30 17:58:21,433 DEBUG [mondrian.sql] 1162: , exec 20 ms 2026-07-30 17:58:21,433 DEBUG [mondrian.sql] 1162: , exec+fetch 21 ms, 1 rows 2026-07-30 17:58:21,433 DEBUG [mondrian.sql] 1163: SqlMemberSource.getLevelMemberCount: executing sql [ select count(*) as "c0" from (select distinct "customer"."city" as "c0", "customer"."state_province" as "c1" from "customer" as "customer") as "init"] 2026-07-30 17:58:21,461 DEBUG [mondrian.sql] 1163: , exec 27 ms 2026-07-30 17:58:21,461 DEBUG [mondrian.sql] 1163: , exec+fetch 28 ms, 1 rows 2026-07-30 17:58:25,833 DEBUG [mondrian.sql] 1164: SqlStatisticsProvider.getColumnCardinality: executing sql [select count(distinct "the_year") from "time_by_day"] 2026-07-30 17:58:25,833 DEBUG [mondrian.sql] 1165: SqlStatisticsProvider.getColumnCardinality: executing sql [select count(distinct "the_year") from "time_by_day"] 2026-07-30 17:58:25,836 DEBUG [mondrian.sql] 1164: , exec 2 ms 2026-07-30 17:58:25,836 DEBUG [mondrian.sql] 1164: , exec+fetch 3 ms, 1 rows 2026-07-30 17:58:25,836 DEBUG [mondrian.sql] 1165: , exec 3 ms 2026-07-30 17:58:25,836 DEBUG [mondrian.sql] 1165: , exec+fetch 3 ms, 1 rows 2026-07-30 17:58:25,837 DEBUG [mondrian.sql] 1166: Segment.load: executing sql [ select "agg_c_10_sales_fact_1997"."the_year" as "c0", sum("agg_c_10_sales_fact_1997"."unit_sales") as "m0" from "agg_c_10_sales_fact_1997" as "agg_c_10_sales_fact_1997" where "agg_c_10_sales_fact_1997"."the_year" = 1997 group by "agg_c_10_sales_fact_1997"."the_year"] 2026-07-30 17:58:25,838 DEBUG [mondrian.sql] 1166: , exec 0 ms 2026-07-30 17:58:25,838 DEBUG [mondrian.sql] 1166: , exec+fetch 1 ms, 1 rows 2026-07-30 17:58:25,841 DEBUG [mondrian.sql] 1167: SqlTupleReader.readTuples [[Yearly Income].[Yearly Income]]: executing sql [ select "customer"."yearly_income" as "c0" from "customer" as "customer" group by "customer"."yearly_income" order by CASE WHEN "customer"."yearly_income" IS NULL THEN 1 ELSE 0 END, "customer"."yearly_income" ASC] 2026-07-30 17:58:25,849 DEBUG [mondrian.sql] 1167: , exec 8 ms 2026-07-30 17:58:25,850 DEBUG [mondrian.sql] 1167: , exec+fetch 9 ms, 8 rows 2026-07-30 17:58:25,850 DEBUG [mondrian.sql] 1168: SqlMemberSource.getMemberChildren: executing sql [ select "customer"."yearly_income" as "c0" from "customer" as "customer" group by "customer"."yearly_income" order by CASE WHEN "customer"."yearly_income" IS NULL THEN 1 ELSE 0 END, "customer"."yearly_income" ASC] 2026-07-30 17:58:25,857 DEBUG [mondrian.sql] 1168: , exec 7 ms 2026-07-30 17:58:25,857 DEBUG [mondrian.sql] 1168: , exec+fetch 7 ms, 8 rows