Table of Contents

File import

Applies to: img Planner 5.2 or later

Overview

File import is a simple tool to import data to from CSV (comma separated) files to Profitbase EPM using pre-defined import templates for standard dimensions and transactional data.

File import can be used to speed up the implementation awaiting data integration or as the import tool in the production phase if no data integration exists.

For financial ledger data, situations may ocurr where new legal entities are acquired and no data integration is available. In such situations a combination of a traditional data integration (existing legal entities) and file import (newly acquired legal entity) may be used. Ledger data for a single legal entity must, however, come from either a file import or a data integration.

To set up an import ruleset, click the + (new) button:

Required fields

  • Ruleset Name
    Set a name for the import ruleset.

  • Destination table
    Select a destination table. The destination table defines what you intend to import and the available import template is defined based on this selection.
    The available destination tables are:

  • Legal entity dimension

  • Account dimension

  • Department dimension

  • Activity dimension

  • Project dimension

  • Employee dimension

  • Product dimension

  • Market dimension

  • Supplier dimension

  • Dim1 dimension

  • Dim2 dimension

  • Dim3 dimension

  • Dim4 dimension

  • Asset group dimension

  • Finance Trial balance and OB fact

  • Driver based measures fact

  • Fixed assets fact

  • Salary fact

    Note that the dimensions available and their format (parent/child or fixed wide) is configured per solution and controlled by the dimension setup.

  • Column delimiter
    The import format is CSV based. Select the delimiter that makes a downloaded template file render correctly in your installation of Excel, i.e. represents one header per column when you open the downloaded template in Excel.

Once the required fields are set, the import process can start:

Download template to your local machine

Click the Download template file, save it to your local machine and open the file in Excel. If the contents does not render correctly, i.e. each header separated into it's own column, alter the column delimiter setting and down load the template again.

Edit the file and save it to your local machine.

Upload and Process file for your local machine

Having edited the downloaded template (i.e. added the content you want to import), click the Upload button and drag the saved file onto the drop-zone available.

Click the Process button to load the file to a temporary storage in Profitbase EPM. Alongside the Process button is a viewer button that allows you to view the contents loaded into the temporary storage.

Validate the processed file

Before you can import the file, it is mandatory to validate the contents of the file. The validation is sensitive to the destination table selected e.g., if you have selected the Account dimension as destination table, the validation will check the content with respect to the data requirements for the Account dimension.

For details on the kind of validation checks performed, please refer to the description given on the Audit page:

Errors and/or warnings are presented if they exist. Please review and correct any issues before attempting to import the data!

Import the processed file

If no validation issues exists, click the Import button to import and process the data.

An explanation regarding the import process to the destination table in question is presented above the import button:

Edit this page