Quanvert special elements
Quanvert axes usually contain various special elements that define special summary and statistics rows and intermediate values that are used during tabulation. Quanvert DSC creates two columns in the virtual table for categorical variables that contain these types of special elements. The first (called varname, where varname is the axis name) stores the responses to the categories and the second (called varname.ex) stores the data for the special elements.
If you examine the data in the database after converting a Quanvert database to a relational MR database, you will see these additional
.ex variables. Some UNICOM Intelligence products, such as UNICOM Intelligence Reporter, recognize the special elements and recombine the two variables when reading a Quanvert database. However, this might not happen when reading a relational MR database and you might therefore see additional
.ex variables listed in the list of variables, and so on. However, you can use the standard variables in the normal way. For more information, see
Quanvert DSC.
Requirements
▪Quanvert 1.6 or later
▪UNICOM Intelligence Data Model 2.7 or later
▪Microsoft SQL Server
See also
1: Preparing the Quanvert database
1 Open the Quanvert database in Quanvert. The first time you do this, Quanvert updates the database and creates a serial number variable called uniq_id.
2 Delete any variables whose name starts with Weight. These are copies of the weighting variables and are superfluous and can cause problems during the conversion.
3 Close Quanvert.
Requirements
Quanvert 1.6 or later
Next topic
See also
2: Creating the .mdd file
The UNICOM Intelligence Data Model includes a component (mdmqvgen2.exe) that can create an .mdd file from a Quanvert database. You run this as follows:
1 Open the Command Prompt.
2 Change to the folder in which the UNICOM Intelligence Data Model components are installed. Typically, this is:
C:\Program Files\Common Files\IBM\SPSS\DataCollection\7\ DataModel.2
3 At the command prompt, type mdmqvgen2 followed by the path of the folder which the Quanvert database is in. For example, if the database is in C:\databases\museum, type:
mdmqvgen2 c:\databases\museum
mdmqvgen2 displays a message indicating whether the creation of the metadata was successful. If not, check that you entered the path correctly. If it was successful, you will find the .mdd file in the folder above the one which the database is in. For example, in this example, the .mdd file would be C:\databases\museum.mdd.
4 For convenience, move the .mdd file to the folder which the database is in.
Requirements
UNICOM Intelligence Data Model
Next topic
See also
3: Creating a new SQL Server database
1 Open SQL Server Management Studio.
2 Use the + symbol to expand the server on which you want to create the database.
3 Select Databases.
4 From the Action menu, choose New Database.
5 Enter a Name for the database.
6 Click OK.
Requirements
Microsoft SQL Server
Next topic
See also
4: Exporting the Quanvert data to the new database
For information on working with the SQL Server Import and Export Wizard, see:
1 From the Windows Start menu, choose: Programs > Microsoft SQL Server > Microsoft SQL Server Management Studio
2 Right-click the appropriate database and select Tasks > Export Data.
This opens the first page of the SQL Server Import/Export wizard.
3 Click Next.
4 From the Data Source list, select UNICOM Intelligence DM-2 OLE DB Provider, and then click Properties.
This opens the Connection tab in the Data Link Properties dialog.
5 From the Metadata Type list, select Intelligence Metadata Document.
6 Enter the Metadata Location, either by typing the name and location of the .mdd file or by clicking Browse. This should be the .mdd file that you created from the Quanvert database.
7 From the Case Data Type list, select Quanvert Database (read-only).
8 Enter the Case Data Location of the Quanvert database. You can either type the name and location of the Quanvert qvinfo or .pkd file into the text box or click Browse and select the file in the Open dialog.
9 Click Test Connection.
Test connection succeeded means that you have entered all of the details correctly.
If Test connection failed is displayed, check that you have entered all of the details correctly.
10 Click OK to return to the Choose a Data Source page of the SQL Server Import/Export wizard, and then click Next.
This opens the Choose a Destination page of the SQL Server Import/Export wizard.
11 From the Destination list, select UNICOM Intelligence DM-2 OLE DB Provider, and then click Properties.
This opens the Connection tab in the Data Link Properties dialog.
12 From the Metadata Type list, select Intelligence Metadata Document.
13 Enter the Metadata Location, either by typing the name and location of the .mdd file, or by clicking Browse. This should also be the .mdd file that you created from the Quanvert database.
14 Select Open metadata read/write.
15 From the Case Data Type list, select UNICOM Intelligence Database (MS SQL Server) (read-write).
16 Enter the Case Data Location. This should be in the form of an OLE DB connection string, for example:
Provider=MSOLEDBSQL.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=MyDatabase;Data Source=LocalHost
17 If necessary, enter your Login ID and Password and click OK.
18 Enter the project name in the Case Data Project text box. Typically, this is the same as the database name.
19 Click Test Connection.
Test connection succeeded means that you have entered all of the details correctly and you have successfully connected to the database.
If Test connection failed is displayed, check that you have entered all of the details correctly, and, if relevant, check your network connection to the server where the database is.
20 Click OK to returns to the Choose a Destination page of the SQL Server Import/Export wizard, and then click Next.
This opens the Specify Table Copy or Query page of the SQL Server Import/Export wizard.
21 Select Copy table(s) and view(s) from the source database, and then click Next.
22 Select the VDATA table for both the Source and Destination, and then click Next.
23 Deselect Run immediately.
24 Select Save SSIS Package.
25 Select SQL Server, if you want to store the SSIS package onto a SQL Server installation, or Structured Storage File, if you want to store the SSIS package in a file.
26 Click Next.
This opens the Save SSIS Package page. The details on this page depend on whether you chose SQL Server or Structured Storage File on the previous page.
27 Enter a Name, Description, and the other details that are required for the SSIS package.
28 Click Next, and then click Finish.
SSIS saves the SSIS package.
Requirements
▪UNICOM Intelligence Data Model
▪Microsoft SQL Server
Next topic
See also
5: Changing the default data source
This topic describes how to change the default data source in an .mdd file. You typically need to do this when you have exported data to a new format and want to analyze the newly exported data in UNICOM Intelligence Reporter. You need to change the default data source because when you load an .mdd file in UNICOM Intelligence Reporter - Survey Tabulation, the default data source is used to connect to the case data.
2 On the left side, select the DataSources folder.
3 On the right side, double-click Default.
This opens the Edit MDM Property dialog.
4 From the list, select the DataSource that you want for the current DataSource, and then click OK.
5 Save the file.
See also