Help & Support ↗ Lucanet Learning Space ↗
Documentation
Getting Started
Global Functions
Lucanet Lume
Administration
Data Hub
Consolidation & Financial Planning
Lease Accounting
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
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
ESG Reporting
Disclosure Management
XBRL Tagger
Tax Compliance & Reporting
Banking & Cash Management
Data Collection
Glossary

Creating and Configuring the Script Lucanet xP&A #3700-xP&A.SQL.FOS

Overview

In order to import an xP&A data export into CFP, you must first create and configure the data transfer script Lucanet xP&A #3700-xP&A.SQL.FOS.

Note for customers who still use Lucanet.Financial Client

You can either perform this step in the Lucanet CFO Solution Platform or in Lucanet.Financial Client. The script will be visible and editable in both systems, no matter where you created it.

Creating and Configuring the Script for the xP&A Import into CFP

To create and configure the data transfer script Lucanet xP&A #3700-xP&A.SQL.FOS used for importing xP&A data into CFP, proceed as follows:

1

In the overview, click the Import and Journals workspace.

2

In the tree view of the workspace, right-click Scripts or a folder and select the following from the context menu: Create | Script:

Shows the 'Import and Journals' workspace with the 'Scripts' folder's right-click context menu open. Highlighted in red are the 'Import and Journals' section and the 'Script' option under 'Create'.
Create a new script
3

Choose one of the following options to load the script xP&A #3700-xP&A.SQL.FOS into the Scripts workspace in the subsequent dialog:

  • Drag and drop the desired script into the dialog.
  • Click browse and navigate to the desired script.
4

Create the script.

5

In the detail view of the script, click Edit and configure the tabs of the script as described in the following under Script Parameters.

6

Click Save (or press Ctrl+S) to save the script configuration.

Script Parameters

'Connection' Tab

The Connection tab is displayed as follows, for example:

Shows the 'Connection' tab of the script Lucanet xP&A #3700-xP&A.SQL.FOS
'Connection' tab

Configure the following options on the Connection tab:

ParameterDescription
Export IDsSelect all xP&A exports, i.e. the models that should be imported. All exports are available which have been created in xP&A and for whose model you have access permissions. You can click Refresh to update the selection of available exports.
DatabaseOptional: Connection to an SQL database Serves as a temporary storage location for reimporting exports already performed from xP&A and for drill-down without restarting the export from xP&A. Connection information for Lucanet.Financial Warehouse can be used here.

'Dimension configuration' Tab

The Dimension configuration tab is displayed as follows, for example:

Shows the 'Dimension configuration' tab of the script Lucanet xP&A #3700-xP&A.SQL.FOS
'Dimension configuration' tab

On the Dimension configuration tab, you map xP&A dimensions to CFP dimensions.

The key mapping dimension is entity (i.e. how does the entity dimension in your xP&A model translate to cost centers in CFP).

The following options are available on the Dimension configuration tab:

OptionWhen to use
Refresh dimensions from xP&AClick Refresh dimensions from xP&A to update the available dimensions from the specified xP&A export(s).
Use dimension for reporting entityActivate if you use a custom dimension in xP&A (not integrated from CFP) and want to map it to reporting entities manually.
Use dimension for transaction currency codeThis is a legacy option and not needed in the current xP&A setups.
Assign cost centers automatically dependent on OIDsActivate when you use the organization element structure from CFP in xP&A. The OID (unique identifier per cost center) enables automatic matching.
Assign cost centers automatically dependent on homonymous namesThis is a fallback option where matches are based on name. Requires a dedicated assignment table.
Dimension mappingAssign xP&A dimensions to Lucanet.Financial OLAP Server (FOS) dimensions. For user-defined dimensions, you can use the target dimensions UserdefinedDimension1 to UserdefinedDimension9; when configuring the data source, use the corresponding DimensionsCode as needed.

Best practice: Always create a separate assignment table for xP&A imports to avoid conflicts with other import processes.

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

Page IDKB7443057

Last updated on May 28, 2026

Table of Contents
OverviewCreating and Configuring the Script for the xP&A Import into CFPScript Parameters'Connection' Tab'Dimension configuration' Tab
Related Articles

Company

Legal Notice

© Copyright 2026 - Lucanet AG