which fields (columns) are extracted from the source system and how the data is stored in the Oracle Hyperion Financial Data Quality Management, Enterprise Edition staging table.
the data format and mapping information for columns in the Oracle Hyperion Planning source system and target applications for a source adapter based integrations.
mapping between the source system segments or chartfields and the dimensions (used in the metadata load and data load process).
mapping between the EPM dimensions and the source system segments or chartfields (used in the write-back process).
mapping information for source adapter based integrations
mapping information between source and target EPM dimensions for data synchronization.
Note:
You do not need to define import mappings for use with human resources source systems. This is only applicable to the rebuilt Peoplesoft HCM integration.
Import formats are created for a single accounting entity. However, if you are importing data from multiple accounting entities that have the same Chart of Accounts, you can define one Import Format using a representative accounting entity, and then use it for importing data for all accounting entities with the same Chart of Accounts.
You define import formats to map source segments or chartfields to target dimensions. You can create import formats to:
You work with import formats on the Import Format screen, which consists of three sections:
Import Format Summary—Displays common information relevant to the source and target applications.
Import Format Detail—Enables you to add and maintain import format information.
Import Format Mappings—Enables you to add and maintain import format mapping information.