Filter
Top Products
8
Chapter 2
Default settings for database connections.
You can now specify default settings for SQL Server
and Oracle dat
abase connections, as well as those already supported for IBM DB2 InfoSphere
Warehouse.
Stream properties and optimization redesign.
The Options t ab on the Stream Properties dialog box
has been redesigned to group the options into categories. The Optimization options have also
moved from User Options to Stream Properties. For more information, see the topic Setting
Options for Streams in Chapter 5 on p. 54.
Node execution timing.
You can now set an option to display individual execution times for
the nodes in a stream. For more information, see the topic Viewing Node Execution Times in
Chapter 5 on p. 67.
You can also set an option (time_ecode_execution_log) in the server configuration file to record
these execution times in the message log.
Stream parameters in SQL queries from Database source node.
You can now include SPSS Modeler
stream parameters in SQL queries that you enter in the Database source node.
Expression Builder supports in-database functions.
If a stream connects to a database through a
Databa se source node and you u se the Expression Builder with a downstream node, you can
include in-datab ase functions from the connected datab ase directly in the expres sion you are
building. For more information, see the topic Selecting Functions in C hapter 7 on p. 120.
IBM Cognos BI node enhancements.
The Cognos BI source node now supports importing Cognos
list reports as well as data, and add itionally supports the use of parameters and filters.
For the Cognos BI source and export nodes, SPSS Modeler n ow automatically detects the version
of IBM Cognos BI in use.
Enhancements to Aggregate node.
The Aggregat e node now supports several new aggregation
modes for aggregate fields: median, count, variance, and firs t and third quartiles.
Merge node supports conditional merge.
You can now p erform inpu t record merges that depend on
satisfyi ng a condition. You can specify the condition directly in the node, or build the condition
using the Expression Builder.
Enhancements to in-database mining nodes for IBM DB2 InfoSphere Warehouse.
For in-database
mining with IBM DB2 InfoSphere Warehouse, the ISW Clustering nod e now supports the
Enhanced BIRCH algorithm in addition to demographic and Kohonen clustering. In addition, the
ISW Association node provides a choice of layout for non-transactional (tabular) da ta.
Table compression for database export.
When exporting to a database, you can now specify table
compression options for SQL Server and Oracle database connections, as well as those already
supported for IBM DB2 InfoSphere War ehouse.
Bulk loading for database export.
Additional help information is availab le for da tabase bulk loading
using an external loader program.