About Parameter Properties

How and where you want to use a parameter determines the properties that you set for it. For example, you might set different properties for a parameter that you want to use as a filter control versus a parameter that you want to use in an expression.

These are the properties that you can set when you create or modify a parameter:

Data Type

Specifies the kind of data the parameter contains and the values or range of values that the parameter accepts. The data type is also used to validate that the parameter is compatible and any expressions are generated correctly for the location where you use the parameter.

Allow Multiple Values

Determines if the parameter can accept a single initial value or multiple initial values.

After you enable multiple values, you use the Initial Value field to specify more than one initial values or write a SQL statement to provide initial values. When your parameter includes multiple initial values and you use the parameter as a filter control, the user can choose one or more initial values.


Many datasets use unfriendly names for the data elements. Use an alias to help users understand what the data element is. For example, instead of LST_OR_DT, you can create an alias "Last Order Date" to make the data element name user-friendly.

Use aliases to provide more familiar, user-friendly names for users to choose from filter controls. For example, for a data value of 1, you can provide an alias of East Sales Region, and for a data value of 2, you can provide an alias of West Sales Region.

You can define aliases when the Possible Values field is set to Value.

Possible Values

A parameter's possible values are any, value, a Logical SQL query, and a range of values.

Select Any to allow users to enter any value supported by the data type.

Select Value to provide one or more values that the user can choose from. If Allow Multiple Values is enabled, then users can choose more than one value.

Select Logical SQL Query to enter a Logical SQL statement to return one or more possible values. You can reference other parameters within the Logical SQL statement.

Select Range to provide start and end values to limit the value a user can choose from.

Initial Value

The initial value is the parameter's default value that is displayed when the user opens the workbook.

You can use a Logical SQL statement to provide a parameter's initial value. You can reference other parameters within the Logical SQL statement.