Is there a way to change the Filter reference for Query Studio Reports.
For example I have a report which pulls data from table A and I want to apply filter on one particular Item. Usually when I apply Filter, Table A is scanned for distinct values and then Displayed under "Pick values from a list". If the table is very big then this takes a long time.
Now I have a seperate table, which contains the values for the filter. So was wondering if there is a way where I can point the Filter to actually look at the Filter Table for displaying the values rather than scanning the Huge original table.
For example I have a report which pulls data from table A and I want to apply filter on one particular Item. Usually when I apply Filter, Table A is scanned for distinct values and then Displayed under "Pick values from a list". If the table is very big then this takes a long time.
Now I have a seperate table, which contains the values for the filter. So was wondering if there is a way where I can point the Filter to actually look at the Filter Table for displaying the values rather than scanning the Huge original table.