Adding a Data Model Parameter

Data Model Parameters are used as dynamic variables for Scripts.

To add a new parameter:

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

2. Click .

   1. Enter the name.

   2. If you enter a description, you can add its translation by clicking .

   3. Select a global variable from the Value drop-down list.

   4. Select a parameter from the Global Parameters drop-down list.

   5. Click Confirm.

   Example

   Here, we add a Month parameter with the Current month value. The @@UDM_CURMONTH global variable is automatically created and you can access this dynamic variable in the SQL Scripts Builder of the Design Data Model window.
   

   

3. When opening a Worksheet, right-click the Data Model and select Set Data Model Parameters.

4. Click Confirm to finish.
   

   

5. Click Skip to bypass values in the Data Model Parameters window.