| 1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374757677 |
- # 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]=
- #
- # Various features.
- #
- supports.top.0=false
- #
- # Various features.
- #
- supports.top.0=false
- #
- # 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]=
- #
- # Numeric scalar functions
- #
- functions.Round[double,any]=CASE WHEN (%1$s) < 0 THEN (CAST( ( (%1$s) * POWER( 10e0, (%2$s) ) - 0.5 ) AS BIGINT ) / POWER( 10e0, (%2$s) ) ) ELSE (CAST( ( (%1$s) * POWER( 10e0, (%2$s) ) + 0.5 ) AS BIGINT ) / POWER( 10e0, (%2$s) ) ) END
- functions.Round[float,any]=CASE WHEN (%1$s) < 0 THEN (CAST( ( (%1$s) * POWER( 10e0, (%2$s) ) - 0.5 ) AS BIGINT ) / POWER( 10e0, (%2$s) ) ) ELSE (CAST( ( (%1$s) * POWER( 10e0, (%2$s) ) + 0.5 ) AS BIGINT ) / POWER( 10e0, (%2$s) ) ) END#
|
