Selecting a Period Derived from the Source Column for the Quick Mode Method

If the source data includes a period column in the data source, the Oracle Enterprise Performance Management Cloud period can be derived from this column.

The source data can include period in various formats like below, such as:

• Jan-20

• January-20

• 01-20

• 01/31/20

• 01-Jan-20

You can also use target expressions to derive the target Year and Period values, or derive the Year and Period using a date field and associated format. For information on using target expressions, see Using Target Expressions.

To derive the target Year and Period values, use the following target expressions.

• substring()—Extract and return characters from a string based on a character position (starting position) and substring length (number of characters to extract).

  For more information, see Substring.

• split()—Split the source value based on a delimiter, and return the n value after splitting the value. This expression type is useful for splitting segment values from strings.

  For more information, see Split.

To derive the Year and Period using a date field and associated format, use these target expressions.

• toPeriod()—Derive Period dimension member based on the source system period name using the syntax: toPeriod(field, "<DATE FORMAT>", Mon)

  
  
  

• toYear()—Derive Year dimension member based on the source system period name using the syntax: toYear(field, "<DATE FORMAT>", "FY+YY")

  
  
  

The <DATEFORMAT> is in the Simple Java Date format. For more information about the Simple Java Data format, see https://docs.oracle.com/javase/8/docs/api/java/text/SimpleDateFormat.html.

Map is another target expression that enables you to accept an input field or field with an expression like substr, split, and series of key value pairs for mapping using the syntax: map(substr(field,1,2),P1:Jan|P2:Feb|P3:Mar|….)

Note:

The map target expression can be used for any expression.