| 123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960 |
- # Licensed Materials - Property of IBM
- # IBM Cognos Products: OQP
- # (C) Copyright IBM Corp. 2005, 2016
- # US Government Users Restricted Rights - Use, duplication or disclosure restricted by GSA ADP Schedule Contract with IBM corp.
- #
- # Conditional expressions
- #
- expressions.Coalesce[timestamp,date]=
- expressions.Coalesce[text,timestamp]=
- expressions.Coalesce[numeric,timestamp]=
- expressions.Coalesce[date,timestamp]=
- expressions.NullIf[timestamp,date]=
- expressions.NullIf[text,timestamp]=
- expressions.NullIf[numeric,timestamp]=
- expressions.NullIf[date,timestamp]=
- #
- # Olap Functions
- #
- olap.Min[any]=
- olap.Max[any]=
- olap.Sum[any]=
- olap.Avg[any]=
- olap.Count[any]=
- olap.CountStar[]=
- olap.CumeDist[]=
- olap.LastValue[any]=
- 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]=
- olap.StdDevSamp[any]=
- olap.StdDevPop[any]=
- olap.VarSamp[any]=
- olap.VarPop[any]=
- olap.NTile[any]=
- olap.FirstValue[any]=
- olap.RatioToReport[any]=
- olap.NthValue[any,any]=
- olap.NthValue[any,any,any]=
- olap.NthValue[any,any,any,any]=
- olap.NthValue[any,any,any]=
- olap.NthValue[any,any,any,any]=
- #
- # Olap (distinct).
- #
- olap.Max.distinct[any]=
- olap.Min.distinct[any]=
- olap.Sum.distinct[any]=
- olap.Avg.distinct[any]=
- olap.Count.distinct[any]=
|
