Multi-dimensional business index management system for aeronautical manufacturing enterprises

Abstract

The invention discloses an aeronautical manufacturing enterprise-oriented multi-dimensional business index management system, which comprises a data source management module for managing data source information required by the multi-dimensional business index management system and executing data source connection and data acquisition; the business domain management module is used for setting business domains, business classifications, index sources and index classification information of to-be-managed indexes; the calculation dimension management module is used for maintaining and performing mutual exclusion group management on each calculation dimension; the index calculation model configuration module is used for configuring a business domain, business classification, an index source, index classification, calculation parameters, a calculation formula, calculation frequency and calculation dimension of an index to be maintained; and the automatic calculation module is used for calculating an index result according to the content configured by the index calculation model configuration module and the calculation frequency. According to the method, the problems of complex flow, large workload, extremely low index calculation and utilization efficiency and the like of the existing calculation mode of the business indexes in the aeronautical manufacturing enterprise are solved.

Description

Technical Field

[0001] This invention relates to, but is not limited to, the field of aerospace manufacturing technology, and in particular to a multi-dimensional business indicator management system for aerospace manufacturing enterprises. Background Technology

[0002] Large aerospace manufacturing companies need to regularly calculate key performance indicators (KPIs) across various business areas during their operations. These KPIs reflect the company's production and operational status and are of great reference value.

[0003] Currently, the calculation of various business indicators in aerospace manufacturing enterprises relies on manually exporting data and then using Excel for calculations, which does not support automatic data acquisition and calculation. Furthermore, due to the numerous departmental levels and complex indicator systems within aerospace manufacturing enterprises, it is often necessary for each sub-department to calculate a specific indicator using the same calculation method after a task is assigned by a higher-level department. The sub-departments then report their results, which are then aggregated and recalculated by the higher-level department before being reported again. This method of calculating business indicators is complex, labor-intensive, and extremely inefficient in terms of indicator calculation and utilization.

[0004] Therefore, a system that can automatically acquire data sources and automatically calculate indicators based on built-in calculation rules is needed to address the aforementioned shortcomings of existing technologies. Summary of the Invention

[0005] The purpose of this invention is to provide a multi-dimensional business indicator management system for aerospace manufacturing enterprises, in order to solve the problems of complex processes, large workload, and extremely low efficiency in indicator calculation and utilization in the existing calculation methods of business indicators in aerospace manufacturing enterprises.

[0006] The technical solution of this invention is as follows: This embodiment of the invention provides a multi-dimensional business indicator management system for aerospace manufacturing enterprises, including the following steps: The data source management module is used to manage the data source information required by the multi-dimensional business indicator management system, and to perform connection to the data source and data acquisition based on the data source information; The business domain management module is used to set the business domain, business category, indicator source, and indicator category information of the indicators to be managed, serving as a basic management item for subsequent indicator management. The Calculation Dimension Management module is used to maintain calculation dimension information and manage mutual exclusion groups for each calculation dimension. This ensures that calculation dimensions within the same mutual exclusion group cannot be selected simultaneously when calculating metrics. The indicator calculation model configuration module, which is connected to the data source management module, business domain management module, and calculation dimension management module respectively, is used to configure the business domain, business category, indicator source, indicator category, calculation parameters, calculation formula, calculation frequency, and calculation dimension of the indicator to be maintained. The automatic indicator calculation module is connected to the indicator calculation model configuration module and is used to calculate the indicator results according to the calculation frequency based on the content configured in the indicator calculation model configuration module.

[0007] Optionally, in the multi-dimensional business indicator management system for aerospace manufacturing enterprises as described above, the data source management module performs connection to the data source and data acquisition based on the data source information, including: The data source management module is used to obtain the data source information to be managed based on user input, including: the database type corresponding to each business system, the address, username, and password of each database; The data source management module is also used to establish connections with each database based on the data source information, and to obtain data from each database through the connections.

[0008] Optionally, in the multi-dimensional business indicator management system for aerospace manufacturing enterprises as described above, The data source management module is also used to configure data filtering conditions for each database. During the process of obtaining data from the database, the obtained data is filtered according to the configured data filtering conditions, and the filtered data to be calculated is output.

[0009] Optionally, in the multi-dimensional business indicator management system for aviation manufacturing enterprises as described above, the calculation dimension information maintained by the calculation dimension management module includes the calculation dimensions of aircraft and organizational structure. The calculation dimensions for aircraft include: aircraft type, model, and number of sorties belonging to the same mutually exclusive group; The computational dimensions of an organization include the computational dimensions corresponding to each level belonging to the same mutually exclusive group.

[0010] Optionally, in the multi-dimensional business indicator management system for aerospace manufacturing enterprises as described above, The computation dimension management module is also used to configure mutual exclusion levels for each computation dimension belonging to the same mutual exclusion group, wherein the mutual exclusion level indicates the hierarchical level of the corresponding computation dimension in the mutual exclusion group.

[0011] Optionally, in the multi-dimensional business indicator management system for aerospace manufacturing enterprises as described above, The calculation parameters configured in the indicator calculation model configuration module include manual parameters and automatic parameters; The indicator calculation model configuration module configures the calculation parameters for addition, subtraction, multiplication, and division by configuring the calculation formula, and supports the use of parentheses to intervene in the calculation order of the calculation parameters; The indicator calculation model configuration module uses the calculation frequency to represent the calculation time and data time range of the indicator; the calculation time is divided into year, half-year, quarter, month, and day; the data time range is divided into current period and cumulative cases. When configuring calculation parameters, the indicator calculation model configuration module selects whether to associate calculation dimensions. If associated, the calculation parameter is calculated according to each associated calculation dimension. If not associated, the data corresponding to the calculation parameter is calculated directly. The calculation dimension is used to determine the data range of the indicator to be maintained, and the source of the calculation dimension is the calculation dimension management module.

[0012] Optionally, in the multi-dimensional business indicator management system for aerospace manufacturing enterprises as described above, Each metric to be maintained has one or more calculation dimensions, and each calculation dimension has one or more calculation frequencies.

[0013] Optionally, in the multi-dimensional business indicator management system for aerospace manufacturing enterprises described above, the automatic indicator calculation module calculates the indicators in the following way: The automatic indicator calculation module runs once a day. For each indicator, it iterates through the list of calculation dimensions; for each calculation dimension, it iterates through the corresponding calculation frequency; it compares the calculation frequency information with the current date, and skips the calculation if the calculation time has not yet arrived; if the calculation time has arrived, it calculates the calculation dimension corresponding to the calculation frequency, and iterates through all indicators to calculate.

[0014] Optionally, in the multi-dimensional business indicator management system for aerospace manufacturing enterprises as described above, In the automatic indicator calculation module, the calculation dimension involved in the calculation is a combination of all possible cases of the selected calculation dimension. Each combination needs to generate a calculation task. When the calculation task is calculated, it first reads the data corresponding to each calculation parameter of the calculation dimension involved in the calculation. If it is calculating the current data, it takes the data within the current calculation period according to the calculation frequency. If it is calculating the cumulative data, it takes all the data.

[0015] The beneficial effects of this invention are as follows: This invention provides a multi-dimensional business indicator management system for aerospace manufacturing enterprises. This system manages the data source information required by the multi-dimensional business indicator management system through a data source management module; it sets the business domain, business category, indicator source, and indicator classification information of the indicators to be managed through a business domain management module, serving as basic management items for subsequent indicator management; it maintains and manages mutually exclusive groups for each calculation dimension through a calculation dimension management module, so that calculation dimensions within the same mutually exclusive group are not selected simultaneously when calculating indicators; it configures the business domain, business category, indicator source, indicator classification, calculation parameters, calculation formula, calculation frequency, and calculation dimension of the indicators to be maintained through an indicator calculation model configuration module; and it uses an automatic indicator calculation module to calculate indicator results according to the calculation frequency based on the content configured in the indicator calculation model configuration module. Using the multi-dimensional business indicator management system for aerospace manufacturing enterprises provided by this invention, it is possible to define calculation rules only once, and subsequently automatically calculate indicator values ​​according to the rules on a regular schedule, solving the problems of complex and inefficient indicator management processes in various business areas of large aerospace manufacturing enterprises; and through centralized management and automatic calculation of indicators, it saves labor costs and improves work efficiency. Attached Figure Description

[0016] The accompanying drawings are provided to further understand the technical solutions of the present invention and constitute a part of the specification. They are used together with the embodiments of this application to explain the technical solutions of the present invention and do not constitute a limitation on the technical solutions of the present invention.

[0017] Figure 1 This is a schematic diagram of the system architecture of a multi-dimensional business indicator management system for aerospace manufacturing enterprises provided in an embodiment of the present invention; Figure 2 This invention provides a schematic diagram of a mutually exclusive set of computational dimensions in an embodiment of the invention. Figure 3 This is a schematic diagram of the calculation process of the automatic indicator calculation module in the multi-dimensional business indicator management system for aviation manufacturing enterprises provided in this embodiment of the invention. Detailed Implementation

[0018] To make the objectives, technical solutions, and advantages of the present invention clearer, the embodiments of the present invention will be described in detail below with reference to the accompanying drawings. It should be noted that, unless otherwise specified, the embodiments and features described in this application can be arbitrarily combined with each other.

[0019] This invention is designed for aviation manufacturing enterprises, providing functions such as connection to indicator data sources, configuration of indicator models, and automatic calculation of indicators across all business dimensions. Users only need to configure the indicators once, and the multi-dimensional business indicator management system can automatically calculate them, solving the problems of complex and inefficient indicator management processes in various business areas of large aviation manufacturing enterprises.

[0020] The present invention provides the following specific embodiments, which can be combined with each other. For the same or similar concepts or processes, they may not be described again in some embodiments.

[0021] Figure 1 This is a schematic diagram of the system architecture of a multi-dimensional business indicator management system for aerospace manufacturing enterprises, provided as an embodiment of the present invention. Figure 1 As shown, the multi-dimensional business indicator management system for aerospace manufacturing enterprises provided by this invention includes: The data source management module is used to manage the data source information required by the multi-dimensional business indicator management system, and to perform connection to the data source and data acquisition based on the data source information; The business domain management module is used to set the business domain, business category, indicator source, and indicator category information of the indicators to be managed, serving as a basic management item for subsequent indicator management. The Calculation Dimension Management module is used to maintain calculation dimension information and manage mutual exclusion groups for each calculation dimension. This ensures that calculation dimensions within the same mutual exclusion group cannot be selected simultaneously when calculating metrics. The indicator calculation model configuration module, which is connected to the data source management module, business domain management module, and calculation dimension management module respectively, is used to configure the business domain, business category, indicator source, indicator category, calculation parameters, calculation formula, calculation frequency, and calculation dimension of the indicator to be maintained. Among them, the calculation parameter configuration item is based on the data source management module to perform summation, averaging, and other results on the acquired data; the calculation dimension configuration item is based on the configuration information in the calculation dimension management module and selects the existing calculation dimension information in accordance with the mutual exclusion group management requirements therein. The automatic indicator calculation module, which is connected to the indicator calculation model configuration module, is used to calculate the indicator results according to the calculation frequency based on the content configured in the indicator calculation model configuration module.

[0022] The following is a detailed description of the implementation methods of each module in the multi-dimensional business indicator management system provided by this invention: (1) Data source management module, used to obtain the data source information to be managed based on user input, including: the database type corresponding to each business system, the address, username and password of each database; The data source management module is also used to establish connections with each database based on the data source information, and to obtain data from each database through the connections.

[0023] This data source management module is also used to configure data filtering conditions for each database. During the process of obtaining data from the database, the obtained data is filtered according to the configured data filtering conditions, and the filtered data to be calculated is output.

[0024] (2) Business domain management module, used to set the business domain, business category, indicator source and indicator category information of the indicators to be managed, as a basic management item for subsequent indicator management.

[0025] (3) The computation dimension management module is used to maintain computation dimension information and manage mutual exclusion groups for each computation dimension; and to configure mutual exclusion levels for each computation dimension belonging to the same mutual exclusion group.

[0026] like Figure 2 As shown, the mutually exclusive groups are divided into two categories: aircraft and organizations. The calculation dimensions of aircraft are aircraft type, aircraft model, and number of flights. The calculation dimensions of organizations include first-level organizations, second-level organizations, and third-level organizations, which belong to a mutually exclusive group with mutual exclusion levels of 1, 2, and 3, respectively.

[0027] (4) Calculation dimension management module, which is used to maintain calculation dimension information and manage mutual exclusion groups for each calculation dimension, so that when calculating indicators, the calculation dimensions in the same mutual exclusion group cannot be selected at the same time. Calculation parameters include manual parameters and automatic parameters; manual parameters need to be entered by the user each time a calculation is performed, while automatic parameters are automatically obtained by the system. The statistical types of calculation parameters are divided into count, summation, maximum value, minimum value, etc.

[0028] The calculation formula allows for the configuration of addition, subtraction, multiplication, and division of calculation parameters, and supports the use of parentheses to intervene in the calculation order of the parameters; The calculation frequency is used to represent the calculation time and data time range of the indicator. The calculation time is divided into categories such as year, half-year, quarter, month, and day, with the categories other than day further subdivided into dates. For calculation frequencies of year, there are two categories: the nth day at the end of the current year and the nth day at the beginning of the following year. The same applies to half-year, quarter, and month. The data time range is divided into two cases: current period and cumulative.

[0029] Calculation dimension: When configuring calculation parameters, you can choose whether to associate calculation dimensions. If associated, the calculation parameter will be calculated separately according to each associated calculation dimension. If not associated, the data corresponding to the calculation parameter will be calculated directly. Calculation dimension is used to determine the data range of the indicator to be maintained. The source of calculation dimension is the calculation dimension management module.

[0030] It should be noted that a single metric to be managed can have multiple calculation dimensions, and each calculation dimension can have multiple calculation frequencies. If you select aircraft type, model, or flight count as the calculation dimension, you also need to select which aircraft type, model, or flight count to calculate. If you select other calculation dimensions such as organization or year, the system will automatically perform the calculation based on the existing dimension data in the database.

[0031] The automatic indicator calculation module automatically calculates the indicators based on the configuration settings in the above modules. This module runs once a day, iterating through all indicators. The specific calculation process is as follows: Figure 3 As shown. For each metric, iterate through its corresponding list of calculation dimensions. For each calculation dimension, iterate through its corresponding calculation frequency. Compare the calculation frequency information with the current date; if the calculation time has not yet arrived, skip it. If the calculation time has arrived, perform the calculation for the corresponding calculation dimension during this period.

[0032] In the automatic indicator calculation module, the calculation dimensions involved are all possible combinations of the selected calculation dimensions. Each combination requires generating one calculation task. For example, if the organizational structure calculation dimension is selected, and the organizational information in the data to be calculated includes departments A and B, then two calculation tasks need to be generated: the indicator for department A and the indicator for department B. If both organization and aircraft type calculation dimensions are selected, and the organizations in the data to be calculated include departments A and B, and the aircraft types include aircraft type 1 and aircraft type 2, then four calculation tasks need to be generated: the aircraft type 1 indicator for department A, the aircraft type 2 indicator for department A, the aircraft type 1 indicator for department B, and the aircraft type 2 indicator for department B.

[0033] The calculation task first reads the data corresponding to each calculation parameter of the calculation dimension. If it is calculating current data, it retrieves data within the current calculation period based on the calculation frequency; if it is calculating cumulative data, it retrieves all data. If there are manually entered parameters, a system task is sent to the corresponding person, and the calculation is performed after they have filled in the manually entered parameters. If no parameters are manually entered, the calculation proceeds directly. After obtaining all calculation parameters, the calculation is performed according to the calculation formula to obtain the result.

[0034] This invention provides a multi-dimensional business indicator management system for aerospace manufacturing enterprises. The system manages the data source information required for the system through a data source management module; it sets the business domain, business category, indicator source, and indicator classification information of the indicators to be managed through a business domain management module, serving as basic management items for subsequent indicator management; it maintains and manages mutually exclusive groups for each calculation dimension through a calculation dimension management module, ensuring that calculation dimensions within the same mutually exclusive group are not selected simultaneously when calculating indicators; it configures the business domain, business category, indicator source, indicator classification, calculation parameters, calculation formula, calculation frequency, and calculation dimension of the indicators to be maintained through an indicator calculation model configuration module; and it uses an automatic indicator calculation module to calculate indicator results according to the calculation frequency based on the content configured in the indicator calculation model configuration module. Using the multi-dimensional business indicator management system for aerospace manufacturing enterprises provided by this invention, it is possible to define calculation rules only once, and subsequently automatically calculate indicator values ​​according to the rules at regular intervals, solving the problems of complex and inefficient indicator management processes in various business areas of large aerospace manufacturing enterprises; and it saves labor costs and improves work efficiency through centralized management and automatic calculation of indicators.

[0035] While the embodiments disclosed in this invention are as described above, they are merely illustrative of the embodiments to facilitate understanding of the invention and are not intended to limit the invention. Any person skilled in the art to which this invention pertains may make any modifications and variations in the form and details of the implementation without departing from the spirit and scope disclosed herein; however, the scope of patent protection for this invention shall still be determined by the scope defined in the appended claims.

Claims

1. A multi-dimensional business indicator management system for aerospace manufacturing enterprises, characterized in that, include: The data source management module is used to manage the data source information required by the multi-dimensional business indicator management system, and to perform connection to the data source and data acquisition based on the data source information; The business domain management module is used to set the business domain, business category, indicator source, and indicator category information of the indicators to be managed, serving as a basic management item for subsequent indicator management. The Calculation Dimension Management module is used to maintain calculation dimension information and manage mutual exclusion groups for each calculation dimension. This ensures that calculation dimensions within the same mutual exclusion group cannot be selected simultaneously when calculating metrics. The indicator calculation model configuration module, which is connected to the data source management module, business domain management module, and calculation dimension management module respectively, is used to configure the business domain, business category, indicator source, indicator category, calculation parameters, calculation formula, calculation frequency, and calculation dimension of the indicator to be maintained. The automatic indicator calculation module, which is connected to the indicator calculation model configuration module, is used to calculate the indicator results according to the calculation frequency based on the content configured in the indicator calculation model configuration module.

2. The multi-dimensional business indicator management system for aerospace manufacturing enterprises according to claim 1, characterized in that, The data source management module performs connection to the data source and data acquisition based on the data source information, including: The data source management module is used to obtain the data source information to be managed based on user input, including: the database type corresponding to each business system, the address, username, and password of each database; The data source management module is also used to establish connections with each database based on the data source information, and to obtain data from each database through the connections.

3. The multi-dimensional business indicator management system for aerospace manufacturing enterprises according to claim 1, characterized in that, The data source management module is also used to configure data filtering conditions for each database. During the process of acquiring data from the database, the acquired data is filtered according to the configured data filtering conditions, and the filtered data to be calculated is output.

4. The multi-dimensional business indicator management system for aerospace manufacturing enterprises according to claim 1, characterized in that, The computational dimension management module maintains computational dimension information including the computational dimensions of aircraft and organizations; The calculation dimensions for aircraft include: aircraft type, model, and number of sorties belonging to the same mutually exclusive group; The computational dimensions of an organization include the computational dimensions corresponding to each level belonging to the same mutually exclusive group.

5. A multi-dimensional business indicator management system for aerospace manufacturing enterprises according to claim 4, characterized in that, The computation dimension management module is also used to configure mutual exclusion levels for each computation dimension belonging to the same mutual exclusion group, wherein the mutual exclusion level indicates the hierarchical level of the corresponding computation dimension in the mutual exclusion group.

6. A multi-dimensional business indicator management system for aerospace manufacturing enterprises according to claim 4, characterized in that, The calculation parameters configured in the indicator calculation model configuration module include manual parameters and automatic parameters; The indicator calculation model configuration module configures the calculation parameters for addition, subtraction, multiplication, and division by configuring the calculation formula, and supports the use of parentheses to intervene in the calculation order of the calculation parameters; The indicator calculation model configuration module uses the calculation frequency to represent the calculation time and data time range of the indicator; the calculation time is divided into year, half-year, quarter, month, and day; the data time range is divided into current period and cumulative cases. When configuring calculation parameters, the indicator calculation model configuration module allows users to choose whether to associate calculation dimensions. If associated, the calculation parameter is calculated separately according to each associated calculation dimension. If not associated, the data corresponding to the calculation parameter is calculated directly. The calculation dimension is used to determine the data range of the metrics to be maintained, and the calculation dimension is sourced from the calculation dimension management module.

7. A multi-dimensional business indicator management system for aerospace manufacturing enterprises according to claim 6, characterized in that, Each metric to be maintained has one or more calculation dimensions, and each calculation dimension has one or more calculation frequencies.

8. A multi-dimensional business indicator management system for aerospace manufacturing enterprises according to claim 7, characterized in that, The automatic indicator calculation module calculates the indicators in the following way: The automatic indicator calculation module runs once a day. For each indicator, it iterates through the list of calculation dimensions; for each calculation dimension, it iterates through the corresponding calculation frequency; it compares the calculation frequency information with the current date, and skips the calculation if the calculation time has not yet arrived; if the calculation time has arrived, it calculates the calculation dimension corresponding to the calculation frequency, and iterates through and calculates all indicators.

9. A multi-dimensional business indicator management system for aerospace manufacturing enterprises according to claim 7, characterized in that, In the automatic indicator calculation module, the calculation dimension involved in the calculation is a combination of all possible cases of the selected calculation dimension. Each combination needs to generate a calculation task. When the calculation task is calculated, it first reads the data corresponding to each calculation parameter of the calculation dimension involved in the calculation. If it is calculating the current data, it takes the data within the current calculation period according to the calculation frequency. If it is calculating the cumulative data, it takes all the data.

Images