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.