Creating custom report functions and function sets

This chapter describes how to create custom report functions and custom function sets for report authors to use in IBM® Cognos® Analytics.

Creating custom report functions
Report authors create report expressions using the expression editor. The expression editor provides a list of functions that can be used in expressions. In addition to the functions that are available by default, such as Today(), ReportDate() or ReportName(), you can create custom functions and make them available to report authors by defining report function libraries.
Example of a custom report functions implementation
This topic illustrates the implementation of a set of custom report functions.
Custom function sets
A function set is a collection of database functions that are vendor-specific. You can customize the Function Description Service to expose or define functions that your data source supports. Defining additional vendor-specific functions is similar to defining custom functions. The following elements are used to specify the vendor group.
Example of creating a custom function set
The following example shows how to add the datepart SQL Server function to the list of functions displayed in the expression editor. This function is not delivered as part of the default FDS content because there is an equivalent extract function in the SQL99 folder.

Parent topic: Framework Manager Developer