Data Converter

Overview

The data conversion facility within Yellowfin allows you to transform data after it has come back 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.

1. Drag the field that you wish to apply the conversion to into the report builder field section.
2. As with the advanced function select the field and click the advanced function button to open the advanced function popup.
3. Choose the 'Data Conversion' tab. This will provide you with the interface to use to select the conversion you wish to apply.
4. Choose the aggregation appropriate for you conversion
5. Click 'add' to apply a conversion - this will present you with a list of possible conversions for the data type you have selected. Yellowfin comes with a java date converter and a Numeric divide convertor (This lets you divide a value by 1000's etc).
   
6. Follow the on screen instructions for the convertor and click save.
   
7. Note that you can add multiple convertors to a data type if required by clicking the add link and creating a new type.