Good Day Guys,
I have a set of queries running against Dremio from Qlik (Qlik sends queries against the VDS based on the user’s selection)
VDS: has a Raw reflection and an aggregated reflection
Base Table: Only has a raw and aggregated reflection:
what seems to happen is that all my queries against the VDS seem to ignore both the aggregated reflections and only use the Raw reflection from the base table.
Am I perhaps missing something here?
please see sample query & profile below
Select fin_year_no as "Financial Year", business_unit_name as "Business Unit", fin_year_no as VSort, BUSINESS_UNIT_NO as HSort, business_unit_name as HDim, fin_year_no as VDim, count(distinct UCID) as UCID From "Qlik Sense".Marketing."Customer Landscape".FullDYTableUpdated11June --Where location_no in (103) group by fin_year_no,business_unit_name,BUSINESS_UNIT_NO
bf0c803b-3fd4-401c-a40d-535f93d91227.zip (147.0 KB)