Variable Builder

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.