# 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#