Once you have set up your spreadsheets in Lucanet xP&A (Extended Planning & Analysis), you have multiple options to create certain views of your data or visualize your data, e.g. for presentation purposes or if you want to share your data with other users.

This article contains the following chapters on viewing and visualizing data in xP&A:

  • Using Dashboards: Dashboards are a nice way for others to view and interact with your model. It shows your model's input variables at the top, with its charts underneath. You also have the option to show them a read-only spreadsheet view, too.
  • Using Charts: Charts can be used to visualize your data, either within the Spreadsheet workspace or the Dashboard workspace. Charts are useful if you want to visualize several variables.
  • Using Tables: Tables can be used in xP&A to visualize your data in a pivot table, either within the Spreadsheet workspace or the Dashboard workspace.
  • Using Scenarios: A scenario is a live variant of your model in which some variables (or cells of a variable) have different values or formulas. The structure of the model — the variables, groups, and sections — does not change across scenarios.
  • Using Views: Views let you create saved filters on your model, to show only specific variables, dimension items, scenarios, time periods, and charts.

Furthermore, xP&A allows you to compare or aggregate your data using the following functionalities:

  • Comparing Versions or Scenarios in Charts and Tables: You often might want to compare different versions and/or scenarios of your model, for example to learn how your actual performance compares to your budget or forecast, see how different scenarios affect your numbers, or compare how a new scenario stacks up against your original forecast.
  • Using Time Aggregation and Relative Comparisons: xP&A offers different functionalities to compare or aggregate your data in order to gain deeper insights, identify trends, and support strategic decision-making across planning and analysis workflows.

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