Wednesday, January 18, 2012

Multiple parameters in CDF / CDE

This tech tip shows how to configure multiple parameters to work in CDE / CDF.

We can use any query, but on this case we'll start with the parameter wizard, located in the datasources panel.

Create a new dashboard and go to the datasources panel. Under the "Wizards" select parameter wizard. Select a cube / dimension and drag it to the rows.


 I selected the multiplebutton but any of the other multiple selection component would work too. The multiple button component supports both single selection (default) or multiple selection. We need to activate it in the component that was generated by the wizard


The generated code works, but we may want to define a set of defaults be preselected. In order to do that, we need to delete our simple parameter and  add a custom parameter with the following code:
["[Markets].[EMEA]","[Markets].[NA]"]



This array has to match the id's we use in the parameter. That way, when we preview the dashboard we get those parameters selected by default as we wanted

Have fun!


-pedro

0 comments:

Post a Comment