Knowledge base

The relationships between entities and the holding are defined in the ownership application. It is a supporting application used in the consolidation tool.

The expand all option can be used to regenerate the EVDRE report. It recreates the structure of the report and refreshes the cells.

A table that contains the transactional data. There are 3 types of tables in the MS version: -FACTWB: real time data storage -FAC2: short term data storage -FACT: long term data storage

Standard BPC logic used to perform the currency conversion. It uses the rates stored in the Rate application and the currency property of the entity to make the calculations.

This range is one of the EVDRE ranges. It makes it possible to define which cells a user only wants to retrieve values. The cells are designated as read-only.

Input schedules have all the same features as BPC reports, but additionally, they have a special flag that allows authorized users to enter and submit data to the database.

Journals are used to record and make adjustments to data in the database. This is typically done as part of the month-end or quarter-end process. Journals consist of a header and detail information.

A Legal consolidation process is a financial process and allows to show the assets, financial position and income of a group as if the group were a single enterprise. To achieve this, all effects on the consolidated financial statements arising from goods and services and financial dependencies between the internal trading partners must be eliminated.

This function allows users to define formulas that perform calculations with special requirements on Planning and Consolidation dimension members and data.

Dimension formulas are MDX calculations linked to a specific dimension (i.e. account) maintained together with the dimension members and properties. Dimension formulas are not stored in the database but retrieve on refresh time of the report.