Wiki Markup |
---|
{anchor:top} h2. Overview {styleclass: Class=topLink}[top|#top]{styleclass} 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. # Drag the field that you wish to apply the conversion to into the report builder field section. # As with the advanced function select the field and click the advanced function button to open the advanced function popup. # Choose the 'Data Conversion' tab. This will provide you with the interface to use to select the conversion you wish to apply. # Choose the aggregation appropriate for you conversion # 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). !164.png|thumbnail,border=1! # Follow the on screen instructions for the convertor and click save. !165.png|thumbnail,border=1! # Note that you can add multiple convertors to a data type if required by clicking the add link and creating a new type. !167.png|thumbnail,border=1! \\ \\ {horizontalrule} {styleclass: Class=topLink}[top|#top]{styleclass} |
Page Comparison
General
Content
Integrations