Variable Builder
- Laura Hounshell (Unlicensed)
- Alex Burns (Unlicensed)
- Former user (Deleted)
Variable Builder is used to create and save a variable. These variables can be used instead of a manually entered value in a cube or a TouchPoint query criteria. A variable can be set up with a single value, list of values, or it can be set up to pull values to be included in criteria using an SQL Query. The main form lists existing variables.
Icon | Description |
|---|---|
| Opens the Add Global Variable dialog. |
| Opens the Prompt Variable dialog |
| Edits the currently selected variable. |
| Deletes the currently selected variable. |
| Shows all user created and system variables. |
| Closes the Variable Builder dialog. |
Add Global Variable
Global variables are a convenient way to store commonly used field values. For instance, if you have a list of states you do not want to mail, you can create a global variable, call it "DoNotMailStates", attach it to the State field, and select the states as the values. Later, when you use the State field – regardless of what MarketWide module you are in-- you can select the DoNotMailStates variable as a value.
To Add a Global Variable
- Open the Add Variable Dialog (
). - Type in a name for the variable, and a description.
- Ensure that the correct field is selected in the "attached to" section.
- Under Values, select single or list.
- Fill in desired values or type in SQL query.
- Click OK to submit.
Add Prompt Variable
When included in a query or campaign, a prompt will appear requiring the user to enter a value specific for that variable when the query or campaign is submitted. Prompt variables are report specific, and only exist within the campaign or query in which they were created.