Help & Support ↗ Lucanet Learning Space ↗
Getting Started
Global Functions
Lucanet Lume
Data Hub
Administration
Extended Planning & Analysis (xP&A)
xP&A Video Tutorials
User Roles in Lucanet xP&A
Lucanet xP&A User Interface
All Steps at a Glance
Basic Concepts and Elements
Creating a Model
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
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

Guideline for Exchanging Data Between xP&A and Consolidation & Financial Planning

Overview

Data can be exchanged in both directions between Lucanet Consolidation & Financial Planning (CFP) and Lucanet xP&A (Extended Planning and Analysis). CFP provides actual data for planning in xP&A; modelled planning data can be transferred back from xP&A into CFP.

This guideline describes the end-to-end process and points to the detailed instructions for each step.

Prerequisites

Before starting, ensure your xP&A models are built with the following in mind:

PrerequisiteDescription
Variables will be mapped to GL accountsThink about this upfront: The CFP assignment tables are used to map each output variable to the correct general ledger account.
Entity dimension must be presentVariables must be split by a dimension that can be mapped to CFP reporting entities or cost centers. Preferably, use the Organization element dimensions synced from CFP for a 1:1 match. Alternatively, a custom dimension can be used and mapped manually.
Work with output sections in your modelCreate a dedicated section (e.g. "Sales outputs") containing only the variables you want to transfer back to CFP. This simplifies selection during data source configuration and reduces maintenance.
Configure accounting rulesConfigure accounting rules since xP&A typically writes a one-sided posting (and debit/credit checks are always applied). You need contra entries to ensure balanced postings. Note: If you model out the full debit/credit logic in xP&A (e.g. when it comes to detailed revenue and working capital predictions), you can also work without accounting rules. In order to do so, select a different import type (e.g. transaction figures) during the data source configuration.

Process Steps for Exchanging Data Between xP&A and CFP

The process for exchanging data between xP&A and CFP consists of the following basic steps:

1

Integrating Data from CFP into xP&A

Data from Consolidation & Financial Planning is integrated as a CFP data source in xP&A.

How to set up a CFP data source in xP&A is described in Connecting to a Lucanet CFP Data Source.

2

Modeling Data in xP&A

Once the data is available in xP&A, you can model them for your planning and analysis purposes.

Detailed instructions on how to work with data in xP&A can be found in our xP&A documentation. In particular, you can refer to e.g. All Steps at a Glance for Lucanet xP&A, Working With Integrated Data, or Modeling Your Data.

3

Importing Data from xP&A back to CFP for the First Time

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

The initial import process consists of the following steps:

1

Create an export of the desired data in xP&A

2

Create and configure the import script Lucanet xP&A #3700-xP&A.SQL.FOS.

3

Create and configure the data source used for the import into CFP.

4

Create the assignment table used for the import into CFP.

5

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

All sub-steps necessary for this initial CFP import are described in detail under Importing Data from xP&A to CFP for the First Time.

4

Updating the Data Import from xP&A to CFP

Once the initial setup is configured, you can then update the import every time you want to transfer updated xP&A data to CFP.

This recurring import process consists of the following steps:

1

Create an export of the updated data in xP&A.

2

Update the configuration of the script Lucanet xP&A #3700-xP&A.SQL.FOS to include the new xP&A exports and update the dimension mappings.

3

Execute the data import of updated data into CFP.

All sub-steps necessary for this recurring CFP import are described in a Quick Reference Guide under Updating the Data Import from xP&A to CFP.

This content was generated using AI and reviewed by Lucanet subject matter experts before publication.

Last updated on May 28, 2026

Table of Contents
OverviewPrerequisitesProcess Steps for Exchanging Data Between xP&A and CFP
Related Articles

Company

Legal Notice

© Copyright 2026 - Lucanet AG