Creating and Configuring Reporting Packages

Getting Started

Global Functions

Lucanet Lume

Data Hub

Administration

Extended Planning & Analysis (xP&A)

Consolidation & Financial Planning

ESG Reporting

Disclosure Management

XBRL Tagger

Lease Accounting

Banking & Cash Management

Data Collection

All Steps at a Glance

User interface of Data Collection

User Roles in Data Collection

Basic Configuration

Creating and Configuring Form Templates

Creating and Configuring Validation Rules

Importing Reporting Entities from Consolidation & Financial Planning

Creating and Configuring Reporting Packages

Collecting Data

Tax Compliance & Reporting

Glossary

A Reporting Package is a virtual container that bundles together the elements required for a data collection process:

Form templates with completion instructions

Reporting entities with assigned collectors and approvers

Intercompany validation rules (if enabled)

Once a reporting package is fully configured, an Administrator can start data collection processes for it.

To create a reporting package:

Navigate to Data Collection | Reporting packages.

Click + Create reporting package in the top right. The Create Reporting Package dialog is displayed:

In the Create Reporting Package dialog, enter a unique name for the reporting package and click Create.

You can now configure the newly created reporting package (see the following section).

The following options are available for configuring reporting packages:

The following options can be configured in this step:

The first step in the create reporting package wizard is displayed. — 'Settings' step

Option	Description
Frequency	Frequency for data collection. Options include: • Monthly • Quarterly • Semi-Annually • Annually
Group currency	Currency used at group level, selectable from a list of ISO currencies
Intercompany validation	Option to enable or disable intercompany validation for this package
Description	Optional description explaining the purpose of the reporting package

The following options can be configured in this step:

The second step in the create reporting package wizard is displayed. — 'Reporting entities' step

Option	Description
Add reporting entities	Opens a dialog to select one or more reporting entities to include in the package
Collectors and Approvers	After adding reporting entities, you can configure user assignments. Assignments are copied by default from the Reporting Entities workspace, but you can overwrite them for this specific package.
Partners, Adjustment levels, and Transaction types	Displays one column per drill down dimension. In the Reporting package default row, you define which elements of the dimension are available for all reporting entities; for individual reporting entities, you can override the selection. For details, see Element Selection for Drill Down Dimensions.

At least one Collector and one Approver must be assigned to each reporting entity. The same user can be assigned as both Collector and Approver.

If the form templates in the package use the partner, transaction type, or adjustment level dimension in a drill down, you can limit which elements of these dimensions are available during data collection. The Reporting entities step displays the columns Partners, Adjustment levels, and Transaction types for this. The Reporting package default row defines the selection that applies to all reporting entities, and each reporting entity row can receive its own override.

To configure the element selection for a dimension:

In the Reporting package default row, click the selection cell of the dimension, or click Override in the row of an individual reporting entity. The element selection dialog is displayed. For a reporting entity, the dialog is pre-populated with the current selection from the Reporting package default row.

Select the elements to make available. The dialog displays all elements of the dimension from Consolidation & Financial Planning with a search field and a counter of the selected elements; all elements are selected by default. Use Select all and Deselect all to change the selection quickly.

For the partner dimension, the additional In reporting package action selects exactly the partners whose names match the reporting entities in the package and deselects all others. The selection is applied once — reporting entities added to the package later do not change a saved selection. You can adjust the selection manually before saving.

Save the selection. If all elements are selected, the cell displays All; otherwise it displays the number of selected elements.

The configured selection behaves as follows:

Collectors only see the selected elements in a drill down. Excluded elements are not displayed and cannot be selected.

During Excel and Lucanet.Financial Warehouse imports, rows that contain an element outside the selection are rejected. The import result identifies the rejected rows.

If all elements remain selected, the behavior is unchanged and all elements of the dimension are available.

Elements added in Consolidation & Financial Planning after the selection was configured are included automatically unless you deselect them.

You can remove a reporting entity's override at any time; for new data collection processes, the reporting entity then uses the selection from the

Reporting package default

row again.

Changes apply only to new data collection processes. Processes already in progress are not affected.

The following options can be configured in this step:

The third step in the create reporting package wizard is displayed. — 'Form templates' step

