BI Publisher - Functions

1 - About

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

3 - Syntax

3.1 - SQL

For extended SQL functions, the syntax is:


3.2 - XSL

For extended XSL functions, the syntax is


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 version.

4 - 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:


5 - Documentation / Reference

Data Science
Data Analysis
Data Science
Linear Algebra Mathematics

Powered by ComboStrap