1. Administering Data Integration for Oracle Enterprise Performance Management Cloud
  2. Defining a Data Integration
  3. Mapping Dimensions
  4. Creating the Dimension Maps
  5. Using Source Expressions
  6. Using Source Expressions for the Amount Dimension
  7. Multiplying by Whole-Number and Decimal Factors (Factor)

Multiplying by Whole-Number and Decimal Factors (Factor)

Use the Factor expression type to multiply a source file amount by a user-defined value. This type of expression lets you scale data in the file by any numeric factor. Using this expression, you can double or halve data.

Use parameters that follow this form: Factor=, where you specify a user-defined whole or decimal number by which to multiply your data. For example, use Factor=1000 to convert the amount from 12500 to 12500000.