Managing Data Model Parameters

Data model parameters are used as dynamic variables for scripts. The data model parameter you create can then be used as a variable in the Column Headings in the Data Model Designer, views, reports and dashboards.

To add a new parameter:

  1. In the Data Models and Views tab, right-click a data model and select Manage Data Model Parameters.

  2. Click Create New Parameter.
  3. In the Manage Data Model Parameters dialog box, perform these steps:

    1. Enter the new parameter's name.

    2. (Optional) Enter a description.

      Tip

      If you add a description for a parameter, you can add its translation by clicking .

    3. Select the appropriate value, which could be a manual entry or a global variable.

    4. Select the appropriate data type from the list. When a global parameter is set, the data type of the Data Model Parameter becomes the data type of the Global Parameter. If there is no Global Parameter set, the user will be allowed to select the data type of their choice.

      Note

      By setting the data type, user input will be validated in the Set Data Model Parameters dialog box.

    5. Select the global parameter in the Prompt drop-down list.

  1. Click Confirm.

To set data model parameters:

  1. In the Data Models and Views tab, right-click a data model and select Set Data Model Parameters.

  2. Enter the appropriate values.

  3. Click Confirm.

Example

Parameters can be used within the Data Model Designer (right-click a data model and select Design Data Model) for calculated columns, using the WHERE clause.