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

Last updated on 2026-05-07

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 accounts

Think about this upfront: The CFP assignment tables are used to map each output variable to the correct general ledger account.

Entity dimension must be present

Variables 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 model

Create 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 rules

Configure 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:

Integrating Data from CFP into xP&A

Data from Consolidation & Financial Planning is integrated using 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.

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.

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.

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.

Contact Us