Configure runtime parameters for a logical table
You can configure runtime parameters to assign values to variables in a logical table. When a node is scheduled, the system automatically replaces the variables with their assigned values. This topic describes how to configure runtime parameters for a logical table.
Procedure
From the top menu bar on the Dataphin homepage, choose Develop > Data Development.
In the top menu bar, select a Project. (In Dev-Prod mode, you also need to select an Environment.)
In the navigation pane on the left, select Logical Dimension Table or Logical Fact Table, and then select the target logical table from the list on the right.
In the function bar at the top of the dimension table, click Scheduling Configuration to open the Scheduling Configuration panel.
In the Scheduling Properties pane's Runtime Parameter area, configure the following parameters.
The system automatically generates parameters based on the calculation logic that you configure. You can then modify the parameter type and assign a value.
Parameter
Description
Parameter Name
The name of the parameter as defined in the logical table. The name can contain only digits, letters, and underscores (_). The maximum length is 32 characters.
Parameter Type
Click the Parameter Type drop-down list to change the parameter type. The available types are Global Variable, Namespace Variable, Local Variable, Cross-node Variable, and Non-variable Type. For more information, see Variable Classification.
To modify multiple parameter types at once, select the parameters or click Select All. Then, click Modify Parameter Type at the bottom of the list.
Parameter Value
Global Variable: Defaults to the value defined for the global variable. This value cannot be changed. For more information, see Variable groups and global variables.
Namespace Variable: The value is the name of the namespace. This value cannot be changed.
Local Variable: Enter a value of up to 256 characters, or leave it empty. To enter a date and time, select or refer to an expression in the list. For more information, see Variable Assignment.
Cross-node Variable: After you set upstream dependencies, select an upstream cross-node output parameter as the value.
Non-variable: Not supported.
NoteIf you reference a global variable that has permission management enabled, the system automatically checks whether you have the required permissions. Global variables for which you lack permission are marked with the
icon. To request permission, click Request Permission. You are then redirected to the Permission Management > Variable Permission Management page.Click Save to save the Runtime Parameter configuration for the logical table.