#IBM Confidential
# 
#OCO Source Materials
# 
#BI and PM: rdbmscert
# 
#(C) Copyright IBM Corp. 2009,2016
# 
#The source code for this program is not published or otherwise divested of its trade secrets,
#irrespective of what has been deposited with the U.S. Copyright Office
# 

# 
# 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
#
#olsp functions
#
olap.FirstValue[any]=
olap.LastValue[any]=