These special features do not pertain to the Teradata Profiler product.
- If an advertised variable has no description, then analyses chained through analysis references are searched for a description. If a description is found for a variable with a matching name, it is used in the advertised metadata. See the Get Variables section in Macro Results.
Note that this is a feature unique to advertising output and is not available when publishing to the Model Manager application, for example.
- Advertised variables include a column containing pseudo-SQL representing how the variable was derived, concatenating the contributions of referenced analyses, if any, separated by three vertical bars |||. Note that if a column is simply passed along from a referenced analysis this is not recorded, unless the column name changes via aliasing. See the Get Variables section in Macro Results.
- Information about the columns contributing to each advertised variable is stored in the metadata, identifying the database, table and column for each contributing column. Columns that only contribute to an expert or join clause and do not contribute directly to a variable or a dimension applied to a variable are not included in this information. See the Get Variable Columns section in Macro Results.
The Advertise Output metadata tables include:
TWMX_DatabaseObjects * TWMX_ObjectAnalyses TWMX_AnalysisProperties TWMX_Procedures TWMX_ProcedureParameters TWMX_ProcedureObjects * TWMX_ProfileSubjects TWMX_ADSFeatures * TWMX_ADSParameters * TWMX_Variables TWMX_VariableColumns TWMX_ScoreFeatures * TWMX_ScoreColumns TWMX_ModelObjects
* updated by stored procedures
The views provided to access the Advertise Output metadata tables include:
TWMXV_DatabaseObjects TWMXV_ObjectAnalyses TWMXV_AnalysisProperties TWMXV_Procedures TWMXV_ProcedureParameters TWMXV_ProcedureObjects TWMXV_ProfileSubjects TWMXV_ADSFeatures TWMXV_ADSParameters TWMXV_Variables TWMXV_VariableColumns TWMXV_ScoreFeatures TWMXV_ScoreColumns TWMXV_ModelObjects