Forum Discussion
filter on multiple values using parameter, in the query editor
Hi AnonymousLydia,
thanks for your reply. I will try to include the screenshots if really necessary but let me try to explain further.
Yes there is of course for each parameter multiple values to choose from, but still only one current value that you can assign to the parameter at one time.
The first link that you provide is a very good example of what I would like to achieve
They filter the FactInternetSales table by using a parameter to filter the Product Category (choosing 1 value only), that will itself filter the Product Sub Category and cascade down to the fact tables.
However, they do that on the report, after full import of the dim & fact tables. My goal, in using a parameter, would be to do it during the import (in the query editor). I have a subcategory information directly in the fact table (on top of the product code), which allows to do some filtering. If I could do this filtering, this would allow to load only the filtered data and improve the loading/refresh time.
Do you see a way to achieve this?
I have exactly the same question :manfrustrated:: how to use the WHOLE list as the filter?
I understand how to use the Paremeter list to filter on ONE value, but I'd like to use it to overcome a query Folding issue (filters and transformations are done on Server rather your laptop, so you odn't need to download 8M rows first..), by applying something like a "where IN" SQL statement to the filter/query.
Maybe the Paremeter is not the way to go here? The need to limit a set of results based on "return only the following few items from the big database" seems like a fairly basic requirement; I do it in SQL all the time using [where xx IN ('abc', 'abd', etc)].
Did you find a solution to this?
It seems odd that you can provided a list of values to use as a parameter but you can only select (manually) one at a time and not load up all of the list.
Please tell me I am missing something obvious on how to use the "List of values" option.
Thanks
Hello,
no i have not found any solution to date.