2026-08-03 15:23:59,595 DEBUG [mondrian.sql] 1169: SqlMemberSource.getLevelMemberCount: executing sql [ select count(*) as "c0" from (select distinct "customer"."country" as "c0" from "customer" as "customer") as "init"] 2026-08-03 15:23:59,628 DEBUG [mondrian.sql] 1169: , exec 30 ms 2026-08-03 15:23:59,628 DEBUG [mondrian.sql] 1169: , exec+fetch 31 ms, 1 rows 2026-08-03 15:23:59,629 DEBUG [mondrian.sql] 1170: 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-08-03 15:23:59,634 DEBUG [mondrian.sql] 1170: , exec 4 ms 2026-08-03 15:23:59,634 DEBUG [mondrian.sql] 1170: , exec+fetch 5 ms, 3 rows 2026-08-03 15:23:59,634 DEBUG [mondrian.sql] 1171: 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-08-03 15:23:59,638 DEBUG [mondrian.sql] 1171: , exec 3 ms 2026-08-03 15:23:59,638 DEBUG [mondrian.sql] 1171: , exec+fetch 4 ms, 3 rows 2026-08-03 15:23:59,639 DEBUG [mondrian.sql] 1172: 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-08-03 15:23:59,639 DEBUG [mondrian.sql] 1172: , exec 0 ms 2026-08-03 15:23:59,639 DEBUG [mondrian.sql] 1172: , exec+fetch 0 ms, 2 rows 2026-08-03 15:23:59,641 DEBUG [mondrian.sql] 1173: 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-08-03 15:23:59,641 DEBUG [mondrian.sql] 1173: , exec 0 ms 2026-08-03 15:23:59,641 DEBUG [mondrian.sql] 1173: , exec+fetch 0 ms, 2 rows 2026-08-03 15:23:59,645 DEBUG [mondrian.sql] 1174: 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-08-03 15:23:59,646 DEBUG [mondrian.sql] 1174: , exec 0 ms 2026-08-03 15:23:59,646 DEBUG [mondrian.sql] 1174: , exec+fetch 1 ms, 2 rows 2026-08-03 15:23:59,646 DEBUG [mondrian.sql] 1175: 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-08-03 15:23:59,646 DEBUG [mondrian.sql] 1175: , exec 0 ms 2026-08-03 15:23:59,646 DEBUG [mondrian.sql] 1175: , exec+fetch 0 ms, 2 rows 2026-08-03 15:23:59,653 DEBUG [mondrian.sql] 1176: 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-08-03 15:23:59,653 DEBUG [mondrian.sql] 1176: , exec 0 ms 2026-08-03 15:23:59,653 DEBUG [mondrian.sql] 1176: , exec+fetch 0 ms, 2 rows 2026-08-03 15:23:59,653 DEBUG [mondrian.sql] 1177: 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-08-03 15:23:59,653 DEBUG [mondrian.sql] 1177: , exec 0 ms 2026-08-03 15:23:59,653 DEBUG [mondrian.sql] 1177: , exec+fetch 0 ms, 2 rows 2026-08-03 15:23:59,657 DEBUG [mondrian.sql] 1178: 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-08-03 15:23:59,659 DEBUG [mondrian.sql] 1178: , exec 1 ms 2026-08-03 15:23:59,659 DEBUG [mondrian.sql] 1178: , exec+fetch 2 ms, 1 rows 2026-08-03 15:23:59,659 DEBUG [mondrian.sql] 1179: 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-08-03 15:23:59,660 DEBUG [mondrian.sql] 1179: , exec 0 ms 2026-08-03 15:23:59,660 DEBUG [mondrian.sql] 1179: , exec+fetch 1 ms, 8 rows 2026-08-03 15:23:59,678 DEBUG [mondrian.sql] 1180: SqlStatisticsProvider.getTableCardinality: executing sql [select count(*) from "agg_c_10_sales_fact_1997"] 2026-08-03 15:23:59,678 DEBUG [mondrian.sql] 1180: , exec 0 ms 2026-08-03 15:23:59,678 DEBUG [mondrian.sql] 1180: , exec+fetch 0 ms, 1 rows 2026-08-03 15:23:59,678 DEBUG [mondrian.sql] 1181: AggStar.FactTable.makeNumberOfRows: executing sql [ select count(*) as "c0" from "agg_c_10_sales_fact_1997" as "agg_c_10_sales_fact_1997"] 2026-08-03 15:23:59,679 DEBUG [mondrian.sql] 1181: , exec 0 ms 2026-08-03 15:23:59,679 DEBUG [mondrian.sql] 1181: , exec+fetch 1 ms, 1 rows 2026-08-03 15:23:59,692 DEBUG [mondrian.sql] 1182: SqlStatisticsProvider.getTableCardinality: executing sql [select count(*) from "agg_c_14_sales_fact_1997"] 2026-08-03 15:23:59,692 DEBUG [mondrian.sql] 1182: , exec 0 ms 2026-08-03 15:23:59,693 DEBUG [mondrian.sql] 1182: , exec+fetch 1 ms, 1 rows 2026-08-03 15:23:59,693 DEBUG [mondrian.sql] 1183: AggStar.FactTable.makeNumberOfRows: executing sql [ select count(*) as "c0" from "agg_c_14_sales_fact_1997" as "agg_c_14_sales_fact_1997"] 2026-08-03 15:23:59,693 DEBUG [mondrian.sql] 1183: , exec 0 ms 2026-08-03 15:23:59,693 DEBUG [mondrian.sql] 1183: , exec+fetch 0 ms, 1 rows 2026-08-03 15:23:59,710 DEBUG [mondrian.sql] 1184: SqlStatisticsProvider.getTableCardinality: executing sql [select count(*) from "agg_g_ms_pcat_sales_fact_1997"] 2026-08-03 15:23:59,710 DEBUG [mondrian.sql] 1184: , exec 0 ms 2026-08-03 15:23:59,710 DEBUG [mondrian.sql] 1184: , exec+fetch 0 ms, 1 rows 2026-08-03 15:23:59,710 DEBUG [mondrian.sql] 1185: 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-08-03 15:23:59,711 DEBUG [mondrian.sql] 1185: , exec 0 ms 2026-08-03 15:23:59,711 DEBUG [mondrian.sql] 1185: , exec+fetch 1 ms, 1 rows 2026-08-03 15:23:59,726 DEBUG [mondrian.sql] 1186: SqlStatisticsProvider.getTableCardinality: executing sql [select count(*) from "agg_l_03_sales_fact_1997"] 2026-08-03 15:23:59,726 DEBUG [mondrian.sql] 1186: , exec 0 ms 2026-08-03 15:23:59,726 DEBUG [mondrian.sql] 1186: , exec+fetch 0 ms, 1 rows 2026-08-03 15:23:59,726 DEBUG [mondrian.sql] 1187: AggStar.FactTable.makeNumberOfRows: executing sql [ select count(*) as "c0" from "agg_l_03_sales_fact_1997" as "agg_l_03_sales_fact_1997"] 2026-08-03 15:23:59,727 DEBUG [mondrian.sql] 1187: , exec 0 ms 2026-08-03 15:23:59,727 DEBUG [mondrian.sql] 1187: , exec+fetch 1 ms, 1 rows 2026-08-03 15:23:59,739 DEBUG [mondrian.sql] 1188: SqlStatisticsProvider.getTableCardinality: executing sql [select count(*) from "agg_l_04_sales_fact_1997"] 2026-08-03 15:23:59,739 DEBUG [mondrian.sql] 1188: , exec 0 ms 2026-08-03 15:23:59,739 DEBUG [mondrian.sql] 1188: , exec+fetch 0 ms, 1 rows 2026-08-03 15:23:59,739 DEBUG [mondrian.sql] 1189: AggStar.FactTable.makeNumberOfRows: executing sql [ select count(*) as "c0" from "agg_l_04_sales_fact_1997" as "agg_l_04_sales_fact_1997"] 2026-08-03 15:23:59,739 DEBUG [mondrian.sql] 1189: , exec 0 ms 2026-08-03 15:23:59,739 DEBUG [mondrian.sql] 1189: , exec+fetch 0 ms, 1 rows 2026-08-03 15:23:59,753 DEBUG [mondrian.sql] 1190: SqlStatisticsProvider.getTableCardinality: executing sql [select count(*) from "agg_l_05_sales_fact_1997"] 2026-08-03 15:23:59,753 DEBUG [mondrian.sql] 1190: , exec 0 ms 2026-08-03 15:23:59,753 DEBUG [mondrian.sql] 1190: , exec+fetch 0 ms, 1 rows 2026-08-03 15:23:59,753 DEBUG [mondrian.sql] 1191: AggStar.FactTable.makeNumberOfRows: executing sql [ select count(*) as "c0" from "agg_l_05_sales_fact_1997" as "agg_l_05_sales_fact_1997"] 2026-08-03 15:23:59,753 DEBUG [mondrian.sql] 1191: , exec 0 ms 2026-08-03 15:23:59,753 DEBUG [mondrian.sql] 1191: , exec+fetch 0 ms, 1 rows 2026-08-03 15:23:59,768 DEBUG [mondrian.sql] 1192: SqlStatisticsProvider.getTableCardinality: executing sql [select count(*) from "agg_lc_06_sales_fact_1997"] 2026-08-03 15:23:59,768 DEBUG [mondrian.sql] 1192: , exec 0 ms 2026-08-03 15:23:59,768 DEBUG [mondrian.sql] 1192: , exec+fetch 0 ms, 1 rows 2026-08-03 15:23:59,769 DEBUG [mondrian.sql] 1193: AggStar.FactTable.makeNumberOfRows: executing sql [ select count(*) as "c0" from "agg_lc_06_sales_fact_1997" as "agg_lc_06_sales_fact_1997"] 2026-08-03 15:23:59,769 DEBUG [mondrian.sql] 1193: , exec 0 ms 2026-08-03 15:23:59,769 DEBUG [mondrian.sql] 1193: , exec+fetch 0 ms, 1 rows 2026-08-03 15:23:59,781 DEBUG [mondrian.sql] 1194: SqlStatisticsProvider.getTableCardinality: executing sql [select count(*) from "agg_ll_01_sales_fact_1997"] 2026-08-03 15:23:59,781 DEBUG [mondrian.sql] 1194: , exec 0 ms 2026-08-03 15:23:59,781 DEBUG [mondrian.sql] 1194: , exec+fetch 0 ms, 1 rows 2026-08-03 15:23:59,782 DEBUG [mondrian.sql] 1195: AggStar.FactTable.makeNumberOfRows: executing sql [ select count(*) as "c0" from "agg_ll_01_sales_fact_1997" as "agg_ll_01_sales_fact_1997"] 2026-08-03 15:23:59,782 DEBUG [mondrian.sql] 1195: , exec 0 ms 2026-08-03 15:23:59,782 DEBUG [mondrian.sql] 1195: , exec+fetch 0 ms, 1 rows 2026-08-03 15:23:59,794 DEBUG [mondrian.sql] 1196: SqlStatisticsProvider.getTableCardinality: executing sql [select count(*) from "agg_pl_01_sales_fact_1997"] 2026-08-03 15:23:59,795 DEBUG [mondrian.sql] 1196: , exec 0 ms 2026-08-03 15:23:59,795 DEBUG [mondrian.sql] 1196: , exec+fetch 1 ms, 1 rows 2026-08-03 15:23:59,795 DEBUG [mondrian.sql] 1197: AggStar.FactTable.makeNumberOfRows: executing sql [ select count(*) as "c0" from "agg_pl_01_sales_fact_1997" as "agg_pl_01_sales_fact_1997"] 2026-08-03 15:23:59,795 DEBUG [mondrian.sql] 1197: , exec 0 ms 2026-08-03 15:23:59,795 DEBUG [mondrian.sql] 1197: , exec+fetch 0 ms, 1 rows 2026-08-03 15:24:00,049 DEBUG [mondrian.sql] 1198: SqlMemberSource.getLevelMemberCount: executing sql [ select count(*) as "c0" from (select distinct "customer"."country" as "c0" from "customer" as "customer") as "init"] 2026-08-03 15:24:00,073 DEBUG [mondrian.sql] 1198: , exec 23 ms 2026-08-03 15:24:00,073 DEBUG [mondrian.sql] 1198: , exec+fetch 24 ms, 1 rows 2026-08-03 15:24:00,074 DEBUG [mondrian.sql] 1199: 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-08-03 15:24:00,080 DEBUG [mondrian.sql] 1199: , exec 6 ms 2026-08-03 15:24:00,080 DEBUG [mondrian.sql] 1199: , exec+fetch 6 ms, 3 rows 2026-08-03 15:24:00,080 DEBUG [mondrian.sql] 1200: 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-08-03 15:24:00,085 DEBUG [mondrian.sql] 1200: , exec 4 ms 2026-08-03 15:24:00,085 DEBUG [mondrian.sql] 1200: , exec+fetch 5 ms, 3 rows 2026-08-03 15:24:00,086 DEBUG [mondrian.sql] 1201: 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-08-03 15:24:00,086 DEBUG [mondrian.sql] 1201: , exec 0 ms 2026-08-03 15:24:00,086 DEBUG [mondrian.sql] 1201: , exec+fetch 0 ms, 2 rows 2026-08-03 15:24:00,087 DEBUG [mondrian.sql] 1202: 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-08-03 15:24:00,087 DEBUG [mondrian.sql] 1202: , exec 0 ms 2026-08-03 15:24:00,088 DEBUG [mondrian.sql] 1202: , exec+fetch 1 ms, 2 rows 2026-08-03 15:24:00,092 DEBUG [mondrian.sql] 1203: 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-08-03 15:24:00,092 DEBUG [mondrian.sql] 1203: , exec 0 ms 2026-08-03 15:24:00,092 DEBUG [mondrian.sql] 1203: , exec+fetch 0 ms, 2 rows 2026-08-03 15:24:00,092 DEBUG [mondrian.sql] 1204: 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-08-03 15:24:00,092 DEBUG [mondrian.sql] 1204: , exec 0 ms 2026-08-03 15:24:00,093 DEBUG [mondrian.sql] 1204: , exec+fetch 1 ms, 2 rows 2026-08-03 15:24:00,098 DEBUG [mondrian.sql] 1205: 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-08-03 15:24:00,099 DEBUG [mondrian.sql] 1205: , exec 0 ms 2026-08-03 15:24:00,099 DEBUG [mondrian.sql] 1205: , exec+fetch 1 ms, 2 rows 2026-08-03 15:24:00,099 DEBUG [mondrian.sql] 1206: 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-08-03 15:24:00,099 DEBUG [mondrian.sql] 1206: , exec 0 ms 2026-08-03 15:24:00,099 DEBUG [mondrian.sql] 1206: , exec+fetch 0 ms, 2 rows 2026-08-03 15:24:00,102 DEBUG [mondrian.sql] 1207: 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-08-03 15:24:00,103 DEBUG [mondrian.sql] 1207: , exec 1 ms 2026-08-03 15:24:00,104 DEBUG [mondrian.sql] 1207: , exec+fetch 2 ms, 1 rows 2026-08-03 15:24:00,104 DEBUG [mondrian.sql] 1208: 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-08-03 15:24:00,104 DEBUG [mondrian.sql] 1208: , exec 0 ms 2026-08-03 15:24:00,104 DEBUG [mondrian.sql] 1208: , exec+fetch 0 ms, 8 rows 2026-08-03 15:24:00,121 DEBUG [mondrian.sql] 1209: SqlStatisticsProvider.getTableCardinality: executing sql [select count(*) from "agg_c_10_sales_fact_1997"] 2026-08-03 15:24:00,122 DEBUG [mondrian.sql] 1209: , exec 0 ms 2026-08-03 15:24:00,122 DEBUG [mondrian.sql] 1209: , exec+fetch 1 ms, 1 rows 2026-08-03 15:24:00,122 DEBUG [mondrian.sql] 1210: AggStar.FactTable.makeNumberOfRows: executing sql [ select count(*) as "c0" from "agg_c_10_sales_fact_1997" as "agg_c_10_sales_fact_1997"] 2026-08-03 15:24:00,122 DEBUG [mondrian.sql] 1210: , exec 0 ms 2026-08-03 15:24:00,122 DEBUG [mondrian.sql] 1210: , exec+fetch 0 ms, 1 rows 2026-08-03 15:24:00,137 DEBUG [mondrian.sql] 1211: SqlStatisticsProvider.getTableCardinality: executing sql [select count(*) from "agg_c_14_sales_fact_1997"] 2026-08-03 15:24:00,137 DEBUG [mondrian.sql] 1211: , exec 0 ms 2026-08-03 15:24:00,137 DEBUG [mondrian.sql] 1211: , exec+fetch 0 ms, 1 rows 2026-08-03 15:24:00,137 DEBUG [mondrian.sql] 1212: AggStar.FactTable.makeNumberOfRows: executing sql [ select count(*) as "c0" from "agg_c_14_sales_fact_1997" as "agg_c_14_sales_fact_1997"] 2026-08-03 15:24:00,138 DEBUG [mondrian.sql] 1212: , exec 0 ms 2026-08-03 15:24:00,138 DEBUG [mondrian.sql] 1212: , exec+fetch 0 ms, 1 rows 2026-08-03 15:24:00,152 DEBUG [mondrian.sql] 1213: SqlStatisticsProvider.getTableCardinality: executing sql [select count(*) from "agg_g_ms_pcat_sales_fact_1997"] 2026-08-03 15:24:00,152 DEBUG [mondrian.sql] 1213: , exec 0 ms 2026-08-03 15:24:00,153 DEBUG [mondrian.sql] 1213: , exec+fetch 0 ms, 1 rows 2026-08-03 15:24:00,153 DEBUG [mondrian.sql] 1214: 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-08-03 15:24:00,153 DEBUG [mondrian.sql] 1214: , exec 0 ms 2026-08-03 15:24:00,153 DEBUG [mondrian.sql] 1214: , exec+fetch 0 ms, 1 rows 2026-08-03 15:24:00,168 DEBUG [mondrian.sql] 1215: SqlStatisticsProvider.getTableCardinality: executing sql [select count(*) from "agg_l_03_sales_fact_1997"] 2026-08-03 15:24:00,168 DEBUG [mondrian.sql] 1215: , exec 0 ms 2026-08-03 15:24:00,168 DEBUG [mondrian.sql] 1215: , exec+fetch 0 ms, 1 rows 2026-08-03 15:24:00,168 DEBUG [mondrian.sql] 1216: AggStar.FactTable.makeNumberOfRows: executing sql [ select count(*) as "c0" from "agg_l_03_sales_fact_1997" as "agg_l_03_sales_fact_1997"] 2026-08-03 15:24:00,168 DEBUG [mondrian.sql] 1216: , exec 0 ms 2026-08-03 15:24:00,168 DEBUG [mondrian.sql] 1216: , exec+fetch 0 ms, 1 rows 2026-08-03 15:24:00,183 DEBUG [mondrian.sql] 1217: SqlStatisticsProvider.getTableCardinality: executing sql [select count(*) from "agg_l_04_sales_fact_1997"] 2026-08-03 15:24:00,183 DEBUG [mondrian.sql] 1217: , exec 0 ms 2026-08-03 15:24:00,183 DEBUG [mondrian.sql] 1217: , exec+fetch 0 ms, 1 rows 2026-08-03 15:24:00,183 DEBUG [mondrian.sql] 1218: AggStar.FactTable.makeNumberOfRows: executing sql [ select count(*) as "c0" from "agg_l_04_sales_fact_1997" as "agg_l_04_sales_fact_1997"] 2026-08-03 15:24:00,183 DEBUG [mondrian.sql] 1218: , exec 0 ms 2026-08-03 15:24:00,183 DEBUG [mondrian.sql] 1218: , exec+fetch 0 ms, 1 rows 2026-08-03 15:24:00,197 DEBUG [mondrian.sql] 1219: SqlStatisticsProvider.getTableCardinality: executing sql [select count(*) from "agg_l_05_sales_fact_1997"] 2026-08-03 15:24:00,197 DEBUG [mondrian.sql] 1219: , exec 0 ms 2026-08-03 15:24:00,197 DEBUG [mondrian.sql] 1219: , exec+fetch 0 ms, 1 rows 2026-08-03 15:24:00,197 DEBUG [mondrian.sql] 1220: AggStar.FactTable.makeNumberOfRows: executing sql [ select count(*) as "c0" from "agg_l_05_sales_fact_1997" as "agg_l_05_sales_fact_1997"] 2026-08-03 15:24:00,197 DEBUG [mondrian.sql] 1220: , exec 0 ms 2026-08-03 15:24:00,198 DEBUG [mondrian.sql] 1220: , exec+fetch 1 ms, 1 rows 2026-08-03 15:24:00,213 DEBUG [mondrian.sql] 1221: SqlStatisticsProvider.getTableCardinality: executing sql [select count(*) from "agg_lc_06_sales_fact_1997"] 2026-08-03 15:24:00,213 DEBUG [mondrian.sql] 1221: , exec 0 ms 2026-08-03 15:24:00,213 DEBUG [mondrian.sql] 1221: , exec+fetch 0 ms, 1 rows 2026-08-03 15:24:00,213 DEBUG [mondrian.sql] 1222: AggStar.FactTable.makeNumberOfRows: executing sql [ select count(*) as "c0" from "agg_lc_06_sales_fact_1997" as "agg_lc_06_sales_fact_1997"] 2026-08-03 15:24:00,213 DEBUG [mondrian.sql] 1222: , exec 0 ms 2026-08-03 15:24:00,213 DEBUG [mondrian.sql] 1222: , exec+fetch 0 ms, 1 rows 2026-08-03 15:24:00,226 DEBUG [mondrian.sql] 1223: SqlStatisticsProvider.getTableCardinality: executing sql [select count(*) from "agg_ll_01_sales_fact_1997"] 2026-08-03 15:24:00,226 DEBUG [mondrian.sql] 1223: , exec 0 ms 2026-08-03 15:24:00,226 DEBUG [mondrian.sql] 1223: , exec+fetch 0 ms, 1 rows 2026-08-03 15:24:00,226 DEBUG [mondrian.sql] 1224: AggStar.FactTable.makeNumberOfRows: executing sql [ select count(*) as "c0" from "agg_ll_01_sales_fact_1997" as "agg_ll_01_sales_fact_1997"] 2026-08-03 15:24:00,226 DEBUG [mondrian.sql] 1224: , exec 0 ms 2026-08-03 15:24:00,226 DEBUG [mondrian.sql] 1224: , exec+fetch 0 ms, 1 rows 2026-08-03 15:24:00,240 DEBUG [mondrian.sql] 1225: SqlStatisticsProvider.getTableCardinality: executing sql [select count(*) from "agg_pl_01_sales_fact_1997"] 2026-08-03 15:24:00,240 DEBUG [mondrian.sql] 1225: , exec 0 ms 2026-08-03 15:24:00,240 DEBUG [mondrian.sql] 1225: , exec+fetch 0 ms, 1 rows 2026-08-03 15:24:00,240 DEBUG [mondrian.sql] 1226: AggStar.FactTable.makeNumberOfRows: executing sql [ select count(*) as "c0" from "agg_pl_01_sales_fact_1997" as "agg_pl_01_sales_fact_1997"] 2026-08-03 15:24:00,240 DEBUG [mondrian.sql] 1226: , exec 0 ms 2026-08-03 15:24:00,240 DEBUG [mondrian.sql] 1226: , exec+fetch 0 ms, 1 rows 2026-08-03 15:24:08,759 DEBUG [mondrian.sql] 1227: SqlMemberSource.getLevelMemberCount: executing sql [ select count(*) as "c0" from (select distinct "customer"."country" as "c0" from "customer" as "customer") as "init"] 2026-08-03 15:24:08,780 DEBUG [mondrian.sql] 1227: , exec 20 ms 2026-08-03 15:24:08,780 DEBUG [mondrian.sql] 1227: , exec+fetch 21 ms, 1 rows 2026-08-03 15:24:08,780 DEBUG [mondrian.sql] 1228: 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-08-03 15:24:08,784 DEBUG [mondrian.sql] 1228: , exec 3 ms 2026-08-03 15:24:08,784 DEBUG [mondrian.sql] 1228: , exec+fetch 4 ms, 3 rows 2026-08-03 15:24:08,784 DEBUG [mondrian.sql] 1229: 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-08-03 15:24:08,788 DEBUG [mondrian.sql] 1229: , exec 3 ms 2026-08-03 15:24:08,788 DEBUG [mondrian.sql] 1229: , exec+fetch 4 ms, 3 rows 2026-08-03 15:24:08,788 DEBUG [mondrian.sql] 1230: 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-08-03 15:24:08,789 DEBUG [mondrian.sql] 1230: , exec 0 ms 2026-08-03 15:24:08,789 DEBUG [mondrian.sql] 1230: , exec+fetch 0 ms, 2 rows 2026-08-03 15:24:08,790 DEBUG [mondrian.sql] 1231: 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-08-03 15:24:08,790 DEBUG [mondrian.sql] 1231: , exec 0 ms 2026-08-03 15:24:08,790 DEBUG [mondrian.sql] 1231: , exec+fetch 0 ms, 2 rows 2026-08-03 15:24:08,793 DEBUG [mondrian.sql] 1232: 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-08-03 15:24:08,794 DEBUG [mondrian.sql] 1232: , exec 0 ms 2026-08-03 15:24:08,794 DEBUG [mondrian.sql] 1232: , exec+fetch 0 ms, 2 rows 2026-08-03 15:24:08,794 DEBUG [mondrian.sql] 1233: 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-08-03 15:24:08,794 DEBUG [mondrian.sql] 1233: , exec 0 ms 2026-08-03 15:24:08,794 DEBUG [mondrian.sql] 1233: , exec+fetch 0 ms, 2 rows 2026-08-03 15:24:08,800 DEBUG [mondrian.sql] 1234: 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-08-03 15:24:08,800 DEBUG [mondrian.sql] 1234: , exec 0 ms 2026-08-03 15:24:08,800 DEBUG [mondrian.sql] 1234: , exec+fetch 0 ms, 2 rows 2026-08-03 15:24:08,800 DEBUG [mondrian.sql] 1235: 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-08-03 15:24:08,801 DEBUG [mondrian.sql] 1235: , exec 0 ms 2026-08-03 15:24:08,801 DEBUG [mondrian.sql] 1235: , exec+fetch 1 ms, 2 rows 2026-08-03 15:24:08,805 DEBUG [mondrian.sql] 1236: 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-08-03 15:24:08,806 DEBUG [mondrian.sql] 1236: , exec 1 ms 2026-08-03 15:24:08,806 DEBUG [mondrian.sql] 1236: , exec+fetch 1 ms, 1 rows 2026-08-03 15:24:08,806 DEBUG [mondrian.sql] 1237: 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-08-03 15:24:08,807 DEBUG [mondrian.sql] 1237: , exec 0 ms 2026-08-03 15:24:08,807 DEBUG [mondrian.sql] 1237: , exec+fetch 1 ms, 8 rows 2026-08-03 15:24:08,825 DEBUG [mondrian.sql] 1238: SqlStatisticsProvider.getTableCardinality: executing sql [select count(*) from "agg_c_10_sales_fact_1997"] 2026-08-03 15:24:08,825 DEBUG [mondrian.sql] 1238: , exec 0 ms 2026-08-03 15:24:08,825 DEBUG [mondrian.sql] 1238: , exec+fetch 0 ms, 1 rows 2026-08-03 15:24:08,825 DEBUG [mondrian.sql] 1239: AggStar.FactTable.makeNumberOfRows: executing sql [ select count(*) as "c0" from "agg_c_10_sales_fact_1997" as "agg_c_10_sales_fact_1997"] 2026-08-03 15:24:08,825 DEBUG [mondrian.sql] 1239: , exec 0 ms 2026-08-03 15:24:08,825 DEBUG [mondrian.sql] 1239: , exec+fetch 0 ms, 1 rows 2026-08-03 15:24:08,840 DEBUG [mondrian.sql] 1240: SqlStatisticsProvider.getTableCardinality: executing sql [select count(*) from "agg_c_14_sales_fact_1997"] 2026-08-03 15:24:08,841 DEBUG [mondrian.sql] 1240: , exec 0 ms 2026-08-03 15:24:08,841 DEBUG [mondrian.sql] 1240: , exec+fetch 1 ms, 1 rows 2026-08-03 15:24:08,841 DEBUG [mondrian.sql] 1241: AggStar.FactTable.makeNumberOfRows: executing sql [ select count(*) as "c0" from "agg_c_14_sales_fact_1997" as "agg_c_14_sales_fact_1997"] 2026-08-03 15:24:08,841 DEBUG [mondrian.sql] 1241: , exec 0 ms 2026-08-03 15:24:08,841 DEBUG [mondrian.sql] 1241: , exec+fetch 0 ms, 1 rows 2026-08-03 15:24:08,856 DEBUG [mondrian.sql] 1242: SqlStatisticsProvider.getTableCardinality: executing sql [select count(*) from "agg_g_ms_pcat_sales_fact_1997"] 2026-08-03 15:24:08,857 DEBUG [mondrian.sql] 1242: , exec 0 ms 2026-08-03 15:24:08,857 DEBUG [mondrian.sql] 1242: , exec+fetch 1 ms, 1 rows 2026-08-03 15:24:08,857 DEBUG [mondrian.sql] 1243: 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-08-03 15:24:08,857 DEBUG [mondrian.sql] 1243: , exec 0 ms 2026-08-03 15:24:08,857 DEBUG [mondrian.sql] 1243: , exec+fetch 0 ms, 1 rows 2026-08-03 15:24:08,873 DEBUG [mondrian.sql] 1244: SqlStatisticsProvider.getTableCardinality: executing sql [select count(*) from "agg_l_03_sales_fact_1997"] 2026-08-03 15:24:08,873 DEBUG [mondrian.sql] 1244: , exec 0 ms 2026-08-03 15:24:08,873 DEBUG [mondrian.sql] 1244: , exec+fetch 0 ms, 1 rows 2026-08-03 15:24:08,873 DEBUG [mondrian.sql] 1245: AggStar.FactTable.makeNumberOfRows: executing sql [ select count(*) as "c0" from "agg_l_03_sales_fact_1997" as "agg_l_03_sales_fact_1997"] 2026-08-03 15:24:08,873 DEBUG [mondrian.sql] 1245: , exec 0 ms 2026-08-03 15:24:08,873 DEBUG [mondrian.sql] 1245: , exec+fetch 0 ms, 1 rows 2026-08-03 15:24:08,889 DEBUG [mondrian.sql] 1246: SqlStatisticsProvider.getTableCardinality: executing sql [select count(*) from "agg_l_04_sales_fact_1997"] 2026-08-03 15:24:08,890 DEBUG [mondrian.sql] 1246: , exec 0 ms 2026-08-03 15:24:08,890 DEBUG [mondrian.sql] 1246: , exec+fetch 1 ms, 1 rows 2026-08-03 15:24:08,890 DEBUG [mondrian.sql] 1247: AggStar.FactTable.makeNumberOfRows: executing sql [ select count(*) as "c0" from "agg_l_04_sales_fact_1997" as "agg_l_04_sales_fact_1997"] 2026-08-03 15:24:08,890 DEBUG [mondrian.sql] 1247: , exec 0 ms 2026-08-03 15:24:08,890 DEBUG [mondrian.sql] 1247: , exec+fetch 0 ms, 1 rows 2026-08-03 15:24:08,903 DEBUG [mondrian.sql] 1248: SqlStatisticsProvider.getTableCardinality: executing sql [select count(*) from "agg_l_05_sales_fact_1997"] 2026-08-03 15:24:08,903 DEBUG [mondrian.sql] 1248: , exec 0 ms 2026-08-03 15:24:08,903 DEBUG [mondrian.sql] 1248: , exec+fetch 0 ms, 1 rows 2026-08-03 15:24:08,903 DEBUG [mondrian.sql] 1249: AggStar.FactTable.makeNumberOfRows: executing sql [ select count(*) as "c0" from "agg_l_05_sales_fact_1997" as "agg_l_05_sales_fact_1997"] 2026-08-03 15:24:08,904 DEBUG [mondrian.sql] 1249: , exec 0 ms 2026-08-03 15:24:08,904 DEBUG [mondrian.sql] 1249: , exec+fetch 1 ms, 1 rows 2026-08-03 15:24:08,918 DEBUG [mondrian.sql] 1250: SqlStatisticsProvider.getTableCardinality: executing sql [select count(*) from "agg_lc_06_sales_fact_1997"] 2026-08-03 15:24:08,919 DEBUG [mondrian.sql] 1250: , exec 0 ms 2026-08-03 15:24:08,919 DEBUG [mondrian.sql] 1250: , exec+fetch 1 ms, 1 rows 2026-08-03 15:24:08,919 DEBUG [mondrian.sql] 1251: AggStar.FactTable.makeNumberOfRows: executing sql [ select count(*) as "c0" from "agg_lc_06_sales_fact_1997" as "agg_lc_06_sales_fact_1997"] 2026-08-03 15:24:08,919 DEBUG [mondrian.sql] 1251: , exec 0 ms 2026-08-03 15:24:08,919 DEBUG [mondrian.sql] 1251: , exec+fetch 0 ms, 1 rows 2026-08-03 15:24:08,933 DEBUG [mondrian.sql] 1252: SqlStatisticsProvider.getTableCardinality: executing sql [select count(*) from "agg_ll_01_sales_fact_1997"] 2026-08-03 15:24:08,933 DEBUG [mondrian.sql] 1252: , exec 0 ms 2026-08-03 15:24:08,933 DEBUG [mondrian.sql] 1252: , exec+fetch 0 ms, 1 rows 2026-08-03 15:24:08,934 DEBUG [mondrian.sql] 1253: AggStar.FactTable.makeNumberOfRows: executing sql [ select count(*) as "c0" from "agg_ll_01_sales_fact_1997" as "agg_ll_01_sales_fact_1997"] 2026-08-03 15:24:08,934 DEBUG [mondrian.sql] 1253: , exec 0 ms 2026-08-03 15:24:08,934 DEBUG [mondrian.sql] 1253: , exec+fetch 0 ms, 1 rows 2026-08-03 15:24:08,948 DEBUG [mondrian.sql] 1254: SqlStatisticsProvider.getTableCardinality: executing sql [select count(*) from "agg_pl_01_sales_fact_1997"] 2026-08-03 15:24:08,948 DEBUG [mondrian.sql] 1254: , exec 0 ms 2026-08-03 15:24:08,948 DEBUG [mondrian.sql] 1254: , exec+fetch 0 ms, 1 rows 2026-08-03 15:24:08,948 DEBUG [mondrian.sql] 1255: AggStar.FactTable.makeNumberOfRows: executing sql [ select count(*) as "c0" from "agg_pl_01_sales_fact_1997" as "agg_pl_01_sales_fact_1997"] 2026-08-03 15:24:08,948 DEBUG [mondrian.sql] 1255: , exec 0 ms 2026-08-03 15:24:08,948 DEBUG [mondrian.sql] 1255: , exec+fetch 0 ms, 1 rows 2026-08-03 15:24:09,184 DEBUG [mondrian.sql] 1256: SqlMemberSource.getLevelMemberCount: executing sql [ select count(*) as "c0" from (select distinct "customer"."country" as "c0" from "customer" as "customer") as "init"] 2026-08-03 15:24:09,205 DEBUG [mondrian.sql] 1256: , exec 21 ms 2026-08-03 15:24:09,205 DEBUG [mondrian.sql] 1256: , exec+fetch 21 ms, 1 rows 2026-08-03 15:24:09,205 DEBUG [mondrian.sql] 1257: 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-08-03 15:24:09,210 DEBUG [mondrian.sql] 1257: , exec 4 ms 2026-08-03 15:24:09,210 DEBUG [mondrian.sql] 1257: , exec+fetch 5 ms, 3 rows 2026-08-03 15:24:09,210 DEBUG [mondrian.sql] 1258: 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-08-03 15:24:09,215 DEBUG [mondrian.sql] 1258: , exec 4 ms 2026-08-03 15:24:09,215 DEBUG [mondrian.sql] 1258: , exec+fetch 4 ms, 3 rows 2026-08-03 15:24:09,215 DEBUG [mondrian.sql] 1259: 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-08-03 15:24:09,216 DEBUG [mondrian.sql] 1259: , exec 0 ms 2026-08-03 15:24:09,216 DEBUG [mondrian.sql] 1259: , exec+fetch 1 ms, 2 rows 2026-08-03 15:24:09,216 DEBUG [mondrian.sql] 1260: 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-08-03 15:24:09,217 DEBUG [mondrian.sql] 1260: , exec 0 ms 2026-08-03 15:24:09,217 DEBUG [mondrian.sql] 1260: , exec+fetch 0 ms, 2 rows 2026-08-03 15:24:09,220 DEBUG [mondrian.sql] 1261: 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-08-03 15:24:09,220 DEBUG [mondrian.sql] 1261: , exec 0 ms 2026-08-03 15:24:09,220 DEBUG [mondrian.sql] 1261: , exec+fetch 0 ms, 2 rows 2026-08-03 15:24:09,220 DEBUG [mondrian.sql] 1262: 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-08-03 15:24:09,220 DEBUG [mondrian.sql] 1262: , exec 0 ms 2026-08-03 15:24:09,220 DEBUG [mondrian.sql] 1262: , exec+fetch 0 ms, 2 rows 2026-08-03 15:24:09,226 DEBUG [mondrian.sql] 1263: 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-08-03 15:24:09,226 DEBUG [mondrian.sql] 1263: , exec 0 ms 2026-08-03 15:24:09,226 DEBUG [mondrian.sql] 1263: , exec+fetch 0 ms, 2 rows 2026-08-03 15:24:09,227 DEBUG [mondrian.sql] 1264: 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-08-03 15:24:09,227 DEBUG [mondrian.sql] 1264: , exec 0 ms 2026-08-03 15:24:09,227 DEBUG [mondrian.sql] 1264: , exec+fetch 0 ms, 2 rows 2026-08-03 15:24:09,230 DEBUG [mondrian.sql] 1265: 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-08-03 15:24:09,231 DEBUG [mondrian.sql] 1265: , exec 1 ms 2026-08-03 15:24:09,231 DEBUG [mondrian.sql] 1265: , exec+fetch 1 ms, 1 rows 2026-08-03 15:24:09,231 DEBUG [mondrian.sql] 1266: 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-08-03 15:24:09,232 DEBUG [mondrian.sql] 1266: , exec 0 ms 2026-08-03 15:24:09,232 DEBUG [mondrian.sql] 1266: , exec+fetch 1 ms, 8 rows 2026-08-03 15:24:09,248 DEBUG [mondrian.sql] 1267: SqlStatisticsProvider.getTableCardinality: executing sql [select count(*) from "agg_c_10_sales_fact_1997"] 2026-08-03 15:24:09,248 DEBUG [mondrian.sql] 1267: , exec 0 ms 2026-08-03 15:24:09,248 DEBUG [mondrian.sql] 1267: , exec+fetch 0 ms, 1 rows 2026-08-03 15:24:09,248 DEBUG [mondrian.sql] 1268: AggStar.FactTable.makeNumberOfRows: executing sql [ select count(*) as "c0" from "agg_c_10_sales_fact_1997" as "agg_c_10_sales_fact_1997"] 2026-08-03 15:24:09,248 DEBUG [mondrian.sql] 1268: , exec 0 ms 2026-08-03 15:24:09,248 DEBUG [mondrian.sql] 1268: , exec+fetch 0 ms, 1 rows 2026-08-03 15:24:09,262 DEBUG [mondrian.sql] 1269: SqlStatisticsProvider.getTableCardinality: executing sql [select count(*) from "agg_c_14_sales_fact_1997"] 2026-08-03 15:24:09,263 DEBUG [mondrian.sql] 1269: , exec 0 ms 2026-08-03 15:24:09,263 DEBUG [mondrian.sql] 1269: , exec+fetch 1 ms, 1 rows 2026-08-03 15:24:09,263 DEBUG [mondrian.sql] 1270: AggStar.FactTable.makeNumberOfRows: executing sql [ select count(*) as "c0" from "agg_c_14_sales_fact_1997" as "agg_c_14_sales_fact_1997"] 2026-08-03 15:24:09,263 DEBUG [mondrian.sql] 1270: , exec 0 ms 2026-08-03 15:24:09,263 DEBUG [mondrian.sql] 1270: , exec+fetch 0 ms, 1 rows 2026-08-03 15:24:09,279 DEBUG [mondrian.sql] 1271: SqlStatisticsProvider.getTableCardinality: executing sql [select count(*) from "agg_g_ms_pcat_sales_fact_1997"] 2026-08-03 15:24:09,279 DEBUG [mondrian.sql] 1271: , exec 0 ms 2026-08-03 15:24:09,279 DEBUG [mondrian.sql] 1271: , exec+fetch 0 ms, 1 rows 2026-08-03 15:24:09,279 DEBUG [mondrian.sql] 1272: 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-08-03 15:24:09,279 DEBUG [mondrian.sql] 1272: , exec 0 ms 2026-08-03 15:24:09,279 DEBUG [mondrian.sql] 1272: , exec+fetch 0 ms, 1 rows 2026-08-03 15:24:09,293 DEBUG [mondrian.sql] 1273: SqlStatisticsProvider.getTableCardinality: executing sql [select count(*) from "agg_l_03_sales_fact_1997"] 2026-08-03 15:24:09,293 DEBUG [mondrian.sql] 1273: , exec 0 ms 2026-08-03 15:24:09,293 DEBUG [mondrian.sql] 1273: , exec+fetch 0 ms, 1 rows 2026-08-03 15:24:09,294 DEBUG [mondrian.sql] 1274: AggStar.FactTable.makeNumberOfRows: executing sql [ select count(*) as "c0" from "agg_l_03_sales_fact_1997" as "agg_l_03_sales_fact_1997"] 2026-08-03 15:24:09,294 DEBUG [mondrian.sql] 1274: , exec 0 ms 2026-08-03 15:24:09,294 DEBUG [mondrian.sql] 1274: , exec+fetch 0 ms, 1 rows 2026-08-03 15:24:09,308 DEBUG [mondrian.sql] 1275: SqlStatisticsProvider.getTableCardinality: executing sql [select count(*) from "agg_l_04_sales_fact_1997"] 2026-08-03 15:24:09,309 DEBUG [mondrian.sql] 1275: , exec 0 ms 2026-08-03 15:24:09,309 DEBUG [mondrian.sql] 1275: , exec+fetch 1 ms, 1 rows 2026-08-03 15:24:09,309 DEBUG [mondrian.sql] 1276: AggStar.FactTable.makeNumberOfRows: executing sql [ select count(*) as "c0" from "agg_l_04_sales_fact_1997" as "agg_l_04_sales_fact_1997"] 2026-08-03 15:24:09,309 DEBUG [mondrian.sql] 1276: , exec 0 ms 2026-08-03 15:24:09,309 DEBUG [mondrian.sql] 1276: , exec+fetch 0 ms, 1 rows 2026-08-03 15:24:09,322 DEBUG [mondrian.sql] 1277: SqlStatisticsProvider.getTableCardinality: executing sql [select count(*) from "agg_l_05_sales_fact_1997"] 2026-08-03 15:24:09,323 DEBUG [mondrian.sql] 1277: , exec 0 ms 2026-08-03 15:24:09,323 DEBUG [mondrian.sql] 1277: , exec+fetch 0 ms, 1 rows 2026-08-03 15:24:09,323 DEBUG [mondrian.sql] 1278: AggStar.FactTable.makeNumberOfRows: executing sql [ select count(*) as "c0" from "agg_l_05_sales_fact_1997" as "agg_l_05_sales_fact_1997"] 2026-08-03 15:24:09,323 DEBUG [mondrian.sql] 1278: , exec 0 ms 2026-08-03 15:24:09,323 DEBUG [mondrian.sql] 1278: , exec+fetch 0 ms, 1 rows 2026-08-03 15:24:09,336 DEBUG [mondrian.sql] 1279: SqlStatisticsProvider.getTableCardinality: executing sql [select count(*) from "agg_lc_06_sales_fact_1997"] 2026-08-03 15:24:09,336 DEBUG [mondrian.sql] 1279: , exec 0 ms 2026-08-03 15:24:09,336 DEBUG [mondrian.sql] 1279: , exec+fetch 0 ms, 1 rows 2026-08-03 15:24:09,336 DEBUG [mondrian.sql] 1280: AggStar.FactTable.makeNumberOfRows: executing sql [ select count(*) as "c0" from "agg_lc_06_sales_fact_1997" as "agg_lc_06_sales_fact_1997"] 2026-08-03 15:24:09,336 DEBUG [mondrian.sql] 1280: , exec 0 ms 2026-08-03 15:24:09,336 DEBUG [mondrian.sql] 1280: , exec+fetch 0 ms, 1 rows 2026-08-03 15:24:09,347 DEBUG [mondrian.sql] 1281: SqlStatisticsProvider.getTableCardinality: executing sql [select count(*) from "agg_ll_01_sales_fact_1997"] 2026-08-03 15:24:09,347 DEBUG [mondrian.sql] 1281: , exec 0 ms 2026-08-03 15:24:09,347 DEBUG [mondrian.sql] 1281: , exec+fetch 0 ms, 1 rows 2026-08-03 15:24:09,347 DEBUG [mondrian.sql] 1282: AggStar.FactTable.makeNumberOfRows: executing sql [ select count(*) as "c0" from "agg_ll_01_sales_fact_1997" as "agg_ll_01_sales_fact_1997"] 2026-08-03 15:24:09,347 DEBUG [mondrian.sql] 1282: , exec 0 ms 2026-08-03 15:24:09,347 DEBUG [mondrian.sql] 1282: , exec+fetch 0 ms, 1 rows 2026-08-03 15:24:09,359 DEBUG [mondrian.sql] 1283: SqlStatisticsProvider.getTableCardinality: executing sql [select count(*) from "agg_pl_01_sales_fact_1997"] 2026-08-03 15:24:09,360 DEBUG [mondrian.sql] 1283: , exec 0 ms 2026-08-03 15:24:09,360 DEBUG [mondrian.sql] 1283: , exec+fetch 0 ms, 1 rows 2026-08-03 15:24:09,360 DEBUG [mondrian.sql] 1284: AggStar.FactTable.makeNumberOfRows: executing sql [ select count(*) as "c0" from "agg_pl_01_sales_fact_1997" as "agg_pl_01_sales_fact_1997"] 2026-08-03 15:24:09,360 DEBUG [mondrian.sql] 1284: , exec 0 ms 2026-08-03 15:24:09,360 DEBUG [mondrian.sql] 1284: , exec+fetch 0 ms, 1 rows 2026-08-03 15:24:09,581 WARN [mondrian.xmla.Rowset] Warning: Rowset 'DISCOVER_PROPERTIES' does not support property 'ClientProcessID' (value is '17508') 2026-08-03 15:24:09,581 WARN [mondrian.xmla.Rowset] Warning: Rowset 'DISCOVER_PROPERTIES' does not support property 'MdxMissingMemberMode' (value is 'Error') 2026-08-03 15:24:09,581 WARN [mondrian.xmla.Rowset] Warning: Rowset 'DISCOVER_PROPERTIES' does not support property 'DbpropMsmdMDXCompatibility' (value is '1') 2026-08-03 15:24:09,581 WARN [mondrian.xmla.Rowset] Warning: Rowset 'DISCOVER_PROPERTIES' does not support property 'DbpropMsmdSubqueries' (value is '2') 2026-08-03 15:24:09,581 WARN [mondrian.xmla.Rowset] Warning: Rowset 'DISCOVER_PROPERTIES' does not support property 'SspropInitAppName' (value is 'Excel') 2026-08-03 15:24:09,581 WARN [mondrian.xmla.Rowset] Warning: Rowset 'DISCOVER_PROPERTIES' does not support property 'SafetyOptions' (value is '2') 2026-08-03 15:24:09,800 WARN [mondrian.xmla.Rowset] Warning: Rowset 'DISCOVER_PROPERTIES' does not support property 'ClientProcessID' (value is '17508') 2026-08-03 15:24:09,800 WARN [mondrian.xmla.Rowset] Warning: Rowset 'DISCOVER_PROPERTIES' does not support property 'MdxMissingMemberMode' (value is 'Error') 2026-08-03 15:24:09,800 WARN [mondrian.xmla.Rowset] Warning: Rowset 'DISCOVER_PROPERTIES' does not support property 'DbpropMsmdMDXCompatibility' (value is '1') 2026-08-03 15:24:09,800 WARN [mondrian.xmla.Rowset] Warning: Rowset 'DISCOVER_PROPERTIES' does not support property 'DbpropMsmdSubqueries' (value is '2') 2026-08-03 15:24:09,800 WARN [mondrian.xmla.Rowset] Warning: Rowset 'DISCOVER_PROPERTIES' does not support property 'SspropInitAppName' (value is 'Excel') 2026-08-03 15:24:09,800 WARN [mondrian.xmla.Rowset] Warning: Rowset 'DISCOVER_PROPERTIES' does not support property 'SafetyOptions' (value is '2') 2026-08-03 15:24:10,181 WARN [mondrian.xmla.Rowset] Warning: Rowset 'DISCOVER_SCHEMA_ROWSETS' does not support property 'ClientProcessID' (value is '17508') 2026-08-03 15:24:10,181 WARN [mondrian.xmla.Rowset] Warning: Rowset 'DISCOVER_SCHEMA_ROWSETS' does not support property 'MdxMissingMemberMode' (value is 'Error') 2026-08-03 15:24:10,181 WARN [mondrian.xmla.Rowset] Warning: Rowset 'DISCOVER_SCHEMA_ROWSETS' does not support property 'DbpropMsmdMDXCompatibility' (value is '1') 2026-08-03 15:24:10,181 WARN [mondrian.xmla.Rowset] Warning: Rowset 'DISCOVER_SCHEMA_ROWSETS' does not support property 'DbpropMsmdSubqueries' (value is '2') 2026-08-03 15:24:10,181 WARN [mondrian.xmla.Rowset] Warning: Rowset 'DISCOVER_SCHEMA_ROWSETS' does not support property 'SspropInitAppName' (value is 'Excel') 2026-08-03 15:24:10,181 WARN [mondrian.xmla.Rowset] Warning: Rowset 'DISCOVER_SCHEMA_ROWSETS' does not support property 'SafetyOptions' (value is '2') 2026-08-03 15:24:10,487 WARN [mondrian.xmla.Rowset] Warning: Rowset 'MDSCHEMA_PROPERTIES' does not support property 'ClientProcessID' (value is '17508') 2026-08-03 15:24:10,487 WARN [mondrian.xmla.Rowset] Warning: Rowset 'MDSCHEMA_PROPERTIES' does not support property 'MdxMissingMemberMode' (value is 'Error') 2026-08-03 15:24:10,487 WARN [mondrian.xmla.Rowset] Warning: Rowset 'MDSCHEMA_PROPERTIES' does not support property 'DbpropMsmdMDXCompatibility' (value is '1') 2026-08-03 15:24:10,487 WARN [mondrian.xmla.Rowset] Warning: Rowset 'MDSCHEMA_PROPERTIES' does not support property 'DbpropMsmdSubqueries' (value is '2') 2026-08-03 15:24:10,487 WARN [mondrian.xmla.Rowset] Warning: Rowset 'MDSCHEMA_PROPERTIES' does not support property 'SspropInitAppName' (value is 'Excel') 2026-08-03 15:24:10,487 WARN [mondrian.xmla.Rowset] Warning: Rowset 'MDSCHEMA_PROPERTIES' does not support property 'SafetyOptions' (value is '2') 2026-08-03 15:24:10,696 WARN [mondrian.xmla.Rowset] Warning: Rowset 'MDSCHEMA_CUBES' does not support property 'ClientProcessID' (value is '17508') 2026-08-03 15:24:10,696 WARN [mondrian.xmla.Rowset] Warning: Rowset 'MDSCHEMA_CUBES' does not support property 'MdxMissingMemberMode' (value is 'Error') 2026-08-03 15:24:10,696 WARN [mondrian.xmla.Rowset] Warning: Rowset 'MDSCHEMA_CUBES' does not support property 'DbpropMsmdMDXCompatibility' (value is '1') 2026-08-03 15:24:10,696 WARN [mondrian.xmla.Rowset] Warning: Rowset 'MDSCHEMA_CUBES' does not support property 'DbpropMsmdSubqueries' (value is '2') 2026-08-03 15:24:10,697 WARN [mondrian.xmla.Rowset] Warning: Rowset 'MDSCHEMA_CUBES' does not support property 'SspropInitAppName' (value is 'Excel') 2026-08-03 15:24:10,697 WARN [mondrian.xmla.Rowset] Warning: Rowset 'MDSCHEMA_CUBES' does not support property 'SafetyOptions' (value is '2') 2026-08-03 15:24:10,918 WARN [mondrian.xmla.Rowset] Warning: Rowset 'MDSCHEMA_CUBES' does not support property 'ClientProcessID' (value is '17508') 2026-08-03 15:24:10,918 WARN [mondrian.xmla.Rowset] Warning: Rowset 'MDSCHEMA_CUBES' does not support property 'MdxMissingMemberMode' (value is 'Error') 2026-08-03 15:24:10,918 WARN [mondrian.xmla.Rowset] Warning: Rowset 'MDSCHEMA_CUBES' does not support property 'DbpropMsmdMDXCompatibility' (value is '1') 2026-08-03 15:24:10,918 WARN [mondrian.xmla.Rowset] Warning: Rowset 'MDSCHEMA_CUBES' does not support property 'DbpropMsmdSubqueries' (value is '2') 2026-08-03 15:24:10,918 WARN [mondrian.xmla.Rowset] Warning: Rowset 'MDSCHEMA_CUBES' does not support property 'SspropInitAppName' (value is 'Excel') 2026-08-03 15:24:10,918 WARN [mondrian.xmla.Rowset] Warning: Rowset 'MDSCHEMA_CUBES' does not support property 'SafetyOptions' (value is '2') 2026-08-03 15:24:11,124 WARN [mondrian.xmla.Rowset] Warning: Rowset 'DISCOVER_SCHEMA_ROWSETS' does not support property 'ClientProcessID' (value is '17508') 2026-08-03 15:24:11,124 WARN [mondrian.xmla.Rowset] Warning: Rowset 'DISCOVER_SCHEMA_ROWSETS' does not support property 'MdxMissingMemberMode' (value is 'Error') 2026-08-03 15:24:11,124 WARN [mondrian.xmla.Rowset] Warning: Rowset 'DISCOVER_SCHEMA_ROWSETS' does not support property 'DbpropMsmdMDXCompatibility' (value is '1') 2026-08-03 15:24:11,125 WARN [mondrian.xmla.Rowset] Warning: Rowset 'DISCOVER_SCHEMA_ROWSETS' does not support property 'DbpropMsmdSubqueries' (value is '2') 2026-08-03 15:24:11,125 WARN [mondrian.xmla.Rowset] Warning: Rowset 'DISCOVER_SCHEMA_ROWSETS' does not support property 'SspropInitAppName' (value is 'Excel') 2026-08-03 15:24:11,125 WARN [mondrian.xmla.Rowset] Warning: Rowset 'DISCOVER_SCHEMA_ROWSETS' does not support property 'SafetyOptions' (value is '2') 2026-08-03 15:24:11,353 WARN [mondrian.xmla.Rowset] Warning: Rowset 'MDSCHEMA_HIERARCHIES' does not support property 'ClientProcessID' (value is '17508') 2026-08-03 15:24:11,353 WARN [mondrian.xmla.Rowset] Warning: Rowset 'MDSCHEMA_HIERARCHIES' does not support property 'MdxMissingMemberMode' (value is 'Error') 2026-08-03 15:24:11,353 WARN [mondrian.xmla.Rowset] Warning: Rowset 'MDSCHEMA_HIERARCHIES' does not support property 'DbpropMsmdMDXCompatibility' (value is '1') 2026-08-03 15:24:11,353 WARN [mondrian.xmla.Rowset] Warning: Rowset 'MDSCHEMA_HIERARCHIES' does not support property 'DbpropMsmdSubqueries' (value is '2') 2026-08-03 15:24:11,353 WARN [mondrian.xmla.Rowset] Warning: Rowset 'MDSCHEMA_HIERARCHIES' does not support property 'SspropInitAppName' (value is 'Excel') 2026-08-03 15:24:11,353 WARN [mondrian.xmla.Rowset] Warning: Rowset 'MDSCHEMA_HIERARCHIES' does not support property 'SafetyOptions' (value is '2') 2026-08-03 15:24:11,354 DEBUG [mondrian.sql] 1285: SqlMemberSource.getLevelMemberCount: executing sql [ select count(*) as "c0" from (select distinct "time_by_day_Time"."the_year" as "c0" from "time_by_day" as "time_by_day_Time") as "init"] 2026-08-03 15:24:11,355 DEBUG [mondrian.sql] 1285: , exec 0 ms 2026-08-03 15:24:11,355 DEBUG [mondrian.sql] 1285: , exec+fetch 0 ms, 1 rows 2026-08-03 15:24:11,355 DEBUG [mondrian.sql] 1286: SqlMemberSource.getLevelMemberCount: executing sql [ select count(*) as "c0" from (select distinct "time_by_day_Time"."quarter" as "c0", "time_by_day_Time"."the_year" as "c1" from "time_by_day" as "time_by_day_Time") as "init"] 2026-08-03 15:24:11,356 DEBUG [mondrian.sql] 1286: , exec 0 ms 2026-08-03 15:24:11,356 DEBUG [mondrian.sql] 1286: , exec+fetch 1 ms, 1 rows 2026-08-03 15:24:11,357 DEBUG [mondrian.sql] 1287: SqlMemberSource.getLevelMemberCount: executing sql [ select count(*) as "c0" from (select distinct "time_by_day_Time"."month_of_year" as "c0", "time_by_day_Time"."quarter" as "c1", "time_by_day_Time"."the_year" as "c2" from "time_by_day" as "time_by_day_Time") as "init"] 2026-08-03 15:24:11,358 DEBUG [mondrian.sql] 1287: , exec 0 ms 2026-08-03 15:24:11,358 DEBUG [mondrian.sql] 1287: , exec+fetch 1 ms, 1 rows 2026-08-03 15:24:11,358 DEBUG [mondrian.sql] 1288: SqlMemberSource.getLevelMemberCount: executing sql [ select count(*) as "c0" from (select distinct "time_by_day_Time"."the_year" as "c0" from "time_by_day" as "time_by_day_Time") as "init"] 2026-08-03 15:24:11,359 DEBUG [mondrian.sql] 1288: , exec 0 ms 2026-08-03 15:24:11,359 DEBUG [mondrian.sql] 1288: , exec+fetch 1 ms, 1 rows 2026-08-03 15:24:11,359 DEBUG [mondrian.sql] 1289: SqlMemberSource.getLevelMemberCount: executing sql [ select count(*) as "c0" from (select distinct "time_by_day_Time"."month_of_year" as "c0", "time_by_day_Time"."the_year" as "c1" from "time_by_day" as "time_by_day_Time") as "init"] 2026-08-03 15:24:11,359 DEBUG [mondrian.sql] 1289: , exec 0 ms 2026-08-03 15:24:11,359 DEBUG [mondrian.sql] 1289: , exec+fetch 0 ms, 1 rows 2026-08-03 15:24:11,361 DEBUG [mondrian.sql] 1290: SqlMemberSource.getLevelMemberCount: executing sql [ select count(*) as "c0" from (select distinct "store_d_Store"."store_country" as "c0" from (select * from "store" left join "employee" on "store"."store_id" = "employee"."store_id") as "store_d_Store") as "init"] 2026-08-03 15:24:11,364 DEBUG [mondrian.sql] 1290: , exec 3 ms 2026-08-03 15:24:11,364 DEBUG [mondrian.sql] 1290: , exec+fetch 3 ms, 1 rows 2026-08-03 15:24:11,364 DEBUG [mondrian.sql] 1291: SqlMemberSource.getLevelMemberCount: executing sql [ select count(*) as "c0" from (select distinct "store_d_Store"."store_state" as "c0" from (select * from "store" left join "employee" on "store"."store_id" = "employee"."store_id") as "store_d_Store") as "init"] 2026-08-03 15:24:11,367 DEBUG [mondrian.sql] 1291: , exec 2 ms 2026-08-03 15:24:11,367 DEBUG [mondrian.sql] 1291: , exec+fetch 3 ms, 1 rows 2026-08-03 15:24:11,367 DEBUG [mondrian.sql] 1292: SqlMemberSource.getLevelMemberCount: executing sql [ select count(*) as "c0" from (select distinct "store_d_Store"."store_city" as "c0", "store_d_Store"."store_state" as "c1" from (select * from "store" left join "employee" on "store"."store_id" = "employee"."store_id") as "store_d_Store") as "init"] 2026-08-03 15:24:11,370 DEBUG [mondrian.sql] 1292: , exec 2 ms 2026-08-03 15:24:11,370 DEBUG [mondrian.sql] 1292: , exec+fetch 3 ms, 1 rows 2026-08-03 15:24:11,370 DEBUG [mondrian.sql] 1293: SqlMemberSource.getLevelMemberCount: executing sql [ select count(*) as "c0" from (select distinct "store_d_Store"."store_name" as "c0" from (select * from "store" left join "employee" on "store"."store_id" = "employee"."store_id") as "store_d_Store") as "init"] 2026-08-03 15:24:11,372 DEBUG [mondrian.sql] 1293: , exec 2 ms 2026-08-03 15:24:11,372 DEBUG [mondrian.sql] 1293: , exec+fetch 2 ms, 1 rows 2026-08-03 15:24:11,374 DEBUG [mondrian.sql] 1294: SqlMemberSource.getLevelMemberCount: executing sql [ select count(*) as "c0" from (select distinct "employee_d_Employees"."employee_id" as "c0" from (select "pay_type" "pay_type", "employee_id" "employee_id", "supervisor_id" "supervisor_id", "full_name" "full_name", "management_role" "management_role", "position_title" "position_title" from "employee" left join "position" on "employee"."position_id" = "position"."position_id") as "employee_d_Employees") as "init"] 2026-08-03 15:24:11,376 DEBUG [mondrian.sql] 1294: , exec 2 ms 2026-08-03 15:24:11,376 DEBUG [mondrian.sql] 1294: , exec+fetch 2 ms, 1 rows 2026-08-03 15:24:11,377 DEBUG [mondrian.sql] 1295: SqlMemberSource.getLevelMemberCount: executing sql [ select count(*) as "c0" from (select distinct "employee_d_Position"."management_role" as "c0" from (select "pay_type" "pay_type", "employee_id" "employee_id", "supervisor_id" "supervisor_id", "full_name" "full_name", "management_role" "management_role", "position_title" "position_title" from "employee" left join "position" on "employee"."position_id" = "position"."position_id") as "employee_d_Position") as "init"] 2026-08-03 15:24:11,380 DEBUG [mondrian.sql] 1295: , exec 2 ms 2026-08-03 15:24:11,380 DEBUG [mondrian.sql] 1295: , exec+fetch 3 ms, 1 rows 2026-08-03 15:24:11,380 DEBUG [mondrian.sql] 1296: SqlMemberSource.getLevelMemberCount: executing sql [ select count(*) as "c0" from (select distinct "employee_d_Position"."position_title" as "c0", "employee_d_Position"."management_role" as "c1" from (select "pay_type" "pay_type", "employee_id" "employee_id", "supervisor_id" "supervisor_id", "full_name" "full_name", "management_role" "management_role", "position_title" "position_title" from "employee" left join "position" on "employee"."position_id" = "position"."position_id") as "employee_d_Position") as "init"] 2026-08-03 15:24:11,383 DEBUG [mondrian.sql] 1296: , exec 3 ms 2026-08-03 15:24:11,383 DEBUG [mondrian.sql] 1296: , exec+fetch 3 ms, 1 rows 2026-08-03 15:24:11,679 WARN [mondrian.xmla.Rowset] Warning: Rowset 'DISCOVER_SCHEMA_ROWSETS' does not support property 'ClientProcessID' (value is '17508') 2026-08-03 15:24:11,679 WARN [mondrian.xmla.Rowset] Warning: Rowset 'DISCOVER_SCHEMA_ROWSETS' does not support property 'MdxMissingMemberMode' (value is 'Error') 2026-08-03 15:24:11,679 WARN [mondrian.xmla.Rowset] Warning: Rowset 'DISCOVER_SCHEMA_ROWSETS' does not support property 'DbpropMsmdMDXCompatibility' (value is '1') 2026-08-03 15:24:11,679 WARN [mondrian.xmla.Rowset] Warning: Rowset 'DISCOVER_SCHEMA_ROWSETS' does not support property 'DbpropMsmdSubqueries' (value is '2') 2026-08-03 15:24:11,680 WARN [mondrian.xmla.Rowset] Warning: Rowset 'DISCOVER_SCHEMA_ROWSETS' does not support property 'SspropInitAppName' (value is 'Excel') 2026-08-03 15:24:11,680 WARN [mondrian.xmla.Rowset] Warning: Rowset 'DISCOVER_SCHEMA_ROWSETS' does not support property 'SafetyOptions' (value is '2') 2026-08-03 15:24:11,888 WARN [mondrian.xmla.Rowset] Warning: Rowset 'MDSCHEMA_MEASURES' does not support property 'ClientProcessID' (value is '17508') 2026-08-03 15:24:11,888 WARN [mondrian.xmla.Rowset] Warning: Rowset 'MDSCHEMA_MEASURES' does not support property 'MdxMissingMemberMode' (value is 'Error') 2026-08-03 15:24:11,888 WARN [mondrian.xmla.Rowset] Warning: Rowset 'MDSCHEMA_MEASURES' does not support property 'DbpropMsmdMDXCompatibility' (value is '1') 2026-08-03 15:24:11,888 WARN [mondrian.xmla.Rowset] Warning: Rowset 'MDSCHEMA_MEASURES' does not support property 'DbpropMsmdSubqueries' (value is '2') 2026-08-03 15:24:11,888 WARN [mondrian.xmla.Rowset] Warning: Rowset 'MDSCHEMA_MEASURES' does not support property 'SspropInitAppName' (value is 'Excel') 2026-08-03 15:24:11,888 WARN [mondrian.xmla.Rowset] Warning: Rowset 'MDSCHEMA_MEASURES' does not support property 'SafetyOptions' (value is '2') 2026-08-03 15:24:12,364 WARN [mondrian.xmla.Rowset] Warning: Rowset 'MDSCHEMA_SETS' does not support property 'ClientProcessID' (value is '17508') 2026-08-03 15:24:12,364 WARN [mondrian.xmla.Rowset] Warning: Rowset 'MDSCHEMA_SETS' does not support property 'MdxMissingMemberMode' (value is 'Error') 2026-08-03 15:24:12,364 WARN [mondrian.xmla.Rowset] Warning: Rowset 'MDSCHEMA_SETS' does not support property 'DbpropMsmdMDXCompatibility' (value is '1') 2026-08-03 15:24:12,364 WARN [mondrian.xmla.Rowset] Warning: Rowset 'MDSCHEMA_SETS' does not support property 'DbpropMsmdSubqueries' (value is '2') 2026-08-03 15:24:12,364 WARN [mondrian.xmla.Rowset] Warning: Rowset 'MDSCHEMA_SETS' does not support property 'SspropInitAppName' (value is 'Excel') 2026-08-03 15:24:12,364 WARN [mondrian.xmla.Rowset] Warning: Rowset 'MDSCHEMA_SETS' does not support property 'SafetyOptions' (value is '2') 2026-08-03 15:24:12,625 WARN [mondrian.xmla.Rowset] Warning: Rowset 'MDSCHEMA_CUBES' does not support property 'ClientProcessID' (value is '17508') 2026-08-03 15:24:12,625 WARN [mondrian.xmla.Rowset] Warning: Rowset 'MDSCHEMA_CUBES' does not support property 'MdxMissingMemberMode' (value is 'Error') 2026-08-03 15:24:12,625 WARN [mondrian.xmla.Rowset] Warning: Rowset 'MDSCHEMA_CUBES' does not support property 'DbpropMsmdMDXCompatibility' (value is '1') 2026-08-03 15:24:12,625 WARN [mondrian.xmla.Rowset] Warning: Rowset 'MDSCHEMA_CUBES' does not support property 'DbpropMsmdSubqueries' (value is '2') 2026-08-03 15:24:12,625 WARN [mondrian.xmla.Rowset] Warning: Rowset 'MDSCHEMA_CUBES' does not support property 'SspropInitAppName' (value is 'Excel') 2026-08-03 15:24:12,625 WARN [mondrian.xmla.Rowset] Warning: Rowset 'MDSCHEMA_CUBES' does not support property 'SafetyOptions' (value is '2') 2026-08-03 15:24:12,822 WARN [mondrian.xmla.Rowset] Warning: Rowset 'MDSCHEMA_DIMENSIONS' does not support property 'ClientProcessID' (value is '17508') 2026-08-03 15:24:12,822 WARN [mondrian.xmla.Rowset] Warning: Rowset 'MDSCHEMA_DIMENSIONS' does not support property 'MdxMissingMemberMode' (value is 'Error') 2026-08-03 15:24:12,822 WARN [mondrian.xmla.Rowset] Warning: Rowset 'MDSCHEMA_DIMENSIONS' does not support property 'DbpropMsmdMDXCompatibility' (value is '1') 2026-08-03 15:24:12,822 WARN [mondrian.xmla.Rowset] Warning: Rowset 'MDSCHEMA_DIMENSIONS' does not support property 'DbpropMsmdSubqueries' (value is '2') 2026-08-03 15:24:12,822 WARN [mondrian.xmla.Rowset] Warning: Rowset 'MDSCHEMA_DIMENSIONS' does not support property 'SspropInitAppName' (value is 'Excel') 2026-08-03 15:24:12,822 WARN [mondrian.xmla.Rowset] Warning: Rowset 'MDSCHEMA_DIMENSIONS' does not support property 'SafetyOptions' (value is '2') 2026-08-03 15:24:13,109 WARN [mondrian.xmla.Rowset] Warning: Rowset 'MDSCHEMA_HIERARCHIES' does not support property 'ClientProcessID' (value is '17508') 2026-08-03 15:24:13,109 WARN [mondrian.xmla.Rowset] Warning: Rowset 'MDSCHEMA_HIERARCHIES' does not support property 'MdxMissingMemberMode' (value is 'Error') 2026-08-03 15:24:13,109 WARN [mondrian.xmla.Rowset] Warning: Rowset 'MDSCHEMA_HIERARCHIES' does not support property 'DbpropMsmdMDXCompatibility' (value is '1') 2026-08-03 15:24:13,109 WARN [mondrian.xmla.Rowset] Warning: Rowset 'MDSCHEMA_HIERARCHIES' does not support property 'DbpropMsmdSubqueries' (value is '2') 2026-08-03 15:24:13,109 WARN [mondrian.xmla.Rowset] Warning: Rowset 'MDSCHEMA_HIERARCHIES' does not support property 'SspropInitAppName' (value is 'Excel') 2026-08-03 15:24:13,109 WARN [mondrian.xmla.Rowset] Warning: Rowset 'MDSCHEMA_HIERARCHIES' does not support property 'SafetyOptions' (value is '2') 2026-08-03 15:24:13,445 WARN [mondrian.xmla.Rowset] Warning: Rowset 'MDSCHEMA_LEVELS' does not support property 'ClientProcessID' (value is '17508') 2026-08-03 15:24:13,445 WARN [mondrian.xmla.Rowset] Warning: Rowset 'MDSCHEMA_LEVELS' does not support property 'MdxMissingMemberMode' (value is 'Error') 2026-08-03 15:24:13,445 WARN [mondrian.xmla.Rowset] Warning: Rowset 'MDSCHEMA_LEVELS' does not support property 'DbpropMsmdMDXCompatibility' (value is '1') 2026-08-03 15:24:13,445 WARN [mondrian.xmla.Rowset] Warning: Rowset 'MDSCHEMA_LEVELS' does not support property 'DbpropMsmdSubqueries' (value is '2') 2026-08-03 15:24:13,445 WARN [mondrian.xmla.Rowset] Warning: Rowset 'MDSCHEMA_LEVELS' does not support property 'SspropInitAppName' (value is 'Excel') 2026-08-03 15:24:13,445 WARN [mondrian.xmla.Rowset] Warning: Rowset 'MDSCHEMA_LEVELS' does not support property 'SafetyOptions' (value is '2') 2026-08-03 15:24:13,781 WARN [mondrian.xmla.Rowset] Warning: Rowset 'MDSCHEMA_MEASUREGROUPS' does not support property 'ClientProcessID' (value is '17508') 2026-08-03 15:24:13,781 WARN [mondrian.xmla.Rowset] Warning: Rowset 'MDSCHEMA_MEASUREGROUPS' does not support property 'MdxMissingMemberMode' (value is 'Error') 2026-08-03 15:24:13,781 WARN [mondrian.xmla.Rowset] Warning: Rowset 'MDSCHEMA_MEASUREGROUPS' does not support property 'DbpropMsmdMDXCompatibility' (value is '1') 2026-08-03 15:24:13,781 WARN [mondrian.xmla.Rowset] Warning: Rowset 'MDSCHEMA_MEASUREGROUPS' does not support property 'DbpropMsmdSubqueries' (value is '2') 2026-08-03 15:24:13,781 WARN [mondrian.xmla.Rowset] Warning: Rowset 'MDSCHEMA_MEASUREGROUPS' does not support property 'SspropInitAppName' (value is 'Excel') 2026-08-03 15:24:13,781 WARN [mondrian.xmla.Rowset] Warning: Rowset 'MDSCHEMA_MEASUREGROUPS' does not support property 'SafetyOptions' (value is '2') 2026-08-03 15:24:15,658 WARN [mondrian.xmla.Rowset] Warning: Rowset 'MDSCHEMA_CUBES' does not support property 'ClientProcessID' (value is '17508') 2026-08-03 15:24:15,658 WARN [mondrian.xmla.Rowset] Warning: Rowset 'MDSCHEMA_CUBES' does not support property 'MdxMissingMemberMode' (value is 'Error') 2026-08-03 15:24:15,658 WARN [mondrian.xmla.Rowset] Warning: Rowset 'MDSCHEMA_CUBES' does not support property 'DbpropMsmdMDXCompatibility' (value is '1') 2026-08-03 15:24:15,658 WARN [mondrian.xmla.Rowset] Warning: Rowset 'MDSCHEMA_CUBES' does not support property 'DbpropMsmdSubqueries' (value is '2') 2026-08-03 15:24:15,658 WARN [mondrian.xmla.Rowset] Warning: Rowset 'MDSCHEMA_CUBES' does not support property 'SspropInitAppName' (value is 'Excel') 2026-08-03 15:24:15,658 WARN [mondrian.xmla.Rowset] Warning: Rowset 'MDSCHEMA_CUBES' does not support property 'SafetyOptions' (value is '2') 2026-08-03 15:24:15,935 WARN [mondrian.xmla.Rowset] Warning: Rowset 'MDSCHEMA_DIMENSIONS' does not support property 'ClientProcessID' (value is '17508') 2026-08-03 15:24:15,935 WARN [mondrian.xmla.Rowset] Warning: Rowset 'MDSCHEMA_DIMENSIONS' does not support property 'MdxMissingMemberMode' (value is 'Error') 2026-08-03 15:24:15,935 WARN [mondrian.xmla.Rowset] Warning: Rowset 'MDSCHEMA_DIMENSIONS' does not support property 'DbpropMsmdMDXCompatibility' (value is '1') 2026-08-03 15:24:15,935 WARN [mondrian.xmla.Rowset] Warning: Rowset 'MDSCHEMA_DIMENSIONS' does not support property 'DbpropMsmdSubqueries' (value is '2') 2026-08-03 15:24:15,935 WARN [mondrian.xmla.Rowset] Warning: Rowset 'MDSCHEMA_DIMENSIONS' does not support property 'SspropInitAppName' (value is 'Excel') 2026-08-03 15:24:15,935 WARN [mondrian.xmla.Rowset] Warning: Rowset 'MDSCHEMA_DIMENSIONS' does not support property 'SafetyOptions' (value is '2') 2026-08-03 15:24:16,131 WARN [mondrian.xmla.Rowset] Warning: Rowset 'MDSCHEMA_HIERARCHIES' does not support property 'ClientProcessID' (value is '17508') 2026-08-03 15:24:16,131 WARN [mondrian.xmla.Rowset] Warning: Rowset 'MDSCHEMA_HIERARCHIES' does not support property 'MdxMissingMemberMode' (value is 'Error') 2026-08-03 15:24:16,131 WARN [mondrian.xmla.Rowset] Warning: Rowset 'MDSCHEMA_HIERARCHIES' does not support property 'DbpropMsmdMDXCompatibility' (value is '1') 2026-08-03 15:24:16,131 WARN [mondrian.xmla.Rowset] Warning: Rowset 'MDSCHEMA_HIERARCHIES' does not support property 'DbpropMsmdSubqueries' (value is '2') 2026-08-03 15:24:16,131 WARN [mondrian.xmla.Rowset] Warning: Rowset 'MDSCHEMA_HIERARCHIES' does not support property 'SspropInitAppName' (value is 'Excel') 2026-08-03 15:24:16,131 WARN [mondrian.xmla.Rowset] Warning: Rowset 'MDSCHEMA_HIERARCHIES' does not support property 'SafetyOptions' (value is '2') 2026-08-03 15:24:16,464 WARN [mondrian.xmla.Rowset] Warning: Rowset 'MDSCHEMA_LEVELS' does not support property 'ClientProcessID' (value is '17508') 2026-08-03 15:24:16,464 WARN [mondrian.xmla.Rowset] Warning: Rowset 'MDSCHEMA_LEVELS' does not support property 'MdxMissingMemberMode' (value is 'Error') 2026-08-03 15:24:16,464 WARN [mondrian.xmla.Rowset] Warning: Rowset 'MDSCHEMA_LEVELS' does not support property 'DbpropMsmdMDXCompatibility' (value is '1') 2026-08-03 15:24:16,464 WARN [mondrian.xmla.Rowset] Warning: Rowset 'MDSCHEMA_LEVELS' does not support property 'DbpropMsmdSubqueries' (value is '2') 2026-08-03 15:24:16,464 WARN [mondrian.xmla.Rowset] Warning: Rowset 'MDSCHEMA_LEVELS' does not support property 'SspropInitAppName' (value is 'Excel') 2026-08-03 15:24:16,464 WARN [mondrian.xmla.Rowset] Warning: Rowset 'MDSCHEMA_LEVELS' does not support property 'SafetyOptions' (value is '2') 2026-08-03 15:24:16,806 DEBUG [mondrian.mdx] 13827: USER_ID="null" CUBE="HR (attributes)" SESSION_ID="6789j2lqp8l" query: select from [HR (attributes)] where ([Measures].[Count]) 2026-08-03 15:24:16,809 DEBUG [mondrian.sql] 1297: Segment.load: executing sql [ select count("salary"."employee_id") as "m0" from "salary" as "salary"] 2026-08-03 15:24:16,810 DEBUG [mondrian.sql] 1297: , exec 0 ms 2026-08-03 15:24:16,810 DEBUG [mondrian.sql] 1297: , exec+fetch 1 ms, 1 rows 2026-08-03 15:24:16,811 DEBUG [mondrian.mdx] 13827: exec: 4 ms 2026-08-03 15:24:17,064 WARN [mondrian.xmla.Rowset] Warning: Rowset 'MDSCHEMA_CUBES' does not support property 'ClientProcessID' (value is '17508') 2026-08-03 15:24:17,064 WARN [mondrian.xmla.Rowset] Warning: Rowset 'MDSCHEMA_CUBES' does not support property 'MdxMissingMemberMode' (value is 'Error') 2026-08-03 15:24:17,064 WARN [mondrian.xmla.Rowset] Warning: Rowset 'MDSCHEMA_CUBES' does not support property 'DbpropMsmdMDXCompatibility' (value is '1') 2026-08-03 15:24:17,064 WARN [mondrian.xmla.Rowset] Warning: Rowset 'MDSCHEMA_CUBES' does not support property 'DbpropMsmdSubqueries' (value is '2') 2026-08-03 15:24:17,064 WARN [mondrian.xmla.Rowset] Warning: Rowset 'MDSCHEMA_CUBES' does not support property 'SspropInitAppName' (value is 'Excel') 2026-08-03 15:24:17,064 WARN [mondrian.xmla.Rowset] Warning: Rowset 'MDSCHEMA_CUBES' does not support property 'SafetyOptions' (value is '2') 2026-08-03 15:24:17,293 WARN [mondrian.xmla.Rowset] Warning: Rowset 'MDSCHEMA_CUBES' does not support property 'ClientProcessID' (value is '17508') 2026-08-03 15:24:17,293 WARN [mondrian.xmla.Rowset] Warning: Rowset 'MDSCHEMA_CUBES' does not support property 'MdxMissingMemberMode' (value is 'Error') 2026-08-03 15:24:17,293 WARN [mondrian.xmla.Rowset] Warning: Rowset 'MDSCHEMA_CUBES' does not support property 'DbpropMsmdMDXCompatibility' (value is '1') 2026-08-03 15:24:17,293 WARN [mondrian.xmla.Rowset] Warning: Rowset 'MDSCHEMA_CUBES' does not support property 'DbpropMsmdSubqueries' (value is '2') 2026-08-03 15:24:17,293 WARN [mondrian.xmla.Rowset] Warning: Rowset 'MDSCHEMA_CUBES' does not support property 'SspropInitAppName' (value is 'Excel') 2026-08-03 15:24:17,293 WARN [mondrian.xmla.Rowset] Warning: Rowset 'MDSCHEMA_CUBES' does not support property 'SafetyOptions' (value is '2') 2026-08-03 15:24:17,510 WARN [mondrian.xmla.Rowset] Warning: Rowset 'DBSCHEMA_CATALOGS' does not support property 'ClientProcessID' (value is '17508') 2026-08-03 15:24:17,510 WARN [mondrian.xmla.Rowset] Warning: Rowset 'DBSCHEMA_CATALOGS' does not support property 'MdxMissingMemberMode' (value is 'Error') 2026-08-03 15:24:17,510 WARN [mondrian.xmla.Rowset] Warning: Rowset 'DBSCHEMA_CATALOGS' does not support property 'DbpropMsmdMDXCompatibility' (value is '1') 2026-08-03 15:24:17,510 WARN [mondrian.xmla.Rowset] Warning: Rowset 'DBSCHEMA_CATALOGS' does not support property 'DbpropMsmdSubqueries' (value is '2') 2026-08-03 15:24:17,511 WARN [mondrian.xmla.Rowset] Warning: Rowset 'DBSCHEMA_CATALOGS' does not support property 'SspropInitAppName' (value is 'Excel') 2026-08-03 15:24:17,511 WARN [mondrian.xmla.Rowset] Warning: Rowset 'DBSCHEMA_CATALOGS' does not support property 'SafetyOptions' (value is '2') 2026-08-03 15:24:18,468 WARN [mondrian.xmla.Rowset] Warning: Rowset 'MDSCHEMA_CUBES' does not support property 'ClientProcessID' (value is '17508') 2026-08-03 15:24:18,468 WARN [mondrian.xmla.Rowset] Warning: Rowset 'MDSCHEMA_CUBES' does not support property 'MdxMissingMemberMode' (value is 'Error') 2026-08-03 15:24:18,469 WARN [mondrian.xmla.Rowset] Warning: Rowset 'MDSCHEMA_CUBES' does not support property 'DbpropMsmdMDXCompatibility' (value is '1') 2026-08-03 15:24:18,469 WARN [mondrian.xmla.Rowset] Warning: Rowset 'MDSCHEMA_CUBES' does not support property 'DbpropMsmdSubqueries' (value is '2') 2026-08-03 15:24:18,469 WARN [mondrian.xmla.Rowset] Warning: Rowset 'MDSCHEMA_CUBES' does not support property 'SspropInitAppName' (value is 'Excel') 2026-08-03 15:24:18,469 WARN [mondrian.xmla.Rowset] Warning: Rowset 'MDSCHEMA_CUBES' does not support property 'SafetyOptions' (value is '2') 2026-08-03 15:24:18,680 WARN [mondrian.xmla.Rowset] Warning: Rowset 'MDSCHEMA_CUBES' does not support property 'ClientProcessID' (value is '17508') 2026-08-03 15:24:18,680 WARN [mondrian.xmla.Rowset] Warning: Rowset 'MDSCHEMA_CUBES' does not support property 'MdxMissingMemberMode' (value is 'Error') 2026-08-03 15:24:18,681 WARN [mondrian.xmla.Rowset] Warning: Rowset 'MDSCHEMA_CUBES' does not support property 'DbpropMsmdMDXCompatibility' (value is '1') 2026-08-03 15:24:18,681 WARN [mondrian.xmla.Rowset] Warning: Rowset 'MDSCHEMA_CUBES' does not support property 'DbpropMsmdSubqueries' (value is '2') 2026-08-03 15:24:18,681 WARN [mondrian.xmla.Rowset] Warning: Rowset 'MDSCHEMA_CUBES' does not support property 'SspropInitAppName' (value is 'Excel') 2026-08-03 15:24:18,681 WARN [mondrian.xmla.Rowset] Warning: Rowset 'MDSCHEMA_CUBES' does not support property 'SafetyOptions' (value is '2') 2026-08-03 15:24:18,885 WARN [mondrian.xmla.Rowset] Warning: Rowset 'MDSCHEMA_DIMENSIONS' does not support property 'ClientProcessID' (value is '17508') 2026-08-03 15:24:18,885 WARN [mondrian.xmla.Rowset] Warning: Rowset 'MDSCHEMA_DIMENSIONS' does not support property 'MdxMissingMemberMode' (value is 'Error') 2026-08-03 15:24:18,885 WARN [mondrian.xmla.Rowset] Warning: Rowset 'MDSCHEMA_DIMENSIONS' does not support property 'DbpropMsmdMDXCompatibility' (value is '1') 2026-08-03 15:24:18,885 WARN [mondrian.xmla.Rowset] Warning: Rowset 'MDSCHEMA_DIMENSIONS' does not support property 'DbpropMsmdSubqueries' (value is '2') 2026-08-03 15:24:18,885 WARN [mondrian.xmla.Rowset] Warning: Rowset 'MDSCHEMA_DIMENSIONS' does not support property 'SspropInitAppName' (value is 'Excel') 2026-08-03 15:24:18,886 WARN [mondrian.xmla.Rowset] Warning: Rowset 'MDSCHEMA_DIMENSIONS' does not support property 'SafetyOptions' (value is '2') 2026-08-03 15:24:19,101 WARN [mondrian.xmla.Rowset] Warning: Rowset 'MDSCHEMA_HIERARCHIES' does not support property 'ClientProcessID' (value is '17508') 2026-08-03 15:24:19,101 WARN [mondrian.xmla.Rowset] Warning: Rowset 'MDSCHEMA_HIERARCHIES' does not support property 'MdxMissingMemberMode' (value is 'Error') 2026-08-03 15:24:19,102 WARN [mondrian.xmla.Rowset] Warning: Rowset 'MDSCHEMA_HIERARCHIES' does not support property 'DbpropMsmdMDXCompatibility' (value is '1') 2026-08-03 15:24:19,102 WARN [mondrian.xmla.Rowset] Warning: Rowset 'MDSCHEMA_HIERARCHIES' does not support property 'DbpropMsmdSubqueries' (value is '2') 2026-08-03 15:24:19,102 WARN [mondrian.xmla.Rowset] Warning: Rowset 'MDSCHEMA_HIERARCHIES' does not support property 'SspropInitAppName' (value is 'Excel') 2026-08-03 15:24:19,102 WARN [mondrian.xmla.Rowset] Warning: Rowset 'MDSCHEMA_HIERARCHIES' does not support property 'SafetyOptions' (value is '2') 2026-08-03 15:24:19,396 WARN [mondrian.xmla.Rowset] Warning: Rowset 'MDSCHEMA_LEVELS' does not support property 'ClientProcessID' (value is '17508') 2026-08-03 15:24:19,396 WARN [mondrian.xmla.Rowset] Warning: Rowset 'MDSCHEMA_LEVELS' does not support property 'MdxMissingMemberMode' (value is 'Error') 2026-08-03 15:24:19,396 WARN [mondrian.xmla.Rowset] Warning: Rowset 'MDSCHEMA_LEVELS' does not support property 'DbpropMsmdMDXCompatibility' (value is '1') 2026-08-03 15:24:19,396 WARN [mondrian.xmla.Rowset] Warning: Rowset 'MDSCHEMA_LEVELS' does not support property 'DbpropMsmdSubqueries' (value is '2') 2026-08-03 15:24:19,396 WARN [mondrian.xmla.Rowset] Warning: Rowset 'MDSCHEMA_LEVELS' does not support property 'SspropInitAppName' (value is 'Excel') 2026-08-03 15:24:19,396 WARN [mondrian.xmla.Rowset] Warning: Rowset 'MDSCHEMA_LEVELS' does not support property 'SafetyOptions' (value is '2') 2026-08-03 15:24:19,708 WARN [mondrian.xmla.Rowset] Warning: Rowset 'MDSCHEMA_PROPERTIES' does not support property 'ClientProcessID' (value is '17508') 2026-08-03 15:24:19,708 WARN [mondrian.xmla.Rowset] Warning: Rowset 'MDSCHEMA_PROPERTIES' does not support property 'MdxMissingMemberMode' (value is 'Error') 2026-08-03 15:24:19,708 WARN [mondrian.xmla.Rowset] Warning: Rowset 'MDSCHEMA_PROPERTIES' does not support property 'DbpropMsmdMDXCompatibility' (value is '1') 2026-08-03 15:24:19,708 WARN [mondrian.xmla.Rowset] Warning: Rowset 'MDSCHEMA_PROPERTIES' does not support property 'DbpropMsmdSubqueries' (value is '2') 2026-08-03 15:24:19,708 WARN [mondrian.xmla.Rowset] Warning: Rowset 'MDSCHEMA_PROPERTIES' does not support property 'SspropInitAppName' (value is 'Excel') 2026-08-03 15:24:19,708 WARN [mondrian.xmla.Rowset] Warning: Rowset 'MDSCHEMA_PROPERTIES' does not support property 'SafetyOptions' (value is '2') 2026-08-03 15:24:19,948 DEBUG [mondrian.mdx] 14107: USER_ID="null" CUBE="HR (attributes)" SESSION_ID="6789j2lqp8l" query: select NON EMPTY Hierarchize({DrilldownLevel({[Department.Department Description].[All Department.Department Descriptions]}, , , INCLUDE_CALC_MEMBERS)}) DIMENSION PROPERTIES PARENT_UNIQUE_NAME ON COLUMNS from [HR (attributes)] where ([Measures].[Count]) 2026-08-03 15:24:19,949 DEBUG [mondrian.sql] 1298: SqlTupleReader.readTuples [[Department.Department Description].[Department Description]]: executing sql [ select "department_Department"."department_id" as "c0" from "department" as "department_Department" group by "department_Department"."department_id" order by CASE WHEN "department_Department"."department_id" IS NULL THEN 1 ELSE 0 END, "department_Department"."department_id" ASC] 2026-08-03 15:24:19,950 DEBUG [mondrian.sql] 1298: , exec 0 ms 2026-08-03 15:24:19,950 DEBUG [mondrian.sql] 1298: , exec+fetch 1 ms, 12 rows 2026-08-03 15:24:19,950 DEBUG [mondrian.sql] 1299: SqlMemberSource.getMemberChildren: executing sql [ select "department_Department"."department_id" as "c0" from "department" as "department_Department" group by "department_Department"."department_id" order by CASE WHEN "department_Department"."department_id" IS NULL THEN 1 ELSE 0 END, "department_Department"."department_id" ASC] 2026-08-03 15:24:19,950 DEBUG [mondrian.sql] 1299: , exec 0 ms 2026-08-03 15:24:19,950 DEBUG [mondrian.sql] 1299: , exec+fetch 0 ms, 12 rows 2026-08-03 15:24:19,953 DEBUG [mondrian.sql] 1300: Segment.load: executing sql [ select "department_Department"."department_id" as "c0", count("salary"."employee_id") as "m0" from "salary" as "salary", "department" as "department_Department" where "salary"."department_id" = "department_Department"."department_id" group by "department_Department"."department_id"] 2026-08-03 15:24:20,002 DEBUG [mondrian.sql] 1300: , exec 48 ms 2026-08-03 15:24:20,003 DEBUG [mondrian.sql] 1300: , exec+fetch 50 ms, 12 rows 2026-08-03 15:24:20,005 DEBUG [mondrian.mdx] 14107: exec: 57 ms 2026-08-03 15:24:29,463 WARN [mondrian.xmla.Rowset] Warning: Rowset 'MDSCHEMA_CUBES' does not support property 'ClientProcessID' (value is '17508') 2026-08-03 15:24:29,463 WARN [mondrian.xmla.Rowset] Warning: Rowset 'MDSCHEMA_CUBES' does not support property 'MdxMissingMemberMode' (value is 'Error') 2026-08-03 15:24:29,463 WARN [mondrian.xmla.Rowset] Warning: Rowset 'MDSCHEMA_CUBES' does not support property 'DbpropMsmdMDXCompatibility' (value is '1') 2026-08-03 15:24:29,463 WARN [mondrian.xmla.Rowset] Warning: Rowset 'MDSCHEMA_CUBES' does not support property 'DbpropMsmdSubqueries' (value is '2') 2026-08-03 15:24:29,463 WARN [mondrian.xmla.Rowset] Warning: Rowset 'MDSCHEMA_CUBES' does not support property 'SspropInitAppName' (value is 'Excel') 2026-08-03 15:24:29,463 WARN [mondrian.xmla.Rowset] Warning: Rowset 'MDSCHEMA_CUBES' does not support property 'SafetyOptions' (value is '2') 2026-08-03 15:24:29,657 WARN [mondrian.xmla.Rowset] Warning: Rowset 'MDSCHEMA_CUBES' does not support property 'ClientProcessID' (value is '17508') 2026-08-03 15:24:29,657 WARN [mondrian.xmla.Rowset] Warning: Rowset 'MDSCHEMA_CUBES' does not support property 'MdxMissingMemberMode' (value is 'Error') 2026-08-03 15:24:29,657 WARN [mondrian.xmla.Rowset] Warning: Rowset 'MDSCHEMA_CUBES' does not support property 'DbpropMsmdMDXCompatibility' (value is '1') 2026-08-03 15:24:29,657 WARN [mondrian.xmla.Rowset] Warning: Rowset 'MDSCHEMA_CUBES' does not support property 'DbpropMsmdSubqueries' (value is '2') 2026-08-03 15:24:29,657 WARN [mondrian.xmla.Rowset] Warning: Rowset 'MDSCHEMA_CUBES' does not support property 'SspropInitAppName' (value is 'Excel') 2026-08-03 15:24:29,657 WARN [mondrian.xmla.Rowset] Warning: Rowset 'MDSCHEMA_CUBES' does not support property 'SafetyOptions' (value is '2') 2026-08-03 15:24:29,846 WARN [mondrian.xmla.Rowset] Warning: Rowset 'MDSCHEMA_DIMENSIONS' does not support property 'ClientProcessID' (value is '17508') 2026-08-03 15:24:29,846 WARN [mondrian.xmla.Rowset] Warning: Rowset 'MDSCHEMA_DIMENSIONS' does not support property 'MdxMissingMemberMode' (value is 'Error') 2026-08-03 15:24:29,846 WARN [mondrian.xmla.Rowset] Warning: Rowset 'MDSCHEMA_DIMENSIONS' does not support property 'DbpropMsmdMDXCompatibility' (value is '1') 2026-08-03 15:24:29,846 WARN [mondrian.xmla.Rowset] Warning: Rowset 'MDSCHEMA_DIMENSIONS' does not support property 'DbpropMsmdSubqueries' (value is '2') 2026-08-03 15:24:29,846 WARN [mondrian.xmla.Rowset] Warning: Rowset 'MDSCHEMA_DIMENSIONS' does not support property 'SspropInitAppName' (value is 'Excel') 2026-08-03 15:24:29,846 WARN [mondrian.xmla.Rowset] Warning: Rowset 'MDSCHEMA_DIMENSIONS' does not support property 'SafetyOptions' (value is '2') 2026-08-03 15:24:30,037 WARN [mondrian.xmla.Rowset] Warning: Rowset 'MDSCHEMA_HIERARCHIES' does not support property 'ClientProcessID' (value is '17508') 2026-08-03 15:24:30,037 WARN [mondrian.xmla.Rowset] Warning: Rowset 'MDSCHEMA_HIERARCHIES' does not support property 'MdxMissingMemberMode' (value is 'Error') 2026-08-03 15:24:30,037 WARN [mondrian.xmla.Rowset] Warning: Rowset 'MDSCHEMA_HIERARCHIES' does not support property 'DbpropMsmdMDXCompatibility' (value is '1') 2026-08-03 15:24:30,037 WARN [mondrian.xmla.Rowset] Warning: Rowset 'MDSCHEMA_HIERARCHIES' does not support property 'DbpropMsmdSubqueries' (value is '2') 2026-08-03 15:24:30,037 WARN [mondrian.xmla.Rowset] Warning: Rowset 'MDSCHEMA_HIERARCHIES' does not support property 'SspropInitAppName' (value is 'Excel') 2026-08-03 15:24:30,037 WARN [mondrian.xmla.Rowset] Warning: Rowset 'MDSCHEMA_HIERARCHIES' does not support property 'SafetyOptions' (value is '2') 2026-08-03 15:24:30,301 WARN [mondrian.xmla.Rowset] Warning: Rowset 'MDSCHEMA_LEVELS' does not support property 'ClientProcessID' (value is '17508') 2026-08-03 15:24:30,301 WARN [mondrian.xmla.Rowset] Warning: Rowset 'MDSCHEMA_LEVELS' does not support property 'MdxMissingMemberMode' (value is 'Error') 2026-08-03 15:24:30,301 WARN [mondrian.xmla.Rowset] Warning: Rowset 'MDSCHEMA_LEVELS' does not support property 'DbpropMsmdMDXCompatibility' (value is '1') 2026-08-03 15:24:30,301 WARN [mondrian.xmla.Rowset] Warning: Rowset 'MDSCHEMA_LEVELS' does not support property 'DbpropMsmdSubqueries' (value is '2') 2026-08-03 15:24:30,301 WARN [mondrian.xmla.Rowset] Warning: Rowset 'MDSCHEMA_LEVELS' does not support property 'SspropInitAppName' (value is 'Excel') 2026-08-03 15:24:30,301 WARN [mondrian.xmla.Rowset] Warning: Rowset 'MDSCHEMA_LEVELS' does not support property 'SafetyOptions' (value is '2') 2026-08-03 15:24:30,619 WARN [mondrian.xmla.Rowset] Warning: Rowset 'MDSCHEMA_PROPERTIES' does not support property 'ClientProcessID' (value is '17508') 2026-08-03 15:24:30,619 WARN [mondrian.xmla.Rowset] Warning: Rowset 'MDSCHEMA_PROPERTIES' does not support property 'MdxMissingMemberMode' (value is 'Error') 2026-08-03 15:24:30,619 WARN [mondrian.xmla.Rowset] Warning: Rowset 'MDSCHEMA_PROPERTIES' does not support property 'DbpropMsmdMDXCompatibility' (value is '1') 2026-08-03 15:24:30,619 WARN [mondrian.xmla.Rowset] Warning: Rowset 'MDSCHEMA_PROPERTIES' does not support property 'DbpropMsmdSubqueries' (value is '2') 2026-08-03 15:24:30,619 WARN [mondrian.xmla.Rowset] Warning: Rowset 'MDSCHEMA_PROPERTIES' does not support property 'SspropInitAppName' (value is 'Excel') 2026-08-03 15:24:30,619 WARN [mondrian.xmla.Rowset] Warning: Rowset 'MDSCHEMA_PROPERTIES' does not support property 'SafetyOptions' (value is '2') 2026-08-03 15:24:30,827 DEBUG [mondrian.mdx] 14473: USER_ID="null" CUBE="HR (attributes)" SESSION_ID="6789j2lqp8l" query: select NON EMPTY Crossjoin(Hierarchize({DrilldownLevel({[Department.Department Description].[All Department.Department Descriptions]}, , , INCLUDE_CALC_MEMBERS)}), Hierarchize({DrilldownLevel({[Employees].[All Employees]}, , , INCLUDE_CALC_MEMBERS)})) DIMENSION PROPERTIES PARENT_UNIQUE_NAME ON COLUMNS from [HR (attributes)] where ([Measures].[Count]) 2026-08-03 15:24:30,829 DEBUG [mondrian.sql] 1301: SqlTupleReader.readTuples [[Employees].[Employee Id]]: executing sql [ select "employee_d_Employees"."employee_id" as "c0" from (select "pay_type" "pay_type", "employee_id" "employee_id", "supervisor_id" "supervisor_id", "full_name" "full_name", "management_role" "management_role", "position_title" "position_title" from "employee" left join "position" on "employee"."position_id" = "position"."position_id") as "employee_d_Employees" group by "employee_d_Employees"."employee_id" order by CASE WHEN "employee_d_Employees"."employee_id" IS NULL THEN 1 ELSE 0 END, "employee_d_Employees"."employee_id" ASC] 2026-08-03 15:24:30,831 DEBUG [mondrian.sql] 1301: , exec 2 ms 2026-08-03 15:24:30,834 DEBUG [mondrian.sql] 1301: , exec+fetch 5 ms, 1155 rows 2026-08-03 15:24:30,834 DEBUG [mondrian.sql] 1302: SqlMemberSource.getMemberChildren: executing sql [ select "employee_d_Employees"."employee_id" as "c0" from (select "pay_type" "pay_type", "employee_id" "employee_id", "supervisor_id" "supervisor_id", "full_name" "full_name", "management_role" "management_role", "position_title" "position_title" from "employee" left join "position" on "employee"."position_id" = "position"."position_id") as "employee_d_Employees" group by "employee_d_Employees"."employee_id" order by CASE WHEN "employee_d_Employees"."employee_id" IS NULL THEN 1 ELSE 0 END, "employee_d_Employees"."employee_id" ASC] 2026-08-03 15:24:30,836 DEBUG [mondrian.sql] 1302: , exec 1 ms 2026-08-03 15:24:30,837 DEBUG [mondrian.sql] 1302: , exec+fetch 3 ms, 1155 rows 2026-08-03 15:24:30,851 DEBUG [mondrian.sql] 1303: SqlStatisticsProvider.getQueryCardinality: executing sql [ select count(*) from (select distinct "employee_d_Employees"."employee_id" as "c0" from (select "pay_type" "pay_type", "employee_id" "employee_id", "supervisor_id" "supervisor_id", "full_name" "full_name", "management_role" "management_role", "position_title" "position_title" from "employee" left join "position" on "employee"."position_id" = "position"."position_id") as "employee_d_Employees")] 2026-08-03 15:24:30,853 DEBUG [mondrian.sql] 1303: , exec 2 ms 2026-08-03 15:24:30,853 DEBUG [mondrian.sql] 1303: , exec+fetch 2 ms, 1 rows 2026-08-03 15:24:30,867 DEBUG [mondrian.sql] 1304: Segment.load: executing sql [ select "employee_d_Employees"."employee_id" as "c0", count("salary"."employee_id") as "m0" from "salary" as "salary", (select "pay_type" "pay_type", "employee_id" "employee_id", "supervisor_id" "supervisor_id", "full_name" "full_name", "management_role" "management_role", "position_title" "position_title" from "employee" left join "position" on "employee"."position_id" = "position"."position_id") as "employee_d_Employees" where "salary"."employee_id" = "employee_d_Employees"."employee_id" group by "employee_d_Employees"."employee_id"] 2026-08-03 15:24:30,897 DEBUG [mondrian.sql] 1304: , exec 29 ms 2026-08-03 15:24:30,905 DEBUG [mondrian.sql] 1304: , exec+fetch 38 ms, 1155 rows 2026-08-03 15:24:31,012 DEBUG [mondrian.sql] 1305: Segment.load: executing sql [ select "department_Department"."department_id" as "c0", "employee_d_Employees"."employee_id" as "c1", count("salary"."employee_id") as "m0" from "salary" as "salary", "department" as "department_Department", (select "pay_type" "pay_type", "employee_id" "employee_id", "supervisor_id" "supervisor_id", "full_name" "full_name", "management_role" "management_role", "position_title" "position_title" from "employee" left join "position" on "employee"."position_id" = "position"."position_id") as "employee_d_Employees" where "salary"."department_id" = "department_Department"."department_id" and "salary"."employee_id" = "employee_d_Employees"."employee_id" group by "department_Department"."department_id", "employee_d_Employees"."employee_id"] 2026-08-03 15:24:31,041 DEBUG [mondrian.sql] 1305: , exec 29 ms 2026-08-03 15:24:31,048 DEBUG [mondrian.sql] 1305: , exec+fetch 36 ms, 1155 rows 2026-08-03 15:24:31,217 DEBUG [mondrian.mdx] 14473: exec: 390 ms