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
Modeling Your Data
Viewing and Visualizing Data
Working with Models
Editing the Model Settings
Organizing Models
Linking Models
Cloning a Model
Sharing a Model or Folder
Exporting a Model
Versioning a Model
Viewing the Audit Logs of a Model
Troubleshooting for Slow or Large Models
Cells and Limits
Multi-Player Modeling
Proposing Changes to a Model
Handling Errors in a Model Using AI
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

Working with Models in Lucanet xP&A

Overview

A model in Lucanet xP&A (Extended Planning & Analysis) refers to a structured representation of data and calculations, similar to a tab in a spreadsheet.

Models in xP&A can be:

  • Organized into folders, cloned, and linked with other models
  • Shared in parts through views or as a whole to collaborate with others within the xP&A solution
  • Exported to be used and to collaborate with others outside the xP&A solution

This article contains the following chapters on working with models in xP&A:

  • Organizing Models: For a better overview, models can be organized in folders. You can also assign a specific icon to identify a model easier, and set up favorites for your models.
  • Linking Models: Instead of a single model with all of your variables and formulas, you can structure your work into separate, smaller models, and import variables between them.
  • Cloning a Model: By cloning a model, you can create an identical copy of the model.
  • Exporting a Model: You can export your model(s) out of xP&A into a variety of formats and file types.
  • Sharing a Model: After building a model, you have the option to share this model with other users. You can also organize your model into folders and share folders if you want to grant access to multiple models at once.
  • Versioning a Model: xP&A automatically takes snapshots of your model (or set of linked models) at regular intervals, and you can also manually save a named version of a model.
  • Viewing the Audit Log of a Model: Audit logs are a model-by-model running history of who has made what edits (and when) to a model's variables, dimensions, visuals, or data.
  • Cells and Limits: A cell in xP&A represents a single number in the spreadsheet, and there are limits on the number of cells that can be used across your organization.
  • Editing the Model Settings: For every model, you can define certain time settings, which include the granularity, the date range, and the last actual date for your model.
  • Handling Errors in a Model Using AI: When a variable contains a calculation error, xP&A displays the error directly in the variable's warning panel and provides two AI-assisted features to help you understand and resolve it: Explain with AI and Fix with AI.
  • Multi-Player Modeling: xP&A allows multiple users to work in the spreadsheet of a model at the same time.
  • Proposing and Approving Changes to a Model: The Propose changes feature enables collaborative model updates through a structured review workflow. Data Collectors can suggest changes without directly modifying live data, while Editors review, approve, or reject proposed updates before they are applied.
  • Troubleshooting for Slow or Large Models: The performance of a model in xP&A, i.e. the speed of loading or calculating it, depends on various factors such as model size, formula complexity, and visual complexity.

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

Last updated on May 1, 2026

Table of Contents
Overview
Related Articles

Company

Legal Notice

© Copyright 2026 - Lucanet AG