Exporting a Model

Getting Started

Global Functions

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

You can export your model(s) out of xP&A into a variety of formats and file types. This is useful for a variety of situations, for example:

Sharing your model with people outside of xP&A

For using the model data or outputs in systems outside of xP&A

Saving a local or offline copy of your model and its data

To export a model:

Click the Settings button and navigate to the Export and download section.

Click + to create a new export. The New export dialog is displayed:

Specify the below options for the export.

Click Next and Create export.

Name of your export

Raw

values: useful format for inputting into another system (e.g. data warehouse) for further manipulation, or creating pivot tables from.

Formatted

values

This format is organized like your xP&A model, with time as columns and variables as rows.

Choose the output of the export:

Download

Use this option to export as a download file and choose the file format:

If you export

formatted values

, the output format is always an

Excel

file.

If you export

raw values

, you can choose between,

CSV, Excel, Google Sheets

, or

Parquet

(a compressed file format designed for fast querying and efficient storage, especially for big data volumes)

External sync

:

Use this option if you want the export to be

synced

with an external system and choose the

target system

and the

parameters

for the synchronization.

In addition, specify the

export schedule

, i.e. if you want to sync the export one-time only or regularly on a specific day and time.

The External sync option is only available for raw values and for the following target systems: BigQuery, Databricks, MySQ L, Redshift, Postgres and Snowflake.

Choose the content to be exported:

All values

: Export

all values

View

: Filter values via a

view

(you will need to exit the export modal if you need to create a view).

Version

: Choose a specific

version

to be exported.

Specify whether linked models are to be exported as well:

All

: All linked models are exported.

Customize

: Choose the linked models you want to export as well.

Choose the date range to export:

Model time dimension

: Will export all dates in the model

Model time filter

: Will limit the exported dates to the currently selected time filter.

Last updated on Aug 16, 2023

Exporting a Model

Overview

Exporting a Model

Overview