BI Publisher - Functions

Card Puncher Data Processing

About

For use in RTF templates, BI Publisher has extended a set of SQL and XSL functions .

Syntax

SQL

For extended SQL functions, the syntax is:

<?xdofx:expression?>

XSL

For extended XSL functions, the syntax is

<?xdoxslt:expression?>

You have more detail in the documentation but not all. Here below is a Java Doc only for extended XSL functions with all the detail for the 10.1.3.4 version. xsltfunctions10134.zip

Example

In my dataset I have COL4 and COL5. I would like to calculate the difference between these 2 columns an put this in a new column. The function to do this is:

<?xdofx:COL4-COL5?>

Documentation / Reference





Discover More
Card Puncher Data Processing
Business Intelligence Publisher

BIP is a highly scalable reporting engine capable of generating pixel perfect reports from multiple data sources in multiple formats via multiple delivery channels. Bi Publisher is based on the Apache...



Share this page:
Follow us:
Task Runner