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

ERPF报表维护手册建设银行ERPF项目

文档编号CCBBI_PM061110_001

版本号V1.00

密级内部资料

cognos报表数据项表达式函数的应用手册文档信息

批复信息

文件控制

目录

1引言 (5)

1.1编写目的 (5)

1.2背景 (5)

1.3参考资料 (5)

1.4术语定义及说明 (5)

2汇总函数 (6)

2.1aggregate (6)

2.2average (6)

2.3count (6)

2.4maximum (7)

2.5median (7)

2.6minimum (7)

2.7moving-average (7)

2.8moving-total (8)

2.9percentage (9)

2.10percentile (9)

2.11quantile (9)

2.12quartile (10)

2.13rank (11)

2.14running-average (11)

2.15running-count (12)

2.16running-difference (12)

2.17running-maximum (13)

2.18running-minimum (13)

2.19running-total (14)

2.20standard-deviation (14)

2.21standard-deviation-pop (15)

2.22total (15)

2.23variance (15)

2.24variance-pop (15)

3业务日期/时间函数 (17)

3.1_add_days (17)

3.2_add_months (17)

3.3_add_years (17)

3.4_age (18)

3.5_day_of_week (18)

3.6_day_of_year (18)

3.7_days_between (18)

3.8_days_to_end_of_month (19)

3.9_first_of_month (19)

3.10_last_of_month (19)

3.11_make_timestamp (20)

3.12_months_between (20)

3.13_week_of_year (20)

3.14_years_between (20)

3.15_ymdint_between (21)

4块函数 (22)

4.1_firstFromSet (22)

4.2_remainderSet (22)

5供应商特定函数（Oracle函数） (23)

5.1add_months (23)

5.2ascii (23)

5.3char_length (23)

5.4chr (23)

5.5concat (24)

5.6decode (24)

5.7dump (24)

5.8greatest (24)

5.9initcap (25)

5.10instr (25)

5.11instrb (25)

5.12least (26)

5.13length (26)

5.14lengthb (26)

5.15lpad (26)

5.16ltrim (27)

5.17months_between (27)

5.18new_time (27)

5.19next_day (27)

5.20nls_initcap (28)

5.21nls_lower (28)

5.22nls_upper (28)

5.23nvl (28)

5.24replace (29)

5.25round (29)

5.26rpad (29)

5.27rtrim (30)

5.28sign (30)

5.29soundex (30)

5.30substr (30)

5.32to_char (31)

5.33to_date (31)

5.34to_number (31)

5.35translate (32)

5.36trunc (32)

5.37trunc (32)

5.38vsize (32)

5.39{sysdate} (33)

5.40{user} (33)

6Oracle Cast函数 (34)

6.1cast_varchar (34)

6.2cast_timestamp (34)

7Oracle数学函数 (35)

7.1Log (35)

8Oracle三角函数 (36)

8.1acos (36)

8.2asin (36)

8.3atan (36)

8.4atan2 (36)

8.5cos (37)

8.6cosh (37)

8.7sin (37)

8.8sinh (37)

8.9tan (38)

8.10tanh (38)

9通用函数 (39)

9.1_format (39)

9.2_round (39)

9.3abs (39)

9.4cast (39)

9.5ceiling (40)

9.6character_length (40)

9.7coalesce (40)

9.8current_date (40)

9.9current_time (41)

9.10current_timestamp (41)

9.11exp (41)

9.12extract (41)

9.13floor (42)