IBM Cognos Software Development Kit Version 11.0.0 Dynamic Query Extensibility Developer Guide
This IBM Cognos Software Development Kit Version 11.0.0 guide explains dynamic query extensibility for IBM Cognos Analytics. It is intended for function writers, system administrators, and report authors who extend the dynamic query engine with functions that the engine can evaluate locally.
The guide covers scalar, aggregate, and table functions, with SQL and Java examples. It also describes deployment descriptor files, Java Archive packaging, deployment to the Cognos Analytics server, implicit type conversion, overloaded and variadic functions, and the BNF grammar for the deployment descriptor file.
It is a mechanism for extending the dynamic query engine in IBM Cognos Analytics by adding functions that the engine can evaluate locally.
You can write scalar functions, aggregate functions, and table functions.
They can be written in SQL, Java, or JSR-223 scripting languages that can run on the Java virtual machine.
The system administrator deploys the Java Archive files to the Cognos Analytics server.