Pass parameters to data sets related to widgets

Question

Hello.
I'm trying to create cockpits fetching data from fairly large databases wit millions of records. Therefore, I need my datasets to be pretty specific to avoid querying large amounts of data. But at the same time I need about 30 filters on the cockpit. So, I'd like to pass parameters selected in widgets to datasets to get only the data I need  to avoid poor performance. The problem is that I can't find any ways to pass parameters to datasets associated with widgets. I cant only set the parameter values when I add the widget. Is it even possible to do that or perhaps there's a workaround? Thanks!

Answer 1

Somehow I missed it from the tutorial, but there are two places, where you can create a cockpit - in "MyWorkspace" and in "Documents". Only the latter option offers adding an analytical driver on the cockpit. Then the cockpit will have a previously absent "parameters" section on the toolbar. We can set those there and then pass the set values to the dataset parameters.

For example, we can add a driver on the dashboard and give it a url of "name", then setting the dataset parameter to $P{name} will do the trick. Hope it helps someone.