2026-07-30 17:57:28,532 DEBUG [mondrian.mdx] 10188: USER_ID="null" CUBE="Sales" SESSION_ID="44li9327uql" query: select NON EMPTY Hierarchize(AddCalculatedMembers({[Time].[Year].Members})) DIMENSION PROPERTIES PARENT_UNIQUE_NAME, HIERARCHY_UNIQUE_NAME ON COLUMNS from [Sales] 2026-07-30 17:57:28,536 DEBUG [mondrian.mdx] 10205: USER_ID="null" CUBE="Sales" SESSION_ID="44li9327uql" query: select NON EMPTY Hierarchize(AddCalculatedMembers({[Time].[Year].Members})) DIMENSION PROPERTIES PARENT_UNIQUE_NAME, HIERARCHY_UNIQUE_NAME ON COLUMNS from [Sales] 2026-07-30 17:57:28,547 DEBUG [mondrian.mdx] 10205: exec: 11 ms 2026-07-30 17:57:28,547 DEBUG [mondrian.mdx] 10188: exec: 13 ms 2026-07-30 17:57:30,333 DEBUG [mondrian.mdx] 10283: USER_ID="null" CUBE="Sales" SESSION_ID="44li9327uql" query: select NON EMPTY Hierarchize(AddCalculatedMembers({[Time].[Year].Members})) DIMENSION PROPERTIES PARENT_UNIQUE_NAME, HIERARCHY_UNIQUE_NAME ON COLUMNS, NON EMPTY Hierarchize(AddCalculatedMembers({[Time.Weekly].[(All)].Members})) DIMENSION PROPERTIES PARENT_UNIQUE_NAME, HIERARCHY_UNIQUE_NAME ON ROWS from [Sales] 2026-07-30 17:57:30,333 DEBUG [mondrian.mdx] 10282: USER_ID="null" CUBE="Sales" SESSION_ID="44li9327uql" query: select NON EMPTY Hierarchize(AddCalculatedMembers({[Time].[Year].Members})) DIMENSION PROPERTIES PARENT_UNIQUE_NAME, HIERARCHY_UNIQUE_NAME ON COLUMNS, NON EMPTY Hierarchize(AddCalculatedMembers({[Time.Weekly].[(All)].Members})) DIMENSION PROPERTIES PARENT_UNIQUE_NAME, HIERARCHY_UNIQUE_NAME ON ROWS from [Sales] 2026-07-30 17:57:30,335 DEBUG [mondrian.mdx] 10283: exec: 2 ms 2026-07-30 17:57:30,335 DEBUG [mondrian.mdx] 10282: exec: 2 ms 2026-07-30 17:57:36,979 DEBUG [mondrian.mdx] 10387: USER_ID="null" CUBE="Sales" SESSION_ID="44li9327uql" query: select NON EMPTY Hierarchize(AddCalculatedMembers({[Time].[Year].Members})) DIMENSION PROPERTIES PARENT_UNIQUE_NAME, HIERARCHY_UNIQUE_NAME ON COLUMNS, NON EMPTY Hierarchize(DrilldownMember({{DrilldownMember({{[Time.Weekly].[(All)].Members}}, {[Time.Weekly].[All Time.Weeklys]})}}, {[Time.Weekly].[All Time.Weeklys]})) DIMENSION PROPERTIES PARENT_UNIQUE_NAME, HIERARCHY_UNIQUE_NAME ON ROWS from [Sales] 2026-07-30 17:57:36,979 DEBUG [mondrian.mdx] 10389: USER_ID="null" CUBE="Sales" SESSION_ID="44li9327uql" query: select NON EMPTY Hierarchize(AddCalculatedMembers({[Time].[Year].Members})) DIMENSION PROPERTIES PARENT_UNIQUE_NAME, HIERARCHY_UNIQUE_NAME ON COLUMNS, NON EMPTY Hierarchize(DrilldownMember({{DrilldownMember({{[Time.Weekly].[(All)].Members}}, {[Time.Weekly].[All Time.Weeklys]})}}, {[Time.Weekly].[All Time.Weeklys]})) DIMENSION PROPERTIES PARENT_UNIQUE_NAME, HIERARCHY_UNIQUE_NAME ON ROWS from [Sales] 2026-07-30 17:57:36,981 DEBUG [mondrian.mdx] 10389: exec: 2 ms 2026-07-30 17:57:36,981 DEBUG [mondrian.mdx] 10387: exec: 2 ms 2026-07-30 17:57:47,345 DEBUG [mondrian.mdx] 10738: USER_ID="null" CUBE="Sales" SESSION_ID="44nsgyhwikl" query: select NON EMPTY Hierarchize(AddCalculatedMembers(DrilldownMember({{[Product].[(All)].Members}}, {[Product].[All Products]}))) DIMENSION PROPERTIES PARENT_UNIQUE_NAME, HIERARCHY_UNIQUE_NAME ON COLUMNS, NON EMPTY Hierarchize(DrilldownMember({{[Store].[(All)].Members}}, {[Store].[All Stores]})) DIMENSION PROPERTIES PARENT_UNIQUE_NAME, HIERARCHY_UNIQUE_NAME, [Store].[Store Name].[Store Type], [Store].[Store Name].[Store Manager], [Store].[Store Name].[Store Sqft], [Store].[Store Name].[Grocery Sqft], [Store].[Store Name].[Frozen Sqft], [Store].[Store Name].[Meat Sqft], [Store].[Store Name].[Has coffee bar], [Store].[Store Name].[Street address] ON ROWS from [Sales] 2026-07-30 17:57:51,441 DEBUG [mondrian.mdx] 10738: exec: 4096 ms 2026-07-30 17:58:25,832 DEBUG [mondrian.mdx] 11922: USER_ID="null" CUBE="Sales" SESSION_ID="44o2bk0b4lq" query: select NON EMPTY Hierarchize(AddCalculatedMembers({[Yearly Income].[(All)].Members})) DIMENSION PROPERTIES PARENT_UNIQUE_NAME, HIERARCHY_UNIQUE_NAME ON COLUMNS from [Sales] 2026-07-30 17:58:25,832 DEBUG [mondrian.mdx] 11923: USER_ID="null" CUBE="Sales" SESSION_ID="44o2bk0b4lq" query: select NON EMPTY Hierarchize(AddCalculatedMembers({[Yearly Income].[(All)].Members})) DIMENSION PROPERTIES PARENT_UNIQUE_NAME, HIERARCHY_UNIQUE_NAME ON COLUMNS from [Sales] 2026-07-30 17:58:25,839 DEBUG [mondrian.mdx] 11923: exec: 7 ms 2026-07-30 17:58:25,839 DEBUG [mondrian.mdx] 11922: exec: 7 ms 2026-07-30 17:58:28,234 DEBUG [mondrian.mdx] 11986: USER_ID="null" CUBE="Sales" SESSION_ID="44o2bk0b4lq" query: select NON EMPTY Hierarchize(AddCalculatedMembers({[Yearly Income].[(All)].Members})) DIMENSION PROPERTIES PARENT_UNIQUE_NAME, HIERARCHY_UNIQUE_NAME ON COLUMNS from [Sales] 2026-07-30 17:58:28,234 DEBUG [mondrian.mdx] 11987: USER_ID="null" CUBE="Sales" SESSION_ID="44o2bk0b4lq" query: select NON EMPTY Hierarchize(AddCalculatedMembers({[Yearly Income].[(All)].Members})) DIMENSION PROPERTIES PARENT_UNIQUE_NAME, HIERARCHY_UNIQUE_NAME ON COLUMNS from [Sales] 2026-07-30 17:58:28,235 DEBUG [mondrian.mdx] 11986: exec: 1 ms 2026-07-30 17:58:28,235 DEBUG [mondrian.mdx] 11987: exec: 1 ms