This is applicable when input type for the parameter is Slider. Slider works for Date or Number data types. Values that should appear on slider can be pre-defined or dynamically fetched from database.
To set pre-defined values
You need to follow the below steps to set pre-defined values for a slider parameter:
- Under Slider Source, select Pre Defined
- Specify Minimum Value and Maximum Value for the slider that should be displayed on Input Parameter Form (IPF).
- In Step entry box, specify the value that should be used to step up and down the slider.
- You can specify the Time Level as day, month, year etc. to be used as a unit for Step (in case of Date data type).
Figure 6: Pre Defined options for a Slider Parameter
To get dynamic values
You need to follow the below steps to get dynamic values for a slider parameter:
- Under Slider Source, select Dynamic
- In Source Statement, specify SQL to be used to get data.
- Click Verify If the SQL is valid, the values it returned will be listed in Minimum Column and Maximum Column.
- Specify Minimum Column and Maximum Column for the slider that should be displayed on Input Parameter Form (IPF).
- In Step entry box, specify the value that should be used to step up and down the slider.
- You can specify the Time Level as day, month, year etc. to be used as a unit for Step (in case of Date data type).
Figure 7: Defining a Dynamic statement for a Slider Parameter