Intellicus Enterprise Reporting and Business Insights 19.0

Slider

0 views June 28, 2020 0

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:

  1. Under Slider Source, select Pre Defined
  2. Specify Minimum Value and Maximum Value for the slider that should be displayed on Input Parameter Form (IPF).
  3. In Step entry box, specify the value that should be used to step up and down the slider.
  4. 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).

Pre Defined values
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:

  1. Under Slider Source, select Dynamic
  2. In Source Statement, specify SQL to be used to get data.
  3. Click Verify If the SQL is valid, the values it returned will be listed in Minimum Column and Maximum Column.
  4. Specify Minimum Column and Maximum Column for the slider that should be displayed on Input Parameter Form (IPF).
  5. In Step entry box, specify the value that should be used to step up and down the slider.
  6. 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).

Defining a Dynamic statement
Figure 7: Defining a Dynamic statement for a Slider Parameter