Add Rule Parameter

Introduction

Users can specify Rule Parameters to pass values to SQL Rules. Rule Parameters are useful when a Rule requires end-user input. This article demonstrates how to add Rule Parameters.

 

 

Add Parameter

1. Go to Modeler and select the target SQL Rule.

 

 

Tip: If you do not know how to create a SQL Rule, refer to this article. 

 

2. Select Edit and go to the Parameter tab.

 

 

3. Select Add to create a new parameter.

 

 

4. In the Add Rule Parameter window, enter a Parameter Name (used for SQL definition) and a Display Name (user-friendly name).

 

 

5. In the Type dropdown, select the Parameter type:

 

• Float: Pass numeric values to the SQL Rule
• String: Pass text values to the SQL Rule
• Member Picker: Pass selected Member(s) from a controlled list to the SQL Rule, rather than a typed value

 

6. Configure type-specific settings.

7. Select OK. 

 

The Add Rule Parameter window should close, and you should see your parameter added. You can start using the parameter(s) in the SQL Rule.

 

 

Tip: You can edit a parameter's definition by selecting the gear icon under the Edit column. 

 

 

Type-Specific Settings

This section explains how to configure settings for the different Parameter types. 

 

Float

Below are specific settings for the Float Parameter type.

 

Format

Specify the Parameter's display format:

 

• Default/Standard: Rule will treat value as is (1 as 1)
• Percent: Rule will treat value as a percentage (1 as 1%)

 

 

Default (Optional)

Specify a default value for the Parameter. If nothing is specified, the input box for the Parameter will be blank when the Rule window is opened. 

 

 

Here is an example of the SQL Rule with a Float Parameter:

 

 

String

Below are specific settings for the String Parameter type.

 

Default (Optional)

Specify a default value for the Parameter. If nothing is specified, the input box for the Parameter will be blank when the Rule window is opened. 

 

 

Height

The default height of a String input box is 25 px. Customize the height of the input box by changing this value.

 

 

Here is an example of the SQL Rule with a String Parameter:

 

 

Member Picker

Below are specific settings for the Member Picker Parameter type.

 

Dimension and Hierarchy

Select the relevant Dimension for the Parameter from the Dimension and Hierarchy dropdowns. These selections define the controlled list users will choose from.

 

 

Member (Optional)

Select a default Member for the Parameter. If nothing is specified, users will see "Please select..." in the dropdown.

 

 

Multi-select

This option allows users to choose multiple Members.

 

(Leaves Only) Selectable

This option restricts users from picking only leaf-level Members.

 

(All) Non-Selectable

This option prevents users from choosing the All Dimension Member.

 

 

Here is an example of the SQL Rule with a Member Picker Parameter: