1. One of the useful features in Ordered Analytical Computation is to produce/define data sets or data subsets dynamically. This is done by the usage of the OVER () phrase (detail later). This OVER () feature can be used with all the aggregate functions too. 2. Introducing the usage of QUALIFY Clause: If there is [...]

OLAP or On Line Analytical Processing functions are knows as “Ordered” analytical functions in Teradata environment.  These functions provides support for many decision support  operations in data mining environments that require an ordered set of results set or depend on values from a previous row. These functions are categorized as follows: • Window aggregate functions [...]