This guide will teach you how to create your own advanced functions and use them in reports.
Overview
Advanced functions allow you to perform operations on top of report data after the primary SQL query has been run, unlike a calculated field, which is added to the report’s SQL statement. Functions can range from simple mathematical calculations and text manipulation, to more complex API calls with user input parameters.
The following guide is broken into:
Basics (Optional) - This section shows how to create an advanced function in Eclipse. Start here if you are new to coding Yellowfin plug-ins.
Creating an advanced function - The core methods required to code the function.
Setting up parameters - Provide user input parameters such as radio buttons and drop down menus.
Dependent parameter display - Create dynamic interfaces by expanding upon the basic user input parameters.
Accessing and modifying data - Use values from other columns, then return a customized result set.
Next topic: Advanced function basics