When you create an import, you define the settings and the import format mapping definition. You can create:
One-to-One Mappings—Single Segment and Single Chartfield mappings:
Define a simple one-to-one mapping between source segments and target dimension members.
Pull all members from the source value set as members into the target dimension.
The following figure shows a one-to-one mapping between segments or chartfields in a source system and dimensions in a target EPM application.
Note:
Each member in the source is created as a single member in the target dimension.
Many-to-One Mappings—You can concatenate segments or chartfields to map multiple segments or chartfields from the source into a single EPM dimension member.
When dimensions are mapped as a concatenated segment, the new dimension is created based on the traversal order that you define for the source hierarchies into the concatenated member target dimension. Up to five segments may be concatenated into the target dimension. The following table shows an example of how the segments map to dimensions. In this example, two segments (Company and Department) map to one dimension (Entity).
Segment / Chartfield EPM Dimension Company Entity Department Product Product Account Account