Model Properties

Teradata Warehouse Miner User Guide - Volume 1Introduction and Profiling

brand
Software
prodname
Teradata Warehouse Miner
vrm_release
5.4.4
category
User Guide
featnum
B035-2300-077K

The Model Properties dialog is accessed by clicking Properties on the Published Models dialog. It displays model properties and variables, ADS properties and literal parameters, and Score properties and columns for the currently selected model.

Note that a model may contain one or more instances of an analytic data set (ADS), one or more instances of a score table, or one or more instances of both. The first instance of either is created when an analysis is published. Additional instances are created each time a Teradata Model Manager user saves a model’s parameter settings.

The Model Properties dialog displays the following fields for each published model. Note that the model name, description, version, status and expiration date may be modified using this dialog*.
  • Model Properties
    • Name*
    • Description*
    • Version*
    • Status*
    • Published Date
    • Expiration Date*
  • Model Variables — These are the columns in the analytic data set if the model contains one.
  • ADS Properties
    • Anchor Database and Table — The anchor table determines the key values included in the data set.
    • ADS Database and Table — The analytic data set table in the database.
    • Target Date — An optional parameter used in time sensitive data set variables.
    • Last Executed — The time that the data set was last built by the Teradata Model Manager.
    • Published -or- Executed/Updated — For the first instance of ADS properties, this field displays the date and time that the ADS was published. For subsequent instances, this field displays the date and time that this ADS instance was either built or had its parameters updated by the Teradata Model Manager.
    • Seconds — If this instance of ADS properties is not the first instance and represents the building of the ADS by the Teradata Model Manager, this field indicates the execution time in seconds.
    • Result — If this instance of ADS properties is not the first instance and represents the building of the ADS by the Teradata Model Manager, this field indicates either successful completion or any resulting error message. It may also indicate that parameters were updated by a particular user.
  • ADS Parameters — These are the optional literal parameters associated with the Variable Creation or Variable Transformation that contributed to building the analytic data set. The values displayed are either the original values at the time the model was published, or the values saved by a user of the Teradata Model Manager application after they were altered.
    • Name — The name of the literal parameter.
    • Type — The data type of the literal parameter, either String, Number, Date, Time, Timestamp or Text (free-form SQL text).
    • Value — The value of the literal parameter.
    • Fixed — This indicator field is set to ‘0’ if the parameter can be changed in the Teradata Model Manager application, or ‘1’ if the parameter is fixed and cannot be changed there.
    • Description — The optional description of the literal parameter.
  • Score Properties
    • Input Database and Table — The name and location of the input table that was scored.
    • Output Database and Table — The name and location of the output score table.
    • UDF database — The database that contains any User Defined Functions used in scoring.
    • Last Executed — The time that the score table was last built by the Teradata Model Manager.
    • Published -or- Executed/Updated — For the first instance of Score properties, this field displays the date and time that the Score SQL was published. For subsequent instances, this field displays the date and time that this Score table instance was either built or had its parameters updated by the Teradata Model Manager.
    • Seconds — If this instance of Score properties is not the first instance and represents the building of the Score table by the Teradata Model Manager, this field indicates the execution time in seconds.
    • Result — If this instance of Score properties is not the first instance and represents the building of the Score table by the Teradata Model Manager, this field indicates either successful completion or any resulting error message. It may also indicate that parameters were updated by a particular user.
  • Score Columns — These are the columns included in the score table if one is included in the model, along with their optional descriptions. They typically include such items as key values, predicted values, probabilities or other evaluation measures and any columns carried through from the score input table. Note that the columns may be displayed in a desired order by clicking on the display column headers.