JPH1196250A - Data summary and display device and storage medium - Google Patents

Abstract

PROBLEM TO BE SOLVED: To facilitate an operation and a processing when contents of summary in a summary table are classified into desired summary items and summed up. SOLUTION: A classification and summary processing of the summary items in a database by executing a data analyzing processing regarding the summary table, reading a specified database record to be processed from the database stored in a storage device 7, setting hierarchal structure to relate the summary items with one another by grouping each summary item set in the database record by every analyzing key item, setting an index key item and a name of a data item to be analyzed in a recording form of the database for analysis to be explained later, simultaneously setting the analyzing key item and calculation item by every group in the recording form of the analyzing key and the calculation item to be explained later, displaying an analyzing browser screen in which selection keys for classification and summary in a line direction and a column direction based on the analyzing key item and simplifying a narrowing operation of the summary items simply by operating the selection keys for classification and summary by a CPU 2.

Description

DETAILED DESCRIPTION OF THE INVENTION

[0001]

[0001] 1. Field of the Invention [0002] The present invention relates to a data tabulation display device for facilitating classification and tabulation of a tabulation table composed of a plurality of item data into desired item data, and a storage medium for storing a processing program therefor.

[0002]

2. Description of the Related Art Conventionally, for example, various application programs such as spreadsheets and databases are used in office computers and general-purpose computers mainly for office work. It is used for

[0003] The tabulation tables of various formats created by using this application program are constructed based on a plurality of item data, and change the description formula in which the tabulation conditions of the item data to be tabulated are set. By doing so, the user can change the tabulated content to a desired classification format.

[0004]

However, in such a summary table created by using such a conventional application program, the description formula in which the summary condition of the item data to be summarized is set is changed. This allows the user to change the contents of the tabulation to the desired format.However, the screen operation until reaching the screen for changing the description formula is complicated, and the description content of the description formula is changed. There was a problem that it was difficult for beginners to understand and change.

[0005] Further, in the conventional tabulation table, since all record data in the database is displayed in a tabular form, in order to instruct classification and tabulation with a desired tabulation item, in addition to the above-mentioned change of the description formula, A plurality of complicated operations, such as calling various sub-windows for designating the classification total item, are required, and there is a problem that it takes time and effort to obtain the classification total result of the desired total item.

SUMMARY OF THE INVENTION It is an object of the present invention to facilitate operations and processes for totalizing the contents of a totaling table into desired totaling items.

[0007]

According to the first aspect of the present invention,
In a data tabulation display device that stores records distinguished by a plurality of key items in a plurality of databases and displays data obtained by classifying and summarizing each record with a key item selected arbitrarily, each record corresponds to each of the key items. Display control means for displaying operation buttons to be operated in the X-axis direction and the Y-axis direction, respectively, and the records are classified and totalized in the X-axis direction by key items designated by operation of the operation buttons in the X-axis direction. Classifying and totaling means for classifying and totaling the records in the Y-axis direction by key items designated by operating the operation buttons in the Y-axis direction, and outputting the respective totalized data.

According to the first aspect of the present invention, records distinguished by a plurality of key items are stored in a plurality of databases, and data obtained by classifying and summarizing each of the records by a arbitrarily selected key item is displayed. In the data totaling display device, the display control means displays operation buttons corresponding to each of the key items in the X-axis direction and the Y-axis direction, respectively, and the classification and totalization means operates the operation buttons in the X-axis direction. The records are classified and totaled in the X-axis direction by the key items specified in the above, and the records are classified and totalized in the Y-axis direction by the key items specified by operating the operation buttons in the Y-axis direction. Output data.

[0009] Therefore, the operation of classifying and totaling a database such as a totaling table in the secondary case direction by an arbitrary key item is as simple as a button operation, and the lower-level totalizing items hierarchized by groups in the database. It is possible to easily perform the classification and tallying process.

According to a fifth aspect of the present invention, there is provided a data totaling display for storing records distinguished by a plurality of key items in a plurality of databases, and displaying data obtained by classifying and totaling these records by arbitrarily selected key items. In the apparatus, display control means for displaying operation buttons corresponding to the respective key items, and classification and aggregation means for classifying and totaling the records by the key items designated by the operation of the operation buttons and outputting aggregated data, It is characterized by having.

According to the fifth aspect of the present invention, records distinguished by a plurality of key items are stored in a plurality of databases, and data obtained by classifying and summarizing each record by a key item arbitrarily selected is displayed. In the data tallying display device, the display control means displays operation buttons corresponding to the respective key items, and the classification and tallying means sorts and totalizes the records according to the key items designated by the operation of the operation buttons, thereby obtaining tally data. Is output.

Therefore, the operation of classifying and totaling a database such as a totaling table in the primary case direction by an arbitrary key item becomes as simple as a button operation. Can be easily performed.

[0013]

Embodiments of the present invention will be described below in detail with reference to the drawings.

FIGS. 1 to 18 show an embodiment of a computer system to which the present invention is applied.

First, the configuration will be described.

FIG. 1 is a block diagram showing a main configuration of a computer system 1 according to the present embodiment. In FIG. 1, the computer system 1 includes a CPU 2, an input device 3, a RAM 4, a display device 5, a printing device 6, a storage device 7, and a storage medium 8, and a storage medium 8
Each part except for is connected to the bus 9.

CPU (Central Processing Unit) 2
Expands an application program specified from a system program stored in the storage device 7 and various application programs corresponding to the system into a program storage area (not shown) in the RAM 6 and is input from the input device 3. Various instructions or data are temporarily stored in the RAM 6, various processings are executed in accordance with the input instructions and the input data according to the application programs stored in the storage device 7, and the processing results are stored in the RAM 6. , On the display device 5. Then, the processing result stored in the RAM 6 is stored in a storage destination in the storage device 7 which is instructed to be input from the input device 3.

The CPU 2 executes a data analysis process relating to a tally table, which will be described later, reads out a specified database record to be processed from the database stored in the storage device 7, and sets each tally item set in this database record. Are grouped by analysis key item, and a hierarchical structure is set to associate the aggregation items. The index key item and the data item name to be analyzed are set in the record format of the analysis database described later. The analysis browser screen in which the analysis key item and the calculation item for each group are set in the record format of the calculation item and the selection buttons for classification and aggregation are arranged in the row direction and the column direction based on the analysis key item is displayed on the display device 5. By simply operating the selection button for classification and aggregation, the operation of narrowing down the aggregation items is simplified, To facilitate the classification aggregation processing of the aggregate field in the database.

The CPU 2 stores the selected state of the key item selected on the analysis browser screen in the selected state table 4a stored in the RAM 4, and stores the selected item data in the extraction condition table 4 stored in the RAM 4.
c to store the data record range to be analyzed, and to store the key item hierarchical designation status of each group in the group hierarchical designation status table 4b stored in the RAM 4.

Further, the CPU 2 executes a group hierarchy display process, which will be described later, based on the contents stored in the extraction condition table 4c so that each key item selected on the analysis browser screen can be identified by group. The hierarchical display frames for each group are displayed on the display device 5 in different colors, and the selection key items stored in the selection state table 4a are highlighted in the hierarchical display frames for each group, and the narrowed-down total items are grouped. Display in a separate hierarchy.

Further, the CPU 2 executes an item arranging process, which will be described later, to determine an arranging method of the database record developed by the data analysis process, and displays a selection screen for selecting an arranging method of the items on the display device 5. Display,
As the item arrangement method, for example, when a horizontal row, a vertical column, or a plurality of rows are selected, the arrangement positions of the database items expanded based on the item arrangement method are set, and all records are expanded. The arrangement direction of the tally item can be easily changed.

The input device 3 includes a cursor key, numeric input keys, various function keys, and the like, and outputs a pressing signal of the pressed key to the CPU 2.

A RAM (Random Access Memory) 4 is a C
The PU2 forms a memory area for expanding various data when the PU2 executes the various application programs, and the selection state table 4 is used as a table used in data analysis processing executed by the CPU2.
a, a group-specific hierarchy designation state table 4b, and an extraction condition table 4c. This selection state table 4
FIG. 2 shows specific examples of a, the group-specific hierarchy designation state table 4b, and the extraction condition table 4c.

FIG. 2A shows a selected state table 4a. The selected state table 4a includes each key item (line direction: x-axis,
Column direction: column direction) is stored. FIG. 4B shows a group-specific hierarchy designation state table 4b. The group-specific hierarchy designation state table 4b shows the number of layers currently selected for each group to which each key item selected on the analysis browser screen corresponds. It is memorized. FIG. 5C shows an extraction condition table 4c.
Each key item selected on the analysis browser screen is stored in a corresponding group.

The display device 5 is a CRT (Cathode Ray Tub).
e) and the like, and displays display data input from the CPU 2. The printing device 6 prints print data (record data of a tabulation table or the like) input from the CPU 2 on predetermined recording paper and outputs the print data.

The storage device 7 has a storage medium 8 in which programs, data and the like are stored in advance, and this storage medium 8 is constituted by a magnetic or optical recording medium or a semiconductor memory. The storage medium 8 is fixedly provided in the storage device 7 or is detachably mounted. The storage medium 8 includes the system program, various application programs corresponding to the system, a data analysis processing program, It stores a slice button processing program, a group hierarchy display processing program, an item arrangement processing program, data processed by each processing program, and the like.

The program, data, and the like stored in the storage medium 8 may be configured to be received and stored from another device connected via a communication line or the like. A storage device having the storage medium may be provided on the other connected device side, and the program and data stored in the storage medium 8 may be used via a communication line.

Further, in the storage medium 8, the analysis key item which is each total item set in the database record to be processed by the data analysis process executed by the CPU 2 is used as an index key item and a data item name to be analyzed. , Are set and stored in the record format of the analysis database shown in FIG. This figure 3
In the record format of the analysis database shown in (a),
As the analysis key items, “item, genre, product, sales office, business partner, year, month, year, month” are set in the index key column, and “sales” is data as the analysis data item name corresponding to the index key item. It is set in the item name column.

Further, the storage medium 8 has the CPU
FIG. 3B shows the analysis key items and their calculation items grouped from the total items set in the database record to be analyzed by the data analysis process executed by the data analysis process 2 in FIG.
Are set and stored in the record format of the analysis key and the calculation item shown in FIG. In the record format of the analysis key and the calculation item shown in FIG. 3B, the grouping branch key items are set in the analysis key column for each hierarchy. The grouping is “item, department, customer, date”, the item analysis group is “item, genre, product”, the department analysis group is “sales office, person in charge”, and the customer analysis group The analysis key items of “business partner” and “date, year and month” are set for each hierarchy in the date analysis group. As calculation items, calculation contents “#Aggregation (), #composition ratio ()” corresponding to “sales, composition ratio” are set in the calculation item column, and the record format of the analysis key and the calculation item is tabulated. And stored in the storage medium 8.

Next, the operation of this embodiment will be described.

First, the data analysis process executed by the CPU 2 will be described with reference to the flowcharts shown in FIGS.

In FIG. 4, first, the CPU 2 causes the display device 5 to display a database designation screen for prompting designation of a database to be subjected to data analysis, and when a database to be subjected to data analysis is designated (step S1). ,
It is determined whether or not an analysis key of a format corresponding to the designated database and a record format table of calculation items are set in the storage medium 8 (step S2). If it is set, the process proceeds to step S4. If not, the setting of the analysis key item grouping and the calculation item are set from the total item set in the designated database, and FIG. ) Is stored in the storage medium 8 as a record format table of the analysis key and the calculation item (step S3).

Next, a selection button corresponding to the number of groups of the analysis key items set in the record format table of the analysis key and the calculation item is displayed on the vertical axis (y
The data is developed in the RAM 4 so as to be arranged on the axis (row direction) and the horizontal axis (x axis: column direction) (step S4). And RA
The 0th hierarchy is set to each of the groups A to D in the group-specific hierarchy designation state table 4b shown in FIG. 2B stored in M4 (step S5).

In step S4, the analysis key item names (item, sales office, business partner, year) of the 0th hierarchy are set to the selection buttons arranged on the vertical axis and the horizontal axis in the analysis browser screen configuration, and the display device 5 Then, an analysis browser screen is displayed (step S6). Next, the data of the calculation item is calculated for all the records in the designated database, that is, the calculation key “sales” set in the record format table of the analysis key and the calculation item shown in FIG. , Composition ratio ”is calculated for all records (step S7) and displayed in a table format on the analysis browser screen (step S8).

FIG. 6 shows an example of the top screen of the analysis browser displayed on the display device 5 by the processing of steps S4 to S8. On the top screen of the analysis browser shown in FIG. 6, each of the selection buttons arranged in the row direction (y-axis) and the column direction (x-axis) has the analysis of the 0th hierarchy grouped from the designated database. Key items "item, sales office, business partner, year" are set,
Calculation items “sales, composition ratio” are displayed in a table format.

Next, it is determined whether or not a row or column selection button is operated on the top screen of the analysis browser shown in FIG. 6 (step S9). When the selection button is operated, the operated row or column direction is determined. The key item set in the column direction selection button is specified as a selection key, and the specified selection key item is stored in the RAM 4 in FIG.
(A) is stored in the selection state table 4a (Step S)
10). Then, the group in the group-specific hierarchy designation state table 4b to which the selected key item corresponds is incremented by +1.
Update (step S11).

The records in the database are classified according to each selection key item specified in step S10 (step S12), the data of the calculation item is calculated according to the classification (step S13), and the analysis browser is displayed in a table form according to the classification. It is displayed on the screen (step S14). FIG. 7 shows an example of an analysis browser screen that displays the results of calculations by classifying records in the database for each of the selection key items. In the analysis browser screen shown in FIG. 7, on the top screen of the analysis browser shown in FIG. 6, the "item" key is selected as a row digging key, a digging process is executed, and "calculator" and "clock" , The results of calculating the “sales” and “composition ratio” by classifying the records for each “” are displayed in a table format.

In the analysis browser screen shown in FIG.
In the analysis browser screen of FIG. 6, “item” is selected as a key to drill down into a row, and as a result, the key to be drilled down in the row is displayed one level down from the 0th layer “item” of the group to which “item” corresponds. The analysis key item "genre" of the first level is displayed as a selection button,
In the in-depth key display area of the row, the “item” selection button is deleted because the “item” selection button on the row side is selected. Also, on the analysis browser screen shown in FIG. 7, item buttons that can be selected and operated are set in each item portion of “calculator” and “clock” displayed in the item column in a table format.

Next, on the analysis browser screen in which the database as shown in FIG. 7 is classified according to the selected digging item and the calculation result is displayed in a table format, the operation of the selection button in the row and column digging key display area Alternatively, it is determined whether or not an item button has been operated in the tabular display area (step S15). When the button is operated,
It is determined whether or not the operated button has been operated to select the analysis key item in the row and column digging key display area (step S16). If the selection button of the analysis key item is operated, the process proceeds to step S18. If the selection button of the analysis key item is not operated and the item button in the table is selected, the selected item data is deleted. The data of the corresponding key item is stored in the extraction condition table 4c of FIG. 2C stored in the RAM 4 (step S17), and the process returns to the button operation determination process of step S15.

When the analysis key item selection button is operated, in step S18, the operated analysis key item button is selected on the selected axis, that is, in step S18.
In the process of 10, it is determined whether or not the selected row side (x axis) or column side (y axis) button stored in the selection state table 4a. If the button of the selected axis has not been operated, the process proceeds to step S27. If the button of the selected axis has been operated, the item data selected by the previous button operation is stored in the extraction condition table 4c. It is checked whether or not it has been performed (step S19). If the selected item data is not stored in the extraction condition table 4c, the process returns to the button operation determination processing in step S15. If the selected item data is stored in the extraction condition table 4c, the operated selection button is the same as the selection key item name of the x-axis or y-axis selection button stored in the selection state table 4a. It is checked whether it is (Step S20).

If the operated selection button is not the same as the selection key item name stored in the selection state table 4a, the process returns to step S10 for specifying the selection key item of the operated selection button. When the operated selection button is the same as the selection key item name stored in the selection state table 4a, it is further determined whether or not the operated selection button is the same axis as the selected axis. Check (step S21). If the operated selection button is not the same axis as the selected axis, the process proceeds to step S26, and if the operated selection button is the same axis as the selected axis, FIG. The analysis key item of the first hierarchy which is the lower hierarchy in the same group set in the analysis key column in the record key table of the analysis key and the calculation item shown in (1) is specified as the selection key item (step S2).
2).

Next, the group in the group-specific hierarchy designation state table 4b to which the selected analysis key item corresponds is updated by +1 (step S23), and the selection state table 4 is selected by the selection key item specified in the processing of step S22.
The content stored in a is updated (step S24). Then, a record range in the database that matches the extraction condition of the selection key item stored in the extraction condition table 4c is specified (step S25), and the process returns to the step S12, and is shown in steps S12 to S14. By performing the above processing, the records in the database are classified according to each selection key item of the specified record range, the data of the calculation item is calculated according to the classification, and the data is calculated in the analysis browser screen in the form of a table according to the classification. indicate. FIG. 8 shows an example of an analysis browser screen that displays the results of sorting and calculating the records in the database for each selected key item in the specified record range.

In the analysis browser screen shown in FIG. 8, in the analysis browser screen shown in FIG. 7, the item "calculator" button in the table format is selected, and the "sales office" key is selected as the row down key, and A case is shown in which the processing is executed, the records are classified into “calculator” and “sales office” as the items, and the results of calculating “sales” and “composition ratio” are displayed in a table format.

On the analysis browser screen shown in FIG.
In the analysis browser screen of FIG. 7, as a result of selecting “sales office” as a drilling key for a row, the “digging office” of the group corresponding to “sales office” is displayed in the drilling key display area of the row.
The analysis key item "person in charge" of the first hierarchy one level lower than the hierarchy "sales office" is displayed as a selection button, and the "sales office" selection button on the column side is selected in the drilling key display area of that column. The "sales office" selection button is deleted. Also, on the analysis browser screen shown in FIG. 8, selectable item buttons are set for each item portion of “Chuo Office” and “Shinjuku Office” displayed in the office field in a table format.

If it is determined in step S21 that the operated selection button is not the same axis as the selected axis, the process proceeds to step S26, where the x-axis (column direction) and the y-axis (row direction) are used. The selection content of the analysis key item whose selection button has been operated is inverted in the axial direction, the selected content of the analysis key item inverted in the axial direction is stored in the selection state table 4a, and the process returns to step S12. By executing the processing shown in steps S12 to S14, the records in the database are classified according to the analysis key items of the x-axis (column direction) and the y-axis (row direction) stored in the selection state table 4a, The calculation item data is calculated for each classification and displayed in the analysis browser screen in a table format for each classification.

The selection contents of the analysis key items whose x-axis (column direction) and y-axis (row direction) selection buttons are operated are inverted in the axis direction, and the analysis key items inverted in the axis direction are stored in the database in the database. FIG. 9 shows an example of an analysis browser screen in which records are classified, calculation item data is calculated for each classification, and the data is displayed in a table format for each classification.

In the analysis browser screen shown in FIG. 9, in the analysis browser screen shown in FIG. 8, the "year" key is selected as a key to drill down into a row, and a drilling process is executed.
The table shows the results of calculating the “sales” and “composition ratio” of the item “calculator” by classifying them by the sales offices “Chuo Office” and “Shinjuku Office” by year and displaying them in a table format.

On the analysis browser screen shown in FIG.
As a result of selecting “year” as the key to drill down in the analysis browser screen of FIG. 8, the key to be drilled down in the row is displayed in the area of the key to be drilled down one layer from the 0th layer “year” of the group to which “year” corresponds. The analysis key item “Year / Month” of the first level is displayed as a selection button, and the “Year” selection button is deleted in the indentation key display area of that row because the “Year” selection button on the column side is selected. You. Also,
In the analysis browser screen shown in FIG. 9, item buttons that can be selected and operated are set for each of the item parts “1995” and “1996” displayed in the year column in a table format.

If the operated button is not the selected axis button in the process of step S18, the process proceeds to step S27, where the analysis key item set in the operated selected button is selected. It is determined whether the selected button is the same as the selected button in the group of the finished axes (x-axis or y-axis). If the analysis key item set for the operated selection button is the same as the group of the selected axis (x-axis or y-axis), the process returns to the button operation determination processing in step S15. If the analysis key item set for the operated selection button is not the same as the group of the selected axis (x-axis or y-axis), the process returns to step S10, and the operation button is set for the operated selection button. The specified analysis key item is specified as a selection key.

Then, the group in the group-specific hierarchy designation state table 4b to which the selected key item corresponds is updated by +1 (step S11), and the records in the database are classified according to each selected key item specified in step S10. (Step S12), the data of the calculation item is calculated for each category (Step S13), and displayed in the analysis browser screen in a table format for each category (Step S1).
4).

As described above, by executing the data analysis processing, the totalization items are grouped as the analysis key items in the database relating to the totalization table, and each analysis key item is set to a hierarchical relationship within the corresponding group. The analysis browser screen in which the grouped analysis key items are set as selection buttons for instructing a drilling process and arranged in the row direction (y-axis) and the column direction (x-axis) is displayed on the display device 5.
, It is possible to simplify the operation of categorizing and summarizing the totals table into arbitrary total items by simply selecting the buttons, and to categorize the lower-level total items organized by group in the database. Aggregation processing can be facilitated.

Next, in the database displayed in a table format in the analysis browser screen by the data analysis processing, a group other than the analysis key items set on the analysis browser screen is designated by a slice button operation (not shown). At this time, the slice button processing executed by the CPU 2 will be described based on the flowchart shown in FIG.

That is, in the data analysis process, the case where records are classified and tabulated in the two-dimensional directions of the x-axis and the y-axis by selecting the analysis key item selection button arranged in the analysis browser screen has been described. In the processing, a case will be described in which records are classified and tabulated in the three-dimensional direction of the z-axis by specifying a group including analysis data not arranged in the analysis browser screen by operating a slice button (not shown).

In FIG. 10, first, the CPU 2 displays an analysis browser screen as shown in FIGS.
When a group including a selection key item other than the selection key item is specified by a slice button operation (not shown) (step S31), a data list of key items included in the specified group is shown in, for example, FIG. A sub-window of such a supplier data list is displayed (step S32). When item data is selected in this sub-window (step S33), the selected item data is stored in the extraction condition table 4 shown in FIG.
It is stored as the data of the corresponding key item in c (step S34). Then, a range of records in the database that matches the extraction condition of each selection item data stored in the extraction condition table 4c is specified (step S35).

After specifying the range of the record, the process proceeds to step S12 in FIG.
By executing the processing shown in step S14, the records in the database are classified for each selected key item in the specified record range, the data of the calculation item is calculated for each classification, and the data is analyzed in a table format for each classification. Display in the browser screen.

Next, the group hierarchy display processing executed by the CPU 2 to display the selected state of the analysis key item selected in the analysis browser screen in the data analysis processing for each group will be described with reference to the flowchart shown in FIG. explain.

In FIG. 12, first, the CPU 2 displays, in red, a selected button among a plurality of selection buttons arranged on the x-axis (in the column direction) on the top screen of the analysis browser shown in FIG. The selected button among the plurality of selection buttons arranged on the y-axis (row direction) is displayed in blue (step S41). Next, the contents (analysis key items) stored in the extraction condition table 4c of FIG. 2C, that is, the contents of the selected analysis key items are shown in FIG.
(Step S42), and the background of the group display frame including the analysis key item set to the button selected on the x-axis in each of the group display frames is displayed in red. Then, the background of the group display frame including the analysis key item set to the selected button on the y-axis is displayed in blue, and the group display frame including the analysis key item set to the other non-selected buttons is displayed. The background is displayed in gray (step S43).

Next, the selection key item portion stored in the selection state table 4a of FIG. 2A is highlighted (step S44), and the selection key item specified in the slice button processing is displayed in yellow. (Step S45), and the group hierarchy display processing ends.

The display frame for each group shown in FIG. 13A shows a case where the contents of the analysis key items stored in the extraction condition table 4c are displayed in four display frames for each of groups 1 to 4. In the group 1 display frame, the analysis key items "item (calculator), genre (),
Product () ”is set, and the analysis key items in Group 1 are not selected, so the background is displayed in gray, and the Group 2 display frame has“ Sales Office (),
"Responsibility ()" is displayed, and since the analysis key item "Sales office ()" in the group 2 is selected on the y-axis side, the background is displayed in blue and the selected key item is highlighted. I have. In the group 3 display frame, “business partner ()” is set as an analysis key item. Since the analysis key item in the group 3 is not selected, the background is displayed in gray and the analysis key item is displayed in the group 4 display frame. "Year (), year, month ()" are displayed as key items, and the analysis key item "Sales office ()" in the group 4 is selected on the x-axis side, so that the background is displayed in red and The selection key item is highlighted.

Then, in the group 3 display frame shown in FIG. 7B, the specified supplier "(company B)" is displayed in yellow as a selection key item after the analysis key item is selected by the slice button. Is shown.

The above-described group hierarchy display processing is repeatedly executed every time a selection key item is selected and a slice button is operated in the data analysis processing.

As described above, by executing the group hierarchy display processing, the group hierarchical position corresponding to the selection key item selected on the analysis browser screen in the data analysis processing is displayed, and the analysis data item is selected. The state can be visually recognized.

Next, the item arrangement process executed by the CPU 2 when changing the item arrangement of the database record displayed in the table format in the analysis browser screen in the data analysis process will be described with reference to the flowchart shown in FIG. I do.

In FIG. 14, first, the CPU 2 displays a selection window for selecting an item arrangement process on the display device 5.
(Step S51). FIG. 15 shows a display example of this selection window. The selection window shown in FIG. 15 shows a case where “display format, rearrangement, warning display, composition ratio, display restriction, item arrangement” is displayed as selectable processing contents.

When "item arrangement" is selected by a mouse click operation in this selection window, an item arrangement window for selecting an item arrangement method shown in FIG. 15 is displayed (step S52). In the item arrangement window shown in FIG. 15, "arrangement in one row, arrangement in one column, arrangement in a plurality of rows" is displayed as an arrangement method of selectable items, and an item number designation frame in one line is displayed. Is shown.

When an item arranging method is selected in the item arranging window, the selected item arranging method is determined (step S53). When "arrange horizontally" is selected as the item arrangement method, the labels of the calculation items in the database are arranged horizontally (step S54), and the total data of the calculation items of each record is arranged below the corresponding label. (Step S55). This horizontal arrangement of the aggregated data is repeatedly executed for all records (step S5).
6) When it is confirmed that the horizontal arrangement of the total data of all the records has been completed, each record in the horizontal arrangement is displayed in a tabular form by enclosing it in a bold frame line (step S65), and this item arrangement processing ends. I do.

As the item arrangement method, "arrange in a horizontal line"
FIG. 18 shows a display example of the database when is selected.

When "arrange vertically" is selected as the item arrangement method, the labels of the calculation items in the database are arranged vertically (step S57), and the totalized data of the calculation items of each record corresponds. The labels are arranged vertically next to the labels (step S58). This vertical arrangement of the total data is repeatedly executed for all the records (step S59), and when it is confirmed that the vertical arrangement of the total data of all the records is completed, each record in the vertical arrangement is enclosed in a thick frame line in a table format. Is displayed (step S65), and this item arrangement processing ends.

As an item arrangement method, “arrange vertically”
FIG. 16 shows a display example of the database when is selected.

When "arrange in multiple lines" is selected as the item arrangement method, the number of items to be arranged in one line is designated in the item arrangement window shown in FIG. The number of rows in which the aggregate data is expanded is specified based on the number of items to be arranged (step S61). Then, the labels of the calculation items in the database are arranged in a plurality of rows and a plurality of columns based on the specified number of rows (step S6).
2), the total data of the calculation items of each record are arranged in a plurality of rows and a plurality of columns at the positions of the corresponding labels (step S6).
3). The array of plural rows and plural columns of the total data is repeatedly executed for all records (step S64). When it is confirmed that the arrangement of plural lines and plural columns of the total data of all records is completed, the plural rows and plural columns are confirmed. Are displayed in a tabular form with each record arranged in a tabular form (step S65), and the item arrangement processing ends.

As the item arranging method, "arrange in plural lines"
FIG. 17 shows a display example of the database when is selected.

As described above, by executing the item arrangement processing, it is easy to rearrange the classification and aggregation results of the database displayed in a table format on the analysis browser screen in the data analysis processing in an arbitrary item arrangement form. Will be able to

As described above, in the computer system 1 of the present embodiment, in the database relating to the summary table, the summary items are grouped as the analysis key items, and each analysis key item is set to a hierarchical relationship within the corresponding group. Then, the grouped analysis key items are set as selection buttons for instructing the digging process, and the row direction (y-axis) is set.
And the analysis browser screen arranged in the column direction (x-axis) is displayed on the display device 5, so that the operation of classifying and summarizing the summary table into an arbitrary summary item is as simple as the operation of the select button, and the database can be easily displayed. It is possible to easily perform the classification and summarization process to the summation items of the lower hierarchy hierarchized by group.

Therefore, the classification and totaling process of the database based on the desired total item which conventionally required the change of the description formula describing the classification condition and the complicated window operation can be executed with only a simple button operation. Therefore, it is possible to reduce the user's labor and time required for the classification and aggregation process.

Further, in the computer system 1 of the present embodiment, by executing the above-mentioned slice button processing, it is possible to specify a group including analysis data which is not arranged in the analysis browser screen, and the z-axis Records can be easily classified and tabulated in three-dimensional directions.

Further, in the computer system 1 of the present embodiment, by executing the group hierarchy display processing, the group hierarchical position corresponding to the selection key item selected on the analysis browser screen in the data analysis processing is displayed. Thus, the selection state of the analysis data item can be visually recognized.

In the above data analysis processing, when the same analysis key item is designated on the other axis with respect to the analysis key item designated by the selection button arranged on the x-axis or the y-axis, Since the analysis key items specified by the x-axis and the y-axis are exchanged, and records can be classified and totalized by the exchanged analysis key items, selection corresponding to the analysis key items arranged in the secondary case is performed. The axis direction for sorting and totaling can be easily changed and designated simply by operating a button.

Further, in the computer system 1 of the present embodiment, by executing the item arrangement processing,
In the data analysis process, it is possible to easily rearrange the classification / aggregation result of the database displayed in the table format on the analysis browser screen in an arbitrary item arrangement form.

[0079]

According to the data tabulation display device of the first aspect of the present invention, the operation of classifying and tabulating a database such as a tabulation table in the secondary case direction by an arbitrary key item is as simple as a button operation. In addition, it is possible to easily perform a classification and totalizing process on the total items of the lower hierarchy hierarchized by groups in the database.

According to the data totaling and displaying apparatus of the second aspect of the present invention, it is possible to specify a group including key items that are not displayed, and it is easy to sort and totalize records in three-dimensional directions.

According to the third aspect of the present invention, it is possible to confirm the selection state of the specified key item.

According to the data totaling display device of the fourth aspect of the present invention, it is possible to easily change the axis direction for classification and totaling by simply operating the selection button corresponding to the key item arranged in the secondary case. it can.

According to the data tabulation display device of the fifth aspect of the present invention, the operation of classifying and tabulating a database such as a tabulation table in the primary case direction by an arbitrary key item is as simple as a button operation. , It is possible to easily perform a classification and totalizing process on the total items of the lower hierarchy hierarchized by groups.

According to the data totaling and displaying apparatus of the present invention, it is possible to easily designate the key items classified by hierarchy only by operating the same button, and to specify the key items within the same division. It is possible to easily execute the process of classifying and summarizing the database by drilling down.

According to the data totaling and displaying apparatus of the present invention, it is possible to confirm the operation state of the key item of the lower hierarchy in the same section on the operation button.

According to the data tabulation display device of the present invention, it is possible to easily perform a process of further subdividing the tabulated data, which has been classified and tabulated by a predetermined key item, by specifying key items of different categories. Can be.

According to the data totaling and displaying apparatus of the ninth aspect, the database can be classified and totalized from a plurality of item data.

According to the data tabulation display device of the invention according to the tenth and eleventh aspects, when the tabulated data is output in the form of a table with each specified item data as a heading, the arrangement form of each item data Can be specified and output in a table format.

According to the storage medium of the twelfth aspect of the present invention, when a database such as a tabulation table is classified and tabulated in the secondary case direction by an arbitrary key item, only button operation is performed, and the database is hierarchized for each group. A computer can be executed by a computer for facilitating the classification and totalizing process into the totalized items of the lower hierarchy.

According to the storage medium of the thirteenth aspect of the present invention, when a database such as a tabulation table is classified and tabulated in the primary case direction by an arbitrary key item, only a button operation is performed, and the database is hierarchized for each group. A program can be executed by a computer for facilitating the classification and summarizing process into the summed items of the lower hierarchy.

[Brief description of the drawings]

FIG. 1 is a block diagram illustrating a main configuration of a computer system 1 according to an embodiment of the present invention.

FIGS. 2A and 2B are diagrams showing various tables stored in a RAM 4 of FIG. 1; FIG. 2A is a diagram showing a selection status table 4a; FIG. 2B is a diagram showing a group-specific hierarchy designation status table 4b; () Is a diagram showing an extraction condition table 4c.

3A and 3B are diagrams showing a record format set in a storage medium 8 of FIG. 1, wherein FIG. 3A shows a record format of an analysis database, and FIG. 3B shows a record format of an analysis key and a calculation item. FIG.

FIG. 4 is a flowchart showing a part of a data analysis process executed by a CPU 2 of FIG. 1;

FIG. 5 is a flowchart showing a part of the data analysis process following FIG. 4;

6 is a diagram showing a top screen of an analysis browser displayed on a display device 5 in the data analysis processing of FIG.

FIG. 7 is a diagram showing an analysis browser screen displayed on the display device 5 after an in-depth “item” in the row direction is executed on the top screen of the analysis browser of FIG. 6;

8 is a diagram showing an analysis browser screen displayed on the display device 5 after the “calculator” and the “sales office” in the row direction have been dug down in the analysis browser screen of FIG. 7;

9 is a diagram showing the analysis browser screen displayed on the display device 5 after the drilling down by the “year” in the column direction is performed on the analysis browser screen of FIG. 8;

FIG. 10 is a flowchart showing a slice button process executed by a CPU 2 of FIG. 1;

11 is a diagram showing a supplier data sub-window displayed on the display device 5 by the slice button processing of FIG.

FIG. 12 is a flowchart showing a group hierarchy display process executed by the CPU 2 of FIG. 1;

13A and 13B are diagrams showing display contents displayed on the display device 5 by the group hierarchy display process of FIG. 12, wherein FIG. 13A shows a group hierarchy display, and FIG. 13B shows a display after a slice button is selected. FIG.

FIG. 14 is a flowchart showing an item arrangement process executed by the CPU 2 of FIG. 1;

15 is a diagram showing a display format and an item arrangement method selection screen displayed on the display device 5 by the item arrangement processing of FIG.

16 is a diagram showing an example of a database record displayed on the display device 5 when one vertical column is selected by the item arrangement processing of FIG. 14;

17 is a diagram showing an example of a database record displayed on the display device 5 when a plurality of rows are selected by the item arrangement processing of FIG.

18 is a diagram illustrating an example of a database record displayed on the display device 5 when one horizontal row is selected by the item arrangement processing of FIG. 14;

[Explanation of symbols]

 DESCRIPTION OF SYMBOLS 1 Computer system 2 CPU 3 Input device 4 RAM 4a Selection status table 4b Hierarchy designation status table by group 4c Extraction condition table 5 Display device 6 Printing device 7 Storage device 8 Storage medium 9 Bus

Claims (13)

[Claims] 1. A data totaling and displaying apparatus for storing records distinguished by a plurality of key items in a plurality of databases and displaying data obtained by classifying and totaling the records with a key item selected arbitrarily. Display control means for displaying operation buttons corresponding to the respective items in the X-axis direction and the Y-axis direction; and the record is classified in the X-axis direction by key items designated by operation of the operation buttons in the X-axis direction. Classifying and totaling means for totalizing, classifying and totaling the records in the Y-axis direction by a key item designated by operating the operation button in the Y-axis direction, and outputting the respective totalized data. Data aggregation and display device. 2. The display control means further displays a key item designation button for designating another key item not designated by each of the operation buttons displayed in the X-axis direction and the Y-axis direction. When a key item is designated by the key item designation means, the records are classified and counted in the X-axis direction and the Y-axis direction within the range of the record including the item data corresponding to the key item. 2. The data totaling display device according to claim 1, wherein the totalizing result is output. 3. The apparatus according to claim 1, wherein said display control means displays each of said plurality of key items and identifies key items designated in said X-axis direction and Y-axis direction.
Alternatively, the data totaling display device according to 2. 4. When an operation button corresponding to a key item specified by the other axis is operated on one of the X axis and the Y axis, the classification and counting means is configured to execute the X axis operation. And Y
A key item designated by an axis is exchanged, the records are classified and counted in the X-axis direction and the Y-axis direction by the exchanged key item, and a result of the aggregation is output. 2. The data totaling display device according to 1. 5. A data totaling display device which stores records distinguished by a plurality of key items in a plurality of databases, and displays data obtained by classifying and totaling the records by a key item arbitrarily selected. Display control means for displaying an operation button corresponding to the item; and classification and aggregation means for classifying and totaling the records by a key item designated by operation of the operation button and outputting aggregated data, Data aggregation display device. 6. At least one key item among the key items includes a plurality of classification key items that are divided in a hierarchy, and the display control means includes an operation button corresponding to the key item including the classification key item. When the operation button corresponding to the key item is further operated in a state where the key item including the classification key item is designated, the classification and aggregation means 6. The data totaling display device according to claim 5, wherein a classification key item of a lower hierarchy than the first hierarchy is designated, and the records are classified and totalized by the key item of the lower hierarchy to output total data. 7. The display control means, when displaying the totalized data classified and totalized for the record by the key item of the lower hierarchy by the classification and totalization means, the operation button corresponding to the key item of the lower hierarchy. 7. The data totaling display device according to claim 6, wherein the key item name of the lower hierarchy is displayed. 8. The grouping and summarizing means selects desired item data from the key items included in the specified grouped items of the grouped data displayed by being classified and summed up by the designated key item, and When an operation button corresponding to a key item in a section different from the key item is further operated, the key item designated by the further operated operation button is set as a new key item and includes the selected item data. 6. The data totaling display device according to claim 5, wherein a range of the record is specified, and totalized data classified and totaled by a newly designated key item within the range of the record is output. 9. The item data to be classified and tabulated is:
6. A plurality of arbitrarily specified item data, wherein the classification and tabulation means outputs respective tabulated data obtained by classifying and totaling the records according to the arbitrarily specified plural item data. Data aggregation display device as described. 10. When outputting the tabulated data in the form of a table with each item data designated by the classification and tabulation means as a heading, an array form designating means for arbitrarily specifying the arrangement form of each item data is further provided. 10. The totalized data is output in a table format with each item data as a heading according to the designated arrangement form.
Data aggregation display device as described. 11. An arrangement form designated by the arrangement form designation means may be a horizontal one line arrangement or a vertical one line arrangement,
Alternatively, a plurality of rows are arranged, and by selecting any one of the arrangement forms, the classification and aggregation means outputs the total data in the form of a table using the item data as a heading in the selected arrangement form. Claim 1.
0. A data tally display device. 12. A storage medium storing a computer-executable program, wherein an operation button corresponding to each of a plurality of key items for distinguishing records stored in a plurality of databases is arranged in an X-axis direction and a Y-axis direction. The records are classified and counted in the X-axis direction by a computer-executable program code for displaying the respective records, and key items designated by operating the X-axis operation buttons. A computer-executable program code for classifying and summarizing the records in the Y-axis direction by a key item designated by operation of an operation button, and outputting the summed data; and storing a program including: Storage media. 13. A storage medium storing a computer-executable program, wherein an operation button corresponding to each of a plurality of key items for distinguishing records stored in a plurality of databases is arranged in an X-axis direction and a Y-axis direction. A computer-executable program code for displaying each of the records, and a computer-executable program code for classifying and totaling the records by a key item designated by operating the operation button and outputting the aggregated data. A storage medium storing a program including: