These values will be included in the drop down list and will be hardcoded using the “SQL Result” option in “Show” property of the Dashboard Prompt. Create a Dashboard Prompt to set a Presentation Variableįirst of all we need to create a Dashboard Prompt that contains the two possible values for the new Presentation Variable.
The user does not want to have them in separate Dashboard Pages but in one single dashboard page, displaying one report or the other based on a “Measure Selector”. The requirement is to be able to switch between two reports that differ only in some columns (in this case, a set of measures). In this blog article we will show a way of simulating the Column Selector view when we need to change multiple columns in a report. So in the case that we need to change multiple columns, we will be executing multiple intermediate useless queries. An important one is that every time a new subject column is selected, a new query is executed to refresh the data. Unfortunately, using the Column Selector view has some limitation. This view allows the user to select a subject area column dynamically and to get results based on that selection (e.g. This flexibility reduces the number of requests to be developed and increases the user experience.Ī common way of achieving this flexibility is by using the Column Selector view. Dynamically changing the information displayed in a dashboard should be one major objective for the developers.