Initial data load from the business perspective

Initial data load is performed by an administrator or implementation consultant at the beginning of each integration project between a source system and Infor EPM.

This table shows a step-by-step description of the initial data load:

Step	Description
1. Publish the data from the source system.	Check that the data fulfills these conditions: All intercompany financial transactions have references to the assigned intercompany partner. For example, an intercompany loan between entity UK and entity US must contain both entities' IDs. That is, UK for entity UK and US for intercompany partner US. Financial intercompany data is complete. For example, an intercompany loan between entity UK and entity US must contain transactions for both entities within the same period. That is, for the UK entity with the US intercompany partner and for the US entity with the UK intercompany partner. In the case of multiple charts of accounts, all accounts at the entity (local) level must have a group account assigned. For example, a Fixed Assets UK account must have a Group Fixed Assets account assigned.
2. The data is published to Data Lake by the source system.	The data must be in sync with Data Lake.
3. Import the data into relational modeling.	Run load queries. The Infor EPM relational databases are fed data by Data Lake. In some integrations, such as Infor M3, an administrator performs data manipulations in the Staging database and then uses load queries to load data into the Infor EPM Integration database.
4. Configure Business Modeling for the metadata import.	Activate appropriate modules, and then activate and configure custom dimensions on the Business Objects Configuration page.
5. Import the metadata into the structures in Business Modeling.	Examples of structures in Business Modeling are accounts, group accounts, entities, custom dimensions, and schedules.
6. Configure Business Modeling for the purposes of Financial Consolidation.	As a minimum, configure these settings: Calendar Settings Financial Consolidation Core module Profit and Loss accounts Balance Sheet accounts
7. Publish the metadata to the OLAP database.
8. Configure Financial Consolidation.	As an initial configuration, configure these settings: Set up entity parameters for all entities into which the data is loaded. On the Landing Page, ensure that the Trial Balance Input and Import Entity Data step has the status of Open for all periods into which the data is loaded.
9. Load financial data into the Infor EPM business applications.	Typically, historical data such as actuals is loaded. Optionally, you can load the Exchange Rates data.