Setting up the RDB Short Drinks project

This topic describes how to use UNICOM Intelligence Interviewer - Server Admin to create a UNICOM Intelligence Reporter - Survey Tabulation project that uses the Short Drinks sample data set.

▪access permissions for creating UNICOM Intelligence Interviewer - Server Admin projects and using the Manage Files activity

▪access to a SQL Server installation and appropriate user access rights. The database comes as a SQL Server backup

1 Restore the backed-up database.

Next, create the UNICOM Intelligence Interviewer - Server Admin project and upload the sample .mdd file.

2 On the toolbar at the top of the My Projects list, click the New Project button

3 From the Project Type list, select Analyze existing data.

4 In the Name text box, enter the project's name as you want it to appear in the UNICOM Intelligence Interviewer - Server Admin project list, for example, Short Drinks. This name is for display purposes only and can be changed at any time during the project's life cycle.

5 In the Description text box, enter a more detailed description of the project.

6 Click OK. The project is created using the default settings, and the Upload Existing Data dialog appears.

7 In the Data Type list, select Other.

8 Click the Browse button beside the File to Upload field, and in the Choose File dialog box, browse to the location where the Short Drinks .mdd file is installed. By default, this is:

[INSTALL_FOLDER]\IBM\SPSS\DataCollection\7\DDL\Data\Mdd

9 Select the short_drinks.mdd file. The file begins to upload immediately. You are asked whether you want to change the name of the .mdd file to match the Project ID. Click No. When the upload is complete, the name of the file appears in the File(s) uploaded list.

10 Click Finish. You are prompted to edit the project properties to set the connection string. Click OK.

11 On the toolbar at the top of the My Projects list, click the Edit Project button

12 Click the Connection tab to display the properties for the project, then click Edit. This displays the Connection tab of the Data Link Properties dialog box.

13 In the Metadata Type list, select UNICOM Intelligence Metadata Document if it is not already selected.

14 Click Browse next to the MetaData Location field. In the Select File dialog box, select the short_drinks.mdd file and click Select.

15 From the Case Data Type list, select UNICOM Intelligence Database (MS SQL Server).

16 If necessary, type short_drinks in the Case Data Project box.

17 Click OK, and then click the Home button to close EditProject

This creates the project and adds it to the list of UNICOM Intelligence Interviewer - Server Admin projects.