Enhanced support of the LAG and LEAD functions

As of release 12.1.1, you can define a V5 expression that replicates the behavior of the LAG and LEAD SQL window functions.

This feature in an extension of the existing support for the LAG and LEAD functions in Cognos® Analytics. It expands calculations flexibility and usability across different authoring environments. For example, you can now define such expressions in a data module, a report, or in a dashboard interface.

The following images are examples of the LAG and LEAD functions in a New Calculation window.