Creating Variables in the Variable Builder

  To add a variable in the Variable Builder:

1. Enter a name to identify the variable.

   You can enter any alphanumeric character. You cannot enter spaces.

   Existing variables are listed under Local Variables in the Operations pane. You cannot an existing variable name.

2. Specify a variable type by clicking next to String, Numeric, or Date.

3. Add the variable:

   • Select an operation and drag it on a column in the left pane.

   • Drag an operation or column into the Variable field.

   • Double-click an operation or column to enter it into the Variable field.

   • Type in the variable.

   To delete a variable from the Variable field, click Clear.

   The types of operations that you can use in your variables appear under the Operations pane on the right-hand side of the Variable Builder (for example, numeric functions, file functions, or operators). To view the available options for an operation, click the plus sign (+) next to the operation, or double-click the operation. (For more information on Production Reporting operations, see Volume 2 in the Hyperion SQR Production Reporting Developer's Guide.)

4. Click OK to close the Variable Builder

   If you accessed the Variable Builder by clicking or by selecting Insert, then Variable, the variable is displayed in your report layout.

   If you accessed the Variable Builder from the Report Fields dialog box, the variable is displayed under the Variables tab. At this point, you can add additional variables, insert the variable into the layout, or close the Report Fields dialog box.

   Tip:

   You can use the name of a calculated field in your variable. For example, could create a calculated field TotalSalarybyRegion and insert into your variable as follows: