This function outputs one or more columns of XML. You can transform the XML to HTML, which is easier to view—see Reports.
The following table is built in the requested Output Database by Factor Scoring. Note that the options selected affect the structure of the table. The table columns in bold comprise the Unique Primary Index (UPI). Also note that there may be repeated groups of columns, and that some columns will be generated only if specific options are selected.
Name | Data Type | Description |
---|---|---|
Key | Key Column Type | One or more unique-key columns that default to the index defined in the table to be scored. |
Groupby Variable | User-Defined | A column is generated for each groupby column. Within each column there are distinct values of the groupby columns for which a factor model was built. |
<app_var> | User-Defined | One or more columns as selected under Retain Columns. The data type defaults to the same as that within the appended table, but can be changed using Columns Types (for appended columns). |
Factor x (Default) |
FLOAT | Column generated for each scored factor. The names of the factor columns are Factor 1, Factor 2, ... Factor n. |
Factor Analysis Score Reports
Report Item | Data Type | Description |
---|---|---|
PartId | INTEGER | For each batch of XML in the second column that is 31000 bytes, partId is incremented. |
XmlModel | User-Defined | A 31000 byte block of an XML representation of the reports if evaluate or scoreandevaluate are selected. |
To extract the XML into a viewable format, run the following query:
SELECT XMLSERIALIZE(Content X.Dot) as XMLText FROM (SELECT * FROM "outputdatabase"."outputtablename_rpt") AS C, XMLTable ( '//*' PASSING CREATEXML(C.XmlModel) ) AS X ("Dot");