---
title: "Creating and Configuring the Data Source"
description: "Once you have configured the data transfer script xP&A #3700-xP&A.SQL.FOS, you can create and configure the data source for the import that uses the script and its parameters."
source_url: https://support.lucanet.com/en/documentation/xp-a---extended-planning-and-analysis/integrating-data/guideline-data-exchange-xPA-CFP/importing-data-from-xpa-to-cfp/creating-and-cconfiguring-the-data-source-for_xPA-import
language: en
last_updated: 2026-05-28
---
# Creating and Configuring the Data Source

## Overview

Once you have configured the data transfer script **xP&A #3700-xP&A.SQL.FOS**, you can create and configure the data source for the import that uses the script and its parameters.

{% info-box %}
**Note for customers who still use Lucanet.Financial Client**

You can either perform this step on the CFO Solution Platform or in Lucanet.Financial Client. The data source will be visible and editable in both systems, no matter where you created it.
{% /info-box %}

## Creating and Configuring the Data Source

Proceed as follows to configure the data source necessary for importing data from xP&A into CFP:

{% stepper %}
{% stepper-step %}
Open the **Importing data into reporting entities** workspace.
{% /stepper-step %}
{% stepper-step %}
Right-click the folder **Data sources** and choose **Create | Data source** from the context menu.

Create a new data source

{% /stepper-step %}
{% stepper-step %}
In the **Ceate data source** dialog, choose **Provision via script**, enter a **name**, and click **Save** to create the data source.
{% /stepper-step %}
{% stepper-step %}
Select the data source in the tree view.
{% /stepper-step %}
{% stepper-step %}
In the **General** area on top, behind **Drill down to posting level**, select the app **Lucanet xP&A #3700-xP&A.SQL.FOS** which you configured for transferring the desired data.

 This enables the drill down from data in CFP to the corresponding data in xP&A.

Select drill-down to posting level

{% /stepper-step %}
{% stepper-step %}
Configure the data source parameters as described in the following under _Data Source Parameters_.
{% /stepper-step %}
{% stepper-step %}
Click **Save** (or press **Ctrl+S**) to save the data source configuration.

{% /stepper-step %}
{% /stepper %}
## Data Source Parameters

### 'General' Tab

The **General** tab is displayed as follows, for example:

'General' tab

Configure the following options on the **General** tab:

#### Scripts executed during the data import

**Script** Select the script **Lucanet xP&A #3700-xP&A.SQL.FOS** (the name may be truncated in the dropdown list). This script is executed during the data import.

**Application** Select where the script is executed, e.g. **Execute on the server**.

#### Data to be imported

**Import type** Select one of the following import types:

- **Transaction figures** – imports transaction figures
- **Balances** – imports balances
- **Transaction figures incl. automatic contra entry** – imports transaction figures with automatic contra entries into planning data levels (not for the actual data level).
- **Transaction figures or balances (selection when importing)** – the user chooses transaction figures or balances when executing the import.

#### Accounting periods per year

Select the number of periods per fiscal year (e.g. **12**).

The app supports 12 periods per fiscal year.

#### Dimensions to be imported

Activate to use a dimension from xP&A as transaction currency for the execution settings and select the **Dimension for transaction currency**.

#### Dimensions to be imported

Activate the **Use dimension** checkbox to include the dimension in the import. The **Dimension code** (e.g. **GLAccount** for Account, **CostCenter** for Cost center) is filled in automatically.

#### Cost centers in the Balance Sheet

The area **Cost centers in the Balance Sheet** is only visible if you activated the import of the cost center dimension.

Select if you want to **Use default cost centers always (recommended)** , or if you want to **Use specified cost centers**(e.g. from the reporting entities or assignment table).

#### Reclassify values

Select if and how values shall be reclassified during the import:

- **Attach suffix to account name**
- **Present intercompany postings on separate accounts**
- **Reclassify debtors with credit balances and creditors with a debit balance**

### 'Reporting entities' Tab

The **Reporting entities** tab is displayed as follows, for example:

'Reporting entities' tab

Configure the following options on the **Reporting entities** tab:

#### Reporting entities that can be selected for import

Add the reporting entities that can be selected for import and fill in the table columns:

- **Displayed name** – name as shown in the UI
- **Abbreviation in Lucanet**
- **ID in data source** – name of the reporting entity in Lucanet. Must match the exact name in Lucanet, as this is used as the target of the import.
- **First month of the fiscal year** – e.g. 1 for January
- **Category** – optional category
- **Folder** – optional folder

#### Settings relevant when creating a data import

- **Split data imports during first execution**: If activated, data imports are split during the first execution.
- **Categorize data imports**: If activated, data imports are categorized as specified in the table above.
- **Use folders**: If activated, folders are used for organizing data imports as specified in the table above.
- **Adjust name of the month**: If activated, the name of the month is adjusted with a specified prefix or suffix.

### Script-Specific Parameters - 'Model configuration' Tab

The **Model configuration** tab is displayed as follows, for example:

Configure the following options on the **Model configuration** tab:

#### Export IDs

Table to define the exports created in xP&A that are to be imported into Consolidation & Financial Planning. Specify the following:

**Export ID:** ID of the export from xP&A whose values are to be read (selectable options are based on the script configuration).

**Do not refresh xP&A export:** If activated, the export from xP&A is not executed again on the next import; previously exported data can be used. If no export has been run yet for this export ID, the export will still be executed.

#### Import variables

Option to filter the variables to be imported from xP&A

The following options can be selected:

- **Selected variables** – Recommended option allowing you to select an entire **section** or individual variables.

Selecting a section is less maintenance-heavy: new variables added to that section in xP&A are automatically included on the next refresh.
- **All variables:** All variables from the xP&A export are imported as accounts, except those marked as **Exclude variable** in the **Variables** table.

#### Variables

Table to define specific variables to be imported (if you do not want to import **All variables**) or excluded from the import. The table contains the following columns:

- **Variable** – variable from xP&A to import as an account ( **Refresh** updates the list).
- **Multiply value by -1** – if activated, values for that variable are multiplied by -1.

xP&A typically stores revenue as positive values, but CFP uses debit/credit logic where revenue (P&L credit) must be imported as negative to display correctly.

You can apply this option per variable, per section, or globally via this checkbox at the bottom.
- **Exclude variable** – if activated, the variable is excluded (when **All variables** is selected).

#### Multiply all values by -1

If activated, all values are multiplied by -1.

xP&A typically stores revenue as positive values, but CFP uses debit/credit logic where revenue (P&L credit) must be imported as negative to display correctly.

You can apply this option per variable, per section, or globally via this checkbox at the bottom.

{% idea-box %}
**Tip:** Structure your models with separate sections for revenue and cost outputs, so you can apply the -1 multiplier cleanly at section level.
{% /idea-box %}

### Script-Specific Parameters - 'Import configuration' Tab

The **Import configuration** tab is displayed as follows, for example:

'Model configuration' tab

Configure the following options on the **Import configuration** tab:

| Section | Parameters and description |
|---------|---------|
| **Import values** | Option to specify which currency should be used when importing values. Choose between **As specified currency** (uses the currency from xP&A) or **As default currency** (uses the entity's default currency in CFP). |
| **Scenarios** | Scenarios from xP&A whose values are to be imported into CFP. The selection options can be updated by clicking **Refresh**. |
| **Import additional years** | If your model spans more than one year into the future, specify how many extra years to include. |
| **Use prefix** / **Use suffix** | Optionally add a **prefix** or **suffix** to a specific dimension to control how values are mapped (e.g. for sub-ledger account differentiation). |