Restricting Amount Value to Two Decimal Places in FDMEE for Custom File Export

While exporting data to a custom flat file, Oracle Hyperion Financial Data Quality Management, Enterprise Edition may, some times, not restrict data to two decimal places although the required source parameters are correctly set to restrict data to two decimal places.

Use one of the following options to resolve this issue.

• Set the values of Data Precision and Data Number of Decimal properties to 2. These FDMEE properties can be set in Source Parameters under Data Load Rule.

  Note:

  These settings works only in BSO cubes; they do not work in ASO cubes.
• Create an SQL mapping in data load maps to round the amountx column to 2 decimal places. To round to two decimals, you may use an SQL mapping similar to the following:

  amountx = round(amount,2)