Toad Intelligence Central 6.4 - Release Notes

Custom List of Values for Bind Variables

This feature allows you to define a list of specific values for bind variables, providing you with predefined options to choose from when generating reports. It ensures data integrity by making sure that valid and relevant variable values are selected, reducing errors in reports.

1. Predefined variable values:

   You can define a list of possible values for bind variables when publishing objects (e.g., workbooks, views, automation scripts) from Toad Data Point or Toad Workbook. For details, see the User Guide of the Toad Data Point 6.4.1
   

   The predefined list of values is included as part of the published object in Toad Intelligence Central and after publishing users can use these values or refresh the list to access the latest updates.
   
   

2. Using Predefined Variables

   • Variables are displayed in the Details section under the Variables tab, so users can set default values by typing them in, selecting them from the predefined list or loading values from .txt or .csv files

   • When running a published object, simply choose values from the list of predefined options or load variable values from a file

3. Multiple Value Selection and Restrictions

   • Allow Multiple Value Selection - you can select multiple values from the predefined list. Use a semicolon (;) as a separator when entering multiple values manually

   • Restrict Values to the Predefined List - this option ensures user can only select values from the predefined list. Manual typing is disabled for better control

4. Importing Values from Files

   • Load values directly from a .txt or .csv file - each value in the .txt or .csv file needs to be placed in a new line and no other delimiter should be specified
     

User Permissions:

If You’re a Manager of Published Objects, you can:

• Edit default variable values

• Allow Multi-Select to enable multiple value selection

• Set Restrict to Predefined List to limit variable values

If You’re Not a Manager, you can:

• View variable defaults and settings but cannot edit them

• While running published objects, you can select values based on permissions set by the manager

NOTE:

In Toad Intelligence Central 6.4.1, objects published from earlier versions of Toad Data Point retain their existing settings after upgrade.

• Restrict to Predefined List
  • For objects published with TDP 6.3 or older, this option remains locked and cannot be edited.
  • For objects published with TDP 6.4 or newer, this option is editable and set to unchecked by default.
• Allow Multiple Values
  • For objects published with TDP 6.3, this option is unchecked by default and cannot be changed.
  • For objects published with TDP 6.4, this option is checked by default.
  • For objects published with TDP 6.4.1, this option is unchecked by default.