Transformations
You can translate a single member or a group of members to a new identifier in the generated file. This is done by defining a pattern to select the identifiers in the input file and specifying a new identifier to translate them to in the output file.
If multiple transformations match a field, transformations are processed in the order in which they display.
These are the options:
| Option | Description |
|---|---|
| Private Property Set | Open the Property Set Options dialog box. See "Property Set Options Dialog Box" for further information. |
| Source Pattern | Source pattern to match. See Source Patterns for further information. |
| Target Member | Member name to which to map the data. Click the Down arrow to display the Member Selection dialog box where you can select specific members. Member IDs are not supported. See "Member Selection Dialog Box" for further information. |
| Dimensions | Dimension to where the mappings will apply.
You can define transformations for multiple dimensions.
Note: Mapping to affiliated members must be done separately. If
no transformations are supplied for the affiliated members, the transformations
for the Unit dimension are used.
|