Control dropdowns not populated in analysis / dashboard that uses a dataset with a dataset parameter

Question & Answer
, , , ,
1

I have an analysis where one of the parameters was mapped to a data set parameter. When I pass the proper values for the analysis parameter, correct data is selected from the dataset. However, in my control dropdowns, there are no values shown. As soon as I switch out the data set for one that does not have a data set parameter, the control drop downs are populated. Is there something I need to do in order to populate these dropdowns?

2

Hello,

You can manage your dataset parameters in the Parameters pane of the analysis that is using the dataset that the parameters belong to. In the Dataset Parameters section of the Parameters pane, you can choose to see only the unmapped dataset parameters (default). Alternatively, you can choose to see all mapped and unmapped dataset parameters by choosing ALL from the Viewing dropdown.

3

No, the problem is that the control drop downs in the Analysis and Dashboard aren’t populated with values when I use a DataSet with DataSet parameters (after I’ve mapped them). As soon as I switch out the DataSet with one that does not use DataSet parameters, the values in the control drop downs are populated. This seems like a bug to me, and I created a trouble ticket for it, but I was told to post here.

4

Hello @Bryan_Zeigler, my apologies for the delayed response. If this is an issue you are still dealing with, I believe I understand the problem.

If a parameter is mapped at the dataset level, then you are attaching a control to that same dataset, the control will only show the parameter value. When applied at the dataset level, it is filtering the data that will be returned to the control so the only value that will populate in that field is the one in your parameter.

What you want to do, is set that parameter on the analysis level, create a control from it, and attach that control to that field in a dataset that is not filtering returned values from the parameter.

That should give you the output you are expecting! I will mark my response as a solution for now, but if you still need further guidance on this process, I am happy to help!