cognos报表材料数据项表达式函数的应用

《cognos报表材料数据项表达式函数的应用》由会员上传分享，免费在线阅读，更多相关内容在教育资源-天天文库。

1、'文档编号CCBBI_PM061110_001版本号V1.00密级内部资料cognos报表数据项表达式函数的应用手册文档信息项目名称北京建总行ERPF报表项目项目经理张成浩文档名称cognos报表数据项表达式函数的应用手册批复信息负责人日期意见拟制审核批准文件控制版本记录日期作者版本变更说明2006-11-10郑广珠V1.0审阅记录日期审阅者意见分发记录日期接受人地点'目录1引言51.1编写目的51.2背景51.3参考资料51.4术语定义及说明52汇总函数62.1aggregate62.2average62.3count62.4maximum72.5med

2、ian72.6minimum72.7moving-average72.8moving-total82.9percentage92.10percentile92.11quantile92.12quartile102.13rank112.14running-average112.15running-count122.16running-difference122.17running-maximum132.18running-minimum132.19running-total142.20standard-deviation142.21standard-deviat

3、ion-pop152.22total152.23variance152.24variance-pop153业务日期/时间函数173.1_add_days173.2_add_months173.3_add_years173.4_age183.5_day_of_week183.6_day_of_year183.7_days_between18'3.8_days_to_end_of_month193.9_first_of_month193.10_last_of_month193.11_make_timestamp203.12_months_between203.1

4、3_week_of_year203.14_years_between203.15_ymdint_between214块函数224.1_firstFromSet224.2_remainderSet225供应商特定函数（Oracle函数）235.1add_months235.2ascii235.3char_length235.4chr235.5concat245.6decode245.7dump245.8greatest245.9initcap255.10instr255.11instrb255.12least265.13length265.14lengthb26

5、5.15lpad265.16ltrim275.17months_between275.18new_time275.19next_day275.20nls_initcap285.21nls_lower285.22nls_upper285.23nvl285.24replace295.25round295.26rpad295.27rtrim305.28sign305.29soundex305.30substr30'5.31substrb315.32to_char315.33to_date315.34to_number315.35translate325.36tru

6、nc325.37trunc325.38vsize325.39{sysdate}335.40{user}336OracleCast函数346.1cast_varchar346.2cast_timestamp347Oracle数学函数357.1Log358Oracle三角函数368.1acos368.2asin368.3atan368.4atan2368.5cos378.6cosh378.7sin378.8sinh378.9tan388.10tanh389通用函数399.1_format399.2_round399.3abs399.4cast399.5ceilin

7、g409.6character_length409.7coalesce409.8current_date409.9current_time419.10current_timestamp419.11exp419.12extract419.13floor42'9.14ln429.15localtime429.16localtimestamp429.17lower439.18mod439.19octet_length439.20position439.21power449.22sqrt449.23substring449.24trim449.25upper45'

8、1引言1.1编写目的整理cognos的