- Cognos Tutorial
- Cognos - Home
- Data Warehousing
- Data Warehouse - Overview
- Data Warehouse - Schemas
- ETL & Reporting Tools
- Cognos Basics
- Cognos - Introduction
- Cognos - Components and Services
- Cognos - Connections
- Cognos - Packages
- Cognos - Framework Manager
- Relationships in Metadata Model
- Query Studio
- Cognos - Query Studio
- Cognos - Ad-hoc Reports
- Cognos - Report Types
- Cognos - Creating a Report
- Cognos - Open an Existing Report
- Cognos - Add Data to a Report
- Cognos - Saving a Report
- Cognos - Run a Report
- Cognos - Printing a Report
- Report Studio
- Cognos - Report Studio
- Cognos - Report Templates
- Cognos - List Report
- Cognos - Crosstab Report
- Cognos - Creating a Chart
- Cognos - Report Functions
- Cognos - Report Validation
- Cognos - Report Run with Options
- Cognos - Report Administration
- Cognos - Filters
- Cognos - Custom Calculations
- Analysis Studio
- Cognos - Analysis Studio
- Cognos - Create an Analysis
- Cognos - Save an Analysis
- Cognos - Open Existing Analysis
- Event Studio
- Cognos - Event Studio
- Cognos - Notification Methods
- Cognos Useful Resources
- Cognos - Quick Guide
- Cognos - Useful Resources
- Cognos - Discussion
Cognos - Report Functions
There are various Report functions that can be used in a Cognos report.
Some of these different report functions include −
_days_between
This function is used to return a positive or a negative number representing the number of days between the two datetime expressions. If a timestamp_exp1 < timestamp_exp2 then the result will be a –ve number.
How to use
_days_between(timestamp_exp1, timestamp_exp2)
_days_to_end_of_month
This function is used to return a number representing the number of days remaining in the month represented by the datetime expression timestamp_exp.
How to use
_days_to_end_of_month(timestamp_exp)
_first_of_month
This function is used to return a datetime that is the first day of the month represented by timestamp_exp.
_add_days
This function is used to return the datetime resulting from adding integer_exp days to timestamp_exp.
How to use
_add_days(timestamp_exp, integer_exp)
_add_months
This function is used to return the datetime resulting from adding integer_exp months to timestamp_exp.
How to use
_add_months(timestamp_exp, integer_exp)
_add_years
This function is used to return the datetime resulting from adding integer_exp years to timestamp_exp.
How to use
_add_years(timestamp_exp, integer_exp)
_age
This function is used to return a number that is obtained from subtracting timestamp_exp from today's date in YYYYMMDD format (years, months, days).
How to use
_age(timestamp_exp)
_day_of_week
This function is used to return the day of week (between 1 and 7), where 1 is the first day of the week as indicated by integer_exp (between 1 and 7, 1 being Monday and 7 being Sunday). Note that in ISO 8601 standard, a week begins with Monday being day 1. In North America where Sunday is the first day of the week being day 7.
How to use
_day_of_week(timestamp_exp, integer_exp)
_day_of_year
This function is used to return the ordinal for the day of the year in date_ exp (1 to 366). Also known as the Julian day.
How to use
_day_of_year(timestamp_exp)
Like these, there are various other Report functions as well that can be used.