# Licensed Materials - Property of IBM # IBM Cognos Products: OQP # (C) Copyright IBM Corp. 2005, 2021 # US Government Users Restricted Rights - Use, duplication or disclosure restricted by GSA ADP Schedule Contract with IBM corp. # # Windowed aggregates (SQL/OLAP). # olap.DenseRank[]= olap.CumeDist[]= olap.FirstValue[any]= olap.LastValue[any]= # # Aggregates. # aggregates.PercentileCont[any,any]= aggregates.PercentileDisc[any,any]= aggregates.Median[any]= # # Various features. # supports.blobsInGroupBy=false supports.blobsInOrderBy=false clauses.Top= # # Period predicates. # predicates.PeriodEquals[any,any]=BEGIN(%1$s) = BEGIN(%2$s) AND END(%1$s) = END(%2$s) predicates.PeriodImmediatelyPrecedes[any,any]=END(%1$s) = BEGIN(%2$s) predicates.PeriodImmediatelySucceeds[any,any]=BEGIN(%1$s) = END(%2$s) olap.Lag[any]= olap.Lag[any,any]= olap.Lag[any,any,any]= olap.Lag[any,any,any,any]= olap.Lead[any]= olap.Lead[any,any]= olap.Lead[any,any,any]= olap.Lead[any,any,any,any]=