Setting iterator parameters

You can use iterator to run an action group for several times in a cycle. You use the Iterator Parameters window to manage iterator preferences.

1. In the Actions list of the Task window, right-click the action group that you want to run in a cycle, and then select Set Iterator from the pop-up menu.
2. In the iterator Parameters window, click the ellipsis (…) to specify a query for iterator.

   The columns of this query define iterator variables and the number of rows specifies the number of iterations.

3. In the Open window navigate to and select an object that you want to use as a query for iterator.

   The following objects can be used as a query:

   • Charts
   • Visual Queries
   • Analytical Queries
   • Dynamarts
   • Compound Dynamarts
   • Tables
4. Click Finish. The path to the selected object is displayed in the Query path field.
5. The data source that contains the selected object is added to the Data Sources list. You can specify your login information for a data source in the Login and Password fields.
6. To add another data source to the list, perform the following procedure:
   1. Click Add Data Source to open the Add Data Source window.
   2. From the Data Source list, select a data source that you want to add.
   3. Type your login information in the User name and Password fields.
   4. Select the Remember the password check box if you want QMF to remember the password for the user ID that you entered in the User name field.
7. To remove a previously added data source from the list, select this data source, and then click Remove Data Source.
8. In the Variables list, link the query columns with the prompts used in the source object that you specify in Execute object actions. Click in the Prompt name cell and select the prompt from the drop-down list.
9. Use the Continue on failure check box to specify whether to continue iterator work when an error occurs. If the check box is selected and an error occurs within any iteration, iterator skips this iteration and continues working. If an error occurs and the check box is cleared, iterator stops working.
   Note: All error messages can be viewed in the Output view.
10. Click OK to close the Iterator Parameters window.