Advanced Functions are used to transform results by applying post processing calculations to the initial query results. These functions are database independent as they are performed by Java code, rather than being part of the SQL query.
Yellowfin comes with a set of pre-defined functions. However, your administrator may add in additional functions specifically for your organisation or reporting needs. Expand the following to see the lists of functions available:
|
|
|
|
Data Conversion allows you to adjust results once they've returned from the database. For example you may wish to convert a currency value which is stored in the database from a full currency value to a (‘000) where the value is divided by 1000. This transformation can be achieved using the data conversion. |
We have included an example of a custom advanced function, which enables the use of R within a report.
For Yellowfin to understand and execute R script a slightly different structure will be used in the script discussed below. Consider a sample script called Below is a sample R-Script for Neural Networks. Copy this script and make sure it runs without any errors in R.
|
Once installed, you will be able to use this function through the Advanced Function menu.
|
To apply an advanced function, first you will need to ensure the field you wish to apply it to has been added to your table. Often when applying functions, you may find you need two copies of the field in your table; one to display the original values (such as sales figures) and the second to have a function applied to it (for example, displaying the top 10 rank of sales figures).
To apply a function to a field in your table from the Data step of the report builder, complete the following:
To apply a function to a field in your table from the Charts step of the report builder, complete the following:
To apply a function to a field in your table from the Design step of the report builder, complete the following:
Data in a field can be converted by completing the following: