Index management display method and system and electronic equipment

Abstract

The embodiment of the invention provides an index management display method and system and electronic equipment, and relates to the technical field of index management. The index management display method comprises the following steps: setting a plurality of pages at the front end of VUE; an index correlation table is stored in the JAVA rear end; the index correlation table comprises an index configuration table, an index detailed configuration table and an index landing library table; acquiring operations of a user at the front end of the VUE based on the plurality of pages, wherein the operations comprise a configuration operation, a calculation operation and a query operation; mapping the configuration operation into a table operation for the index correlation table, mapping the calculation operation into a calling execution operation for an index calculation program, and forwarding the query operation to a corresponding interface of a data warehouse where the index correlation table is located; and obtaining an execution result, and feeding back the execution result to the front end of the VUE as feedback of the operation. According to the embodiment provided by the invention, the problem of tedious index configuration of a service user is solved.

Description

Technical Field

[0001] The present application relates to the technical field of indicator management, and specifically to an indicator management display system, an indicator management display method, an electronic device and a corresponding storage medium. Background Art

[0002] With the development of big data technology, various data in enterprises have become more valuable. At present, indicators are needed for report analysis in enterprises. The business logic of indicators is defined by various departments, including basic information definition, business definition, technical definition, and management definition. However, these definitions are not unified and vary. Moreover, the calculation of indicators is written in the program in advance. Every time the indicator changes, the source code of the corresponding program needs to be modified, which makes it impossible for business users to configure flexibly.

[0003] ADSO: Advanced DataStore Object, advanced data storage object.

[0004] BW: Business Warehousing, data warehouse. Summary of the invention

[0005] The purpose of the embodiments of the present application is to provide an indicator management and display method, system and electronic device, which can enable users to flexibly configure indicators and reduce the impact of indicator changes on indicator calculation programs, so as to at least solve some of the problems in the background technology.

[0006] In order to achieve the above-mentioned purpose, an indicator management and display method is provided in the present application, which comprises: setting a plurality of pages on the VUE front end, including: an indicator standard maintenance page, a basic item indicator maintenance page, a composite item indicator maintenance page and an indicator operation page; the JAVA back end stores indicator-related tables; the indicator-related tables include: an indicator configuration table, an indicator detailed configuration table and an indicator landing library table; obtaining the user's operation on the VUE front end based on the plurality of pages, the operation including configuration operation, calculation operation and query operation; mapping the configuration operation to a table operation on the indicator-related table, mapping the calculation operation to a call execution operation on the indicator calculation program, and forwarding the query operation to the corresponding interface of the data warehouse where the indicator-related table is located; obtaining the execution result, and feeding back the execution result to the VUE front end as feedback on the operation.

[0007] Optionally, the indicator standard maintenance page provides indicator adding function and indicator editing function through corresponding buttons; the indicator editing function can maintain the basic attributes, business attributes, management attributes and technical attributes of the indicator; the business attributes include key value classification of the indicator, and after the key value classification is determined, the key value data acquisition logic will be generated in the technical attributes; the optional options of the key value classification include assets and liabilities, profit and loss, cash flow and comprehensive.

[0008] Optionally, the basic item indicator maintenance page includes: providing a page component for updating the business attributes and technical attributes of the indicator; providing metadata configuration when the indicator is stored in the indicator-related table; providing a page component for defining data retrieval logic configuration and key value data retrieval logic; and providing a page component for configuring the analysis dimension mapping relationship.

[0009] Optionally, the composite item indicator maintenance page includes: determining the candidate key values ​​of the indicator based on the maintenance object of the key value acquisition logic; displaying the candidate key values ​​and setting an add button before each candidate key value, and placing the corresponding candidate key values ​​into the calculation formula indicator pool through the add button. The key values ​​in the calculation formula indicator pool will be used as processing objects when the indicator calculation program is called and executed.

[0010] Optionally, the indicator operation page includes: a batch calculation / calculation component, which is used to obtain indicator data and synchronize it to data calculation according to the configured indicator calculation program by selecting multiple indicators or selecting a single indicator; a preview component, which is used to jump to the corresponding data preview page based on the filtering conditions entered by the user; a batch publishing / publishing component, which is used to publish unpublished and calculated indicators; a freeze / thaw component, which is used to freeze or unfreeze associated indicators when the published indicators are referenced by other indicators; a replacement component, which is used to replace the published indicators with the indicators corresponding to the indicator codes entered by the user; an association check component, which is used to view assets that have a reference relationship with the indicator; and a push component, which is used to push the indicator content to the data warehouse based on user operations.

[0011] Optionally, the calculation operation is configured as a scheduled task; the preset process calls the indicator calculation program configured in the JAVA backend based on the set time in the scheduled task, pushes the indicators involved in the indicator calculation program to the data warehouse for calculation, and pulls the calculation log of the data warehouse to the indicator calculation log table for storage; the indicator calculation log table is stored in the JAVA backend.

[0012] Optionally, the indicator calculation program includes: a dynamic internal table establishment module, used to establish a dynamic internal table for storing indicator data involved in the indicator calculation program; an indicator data acquisition module, used to query and fill in corresponding key values ​​from the indicator-related table based on the indicators in the dynamic internal table; a formula calculation module, used to obtain calculation results based on the key values ​​and built-in formulas; a data merging module, used to store the calculation results; and a data copying module, used to merge the stored calculation results into the indicator-related table and delete the dynamic internal table.

[0013] The present application also provides an indicator management and display system, which includes: a VUE front end, the VUE front end is provided with multiple pages, including: an indicator standard maintenance page, a basic item indicator maintenance page, a composite item indicator maintenance page and an indicator operation page; the VUE front end is also configured to: obtain the user's operation on the VUE front end based on the multiple pages, and the operation includes configuration operation, calculation operation and query operation; a JAVA back end, the JAVA back end stores an indicator-related table; the indicator-related table includes: an indicator configuration table, an indicator detailed configuration table and an indicator landing library table; the JAVA back end is also configured to: map the configuration operation to a table operation on the indicator-related table, map the calculation operation to a call execution operation on the indicator calculation program, and forward the query operation to the corresponding interface of the data warehouse where the indicator-related table is located; and obtain the execution result, and feed the execution result back to the VUE front end as feedback on the operation.

[0014] The present application also provides an electronic device, comprising: at least one processor; a memory connected to the at least one processor; wherein the memory stores instructions that can be executed by the at least one processor, and the at least one processor implements the aforementioned indicator management and display method by executing the instructions stored in the memory.

[0015] The present application also provides a machine-readable storage medium, on which instructions are stored. When the instructions are executed by a processor, the processor is configured to execute and implement the aforementioned indicator management and display method.

[0016] The present application also provides a computer program product, including a computer program, which implements the aforementioned indicator management and display method when executed by a processor.

[0017] The above technical solution has the following beneficial effects:

[0018] (1) It can realize comprehensive indicator attribute definition, including basic information definition, business definition, technical definition, and management definition. It can also realize flexible and convenient indicator logic configuration, support flexible definition of composite indicators, and support reference to basic indicators and other composite indicators, which significantly improves the flexibility of indicator association.

[0019] (2) It supports cooperation with the database to realize fast calculation based on logical definition, which simplifies the calculation complexity between indicators.

[0020] (3) It solves the problem of inefficient enterprise indicator management caused by cumbersome indicator configuration by business users and frequent program modifications.

[0021] Other features and advantages of the embodiments of the present application will be described in detail in the subsequent specific implementation section. BRIEF DESCRIPTION OF THE DRAWINGS

[0022] The accompanying drawings are used to provide a further understanding of the embodiments of the present application and constitute a part of the specification. Together with the following specific implementations, they are used to explain the embodiments of the present application, but do not constitute a limitation on the embodiments of the present application. In the accompanying drawings:

[0023] Figure 1 The following is a schematic diagram showing the steps of the indicator management display method according to the implementation mode of the present application;

[0024] Figure 2 The schematic diagram of the architecture of the indicator management and display system according to the implementation manner of the present application is schematically shown. DETAILED DESCRIPTION

[0025] The specific implementation of the embodiment of the present application is described in detail below in conjunction with the accompanying drawings. It should be understood that the specific implementation described here is only used to illustrate and explain the embodiment of the present application, and is not used to limit the embodiment of the present application.

[0026] Figure 1 The following is a schematic diagram showing the steps of the indicator management display method according to the implementation mode of the present application. Figure 1 As shown, a method for displaying indicator management includes:

[0027] S01. Set up multiple pages on the VUE front end, including: indicator standard maintenance page, basic item indicator maintenance page, composite item indicator maintenance page and indicator operation page;

[0028] S02. The JAVA backend stores indicator-related tables; the indicator-related tables include: indicator configuration table, indicator detailed configuration table and indicator landing library table;

[0029] S03, based on the multiple pages, obtaining the user's operation on the VUE front end, the operation including configuration operation, calculation operation and query operation;

[0030] S04, mapping the configuration operation to a table operation on the indicator-related table, mapping the calculation operation to a call execution operation on the indicator calculation program, and forwarding the query operation to a corresponding interface of the data warehouse where the indicator-related table is located;

[0031] S05. Obtain the execution result, and feed the execution result back to the VUE front end as feedback for the operation.

[0032] Through the above implementation, it is only necessary to configure the indicator business logic in the front-end, and the back-end program does not need to adjust the code due to indicator changes. At the same time, the business logic can be pushed to BW for indicator calculation.

[0033] In some embodiments of the present application, the indicator standard maintenance page provides an indicator adding function and an indicator editing function through corresponding buttons; the indicator editing function can maintain the basic attributes, business attributes, management attributes and technical attributes of the indicator; the business attributes include the key value classification of the indicator, and after the key value classification is determined, the key value data acquisition logic will be generated in the technical attributes; the options for the key value classification include assets and liabilities, profit and loss, cash flow and comprehensive. Exemplarily, the user enters the indicator management page. The "Indicator Standard Maintenance" page is displayed by default. The indicator directory is displayed on the left side of the page, and indicators can be added, renamed, moved to, moved up, moved down, expanded, and collapsed.

[0034] Here is an example:

[0035] Click the "Add Indicator" button to add an indicator. You cannot add duplicate indicator names or indicator codes. The status of the newly added indicators is "None" and the indicator type is empty. The indicator type needs to be maintained in the indicator type option of "Business Properties" on the editing page. Click the "Rename" button to rename the indicator name. Click the "Move Up" button to move the first indicator of the hierarchy up. Click the "Move Down" button to move the last indicator of the hierarchy down. Click the "Move To" button to move the indicator to another directory or indicator. If the indicator to be moved has sub-indicators, they will be moved together. The four functions of "Rename", "Move Up", "Move Down" and "Move To" are only effective for indicators. If a directory is selected, the button will be grayed out and cannot be clicked. When an indicator is selected, the button will be blue and clickable.

[0036] The right area of ​​the page initially displays "No data". When the indicator directory on the left (there are indicators under the directory) or indicators are checked, the right area displays the indicators under the checked indicator directory or the checked indicators.

[0037] Click the "Copy" button in the Operation column of the indicator list to display the copy input pop-up window. Enter the new indicator code and indicator name. Do not enter the existing indicator code and indicator name. The selected indicator can be completely copied into a new indicator. Except for the indicator code and indicator name, the rest of the indicator information is consistent with the copied indicator. The copied indicator is in the same directory as the copied indicator.

[0038] Click the "Edit" button in the indicator operation column to enter the editing page. This editing page can only maintain the data of the three TAB pages of "Basic Properties", "Business Properties" and "Management Properties". The "Technical Properties" TAB can only be viewed but not edited. The "Technical Properties" can only be operated on the corresponding value type maintenance TAB page.

[0039] Actual value, monthly, and annual value budget indicator categories. These three fields can only be changed or cleared when the corresponding value type status is "None", "Temporarily stored", or "Unpublished". If the corresponding value type is in the "Published" or "Frozen" status, it cannot be changed. If the corresponding value has maintained the "Technical Attributes" content, when the category is changed or cleared and saved, the "Technical Attributes" content of the corresponding value will be cleared. For example, if the actual value category is "Basic Indicator" and the "Technical Attributes" content has been maintained, and then the actual value category is changed to "Compound Indicator" or the category is cleared and saved, the "Technical Attributes" maintained content will be cleared and need to be maintained again.

[0040] For key value classification, move the mouse pointer to the "?" icon to view the key value corresponding to the classification. If the status of any of the actual value, monthly budget, or annual budget is "released" or "frozen", it cannot be changed. After selecting a key value classification, it will be reflected in the "Key Value Acquisition Logic" module of "Technical Properties". When the key value of the "Key Value Acquisition Logic" module is configured with logic, and the "Key Value Classification" is changed and saved, the original content of the "Key Value Acquisition Logic" module will be cleared and the new key value will be displayed, and the logic needs to be reconfigured.

[0041] In some embodiments of the present application, the basic item indicator maintenance page includes: providing a page component for updating the business attributes and technical attributes of the indicator; providing metadata configuration when the indicator is stored in the indicator-related table; providing a page component for defining the data acquisition logic configuration and the key value data acquisition logic; and providing a page component for configuring the analysis dimension mapping relationship. The page is described as follows: Click the "Edit" button in the operation column of the indicator list to edit the "actual value" of the "technical attribute". According to the indicator type (basic item indicator / composite item indicator) selected in the "business attribute", the corresponding "technical attribute" filling information is also different. After filling in the data according to the corresponding form information, click "Save" to save this indicator. The indicator status after editing is "unpublished" and the calculation status is "uncalculated". If the edited value status is "temporary storage", you can click "temporary save" after editing to complete the middle, without changing the indicator status. The "temporary save" button is only effective for indicators in the "temporary storage" state.

[0042] The actual value of the basic item, the data storage aggregatable flag of "Technical Attributes" defaults to "aggregatable" and cannot be changed. When "Indicator Landing Library" of "Data Storage" is selected, "Analysis Dimension" will be automatically brought out. The automatically brought out dimension is maintained in "System Management Center-Configuration Information Management-Indicator Landing Library Dimension Field Configuration Table". The relationship between "Basic Metadata Type" and "Basic Metadata Object" of "Data Storage" is that only after "Basic Metadata Type" is selected, "Basic Metadata Object" will display the corresponding type metadata object according to the "ADSO" or "TABLE" type selected in "Basic Metadata Type". If "Basic Metadata Type" is not selected, "Basic Metadata Object" is empty.

[0043] In the pop-up window for editing "Data acquisition logic configuration" and "Key value data acquisition logic", you can define the relationship of AND, OR, and minus for different condition groups, or define the AND and OR relationship in the same condition group; AND takes precedence in the operation relationship. The fields in the first box of the conditional filtering pop-up window are derived from the table of the selected "Basic metadata object". Only after the "Basic metadata object" is selected, the fields will be displayed here for field condition configuration.

[0044] "Analysis Dimension Mapping Relationship", this module needs to associate the data of the analysis dimension with the fields of the basic metadata object and the fields of the landing library table one by one: Part 1: The data source and the "Analysis Dimension" selected by the "Data Storage" module; Part 2: The data source and the "Basic Metadata Object" selected by the "Data Storage" module; Part 3: The data source and the "Indicator Landing Library" selected by the "Data Storage" module, and then query the corresponding metadata object based on the selected indicator landing library.

[0045] In some embodiments of the present application, the composite index maintenance page includes: determining the key value to be selected for the index based on the maintenance object of the key value acquisition logic; displaying the key value to be selected and setting an add button before each key value to be selected, and placing the corresponding key value to be selected into the calculation formula index pool through the add button, and the key value in the calculation formula index pool will be used as the processing object when the index calculation program is called and executed. The page is explained as follows: the "technical attributes" of the composite index, the "aggregable identification" of the "data storage" module defaults to "aggregable", and the selection of the "indicator landing library" will not automatically bring out the "storage dimension" and "analysis dimension". When the "aggregable identification" selects "non-aggregable", the "storage dimension" defaults to the three dimensions of "accounting period, fiscal year, and organizational structure", which cannot be changed. "Key value acquisition logic", if the actual value is maintained, the formula configuration selectable indicator key value is the key value of the actual value indicator, if the monthly budget or annual budget is maintained, the formula configuration selectable indicator key value is the key value of the monthly budget or annual budget. Click the "Add" button in front of the key value to place the key value into the "Calculation Formula Related Indicator Pool", and then configure the formula based on the key value in the indicator pool. After configuring the formula, click Save. At this time, the "Storage Dimension" and "Analysis Dimension" of the "Data Storage" module will display the union of the corresponding dimensions of the indicator selected in the formula configuration.

[0046] In some embodiments of the present application, the indicator operation page includes: batch calculation / calculation component, which is used to obtain indicator data by selecting multiple indicators or selecting a single indicator, and synchronize it to the data calculation according to the configured indicator calculation program; preview component, which is used to jump to the corresponding data preview page based on the filter conditions entered by the user; batch publishing / publishing component, which is used to publish unpublished and calculated indicators; freeze / thaw component, which is used to freeze or unfreeze the associated indicators when the published indicators are referenced by other indicators; replacement component, which is used to replace the published indicators with the indicators corresponding to the indicator codes entered by the user; association check component, which is used to view the assets that have a reference relationship with the indicator; and push component, which is used to push the indicator content to the data warehouse based on user operations. The page is explained as follows:

[0047] Indicator operations include: indicator calculation, editing, viewing, publishing and other functions.

[0048] "Batch calculation / calculation" selects multiple indicators or a single indicator to obtain BW data and synchronize it to data calculation according to the configured indicator logic / formula. When you enter the calculation conditions and click OK, the calculation status of the indicator is set to "calculating". If the entered calculation conditions are consistent with the configured indicator logic / formula, the calculation is successful and the calculation status is set to "calculated". Otherwise, the calculation fails and the calculation status is "calculation failed".

[0049] "Preview" displays a pop-up window of preview filter conditions. Enter the corresponding conditions and click OK to jump to the data preview page. If there is no data matching the conditions, it will prompt "No data yet".

[0050] "Batch Publish / Publish" can publish "unpublished, calculated" indicators. The status is set to "publishing". When the publishing is successful, the status is set to "published". Indicators in the published state support operations such as reference and data synchronization by other assets such as API and visualization. If the subordinate indicators of the indicator blood relationship are not published, the association check box will pop up. The subordinate indicators must be published before this indicator can be published.

[0051] Click the "Freeze / Unfreeze" button in the operation column of the "Published" status indicator. If the indicator is referenced by other indicators, an associated check box will pop up to select whether to freeze the associated indicators together. After freezing the indicator, the indicator status changes to "Frozen" and the "Freeze" button changes to "Unfreeze". The frozen indicator can be unfrozen. The indicator status after unfreezing is "Temporarily stored, not calculated". The frozen indicator does not support operations such as reference and data synchronization by other assets such as API and visualization.

[0052] The "Replace" button in the "Published" status indicator operation column can replace the "Technical Attributes" of the corresponding value with another indicator. Click the "Replace" button, and a pop-up window will pop up to enter the indicator code to be replaced. You cannot enter an indicator code that does not exist. You can only replace indicators of the same indicator type. For example, a basic item indicator cannot be replaced with a composite item indicator. The replaced indicator content becomes the original indicator content. If you replace it on the "Actual Value Maintenance" page, you will replace the "Actual Value" of the "Technical Attributes". The same applies to monthly budget maintenance and annual budget maintenance.

[0053] "Relationship Check", check the single indicator to be checked, click "Relationship Check", you can check which assets reference this indicator. You cannot check multiple indicators at the same time.

[0054] The "Push" button can manually push the indicator content to the BW database. For example, when the content or logic of a certain indicator is modified, it needs to be pushed to the BW database to take effect. Push is for all indicators. When the status of an indicator changes to "Published" or "Frozen", it will also be pushed automatically.

[0055] In some embodiments of the present application, the calculation operation is configured as a scheduled task; the preset process calls the indicator calculation program configured in the JAVA backend based on the set time in the scheduled task, pushes the indicators involved in the indicator calculation program to the data warehouse for calculation, and pulls the calculation log of the data warehouse to the indicator calculation log table for storage; the indicator calculation log table is stored in the JAVA backend. Scheduled tasks, XXL-Job regularly calls the indicator calculation program configured in the JAVA backend, pushes the indicators to be calculated to BW for calculation, and pulls the BW calculation log to the indicator calculation log table for storage.

[0056] In some embodiments of the present application, the indicator calculation program includes: a dynamic internal table establishment module, which is used to establish a dynamic internal table for storing the indicator data involved in the indicator calculation program; an indicator data acquisition module, which is used to query and fill in the corresponding key value from the indicator-related table based on the indicator in the dynamic internal table; a formula calculation module, which is used to obtain the calculation result based on the key value and the built-in formula; a data merging module, which is used to store the calculation result; and a data copying module, which is used to merge the stored calculation result into the indicator-related table and delete the dynamic internal table. The following is an implementation description using the calculation of a single company of aggregatable composite indicators as an example. Prepare to store dynamic internal tables. If it is an amount indicator type, the internal table structure is all fields of the target table + sub-indicator 1_A1 + sub-indicator 1_A2_sub-indicator 1_A3 + sub-indicator 2_A1 + sub-indicator 2_A2_sub-indicator 2_A3....... (the A after the sub-indicator represents the corresponding sub-indicator value type, a total of A, B, C, D, E, F six types, 1, 2, 3 represent the corresponding three currency types); if it is a quantity indicator type, the internal table structure is: all fields of the target table + sub-indicator 1_G + sub-indicator 2_H....... (the G and H after the sub-indicator represent the corresponding sub-indicator value type, a total of G, H, I, J, K, L six types). Get all dimension fields of the indicator code through the passed-in indicator code. Find the calculation formula corresponding to the indicator code (table ZKPI_COMPLEX_EXP) according to the indicator code. Through the indicator code, find the relationship between the key value type (ZKEY_VALUE_TYPE) corresponding to the indicator code and the key value type (ZSUB_INDEX_KEY_VALUE_TYPE) of the sub-indicator. Through the sub-indicator code, take the table ZKPI_MASTER_MAIN-zindex_classification (1 basic indicator 2 review indicator) to determine whether each sub-indicator is a basic indicator or a review indicator. The source table of the review indicator is ZKPI_COMPLEX_DT, and the target table of the basic indicator is ZKPI_BASE_ZC_QT (Assets-Others), totaling 15 tables. Query the source table corresponding to the sub-indicator. The sub-indicators determined in the three steps are respectively taken from the corresponding data source table to obtain the corresponding year, period, and organizational structure data. Delete the corresponding indicator year period organizational structure data in the target table, and insert the recalculated data into the target table. Call the function ZKPI_TARG_NBB_TO_C22 to merge the new report data of the corresponding indicator into C22.

[0057] It can be seen from the above implementation methods that the existing indicator business logic, including basic information definition, business definition, technical definition, management definition, and configuration changes, has solved the problem that the code needs to be frequently modified. This application provides an indicator management and display method based on JAVA, Vue, and BW. Through this application, it is possible to configure the indicator business logic only in the foreground, and the program does not need to adjust the code due to indicator changes.

[0058] Based on the same inventive concept, the embodiment of the present application also provides an indicator management and display system. Figure 2 The schematic diagram of the structure of the indicator management and display system according to the implementation mode of this application is shown schematically. Figure 2 As shown, the system includes: a VUE front end, the VUE front end is provided with multiple pages, including: an indicator standard maintenance page, a basic item indicator maintenance page, a composite item indicator maintenance page and an indicator operation page; the VUE front end is also configured to: obtain the user's operation on the VUE front end based on the multiple pages, and the operation includes a configuration operation, a calculation operation and a query operation; a JAVA back end, the JAVA back end stores an indicator-related table; the indicator-related table includes: an indicator configuration table, an indicator detailed configuration table and an indicator landing library table; the JAVA back end is also configured to: map the configuration operation to a table operation on the indicator-related table, map the calculation operation to a call execution operation on the indicator calculation program, and forward the query operation to the corresponding interface of the data warehouse where the indicator-related table is located; and obtain the execution result, and feed the execution result back to the VUE front end as feedback for the operation.

[0059] In some optional implementations of the present application, the indicator standard maintenance page provides indicator adding function and indicator editing function through corresponding buttons; the indicator editing function can maintain the basic attributes, business attributes, management attributes and technical attributes of the indicator; the business attributes include key value classification of the indicator, and after the key value classification is determined, the key value data acquisition logic will be generated in the technical attributes; the optional options of the key value classification include assets and liabilities, profit and loss, cash flow and comprehensive.

[0060] In some optional implementations of the present application, the basic item indicator maintenance page includes: providing a page component for updating the business attributes and technical attributes of the indicator; providing metadata configuration when the indicator is stored in the indicator-related table; providing a page component for defining data retrieval logic configuration and key value retrieval logic; and providing a page component for configuring the analysis dimension mapping relationship.

[0061] In some optional embodiments of the present application, the composite item indicator maintenance page includes: determining the candidate key values ​​of the indicator based on the maintenance object of the key value acquisition logic; displaying the candidate key values ​​and setting an add button before each candidate key value, and placing the corresponding candidate key value into the calculation formula indicator pool through the add button. The key values ​​in the calculation formula indicator pool will be used as processing objects when the indicator calculation program is called and executed.

[0062] In some optional embodiments of the present application, the indicator operation page includes: a batch calculation / calculation component, which is used to obtain indicator data and synchronize it to data calculation according to the configured indicator calculation program by selecting multiple indicators or selecting a single indicator; a preview component, which is used to jump to the corresponding data preview page based on the filtering conditions entered by the user; a batch publishing / publishing component, which is used to publish unpublished and calculated indicators; a freeze / thaw component, which is used to freeze or unfreeze associated indicators when the published indicators are referenced by other indicators; a replacement component, which is used to replace the published indicators with the indicators corresponding to the indicator codes entered by the user; an association check component, which is used to view assets that have a reference relationship with the indicator; and a push component, which is used to push the indicator content to the data warehouse based on user operations.

[0063] In some optional embodiments of the present application, the calculation operation is configured as a scheduled task; the preset process calls the indicator calculation program configured in the JAVA backend based on the set time in the scheduled task, pushes the indicators involved in the indicator calculation program to the data warehouse for calculation, and pulls the calculation log of the data warehouse to the indicator calculation log table for storage; the indicator calculation log table is stored in the JAVA backend.

[0064] In some optional embodiments of the present application, the indicator calculation program includes: a dynamic internal table establishment module, which is used to establish a dynamic internal table for storing indicator data involved in the indicator calculation program; an indicator data acquisition module, which is used to query and fill in corresponding key values ​​from the indicator-related table based on the indicators in the dynamic internal table; a formula calculation module, which is used to obtain calculation results based on the key values ​​and built-in formulas; a data merging module, which is used to store the calculation results; and a data copying module, which is used to merge the stored calculation results into the indicator-related table and delete the dynamic internal table.

[0065] The specific limitations of each functional module in the above-mentioned indicator management and display system can be found in the limitations of the indicator management and display method above, which will not be repeated here. Each module in the above-mentioned system can be implemented in whole or in part by software, hardware and a combination thereof. The above-mentioned modules can be embedded in or independent of the processor in the computer device in the form of hardware, or can be stored in the memory in the computer device in the form of software, so that the processor can call and execute the operations corresponding to the above modules. It also realizes flexible and convenient indicator logic configuration and flexible definition of various indicators, solving the problem of cumbersome indicator configuration by business users and frequent program modifications, resulting in inefficient enterprise indicator management.

[0066] In some embodiments of the present application, an electronic device is also provided, comprising: at least one processor; a memory connected to the at least one processor; wherein the memory stores instructions that can be executed by the at least one processor, and the at least one processor performs the aforementioned index management display method. The control module or processor here has the functions of numerical calculation and logical operation, and it has at least a central processing unit CPU with data processing capability, a random access memory RAM, a read-only memory ROM, a variety of I / O ports and an interrupt system, etc. The processor includes a kernel, and the kernel retrieves the corresponding program unit from the memory. The kernel can be set to one or more, and the aforementioned method is implemented by adjusting the kernel parameters. The memory may include a non-permanent memory in a computer-readable medium, a random access memory (RAM) and / or a non-volatile memory, such as a read-only memory (ROM) or a flash memory (flash RAM), and the memory includes at least one memory chip.

[0067] In one embodiment provided in the present application, a machine-readable storage medium is provided, on which instructions are stored, and when the instructions are executed by a processor, the processor is configured to execute the aforementioned indicator management and display method.

[0068] In one embodiment provided in the present application, a computer program product is provided, including a computer program, which implements the aforementioned indicator management and display method when executed by a processor.

[0069] Those skilled in the art will appreciate that the embodiments of the present application may be provided as methods, systems, or computer program products. Therefore, the present application may adopt the form of a complete hardware embodiment, a complete software embodiment, or an embodiment in combination with software and hardware. Moreover, the present application may adopt the form of a computer program product implemented in one or more computer-usable storage media (including but not limited to disk storage, CD-ROM, optical storage, etc.) that include computer-usable program code.

[0070] The present application is described with reference to the flowcharts and / or block diagrams of the methods, devices (systems), and computer program products according to the embodiments of the present application. It should be understood that each process and / or box in the flowchart and / or block diagram, as well as the combination of the processes and / or boxes in the flowchart and / or block diagram, can be implemented by computer program instructions. These computer program instructions can be provided to a processor of a general-purpose computer, a special-purpose computer, an embedded processor, or other programmable data processing device to generate a machine, so that the instructions executed by the processor of the computer or other programmable data processing device generate instructions for implementing the processes in the flowchart and / or block diagram. Figure 1 A process or multiple processes and / or boxes Figure 1 A device that provides the functions specified in a block or multiple blocks.

[0071] These computer program instructions may also be stored in a computer-readable memory capable of directing a computer or other programmable data processing device to operate in a specific manner, so that the instructions stored in the computer-readable memory produce an article of manufacture comprising an instruction device, which implements the process Figure 1 A process or multiple processes and / or boxes Figure 1 A function specified in one or more boxes.

[0072] These computer program instructions can also be loaded onto a computer or other programmable data processing device so that a series of operating steps are executed on the computer or other programmable device to produce a computer-implemented process, thereby providing instructions for implementing the process. Figure 1 A process or multiple processes and / or boxes Figure 1 A step that specifies a function in one or more boxes.

[0073] In a typical configuration, a computing device includes one or more processors (CPU), input / output interfaces, network interfaces, and memory.

[0074] The memory may include non-permanent memory in a computer-readable medium, random access memory (RAM) and / or non-volatile memory in the form of read-only memory (ROM) or flash RAM. The memory is an example of a computer-readable medium.

[0075] Computer readable media include permanent and non-permanent, removable and non-removable media that can be implemented by any method or technology to store information. Information can be computer readable instructions, data structures, program modules or other data. Examples of computer storage media include, but are not limited to, phase change memory (PRAM), static random access memory (SRAM), dynamic random access memory (DRAM), other types of random access memory (RAM), read-only memory (ROM), electrically erasable programmable read-only memory (EEPROM), flash memory or other memory technology, compact disk read-only memory (CD-ROM), digital versatile disk (DVD) or other optical storage, magnetic cassettes, magnetic tape magnetic disk storage or other magnetic storage devices or any other non-transmission media that can be used to store information that can be accessed by a computing device. As defined herein, computer readable media does not include temporary computer readable media (transitory media), such as modulated data signals and carrier waves.

[0076] It should also be noted that the terms "include", "comprises" or any other variations thereof are intended to cover non-exclusive inclusion, so that a process, method, commodity or device including a series of elements includes not only those elements, but also other elements not explicitly listed, or also includes elements inherent to such process, method, commodity or device. In the absence of more restrictions, the elements defined by the sentence "comprises a ..." do not exclude the existence of other identical elements in the process, method, commodity or device including the elements.

[0077] The above are only embodiments of the present application and are not intended to limit the present application. For those skilled in the art, the present application may have various changes and variations. Any modification, equivalent replacement, improvement, etc. made within the spirit and principle of the present application should be included within the scope of the claims of the present application.

Claims

1. A method for displaying index management, characterized in that: The method includes: Set up multiple pages on the VUE front end, including: indicator standard maintenance page, basic item indicator maintenance page, composite item indicator maintenance page, and indicator operation page; The JAVA backend stores indicator-related tables; the indicator-related tables include: indicator configuration table, indicator detailed configuration table and indicator landing library table; Based on the multiple pages, obtain the user's operation on the VUE front end, where the operation includes configuration operation, calculation operation and query operation; Mapping the configuration operation to a table operation on the indicator-related table, mapping the calculation operation to a call execution operation on the indicator calculation program, and forwarding the query operation to a corresponding interface of the data warehouse where the indicator-related table is located; Obtain the execution result, and feed the execution result back to the VUE front end as feedback for the operation.

2. The method according to claim 1, characterized in that The indicator standard maintenance page provides indicator adding function and indicator editing function through corresponding buttons; The indicator editing function can maintain the basic attributes, business attributes, management attributes and technical attributes of the indicator; The business attributes include key value classification for the indicator. After the key value classification is determined, key value data acquisition logic will be generated in the technical attributes; the options for the key value classification include assets and liabilities, profit and loss, cash flow and comprehensive.

3. The method according to claim 1, characterized in that The basic item indicator maintenance page includes: Provides page components for updating the business and technical attributes of indicators; Provide metadata configuration for the indicator when it is stored in the indicator-related table; Provides page components for defining data retrieval logic configuration and key value retrieval logic; and Provides page components for configuring analysis dimension mapping relationships.

4. The method according to claim 1, characterized in that: The composite item indicator maintenance page includes: Determine the candidate key value of the indicator based on the maintenance object of the key value acquisition logic; Display the key values ​​to be selected and set an add button before each key value to be selected. Through the add button, the corresponding key value to be selected is placed into the calculation formula indicator pool. The key values ​​in the calculation formula indicator pool will be used as processing objects when the indicator calculation program is called and executed.

5. The method according to claim 1, characterized in that The indicator operation page includes: Batch calculation / calculation component, used to obtain indicator data by selecting multiple indicators or selecting a single indicator, and synchronize it to data calculation according to the configured indicator calculation program; Preview component, used to jump to the corresponding data preview page based on the filter conditions entered by the user; Batch publishing / publishing component, used to publish unpublished and calculated metrics; Freeze / unfreeze component, used to freeze or unfreeze related indicators when the published indicators are referenced by other indicators; The replacement component is used to replace the published indicator with the indicator corresponding to the indicator code input by the user; A Relationship Check component to view assets that have a reference relationship with the indicator; and The push component is used to push indicator content to the data warehouse based on user operations.

6. The method according to claim 1, characterized in that The computing operation is configured as a scheduled task; The preset process calls the indicator calculation program configured in the JAVA backend based on the set time in the scheduled task, pushes the indicators involved in the indicator calculation program to the data warehouse for calculation, and pulls the calculation log of the data warehouse to the indicator calculation log table for storage; the indicator calculation log table is stored in the JAVA backend.

7. The method according to claim 1, characterized in that The indicator calculation procedure includes: A dynamic internal table establishment module, used to establish a dynamic internal table for storing the indicator data involved in the indicator calculation program; An indicator data acquisition module, used to query and fill in corresponding key values ​​from the indicator-related table based on the indicators in the dynamic internal table; A formula calculation module, used to obtain a calculation result based on the key value and the built-in formula; A data merging module, used for storing the calculation results; and The data replication module is used to merge the stored calculation results into the indicator-related table and delete the dynamic internal table.

8. An indicator management and display system, characterized in that: The system includes: VUE front end, the VUE front end is provided with multiple pages, including: indicator standard maintenance page, basic item indicator maintenance page, composite item indicator maintenance page and indicator operation page; the VUE front end is also configured to: obtain the user's operation on the VUE front end based on the multiple pages, the operation includes configuration operation, calculation operation and query operation; JAVA backend, the JAVA backend stores indicator-related tables; the indicator-related tables include: indicator configuration table, indicator detailed configuration table and indicator landing library table; the JAVA backend is also configured to: map the configuration operation to the table operation on the indicator-related table, map the calculation operation to the call execution operation on the indicator calculation program, forward the query operation to the corresponding interface of the data warehouse where the indicator-related table is located; and obtain the execution result, and feed the execution result back to the VUE front end as feedback for the operation.

9. An electronic device, characterized in that: include: at least one processor; a memory connected to the at least one processor; The memory stores instructions that can be executed by the at least one processor, and the at least one processor implements the steps of the indicator management and display method described in any one of claims 1 to 7 by executing the instructions stored in the memory.

10. A computer-readable storage medium having a computer program / instruction stored thereon, characterized in that: When the computer program / instructions are executed by a processor, the steps of the indicator management and display method described in any one of claims 1 to 7 are implemented.

Images