1. Administering Data Management for Oracle Enterprise Performance Management Cloud
  2. Integration Tasks
  3. Loading Data
  4. Creating Member Mappings
  5. Format Mask Mapping for Target Values
  6. #FORMAT Mapping Type Components

#FORMAT Mapping Type Components

The #FORMAT mapping type consists of the following components:

Table 4-13 #Format Mapping Type Components

Component Description
#FORMAT Indicates that a mapping type of FORMAT is specified in the target member.
<format mask> User defined format mask with the following characters used to define the format:

  • "?"—Include a character from a specific position in the source member or segment within a member.

  • "#"—Skip or drop a character from the source when creating the target member.

  • "character"—Include the user defined character on the target "as- is". Used for prefixing, suffixing or any fixed string or required character. This can be used in conjunction with the special format mask characters.

  • "*"—Include all characters from the source segment or source. When "*" is used as the only format mask character in a segment, then the entire segment value is copied from the source.

    When "*" is used in conjunction with "#" or the "?" character, then all remaining and unused characters are brought over.

    "*" is a wildcard character that takes the remaining characters not specified by "?" or "#". For example, when the source is "abcd" and "*" is used, then the target is "abcd." When the target is "?#*," then the result is "acd."

    If Data Management encounters a "*" within a segment, then anything specified after the "*" is ignored other than the "character" specified on the format.

<segment delimiter> The optional segment delimiter defines the character that is used to delimit the segments in the source and target member. For this rule type, the source and target delimiter must be the same. When the segment delimiter is not specified, then the format mask is applied to the entire member independent of any segment specification or delimiter.