JPH07262165A - Aggregating method for two-dimensional data - Google Patents

Abstract

PURPOSE:To flexibly cope with the change of the aggregation algorithm and the aggregation object by defining aggregation items of aggregation processings, calculation formulas, etc., to groups into which items defined by rows and columns of two-dimensionally expressed data are divided in relation to making the items hierarchical or the like. CONSTITUTION:A fundamental item extracting part 2 extracts/selects key items, which unequivocally prescribe two-dimensional data, to define fundamental item information. A related item defining part 3 divides items into groups in accordance with an aggregation algorithm and relations between fundamental item information with respect to fundamental item information. A aggregation object selecting part 6 divides items, which are related to one another by the related item defining part 3, furthermore. An output item designating part 4 defines item information of aggregation results. That is, this part 4 selectively defines items to be displayed/outputted on a screen or in a form. These related item information are temporarily stored in an information pattern defining part 7. A aggregation processing part 5 actually executes the aggregation.

Description

Detailed Description of the Invention

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to a two-dimensional data totaling method, in which data is determined by two keys.
The present invention relates to an aggregation method of aggregating data in a group of key values and an aggregate associated with key values and displaying and outputting the result on a screen of a terminal or a form.

[0002]

2. Description of the Related Art Conventionally, so-called spreadsheet software has been known for aggregating processing of two-dimensional data using a computer. In spreadsheet software, each row and column has a meaning, and specific data is input to the cell specified by the row and column.
In the spreadsheet software, when totaling the data input to the cells, the cell is specified and the data of the cell is calculated to perform the totaling. Therefore, in order to perform the calculation, it is necessary to specify the cell itself and set the calculation formula. On the other hand, data that can be expressed in two dimensions is described by a command statement using a programming language, and the totaling target and totaling range are described in the program. This program was fixed, and it was necessary to modify the program itself in order to change the aggregation method and the target range, and it was difficult to dynamically respond to changes in the aggregation algorithm.

[0003]

In a system for tabulating data and aggregating the data to generate new data / information, the data aggregating algorithm and the aggregating target range are Change with. In the conventional aggregation system,
Both are fixed and incorporated into the program, making it difficult to respond to changes.

The present invention has been made in view of the above circumstances, and it is an object of the present invention to provide a totaling method capable of flexibly responding to a change in a totaling algorithm and a totaling target in totaling data in a two-dimensional data format.

[0005]

In order to achieve the above object, the present invention is characterized by having the following configuration. Two
Enter data that can be expressed in dimensions. This is, for example,
It is like inputting data for a combination (so-called "cell" portion) defined by rows and columns in spreadsheet software. Next, the input data is totaled and output, and the present application is characterized by this totaling method.
First, items defined by rows and columns are hierarchically organized (grouped) based on the attribute relationships of the items. For example, as aggregated data, line items are defined as account items such as personnel expenses, travel expenses, equipment expenses, ..., and column items are defined as personnel departments, accounting departments, materials departments ... Defines each item defined in the row and column if is defined. For example, of account items, travel expenses and equipment expenses are indirect expenses, so the indirect expenses are defined as a higher hierarchy. Similarly, within the organization of the company, the personnel department and accounting belong to the general affairs department. The grouped items are stored in a file with an associated number and an associated name. Then, an aggregate process such as an output range and a calculation formula is defined between the defined related item information, and the aggregate process is executed. By doing so, it is possible to quickly perform processing such as totalizing the overhead costs of the general affairs department. Also, if a new welfare section is established in the general affairs department,
By modifying only the hierarchy content of the general affairs department, it is possible to make changes without changing the totalization process itself such as the calculation formula. Further, if a plurality of items (related items) defined by rows and columns are defined, the totaling process can be easily performed for each related item.

[0006]

As described above, the items defined by the rows and columns of the data that can be expressed in two dimensions are grouped in association with each other such as hierarchization, and the grouped items are aggregated and processed. Since the total items such as the calculation formulas are defined, the high-flexibility data total process can be performed without depending on the method of classifying the two-dimensional data.
Also, if the grouping definition and the summary item definition are stored separately from the program for aggregation and stored in a file, the method of aggregation can be changed without changing the program itself that executes the aggregation process. You can change it freely.

[0007]

DETAILED DESCRIPTION OF THE PREFERRED EMBODIMENTS As an embodiment of the present invention, a case will be described below in which a tabulation method relating to key items of two-dimensional data is applied to a profit and loss management form creation process in a management accounting system. FIG. 1 is an overall view of a system that executes the counting method of the present invention. The processing device 1 controls the entire system and includes the following elements. The basic item extraction unit 2 extracts / selects a key item for uniquely defining two-dimensional data and defines basic item information. The related item definition unit 3 performs grouping from the basic item information according to the aggregation algorithm and the relationship between the basic item information.
This is defined as related item information. The aggregation target selection unit 6 further groups the items associated by the related item definition unit 3. The output item designation unit 4 defines item information of the counting result. That is, the items for displaying / outputting the tabulation result on the screen and the form are selectively defined. The selection is performed on the related item information of the first level and the second level. The information pattern definition unit 7 temporarily stores the related item information. The tally processing unit 5 actually executes the above tally. The input unit 8 is an input unit such as a keyboard or a mouse, and an operator's instruction is input. The display means 9 is a display means such as a CRT display or a liquid crystal display. The output means 10 is an output means such as a printer or a plotter for outputting on paper.

The organization master file 11 is a file that stores the definition of a column of two-dimensional data. The account item master file 12 is a file that stores the definition of a row of two-dimensional data. The data file 13 stores the actual value data of the items designated by the row and column definitions of the two-dimensional data. The related item master file 14 is a group of items stored in the organization master file 11 and the account title master file 12. This group may be a simple classification or may be grouped to have a hierarchical structure. The total item master file 15 is stored in the related item master file 14 and stores the definition of the total process of the grouped items. Items to be output, formulas, and the like can be stored in this totaling process. The program file 16 stores a program for executing the totalization process according to the definition of the totalization process stored in the totalization item master file.

FIG. 2 is a view for explaining the operation procedure of this embodiment. First, the basic items to be aggregated are defined (step 21). For example, when the line item is an account item, basic items are defined such that the account item is a1 (ex. Personnel expenses), a2 (ex. Travel expenses), and the account item master file 12 is created. Similarly, when the column data is the organization of the company, the organization is b1 (ex. Personnel section), b2 (ex.
Accounting section) ... Basic items are defined and stored in the organization master file 11. Two types of master file 11,
By creating 12, it is possible to define the aggregation target domain.

Here, FIG. 3 shows a flow of defining the basic items such as organization and account item. The cell 323 specified by the organization and the account item is specified in the format of 31. 31
Reference numeral 1 is an organization code, which is a code indicating an organization 322. Reference numeral 312 is an account item code, which shows the code of the account item 321. Actual value 313 is actually cell 3
It is the data displayed on 23. In this way, when the row and column items are indicated by a code, an identification name for the code is input (38), and registration in the organization master file 11 (36) and registration in the account item master file 12 are performed (37). ). Next, from the input means 8,
When the actual value for the account item is input, it is stored in the actual value data file 13.

Returning again to FIG. Next, the related item definition which is the group definition of the total item is defined (step 22).
Here, as a level 1 group definition, an organization and an account item are associated. Define the target organization and target account for association.

Here, a method of defining the organization-related information will be described with reference to FIGS. FIG. 4 is a diagram showing the concept of related item definition. Generally, a company organization is organized in a hierarchical structure like 42. In the table shown at 41,
Relevance level. It is stored as a related parent-child item. Then, when the range indicated by 43 is selected as the target organization to be totaled, a file of the related item table 44 indicating the selected total target organization is created from the record group of 41. The related item table 44 has an identification name 45 for identifying it.
Is given. Next, the operation procedure of FIG. 4 will be described with reference to FIG. First, related items are extracted from the identification name of the organization master file 11 (step 51). This extraction can be performed by the operator, and the child 415 is designated by the input means 8. Next, the parent 414 and the related name 412 are given as the relationship of the nth level (step 5).
2). These steps 51 and 52 are repeated until there are no items to be extracted (step 53). Next, the same processing is repeated for the (n + 1) th level (steps 54 and 5).
5). Next, the aggregation target is selected from the aggregation target organization table 41 (step 56), the related item table 44 is created, and stored in the related item master file 14 (step 57).

On the other hand, a grouping method relating to the account target account will be described with reference to FIGS. 6 and 7. As shown in FIG. 6, the account items are grouped by product and in Japan and overseas, and are given a group name such as A product, B product, foreign country ... Then, they are put together and classified into profit and loss budget and sales expense. In this way, a hierarchical structure can be defined for account items. Then, 71 tables are created for the relation. When 62 is assumed to be the totaling target, the record corresponding to 62 is selected from 71, and 7 is selected.
The totaling target file 2 is created and stored in the related item master file 14.

Returning to FIG. 2 again, the related item group is displayed.
(Step 23). Here, after associating the basic items, the newly added related items are further associated with each other to define a recognizable total item. This is the form output item.

Here, the procedure of defining the totalized items will be described with reference to FIG. First, the related item table 44 to be totaled is selected from the related item master file 14 (step 81). Next, the aggregation target table 73 is selected from the related item file 14 as the aggregation result item (step 82). Since three items are defined as major categories in the totaling table 73, elaborate selection is repeated (step 83). Selected items are tabulation pattern definition table 8
It is stored in the item column of 8. In this case, calculation numbers 1 to 3 are selected. Next, using the items of calculation Nos. 1 to 3, new items of profit and loss and the achievement rate are defined, and a calculation formula is designated (step 84). The four arithmetic expressions are stored as 89. Next, whether or not the item is an output item is designated as in 90 (step 85), and is stored in the total item master file as one total pattern (step 86).

Returning to FIG. 2 again, the totalization result is finally output (step 24). FIG. 9 is an example of a form output according to the method according to the present invention. It indicates that the specified subjects are totaled for the specified organization object, and only the output specified items are output and displayed.

The form title name, date, etc. are stored in the keyed-in form pattern definition file.

The embodiment of the present invention has been described above. The aggregation algorithm is as follows: organization master file 11, account master file 12, actual value data file 1
3, the related item master file 14 and the total item master file 15 can be separated and made independent. In this method, when the organization is changed or the account is changed, it is possible to deal with it by only changing various definition information without modifying the aggregation algorithm.

[0019]

EFFECT OF THE INVENTION In the aggregation processing by the association of the key groups with respect to the data defined by the two keys, for example, the data in the tabular format, the aggregation algorithm is separated from the processing program, that is, the aggregation. By changing the data of the algorithm, it is possible to flexibly deal with the change of the aggregation target and the aggregation method. For example, in the creation of a profit and loss management form, it is possible to deal with changes in the organization and system of the company, addition of management items, etc., without changing the program, only by changing various definition information. In addition, changes can be made only by updating the definition information, such as profit and loss forecasts for organizational changes,
It can also be used for simulation.

[Brief description of drawings]

FIG. 1 is an overall view of a system that executes a counting method according to an embodiment of the present invention.

FIG. 2 is a flowchart showing an operation procedure of this embodiment.

FIG. 3 is a diagram showing a flow of defining an organization and an account item which are basic items.

FIG. 4 is a diagram for explaining a method of defining organization related information.

FIG. 5 is a flowchart showing a method of defining organization related information.

FIG. 6 is a diagram for explaining grouping of account target accounts.

FIG. 7 is a diagram for explaining grouping of account items to be totaled.

FIG. 8 is a diagram for explaining a procedure of defining a total item.

FIG. 9 is a diagram showing an example of form output according to the present embodiment.

[Explanation of symbols]

 1 Processor 11 Organization Master File 12 Account Master File 13 Data File 14 Related Item Master File 15 Summary Item Master File

Claims (1)

[Claims] 1. A tabulation method for tabulating and outputting data that can be expressed in two dimensions, in which key items defined by rows and columns are hierarchically organized and classified. A two-dimensional output that defines a processing procedure that includes an output range and a formula, stores the defined processing procedure in a storage device that is independent of the aggregation processing program, executes the aggregation processing according to the defined processing procedure, and outputs the result. How to aggregate the data.