Programming References

Getting Started

Global Functions

Administration

Extended Planning & Analysis (xP&A)

Consolidation & Financial Planning

ESG Reporting

Disclosure Management

The Lucanet Disclosure Management User Interface

All Steps at a Glance

Basic Configuration

Dashboard

Configuring a Document

Cockpit

Creating and Editing Chapters

Creating and Editing Periods

Importing Data

Working with MS Office Files

Ribbons for Disclosure Management

Creating and Editing Excel Files

Mode of Excel Files

Configuring an Excel File

Names and Name Extensions in MS Excel

Creating and Editing Columns

Inserting Report Values in MS Excel

Defining Outareas

Programming References

Using Layouts in MS Excel

Inserting Tables From ESG Reports

Creating and Editing Word Files

Versioning and Recovery of MS Office Files

Creating and Inserting Document Variables

Creating and Editing Validations

Using the Data View

Using the XBRL Tagger

Creating Result Document

Rolling Forward or Copying a Document

Editing Documents in the XBRL Tagger

XBRL Tagger

Lease Accounting

Banking & Cash Management

Data Collection

Tax Compliance & Reporting

Glossary

Some report values, for example the numbers in a key figures table, are repeated in multiple places in reports. So that these only have to be updated in one place and are rounded immediately if applicable, References can be set. The use of references is recommended in the following cases, for example:

If a report value is also used elsewhere, only a reference to the

Source value

is set for this. The

Target value

of the reference then no longer needs to be updated separately because changes to the source value will be transferred automatically to the target value by means of the reference.

References can also be set for report values of other documents managed by Disclosure Management. Among other things, this can be used for quarterly reporting to link comparative periods in the balance sheet with figures already published in annual financial statements.

Disclosure Management provides the Programming Assistant for inserting report values in Excel files.

References can be inserted in Excel files using the Excel ribbon. To create a reference, select a cell in the value column where you want the target value to be displayed. The reference can then be inserted using the Programming Assistant. Proceed as follows:

Double-click a cell in a value column or programming column. The Programming Assistant will then be displayed in MS Excel.

Open the Reference Programming tab:

'References Programming' tab of the Programming Assistant in MS Excel

Configure the Document, Chapter, Column, and Period drop-down lists.

If necessary, enter a character string in the Filter input field to filter the list of report values.

In the Name column of the list of report values, activate the check box of the value that you want to carry over to the Excel file as a reference.

Click Adopt.

In the Excel ribbon, click Check In to apply the changes in Disclosure Management.

References must be programmed separately for each cell. Even with programming columns that are on top of each other, the #r[name] entry in the programming column only ever applies to the cell that was selected when the assistant was called up.

The Reference Programming tab contains the various possible settings for selecting a source value. Detailed information for a reference, such as the name of the source value, the value, and the programming, is displayed in the Preview in the bottom area of the assistant.

The following options are available in the Reference Programming tab of the Programming Assistant:

Function	Description
Document	Document where the report value (source value) for the reference is located
Chapter	Chapter in the source document where the report value for the reference is located

Period in the source document where the report value for the reference is located

Filter value for the report data displayed in the list of report values

The abbreviation DP stands for decimal places. Activate the check box if the decimal places of the report values are not to be truncated. In this case, the source format of the report values will be used as the reference instead of the target format of the table.

Once all the settings have been configured, a list will be displayed with all the report values that can be used as reference values.

The Name column displays the content of the name column linked to the displayed report value.

In the Name column, activate the check box of the value that you want to carry over to the Excel file as a reference.

The selected report values are displayed here as a preview along with

their Name (account/item numbers from the alias column),

their Value,

and the Programming in the programming column.

Clears the preview and, after clicking Adopt, clears the value and programming from the Excel file.

Saves the new reference. By adopting the reference, the reference programming in the form #r[row number] is inserted in the corresponding cell of the programming column.

To apply the changes in Disclosure Management, the Excel file must be subsequently checked in.

Last updated on Aug 16, 2023

Programming References

Overview

Inserting References

Configuring References

Overview

Inserting References

Configuring References

Period

Filter

Use extended decimals #rf

List of report values

Name

Preview

Clear

Adopt

Table of Contents

Company

Legal Notice

Table of Contents

Related Articles

Company

Legal Notice