This function is used to describe dimension analytical pyramids.

Principle of the analytical pyramids

  • It is possible to describe as many grouping pyramids as are necessary to each dimension type.
  • The analytical information is entered at detail level only (where the accounts can be allocated).
  • A budget is based on a chart of accounts and on several dimension types (three at most). The entry is done at the detail or grouping level, with a given aggregation level. Only some groupings can be budgeted.
  • The report criteria should specify, for each dimension, the desired aggregation level and potential selection ranges.

The reports are performed via the analysis of the dimension balance, the budget and the financial Data Extraction.

Prerequisites

SEEREFERTTO Refer to documentation Implementation

Screen management

Entry screen

This screen is used to create, modify and view an account or dimension pyramid in graphical form.

SEEINFO The graphical components of the pyramid are defined in the function Graphic components . Standard codes are nevertheless delivered by default:  PYRELT, PYRGRP, PYRHEAD, PYRJOK.

It contains the following elements:

A header block

It identifies the pyramid and its display characteristics.

A block representing the pyramid

The building of the pyramid is dynamic.

  • On a given group, clicking on a group makes it possible to:
    • add a sub-group,
    • assign accounts -with an explicit name or described with wildcards- to this group,
    • consult the detailed record of the group or the element.
  • The levels are assigned automatically (by default with a 10-level interval, and starting with level 10 for the header group). In the same way, the printing order is automatically assigned with a 10 level interval, in the display order of the various sub-groups within a group.

SEEWARNING The automatic allocation of a level to a group makes it possible to have homogeneous levels from one branch of the pyramid to another.

Similarly, the pyramid structure can be modified on the screen by drag and drop. Dragging an element A of the pyramid to an element B enables the first element to be linked to the second element:

  • Left arrow: element A has the same level as element B, but a lower printing order,
  • Right arrow: element A has the same level as element B, but a greater printing order,
  • Top-down arrow: element A is a sub-group of element B. Its printing order is 0.

Block number 4

Add a group

This function is used to add a group to the pyramid, and to specify the main characteristics of this group.

SEEINFO Limit the group creation to 1,000 in order to maintain readability.An error message is displayed if this limit is exceeded.
Add an account

This function is used to:

  • assign an account or a group of accounts linked to the pyramid by a wildcard character,
  • enter the code of the account or all the accounts.
Delete

This is used to delete a pyramid.

SEEWARNING This deletion concerns the pyramid as a whole.To delete an element of the pyramid, the corresponding menu can be accessed by right clicking on this element.
Modify

This function is used, via a window, to modify the main characteristics of the group.
Zoom

This function is used to zoom on the pyramid. The graphical representation starts from the selected group and unfolds its sub-levels.
Standard rerouting action

This function is used to access the basic record via a tunnel.

Reports

By default, the following reports are associated with this function :

  GLGRP : GL journal account details

  GLGRPDEV : General ledger/currency

  PLAN : Chart

This can be changed using a different setup.

This function is used to duplicate the pyramid of selected accounts.
Enter a code and description related to the destination pyramid in the intermediate screen.

SEEWARNING The code and description of the destination pyramid must not have been used for another accounts pyramid.

Block number 1

  • From folder (field DOSORG)
  • To the folder (field DOSDES)

Block number 2

The code of the pyramid will be used later on in all the reports.

The first group of the pyramid being created is arbitrarily named "GLOBAL".
It is possible to rename this group after its creation via the function dimension groupes.

The levels of the pyramid can be set up in the ascending order from the most general to the finest level.
It is possible for example to define levels from 10 to 10 in order to later include an additional level.
  • field DES

This field is used to link a description to its record. This description can be printed on the records, displayed when the record code is entered in a screen, or used on selection.
The title, used by default in the reports and entry masks is replaced by the short title when it is required by display and print constraints.

By default the short title, the long title or the column header of a data are recorded (on creation/update) in the connection language of the user.
You can add your translation in another language using the Translation function:

  • Click Translation from the Actions icon in the corresponding field.
  • In the Translation window, add a new language code with the translation in this language.

A user who logs on with this language will view the short description, long description or column header in their connection language if a translation exists. Otherwise, these descriptions will be available in the folder language.

SEEINFO The connection language must be defined as a default language for thefolder.

This function is used to automatically generate or regenerate an accounts pyramid.

SEEWARNING An error message is displayed when groups have been created for the pyramid to be generated.A non-existent group is not created automatically during the generation.

Block number 1

Code of the pyramid to be generated. It has probably already been created.
This code will be used at a later time in all records.

This field recalls the chart of accounts on which the account or the pyramid (general, analytical, both) will be created or to which they will be attached.

Grid Details

  • Pyramid level (field NIVEAU)

The numerical value entered in the various available fields makes it possible to establish a hierarchy of groups present in the pyramid.

  • Account length (field LENLEV)

The numerical value entered in the various available fields is used to indicate the number of character(s) for each level of the pyramid.
For instance, if the number entered is 4 for the level 40, the length of the groups is of four characters.

Block number 3

  • Use wild-cards (field JOK)

When checked, this box is used to include any new account or dimension to the defined group.
This link is made by entering:

  • a screen,
  • a direct account number.

Example:
Let us consider a pyramid to be created for the SOC chart, grouping accounts 101 001, 101 002 and 101 003 :
1. box checked: the system uses wildcards and includes automatically any account of type 1010* (according to the screen entered). An account of type 101 004, corresponding to the screen, is thus included in the group.
2. box not checked: the system does not use wildcards. It includes only the existing accounts 101 001, 101 002 and 101 003. An account of type 101 004 is not automatically linked to the group.
  • Homogeneous levels (field HOM)

When checked, this box is used to plan the insertion of groups on a same level when they have different length so that each branch of the generated pyramid has the same number of levels.

This function is used to launch a control on all the chart's accounts considered in the selected pyramid.
The resulting log file makes it possible to check that they are referenced.

Grid

  • field LIGNE

Each of the lines in the grid corresponds to a line in the log file.

This option is active only if a "reference pyramid" has been declared for the current chart of accounts.

Its goal is to delete and rebuild the pyramid whilst respecting the structure rules associated with the status "reference pyramid". It also preserves the created groups and assigns to them the accounts from the chart of accounts according to their number.

Limits

  • The number of links created during the synchronization of a pyramid is limited to 10,000 that is to say that there cannot be more than 10,000 groups/accounts in a pyramid. This limit is controlled during the creation or re-synchronization of an accounts or dimensions pyramid.
  • Performance when inquiring or printing the analytical balance can be lowered when the inquiry or printing are based on accounts/dimensions pyramid groups. Indeed, the aggregation of pyramids on groups occurs in real time based on all details recordings (all recordings of analytical balance tables, budgets, balances of commitments/renewed commitments).

Error messages

In addition to the generic error messages, the following messages can appear during the entry :

"Too many groups in this pyramid"

The number cannot exceed 1000 groups.

Tables used

SEEREFERTTO Refer to documentation Implementation