User defined functions

The user defined functions in the database enable you to identify specific members to become part of the query formed by the custom drill through. You can use these functions to run queries on consolidated members. Each function returns a table with these columns:

• mem_id
• mem_pid
• top_mem
• level

Top_Mem is the member ID of the selected consolidated member. Each consolidated member has its complete hierarchy represented.

Each user defined function returns the descendant members of the specified consolidated member. The consolidated member itself is included in the returned records.

These user defined functions are available within the CPM model itself. If custom drill queries are executed against an external data source, the functions that provide the ability to drill through from consolidated levels will not be accessible. Set up leaf level drill through when running queries to an external data source.

The user defined functions are database specific. The syntax is different for different database types.

The user defined functions and the supported platforms are: