Managed Drill-Through - Teradata Schema Workbench

Teradata Schema Workbench User Guide

Product
Teradata Schema Workbench
Release Number
16.20
16.10
15.10
Published
June 2015
Language
English (United States)
Last Update
2018-05-25
dita:mapPath
gvf1512702977003.ditamap
dita:ditavalPath
Audience_PDF_include.ditaval
dita:id
B035-4106
Product Category
Teradata Tools and Utilities

Managed Drill-Through

The cube administrator can use Teradata Schema Workbench to manage the drill-through result set in the following ways:
  • Restrict the result column set to less than the full set of measures
  • Reorder the sequence that the measure columns and dimension columns appear in the result set
  • Define if the results are to be ordered according to one or more columns
  • Extend the result column set to include any column from the source fact table or dimension table, including fact table columns that are defined by the cube administrator as cube measures or as hierarchy keys.

    For example, each transaction may contain a memo field. This field is not aggregated as a measure, but could be valuable to see as part of a drill through result set.