Has anyone discovered a way to make a single select text filter load "empty" by default? This used to be possible in the Windows version, but now that we have migrated to Linux, we have lost that ability.
Use case...we have created dashboards that are deployed and used by different clients (in this case, we display academic data, so our clients filter their dashboards by "Term"). However, our clients all name their terms differently...so we can't set a default value. In Windows you could remove the default value in the .dash file, and then the filter would load empty, therefore making the client choose a value to display data.
In Linux, that now causes the dashboard to load ALL Term values....even on a single select filter. This can be an overwhelming amount of data, and cause timeouts.
Has anyone solved this type of issue in the Linux versions?
Thanks for any pointers.
if you have a text column and you do a text filter in it, you can specify the way the text is filtered at start, the only thing they need to do is change the filter value to something else after (see attachment)
But I think the best way to do it is to narrow down the values that are on your Terms table by doing a segregation on the data security for the cube, that way only users that have access to those terms will be able to see them and you can use the "Include All" functionality as normal.
for more info on data access security
Sisesne R&D have plans on changing this behavior to mach the behavior on Windows version, no ETA but we should see changed in upcoming releases.
As for now I would suggest to add a dummy value to the column from the filter and select it as a default value. This way every user will see this dummy value and will have it selected on dashboard load and will see no data, therefore will have to select a correct/desired value inside filter.