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 Target Expressions
  6. toPeriod

toPeriod

Use the toPeriod target expression type to derive the Period dimension member based on the source system period name.

Use the Java simple date format to provide the format of the Source Period Name. For example, if the source period is Jan-20, then to derive the Period dimension name, use the expression toPeriod(PERIOD, "MMM-yy", "Mon").