Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
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}