JP2001282818A - Business application data analysis system - Google Patents

Abstract

PROBLEM TO BE SOLVED: To provide a business application data analysis system that enables a business application system analyst to specify and select any item when the system analyst extracts data from files used by business applications. SOLUTION: The business application data analysis system has an accumulation file 4 that stores data for business applications, an input device that enters each analytical index of the business applications to the system, an analytical parameter file 7 that stores the analytical indices, an analyzer 8 that retrieves data from the accumulation file according to each item of the analytical indices, and a common house keeping file 5 that replaces the business application files and the file 5 is referenced by the analyzer.

Description

DETAILED DESCRIPTION OF THE INVENTION

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to a business data analyzer for extracting and analyzing data from a file used by a business system.

[0002]

2. Description of the Related Art As a core business system of a company, there are various business systems such as an accounting system, a sales system, and a salary system. For example, each business system owns various files, such as various files such as a product data file, a sales data file, and a billing data file in a sales system.

[0003] An analysis system such as an accounting analysis system or a sales analysis system is provided for each business system so that data trends in each business system can be investigated.

[0004] Here, the conventional analysis method is a method for performing analysis items prepared in advance. In the case of accounting analysis, a data analysis method with a limited range such as in an accounting system is adopted. As for the analysis contents, no complicated analysis such as processing data or adding conditions is performed. In addition, it generally does not have a function of storing analysis results.

[0005]

The above-mentioned conventional analysis method is performed only on the analysis items prepared in advance, so that the required results are limited. Also,
Since the analysis is performed within a limited range, only a data comparative analysis can be performed. Further, since the analysis results are not stored, the same analysis must be performed from the beginning to recall the analysis result once.

SUMMARY OF THE INVENTION It is an object of the present invention to provide a business-related data analysis apparatus having a function that enables a person who intends to analyze a certain business-related system to freely select and set items. is there.

It is another object of the present invention to provide a business data analysis apparatus having a function of managing analysis results as a history.

It is another object of the present invention to provide an apparatus for extracting and analyzing business-related data in which the analysis of a certain business-related system reflects a trend in another business-related system so that a more detailed analysis can be performed. .

[0009]

In order to achieve the above object, a business data analyzer according to the present invention comprises: a totaling target file for storing data of various business systems; An input processing means for inputting items by including the various business systems as targets, an analysis parameter file storing the input analysis indices, and searching the aggregation target file according to each item of the analysis indices, It is characterized by comprising analysis means for analyzing, and a management common file for replacing the various business-related files in common, which is referred to by the analysis means.

With this configuration, it is possible to freely set and select items used for the data analysis processing.

In order to achieve the above object, the business data analysis apparatus according to the present invention includes: a file to be compiled for storing data of various business systems; An input processing means for inputting by including the business system as an object, and an analysis parameter file for storing each item of the input analysis index,
Among the input analysis index items, an extraction parameter file storing extraction parameters for extracting data from the aggregation target file, and searching the aggregation target file according to the extraction parameters, and extracting data of the corresponding item Extraction processing means, a file for commonly replacing the various business files, a management common file referred to by the extraction processing means, an analysis index stored in the analysis parameter file, and the extraction processing means. Analyzing means for searching and analyzing the totaling target file based on the extracted data.

[0012] With this configuration, the analysis process and the data extraction process can be linked with each other, so that a deeper analysis that cannot be found in a conventional analysis system can be performed.

Further, the business data analyzing apparatus according to the present invention is a history file for storing the analysis result of the analyzing means, and a history display for displaying the history list by referring to the history file in response to a history reference command. Means. As a result, past analysis results can be managed.

Further, in the business data analysis apparatus according to the present invention, when there is a reference command for an item selected on the history list display screen, a history result display for extracting and displaying the analysis result of the item from the history file. Means. This makes it possible to prevent duplicate analysis of the same content.

Further, the business data analyzer according to the present invention, when a correction command is issued for an item selected on the history list display screen, retrieves the analysis result of the item from the history file and displays the result. Is stored in the analysis parameter file. As a result, complicated analysis such as adding or processing data can be performed.

Further, in the business data analysis apparatus according to the present invention, the analysis index may be stored in advance in the analysis parameter file. Thereby, the efficiency of the input processing can be improved.

[0017]

BRIEF DESCRIPTION OF THE DRAWINGS FIG.
This will be described with reference to FIG. FIG. 1 is a block diagram showing the configuration of a business data extraction / analysis apparatus according to an embodiment of the present invention.

In FIG. 1, the business data extraction / analysis apparatus according to the present embodiment includes an input processing unit 1 in which a user inputs each item of an analysis index according to an instruction on a display screen of a display unit 10.
And an extraction parameter file 2 storing condition items (extraction parameters) for extracting data from the tallying target file 4 among the analysis index items input from the input processing unit 1. Start by instructions,
An extraction processing unit 2 that extracts data from the tallying target file 4 and the management common file 5 according to the condition items read from the extraction parameter file 3, and an extraction result file 6 that stores the data extracted by the extraction processing unit 3 Have.

Further, the business-related data extraction / analysis apparatus of the present embodiment is referred to when inputting necessary information in the input processing unit 1 and each item of the analysis index (from the input processing unit 1). The analysis parameter file 7 in which the analysis parameters are stored, and an extraction result file 6 and an analysis parameter file 7 which are activated by an instruction from the extraction processing unit 3
According to the contents, the analysis processing unit 8 extracts data from the tallying target file 4 and performs analysis, and displays the analysis result on the display screen of the display unit 10. The analysis result of the analysis processing unit 8 is stored. And an analysis result history file 9 to be referred to.

The tallying target file 4 includes not only a file of a specific business system but also a file of another business system related to an item to be analyzed. The management common file 5 is a file that manages such common items across the files of a plurality of business systems and enables the files of each business system in the aggregation target file 4 to be searched in the same manner. is there.

FIG. 2 shows an example of the configuration of the management common file. As shown in FIG. 2, for example, "company code", "organization code", "department code", and "customer code" are common items.
Are listed. On the other hand, the common code is defined as “001000” in “company code”, “000100” in “organization code”, and “department code”
, "000010" is defined in the "customer code", and "100010" is defined in the "customer code".

On the other hand, FIG. 2 shows that the business system in the tallying target file 4 includes an accounting system, a salary system, and a sales system.
For example, “company code” is “001” in the accounting system.
0 "," 90 "in the salary system, and" 0001 "in the sales system. In this case, by using the common code" 001000 ", the" company code "in the three systems can be easily searched. Become.

Next, input processing, extraction processing, and analysis processing according to the present embodiment will be described with reference to FIGS.

<Input Processing> FIG. 3 is a flowchart showing the operation of the input processing unit 1. FIG. 4 is a display example of the analysis index input screen. In the input processing, first, the user displays an analysis index input screen 11 on the display screen of the display unit 10 (step S1). As shown in FIG. 4, on the input screen 11 for the analysis index, input items of the analysis name 12, the analysis range 13, the analysis item 14, the analysis condition 15, the execution button 16
And a history reference button 17 are displayed.

At the time of inputting each item, the user can refer to the past history by pressing the history reference button 17 in order to avoid duplicate analysis (step S2). The reference to the past history will be described later.

The user inputs each item on the analysis index input screen 11 shown in FIG. 4 (step S3). The input of each item is not particularly limited, and any index to be analyzed can be input at the user's discretion.

For example, as the analysis name 12, “A special sales amount by year (increase rate 15% or more)” is input. As analysis range 13, accounting system: subject master: accounts receivable: 0
0/00/00 to 99/99/99 (all year), Accounting system: Subject master: Accounts payable: 00/00/00 to 99
/ 99/99 (all year), Accounting system: Department master:
1100 to 1100 (customer A), sales system: transfer data: 000000 to 999999 (all year), sales system: customer data: 1101001 to 1101
001 (customer A). “Sales profit” is input as the analysis item 14. As analysis condition 15, "increase rate 1
5% or more. "

When the user completes the input of each item and presses the execute button 16, a new record is created in the analysis parameter file 7 and the above input items are stored (step S4). A new record is created, the condition items among the above input items are stored (step S5), and the extraction processing unit 3 is started.

As shown in FIG. 6, in the analysis parameter file 7, the input date "xxxx", the analysis number "1", the analysis name "sales by ...", the analysis item 1 "sales", .. Are stored. In the extraction parameter file 2, as shown in FIG. 7, the input date "xxx" and the condition No.
"1", condition item 1 "section A", condition item 2 "section B", and so on.

On the other hand, if the user presses the history reference button 17 before inputting each item as described above (step S
2), a list of analysis results as shown in FIG. 5 is read from the analysis result history file 9 and displayed on the display screen of the display unit 10 (step S6). In the analysis result list screen 21,
As illustrated in FIG. 5, a history of past analysis results is displayed in each column of “input date”, “analysis name”, “analysis range”, “analysis item”, and “analysis condition”. The analysis result list screen 21 includes an execution button 16, an analysis result reference button 17, a correction button 18, and a cancel button 1.
Nine buttons are displayed.

In this analysis result list screen, when a certain analysis index is selected and the correction button 18 is pressed (step S
7) Returning to the initial input screen 11 shown in FIG. 4, the analysis information of the analysis index selected on the analysis result list screen 21 is read from the analysis result history file 9 and displayed on the input screen 11. .

Thus, the user uses the history of the analysis information such as inputting the contents of all items or the corresponding items, and partially adding / changing / deleting the relevant items on the input screen 11 for displaying the selected analysis index. Can be corrected (step S3). By pressing the execution button 16, the contents of the correction are captured (steps S4 and S5).

When the cancel button 19 is pressed on the analysis result list screen 21, the screen returns to the initial input screen 11 shown in FIG. 4, but when an analysis index is selected and the analysis result reference button 17 is pressed (step S8, step S8). S9) The past analysis result of the selected analysis index is read from the analysis result history file 9 and displayed on the display screen of the display unit 10 (step S10). This allows the user to avoid duplicate analysis.

Since analysis indices can be registered in the analysis parameter file 7 in advance, it is possible to take measures such as increasing the efficiency of input processing of analysis indices.

<Extraction Processing> FIG. 8 is a flowchart showing the operation of the extraction processing unit 3. In FIG. 8, the analysis conditions are read from the extraction parameter file 2 (step S20), and the contents of the analysis range are extracted from the tallying target file 4 accordingly (step S21). For example, "a
When a condition such as “the item b of the section b is 15% or more” is input, data is extracted in accordance with the condition. The extraction result is temporarily stored in the extraction result file 6 (Step S22). At this time, extraction from data between different systems is also performed based on the information of the management common file illustrated in FIG.

<Analysis Processing> FIG. 4 is a flowchart showing the operation of the analysis processing unit 8. FIG. 10 is an explanatory diagram of the storing operation in the analysis result history file 9. 9, each item of the analysis index is read from the analysis parameter file 7 (step S30), and the extraction result is read from the extraction result file 6 (step S31). Next, data analysis (totaling) of the extraction results read from the extraction result file 6 is performed according to the analysis index items read from the analysis parameter file 7 (step S32). For example, the “increase in sales profit for customer A” is calculated according to the analysis item of the analysis index and the contents of the analysis conditions.

The analysis result is displayed on the display screen of the display unit 10 (step S33). For example, as shown in the upper part of FIG. 10, a list of the analysis results in which the sales of the department A are displayed every month is displayed.

The analysis result is stored in the analysis result history file 9 (step S34). As shown in the lower part of FIG. 10, the analysis result history file 9 includes the input date “xx
Xx ", analysis No." 1 ", analysis name" by sales ", analysis item 1" section A ", and so on. This makes it possible to manage the analysis result as past analysis information. Analysis results managed as history
As described above, it is possible to redisplay by selecting the analysis result reference on the input screen 11.

As described above, the present invention is not limited to the above embodiment, and various modifications are possible. For example,
A configuration in which the extraction process is omitted can also be adopted. In this case, the management processing file 8 refers to the management common file 5.

[0040]

As described above, according to the present invention,
Since the items used for the data analysis process can be freely set and selected, a wide range of analysis can be performed regardless of the system.

Further, since it has a function of managing the analysis information / analysis result as a history, it is possible to prevent duplicate output of the same content, and the analysis efficiency is improved.

Further, by linking the analysis processing with the data extraction processing, it is possible to perform a deeper analysis which is not found in the conventional analysis system.

[Brief description of the drawings]

FIG. 1 is a block diagram showing the configuration of an embodiment of an apparatus for extracting and analyzing business data according to the present invention.

FIG. 2 is an explanatory diagram showing a configuration example of a management common file.

FIG. 3 is a flowchart illustrating an operation of an input processing unit.

FIG. 4 is an explanatory diagram showing a display example of an analysis index input screen.

FIG. 5 is an explanatory diagram showing a display example of an analysis history list.

FIG. 6 is an explanatory diagram of a storing operation in an analysis parameter file.

FIG. 7 is an explanatory diagram of an operation of storing in an extraction parameter file.

FIG. 8 is a flowchart illustrating an operation of an extraction processing unit.

FIG. 9 is a flowchart showing the operation of the analysis processing unit.

FIG. 10 is an explanatory diagram of an operation of storing in an analysis history result file.

[Explanation of symbols]

 DESCRIPTION OF SYMBOLS 1 Input processing part 2 Extraction parameter file 3 Extraction processing part 4 Total file 5 Management common file 6 Extraction result file 7 Analysis parameter file 8 Analysis processing part 9 Analysis result history file 10 Display part 11 Input screen

Claims (6)

[Claims] An input processing means for inputting a file to be collected for storing data of various business systems, an analysis index relating to the business in each of the business systems, and An analysis parameter file for storing the analysis indices obtained, an analysis means for searching and analyzing the file to be counted according to each item of the analysis indices, and a file for commonly replacing the various business-related files, An analysis apparatus for business-related data, comprising: a management common file referred to by an analysis unit. 2. An aggregation processing file for storing data of various business systems, input processing means for inputting each item of an analysis index relating to the business with the various business systems included, and An analysis parameter file storing each item of the obtained analysis index; an extraction parameter file storing an extraction parameter for extracting data from the totaling target file among the input analysis index items; Extraction processing means for searching for the aggregation target file in accordance with the above, and extracting data of a corresponding item; a management common file which is a file for commonly replacing the various business-related files and which the extraction processing means refers to; Based on the analysis index stored in the analysis parameter file and the data extracted by the extraction processing means, An analysis device for business-related data, comprising: analysis means for searching and analyzing a file to be aggregated. 3. The business data analyzing apparatus according to claim 1, wherein a history file storing an analysis result of the analysis unit is referred to, and the history file is referred to in response to a history reference command. A history display means for displaying a history list, comprising: a business data analysis apparatus; 4. The business data analysis apparatus according to claim 3, wherein when there is a reference command for an item selected on the history list display screen, an analysis result of the item is taken out from the history file and displayed. An analysis device for business-related data, comprising: history result display means. 5. The business data analysis apparatus according to claim 3, wherein when a correction command is issued for an item selected on the history list display screen, an analysis result of the item is read from the history file. And a modification permitting unit for taking out and displaying the modification result and storing the modification result in the analysis parameter file. 6. The business data analysis apparatus according to claim 1, wherein an analysis index is stored in the analysis parameter file in advance. Data analysis equipment.