When an extract group is selected that is a KiWIS extract group, information displayed in the Extract Linking section (Extract Editor) is the data Type, KiWIS Url, and the User name and Password needed to access a WISKI database. The

TS Group Id lists all the group ID's in a WISKI database. The TS Group Id can be used to filter WISKI records, which will increase the speed of the query process for large databases when accessing them through HEC-RTS.

The Extract Linking table (Extract Editor) displays the following information when a KiWIS extract group has been selected:

This information does not display by default in the Extract Linking table, you will need to set up the table view, see Extract Editor.

Create a KiWIS Extract Group

A KiWIS extract group maps time series data from the WISKI database to the required model alternative's input time series records that will be stored in the forecast.dss file. You will need the KiWIS URL, a username, and a password to set up a KiWIS extract group.

To create a KiWIS extract group:

1. From the HEC-RTS main window, click on the Setup tab, from the Models menu, click Edit Extract, the Extract Editor will open (Extract Editor).
2. From the Extract Editor, from the Extract Groups box (Figure 1), click New Extract Group. The New Extract Group dialog will open (Figure 2).
   
    
3. In the Name box (Figure 2), enter a name for your KiWIS extract group.
4. From the Type list (Figure 2), select Time Series for the data being extracted and mapped.
5. From the Source list (Figure 2), select KIWIS.
6. From the User box, enter your user login (Figure 2) and from the Password box, enter the password that is associated with the entered user login. Both the username and password are case sensitive. From the KiWIS Url box, enter the url for the WISKI database.
7. The items in the DSS Storage Options box (Figure 2) are only applicable to Oracle and DSS source files. No changes to these values are necessary when using KiWIS as your data source.
8. By default, Run by Default (Figure 2) is selected, which means the extract group will run automatically when a forecast is being computed.
9. Specify the Time Window to extract the data from the Start and End lists (Figure 2); available options are: Extract Start, Start of Simulation, Forecast Time, End of Simulation. Offsets for the start and end times can also be included, available options are: hours, minutes, or seconds. In the Offset box, you will enter the offset increment. This time window is relative to the forecast time window the you defined when you created the forecast.
10. When you are done, click OK, the New Extract Group dialog will close (Figure 2). The new extract group will display at the bottom of the Extract Groups box (Figure 1), and the information about the extract group will display.

Note: Extract groups are run in the order they are displayed in the Extract Groups box. If you run more than one extract group during the extract process and there are records that are mapped in more than one of the selected extract groups, the last extract group mapping will replace all previous mappings.

Adding Required Input Data to Extract Groups

Once an extract group is defined, you can select what Required Input data you want to map to the selected source data. In this case the source data is the WISKI database. Detailed information is provided in Extract Groups.

Selecting KiWIS Source Records

When Required Input records are added to a KiWIS extract group, they display the name of the required input record under the From KiWIS column in the Extract Linking table (Extract Editor). The From KiWIS record pathnames need to be replaced with WISKI database source time series records that will provide data to the To forecast.dss column of the Extract Linking table (Extract Editor).

To select a WISKI database time series record for the From KiWIS record:

1. The TS Group Id list (Figure 3), in the Extract Linking section, provides a list of all the time series groups created in KiWIS. The TS Group Id is used in the Extract Editor to manage the size of a WISKI database request and speeds up the time required to populate the list of records when selecting KiWIS records for the extract.
   
2. Double-click the row in the From KiWIS column (Figure 3) you would like to set the KiWIS time series record for. Click the ellipse that appears in the right section of the cell with the From KiWIS name (Figure 3). The KiWIS Time Series Record Chooser dialog will open (Figure 4).
   
3. You can filter the KiWIS pathnames displayed in the table by using the Search By Parts Parameters at the top of the KiWIS Time Series Record Chooser.
4. To select a KiWIS time series record to replace the one displayed in the selected row back on the Extract Linking table, click the time series record row in the KiWIS Time Series Record Chooser dialog (Figure 4), click Set Pathnames.
5. The WISKI database time series record you selected will display back on the Extract Linking table in the row you original selected.
6. To set another KiWIS time series record, click on the next row in the Extract Linking table where you would like to replace the record. From the KiWIS Time Series Record Chooser dialog (Figure 4), click on the WISKI database time series record you want, click Set Pathname.
7. When all of the KiWIS time series records have been set in the Extract Linking table, from the KiWIS Time Series Record Chooser dialog (Figure 4), from the File menu, click Close.

Ad-Hoc Records - Extract

Additional input data not listed in the Required Extract table may be required for a forecast compute. You can add additional time series records from the WISKI database using the Ad-Hoc Record feature. An Ad-Hoc record allows you to add WISKI database time series records to a DSS time series record in the forecast.dss file.

To add a WISKI Ad-Hoc record:

1. From the Extract Editor, click Add Extract Data Set, the Adhoc: KiWIS Time Series Record Chooser dialog will open.
2. From the Search By Parts area, use the various filter lists to locate the desired WISKI database time series record.
3. Select the pathname row for the record, click Set Pathname.
4. Once you have selected all the pathnames for all the necessary time series records, from the File menu, click Close. The Adhoc: KiWIS Time Series Record Chooser dialog will close.

The From KiWIS and To forecast.dss time series records (Extract Linking table) will display the same pathname. The time series record pathname displayed in the To forecast.dss column of the Extract Linking table will need to be changed to a conventional DSS pathname. You can either enter the DSS pathname, or select one through the KiWIS Time Series Record Chooser dialog (Figure 4).

To select a DSS pathname using the KiWIS Time Series Record Chooser:

1. From the Extract Editor, from the Extact Linking table, select the To forecast.dss record you would like to change.
2. Click Browse To, the KiWIS Time Series Record Chooser dialog will display (Figure 4).
3. From the KiWIS Time Series Record Chooser dialog (Figure 4). from the File menu, click Open. An Open HEC-DSS File browser will open, browse to location of the DSS file you will be copying time series record to, select the filename, click Open. The Open HEC-DSS File browser will close, the DSS file is displayed.
4. Select the pathname for the DSS record listed in the table, click Set Pathname. This will copy the selected record to the Extract Linking table (Extract Editor).
5. When you are finished selecting the DSS pathnames, from the File menu, click Close. The KiWIS Time Series Record Chooser dialog will close (Figure 4).

Running Extracts

Now that you have defined and setup extract groups, you can run extracts. HEC-RTS provides two ways to run extracts - automatic or manually. Running Extracts provides details.