Help & Support ↗ Lucanet Learning Space ↗
Getting Started
Global Functions
Lucanet Lume
Administration
Extended Planning & Analysis (xP&A)
creating-model
xP&A Video Tutorials
User Roles in Lucanet xP&A
Lucanet xP&A User Interface
All Steps at a Glance
Basic Concepts and Elements
Integrating Data
Connecting to a Data Source
sharing-data-connections
Working With Integrated Data
Guideline for Exchanging Data Between xP&A and CFP
Connecting to a Lucanet CFP Data Source
Initial Data Import from xP&A to CFP
Creating a Data Export in xP&A for CFP
Creating and Configuring the Script Lucanet xP&A #3700-xP&A.SQL.FOS
Creating and Configuring the Data Source
Creating an Assignment Table
Creating and Executing the Data Import into CFP
Updating the Data Import from xP&A to CFP
Modeling Your Data
Viewing and Visualizing Data
Working with Models
Using Comments and Descriptions
Comparison: xP&A vs. Excel Performance
Consolidation & Financial Planning
ESG Reporting
Disclosure Management
XBRL Tagger
Lease Accounting
Banking & Cash Management
Data Collection
Tax Compliance & Reporting
Glossary

Importing xP&A Data into Consolidation & Financial Planning for the First Time

Overview

Once the planning data is modeled in xP&A, you can then transfer this data into Consolidation & Financial Planning.

CFP uses an import script (Lucanet xP&A #3700-xP&A.SQL.FOS) to read in xP&A exports.

The following sub-steps are necessary for importing data from xP&A to CFP:

1

Create an export of the desired data in xP&A for each model you would like to import into CFP.

2

Create and configure the script Lucanet xP&A #3700-xP&A.SQL.FOS. CFP uses this import script to read in the xP&A exports. Configuration is done in the script's settings before you execute an import.

3

Create and configure the data source used for the import into CFP. In the data source configuration, you link the script and define certain parameters to be used for the import.

4

Create the assignment table used for the import into CFP.

This assigment table is the basis for assigning all elements imported from xP&A (e.g. accounts, cost centers, transaction currency, etc.) to elements in CFP.

5

Create and execute the data import into CFP and assign the imported elements to the elements in CFP

The data import uses the data source that is linked to the xP&A script and the assigment table you defined for this purpose.

Prerequisites

Before you configure the import into CFP, the following prerequisites must be met:

PrerequisiteDescription
CFP versionIf you work with Consolidation & Financial Planning in Lucanet.Financial Client, the Lucanet version must be Lucanet 25 or higher.
Script fileThe script Lucanet xP&A #3700-xP&A.SQL.FOS is available (e.g. via the partner portal or your Lucanet consultant).
Java libraryThe Java library athena-jdbc-3.4.0-with-dependencies.jar is added to the library of the CFP database (typically done by our Cloud Services or SRE team).
Database connection (optional)For drill-down support and to avoid re-running the xP&A export on each import, a connection to an SQL database can be used as temporary storage. The connection information for Lucanet.Financial Warehouse can be used for this purpose.

Last updated on May 28, 2026

Table of Contents
Importing xP&A Data into Consolidation & Financial Planning for the First TimeOverviewPrerequisites
Related Articles

Company

Legal Notice

© Copyright 2026 - Lucanet AG