Prompt in analysis for dimension value on load
Our users would like to "search" (select) a specific product (e.g. Product number 123456) and load an analysis with criteria set to e.g. "Product Number = 123456". Our issue is that the product dimension has 100k+ values.
So today they have to load the analysis. Use criteria bar to filter on product 123456, where the "search" takes a very long time.
Other BI tools are able to prompt before loading data, hence making it possible to load much less data.
Furthermore, it would be great if it could just load the data, without validating that the product number 123456 actually exists in the dimension (again - we need it to load fast).