Refer to documentation Implementation
Presentation
The header is used to select the characteristics of the requested statistic inquiry (code, periods, site and company criteria, if any).
Close
Fields
The following fields are present on this tab :
Block number 1
| It identifies the current statistical code. A set of totals based on one to eight crossed criteria is linked to each statistical code. |
| When this field is populated with a company code, the inquiry is filtered in order that only those data concerning the selected company are displayed. |
| When this field is populated with a site code, the inquiry is filtered in order that only those data concerning the selected site are displayed. |
| It is used to display the values of the criteria of the current level. |
Block number 2
| The statistical inquiry can be delineated by date, remembering that the start and end dates given here are redefined depending on the frequency period chosen for the statistic. |
|   |
| When the parameterization of the statistic displays comparisons between two periods, the previous period is given here. By default, a period of the same duration and adjacent to the start period is proposed. |
|   |
| It is used to display the current level at which the user is positioned, and the maximum possible level for the statistical code. |
|   |
|   |
Close
Presentation
This tab displays the amounts cumulated and calculated for each criteria combination while taking account of:
Close
Fields
The following fields are present on this tab :
| It is used to display the values of the criteria of the current level. |
| Each column contains the cumulated or calculated amounts defined when the statistic was parameterized. These amounts are displayed on each line at the level of the corresponding total. |
|   |
|   |
|   |
|   |
|   |
|   |
|   |
|   |
|   |
Close
Action icon
When the current criterion corresponds to a record key (for instance, the country code), a right-click displays a line (called Country in this instance) that enables the current record to be displayed (the record of the country whose code is present on the line of the instance).
An additional function can be activated by right click, it is the tunnel function to a basic record, when the current criterion is the key of a record. The title that appears when using the right click depends on the record onto which the tunnel is possible.
For instance, for a statistic built on a set of criteria, one of them being the country code, when positioned at a level giving the detail by country code, a tunnel called Country is obtained, that enables the record of the current country to be displayed.
This button is used to filter lines, when positioned at a statistic level with many lines, by providing the requested code or a template of the requested codes.
Once the filter is set, only the corresponding lines are displayed. It should be noted that the breakdown by period of the second tab is not recalculated in totals for the lines. On the other hand, if the allocation by period of a line issued from the filter is requested, it suffices to switch to the next level using the corresponding button at the bottom of the screen. The content of the second tab will then be refreshed.
Close
Presentation
This tab presents the detail of the amounts of the previous tab by period (cumulated for all the lines of the level, and not only those on display). This detail is broken down into periods, depending on the frequency of the statistic. Thus, depending on the cases, there will be a line per week, per month, even per day.
For readability purposes, those lines corresponding to periods for which there are no transactions are not displayed in this grid, except for quarterly and yearly frequencies.
Fields
The following fields are present on this tab :
| It makes it possible to display the concerned period. |
| Each column contains the cumulated or calculated amounts defined when the statistic was parameterized. These amounts are displayed on each line at the level of the corresponding total. |
|   |
|   |
|   |
|   |
|   |
|   |
|   |
|   |
|   |
Action icon
By default, the following reports are associated with this function :
STAT : Statistics
This can be changed using a different setup.
The following fields are included on the window opened through this button : Selection
Order of criteria
Display
Close This button is used to display a criteria entry screen, that makes it possible to modify the screen being used (defined by the parameterization of the inquiry screens), the periods, the inquiry company and site, in order to perform the inquiry again and display the data again. Moreover it is possible to modify the following information in this screen:
|
It is used to go down by one level in the statistic, in other words, to return to the grid where the current line cumulates the lines that are being displayed. |
It is used to go up by one level in the statistic, in other words, to display the detailed allocation, on the next criterion, of the statistic line on which the cursor is positioned. |
When the second tab of the inquiry is displayed, when positioned on a given line of the period grid and then activating this function, it is possible to display, in the first tab, the detail (at the finest aggregation level) of the transactions of the chosen period.