Cognos - Report Functions

Cognos – Report Functions

There are numerous Report capabilities that can be utilized in a Cognos report.

A few of these completely different report capabilities embody −

_days_between

This operate is used to return a optimistic or a destructive quantity representing the variety of days between the 2 datetime expressions. If a timestamp_exp1 < timestamp_exp2 then the consequence will likely be a –ve quantity.

Learn how to use

_days_between(timestamp_exp1, timestamp_exp2)

_days_to_end_of_month

This operate is used to return a quantity representing the variety of days remaining within the month represented by the datetime expression timestamp_exp.

Learn how to use

_days_to_end_of_month(timestamp_exp)

_first_of_month

This operate is used to return a datetime that’s the first day of the month represented by timestamp_exp.

_add_days

This operate is used to return the datetime ensuing from including integer_exp days to timestamp_exp.

Learn how to use

_add_days(timestamp_exp, integer_exp)

_add_months

This operate is used to return the datetime ensuing from including integer_exp months to timestamp_exp.

Learn how to use

_add_months(timestamp_exp, integer_exp)

_add_years

This operate is used to return the datetime ensuing from including integer_exp years to timestamp_exp.

Learn how to use

_add_years(timestamp_exp, integer_exp)

_age

This operate is used to return a quantity that’s obtained from subtracting timestamp_exp from in the present day’s date in YYYYMMDD format (years, months, days).

Learn how to use

_age(timestamp_exp)

_day_of_week

This operate is used to return the day of week (between 1 and seven), the place 1 is the primary day of the week as indicated by integer_exp (between 1 and seven, 1 being Monday and seven being Sunday). Word that in ISO 8601 customary, per week begins with Monday being day 1. In North America the place Sunday is the primary day of the week being day 7.

Learn how to use

_day_of_week(timestamp_exp, integer_exp)

_day_of_year

This operate is used to return the ordinal for the day of the 12 months in date_ exp (1 to 366). Also referred to as the Julian day.

Learn how to use

_day_of_year(timestamp_exp)

Like these, there are numerous different Report capabilities as nicely that can be utilized.