There are differences between invoking the tdheatmap function, macro, or creating a view. The following table describes the differences to help you choose which method to use.
| Table function tdheatmap | Macro tdheatmap_m | View tdheatmap_v | |
|---|---|---|---|
| Makes sure that the heatmap report is taken from the same AMP. | X | ||
| Ability to check heatmap report on different amps if any skew is suspected. | X | X | |
| Ability to select columns to display. | X | X | |
| Use of ‘StartTableIdUniq’ to join to DBC.TVM.TVMID so as to get English name of the objects. This is required because the operator does not output English description of database and table names, and you must write an additional query to get this. | X | X | X |
| Ability to specify the names of database objects to limit the scope of the heatmap report to generate. | X | X |