Option	Description
Add form template	Opens a dialog to select one or more form templates in state Published to include in the reporting package
Reporting entities	Displays the reporting entities that receive the form template. By default, all reporting entities in the reporting package are assigned. Click the cell to restrict the form template to specific reporting entities. For details, see Restricting Form Templates to Specific Reporting Entities.

By default, every reporting entity in the reporting package receives every form template. If the reporting entities have different reporting obligations — for example, subsidiaries complete a different balance sheet than holding entities — you can assign each form template to specific reporting entities. Each reporting entity then only receives the forms relevant to it, within a single reporting package and a single data collection process.

To assign a form template to specific reporting entities:

In the Form templates step, click the Reporting entities cell of the form template. The Assign Reporting Entities dialog is displayed:

The dialog for assigning reporting entities displays a search field, the actions for selecting and deselecting all reporting entities, and the list of reporting entities in the reporting package. — 'Assign Reporting Entities' dialog

Select the reporting entities that receive the form template. The dialog displays all reporting entities in the reporting package with a search field; all reporting entities are selected by default. Select all and Deselect all apply to the reporting entities that match the current search term.

Click Save. The Reporting entities cell displays the current selection.

The assignment behaves as follows:

The assignment is stored in the reporting package. The same form template can carry a different assignment in every reporting package, and the assignment does not change the form template itself.

A reporting entity added to the reporting package is added automatically to the assignment of every form template in the package. A reporting entity removed from the reporting package is removed automatically from every assignment. A form template removed from the reporting package loses its assignment.

When a data collection process is started, forms are created for each reporting entity only from the form templates assigned to it. Collectors only see the forms created for their reporting entity, and a reporting entity is complete when all of these forms have been submitted. For details, see

Starting Data Collection Processes

Regular validation rules are executed for a reporting entity only when every form template referenced by the rule is assigned to that reporting entity. For details, see

Validation Rules and Reporting Package Scope

. Intercompany validation rules are not affected by the assignment.

You can save an incomplete assignment at any time. The configuration is checked when you publish the reporting package. For details, see

Publishing a Reporting Package

Changes apply only to new data collection processes. Processes already in progress are not affected.

The reporting packages list displays all configured reporting packages with the following information:

A list of created reporting packages is displayed. — Reporting packages list

Column	Description
Reporting package name	Name of the reporting package
State	Current state of the reporting package: • Draft • Published • Invalid — set automatically when a linked form template is opened for editing. A data collection process cannot be started from an invalid reporting package. When the linked form template is republished, the reporting package moves back to Draft state. You must then manually publish the reporting package again to restore it to Published state.
Collection process	Number of data collection processes started for this reporting package
Collection frequency	Configured collection frequency (monthly, quarterly, etc.)
Created on	Creation date
Last modified on	Date of the most recent modification
Context menu	Three-dot menu at the end of each reporting package row. Available actions: • Start data collection - starts a data collection process for the selected reporting package • Edit • Delete

To edit an existing reporting package, click the three-dot menu at the end of the reporting package row and select Edit.

When first created, a reporting package is automatically in Draft state. While in this state, it can undergo any number of modifications. Once its configuration is finalized, the reporting package must be Published before it can be used to start data collection processes.

To publish a reporting package, click Publish in the top right of the reporting package detail view.

The configuration is checked when you publish — while in Draft state, an incomplete configuration can be saved without restriction. A reporting package cannot be published while:

No reporting entity or no form template is included in the reporting package.

A reporting entity has no collector or no approver assigned.

A reporting entity has no form template assigned to it.

A form template has no reporting entity assigned to it.

A form template contains a formula that references another form template, and the referenced form template is not assigned to the same reporting entities as the referencing form template.

If publishing fails, the message Cannot publish reporting package identifies each affected reporting entity and form template. For details on assigning form templates to reporting entities, see Restricting Form Templates to Specific Reporting Entities.

A published reporting package can only be modified if it is not linked to ongoing data collection processes. Editing a published reporting package automatically brings it back to Draft state.

To delete a reporting package, click the three-dot menu at the end of the reporting package row and select Delete. In the confirmation dialog, click Yes, delete.