Hello, We use Amazon Redshift as our data source and were keen to be able to have users adjust the data that is feed into their Dashboards from Data Cubes by passing parameters from the Dashboard back into a data cube and having a refreshed output passed back. There seems to be a method to do this if we use a Microsoft SQL Server 2016 source with a stored procedure but you use Amazon Redshift because of the size of the data we work with. We of course understand that we can filter data using Dashboard controls like slicers but we need to be able to tap in to the greater capabilities of the SQL side. Any ideas?
Passing Parameters back to Data Cubes from Dashboards (without Stored Procedures)
This can be done on top of any data source (not only on top of SQL Server using Stored Procedures). The key here is to make sure that the parameters defined under the data cube are set to be "Public" by checking the "Public" checkbox under the parameter settings screen. By marking a parameter as "Public" you allow a filter control to be connected to it from the dashboard. Parameters can be added under the data cubes different transforms or by using placeholders within a manual SQL query. By default you will be able to connect the public parameters with a matching filter from the same data type (i.e. a textbox filter with a string parameter) so you may want to consider promoting the public parameter to use a bridge parameter that will allow you to then use any hierarchy to filter your data using standard filters like member filters or date range filters (but still sending those filters back to your data cube).
Here is a screenshot of the parameters setting dialog under the filter transform:
