Before the import into reporting entities is performed, the objects required for this must be created and configured based on their data source(s). The required objects can be created in any order. However, because the objects are built upon each other and interconnected, we recommend following the sequence of steps outlined.
1
Preliminary Considerations
Before configuring the import and creating objects in Lucanet, consider and define the following:
Which data are to be imported?
From which Excel file are the data to be derived?
Has the Excel file already been filled with values?
Which elements of the Lucanet data model (data levels, reporting entities, etc.) are to be filled with the data?
2
Creating an Assignment Table
Assignment tables are used to save all elements imported from the source systems (accounts, reporting entities and cost centers, partners, transaction currency, transaction types, data levels, adjustment levels) and their assignment to elements in the Lucanet database. Assignments are defined during the data import and can then be changed or deleted at any time.
In order to import data from an source system, thesource of the data must be defined. For this purpose, a data source for importing an Excel file must be created in the tree view for the Importing data into reporting entities workspace.
Create a data source and configure the data source (see chapter Defining Data Sources).
4
Editing the Audit Trail (Optional)
The data import can only take place if the import of data into the desired reporting entities for the desired period is allowed by the corresponding audit trail.
If necessary, edit the audit trail in Lucanet.Financial Client.
Audit trails are configured under the Posting and planning folder in the Audit trails workspace, by default.
5
Creating and Executing the Data Import
All data that is imported into reporting entities is transferred to the current Lucanet database using data imports. The Data import element is used to determine which data source and assignment table are to be used during the import.
The actions in the detail view of the data import are used to execute the data import, create assignments in the assignment table used and save the data import. You can create any number of data imports.
If, during a data import, new elements have been read in for the first time from the dimensions Accounts, Reporting entities and cost centers, Partner, Transaction currency, Data levels, Adjustment levels, or Transaction types, these elements must be assigned (only once).
The data cannot be imported if there are any assignment errors. Assignment errors are displayed in the data import object.
Check the assignments and/or rectify any faulty assignments (see chapter Assigning Data).