Dimension management display method and system and electronic equipment

Abstract

The embodiment of the invention provides a dimension management display method and system and electronic equipment, and relates to the technical field of dimension management. The dimension management display method comprises the following steps: displaying a dimension management menu at the front end of VUE; a dimension operation button is displayed on the dimension management menu; the JAVA rear end defines the dimension as one of a basic dimension, a conversion dimension and a new dimension value dimension according to whether the dimension can directly map a standard information object in a preset data warehouse; storing the basic dimension, the conversion dimension and the newly-added dimension value dimension in a sub-table manner, and storing the basic dimension, the conversion dimension, the newly-added dimension value dimension and a mapping relation among values through a table; and the JAVA rear end performs corresponding operation on a table based on the operation on the dimension operation button acquired by the VUE front end, and then obtains an operation result and returns the operation result to the VUE front end as feedback of the operation on the dimension operation button. According to the implementation mode provided by the invention, flexible and complete dimension management display is provided.

Description

Technical Field

[0001] The present invention relates to the technical field of dimension management, and in particular to a dimension management display system, a dimension 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. However, the data sources in enterprises are complex, diverse, of varying quality, and belong to different businesses. Data governance is an important part of the digital transformation of enterprises. It promotes the orderly management and circulation of data, and plays an important role in promoting the digital transformation of enterprises and the digital construction of enterprises. Report analysis in enterprises requires dimensions, which are defined in various departments. For example, business attribute definitions and technical attribute definitions have inconsistent dimensions, various changes, inability to convert dimensions, and inability to flexibly expand dimension values. When business users use dimensions for analysis, they often have inconsistent calibers, resulting in inconsistent analysis results and obstacles to business management decisions.

[0003] ADSO: Advanced DataStore Object, advanced data storage object. Summary of the invention

[0004] The purpose of the embodiments of the present invention is to provide a dimension management and display method, system and electronic device, which can enable users to self-configure dimensions, flexibly convert dimensions, add new dimension values ​​and other operations, so as to at least solve some problems in the background technology.

[0005] In order to achieve the above-mentioned purpose, a dimension management display method is provided in the present invention, which comprises: displaying a dimension management menu on a VUE front end; dimension operation buttons are displayed on the dimension management menu, and the dimension operation buttons include: at least one of a new dimension button, a conversion dimension button, a new dimension value button, an association check button, a batch export button, a query preview button, a dimension freeze button and a relationship mapping button; a JAVA back end defines a dimension as one of a basic dimension, a conversion dimension and a new dimension value dimension according to whether the dimension can directly map a standard information object in a preset data warehouse; the basic dimension, the conversion dimension and the new dimension value dimension are stored in separate tables and the mapping relationship between the basic dimension, the conversion dimension and the new dimension value dimension and the values ​​are stored in the table; the JAVA back end performs corresponding operations on the table based on the operation of the dimension operation button obtained by the VUE front end, and obtains the operation result and returns it to the VUE front end as feedback on the operation of the dimension operation button.

[0006] Optionally, a remote function call interface is uniformly used for metadata collection of the preset data warehouse; the remote function call interface includes: at least one of: an information object collection interface, an ADSO collection interface, a table collection interface, a metadata object lineage collection interface and a metadata object data preview interface; the input parameters of the remote function call interface include: an object code and an object description; the output parameters of the remote function call interface include: metadata object basic information and metadata object detailed information.

[0007] Optionally, the JAVA backend defines the dimension as one of a basic dimension, a conversion dimension, and a newly added dimension value dimension according to whether the dimension can directly map a standard information object in a preset data warehouse, including: if the dimension can directly correspond to a standard information object in a preset data warehouse without logical processing, the dimension is defined as a basic dimension; if the dimension cannot directly map a standard information object in a preset data warehouse and needs to be recombined and classified based on the basic dimension, the dimension is defined as a conversion dimension; if the dimension needs to be configured with a new dimension value, calculation logic, or associated indicators before it can directly correspond to a standard information object in a preset data warehouse, the dimension is defined as a newly added dimension value dimension.

[0008] Optionally, the basic dimensions, conversion dimensions and newly added dimension value dimensions are stored in separate tables and the mapping relationships between the basic dimensions, conversion dimensions and newly added dimension value dimensions and values ​​are stored through tables, including: storing the basic dimensions, conversion dimensions and newly added dimension value dimensions in a basic dimension master table, a conversion dimension master table and a newly added dimension value dimension master table respectively; storing the mapping relationships between the basic dimensions, conversion dimensions and newly added dimension value dimensions in multiple mapping relationship tables respectively; storing the mapping relationships between the values ​​of the basic dimensions, conversion dimensions and newly added dimension value dimensions in multiple value mapping relationship tables respectively.

[0009] The present invention also provides a dimension management and display system, which includes: a VUE front end, the VUE front end displays a dimension management menu; dimension operation buttons are displayed on the dimension management menu, and the dimension operation buttons include: at least one of a new dimension button, a conversion dimension button, a new dimension value button, an association check button, a batch export button, a query preview button, a dimension freeze button and a relationship mapping button; a JAVA back end, the JAVA back end includes: a dimension judgment module, which is used to define the dimension as one of a basic dimension, a conversion dimension and a new dimension value dimension according to whether the dimension can directly map a standard information object in a preset data warehouse; a dimension storage module, which is used to store the basic dimension, the conversion dimension and the new dimension value dimension in separate tables and store the mapping relationship between the basic dimension, the conversion dimension and the new dimension value dimension and the value through the table; and an execution feedback module, which is used to perform corresponding operations on the table based on the operation of the dimension operation button obtained by the VUE front end, and return the operation result to the VUE front end as feedback on the operation of the dimension operation button.

[0010] Optionally, a remote function call interface is uniformly used for metadata collection of the preset data warehouse; the remote function call interface includes: at least one of: an information object collection interface, an ADSO collection interface, a table collection interface, a metadata object lineage collection interface and a metadata object data preview interface; the input parameters of the remote function call interface include: an object code and an object description; the output parameters of the remote function call interface include: metadata object basic information and metadata object detailed information.

[0011] Optionally, the JAVA backend defines the dimension as one of a basic dimension, a conversion dimension, and a newly added dimension value dimension according to whether the dimension can directly map a standard information object in a preset data warehouse, including: if the dimension can directly correspond to a standard information object in a preset data warehouse without logical processing, the dimension is defined as a basic dimension; if the dimension cannot directly map a standard information object in a preset data warehouse and needs to be recombined and classified based on the basic dimension, the dimension is defined as a conversion dimension; if the dimension needs to be configured with a new dimension value, calculation logic, or associated indicators before it can directly correspond to a standard information object in a preset data warehouse, the dimension is defined as a newly added dimension value dimension.

[0012] Optionally, the basic dimensions, conversion dimensions and newly added dimension value dimensions are stored in separate tables and the mapping relationships between the basic dimensions, conversion dimensions and newly added dimension value dimensions and values ​​are stored through tables, including: storing the basic dimensions, conversion dimensions and newly added dimension value dimensions in a basic dimension master table, a conversion dimension master table and a newly added dimension value dimension master table respectively; storing the mapping relationships between the basic dimensions, conversion dimensions and newly added dimension value dimensions in multiple mapping relationship tables respectively; storing the mapping relationships between the values ​​of the basic dimensions, conversion dimensions and newly added dimension value dimensions in multiple value mapping relationship tables respectively.

[0013] The present invention also provides an electronic device, comprising: at least one processor; and 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 dimension management and display method by executing the instructions stored in the memory.

[0014] The present invention 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 dimension management and display method.

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

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

[0017] (1) The embodiments of the present invention realize a comprehensive and unified dimension attribute definition, realize a flexible and convenient dimension logic configuration, and support the definition of basic dimensions, support the conversion of dimensions, and support the addition of new dimension values.

[0018] (2) It solves the problems of inconsistent dimension analysis results for business users, inability to convert dimensions, and inability to flexibly expand dimension values.

[0019] (3) It provides a consistent analytical approach for data analysis, overcoming the decision-making obstacles caused by inconsistent analysis results.

[0020] Other features and advantages of the embodiments of the present invention will be described in detail in the subsequent detailed description. BRIEF DESCRIPTION OF THE DRAWINGS

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

[0022] Figure 1A schematic diagram of the steps of the dimension management display method according to an embodiment of the present invention is shown;

[0023] Figure 2 The schematic diagram shows the architecture of the dimension management and display system according to the embodiment of the present invention. DETAILED DESCRIPTION

[0024] The specific implementation of the embodiment of the present invention 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 invention, and is not used to limit the embodiment of the present invention.

[0025] Figure 1 The following is a schematic diagram showing the steps of the dimension management display method according to an embodiment of the present invention. Figure 1 As shown, a dimension management display method includes:

[0026] S01. Display a dimension management menu on the VUE front end; the dimension management menu displays dimension operation buttons, and the dimension operation buttons include: at least one of a new dimension button, a conversion dimension button, a new dimension value button, an association check button, a batch export button, a query preview button, a dimension freeze button, and a relationship mapping button;

[0027] S02. The JAVA backend defines the dimension as one of a basic dimension, a conversion dimension, and a newly added dimension value dimension according to whether the dimension can be directly mapped to a standard information object in a preset data warehouse;

[0028] S03, storing the basic dimension, conversion dimension and newly added dimension value dimension in separate tables and storing the mapping relationship between the basic dimension, conversion dimension and newly added dimension value dimension and the values ​​in the table;

[0029] S04. The JAVA backend performs corresponding operations on the table based on the operations on the dimension operation buttons obtained by the VUE front end, and returns the obtained operation results to the VUE front end as feedback on the operations on the dimension operation buttons.

[0030] The above implementation method combines the front-end display of the dimension list, the back-end data processing, and the pushing to the data warehouse for storage. This implementation method solves the problem that the business user's dimension analysis results are inconsistent, the dimension cannot be converted, and the dimension value cannot be flexibly expanded.

[0031] In some embodiments of the present invention, the main contents provided by the dimension operation button include: adding new dimensions, converting dimensions, adding new dimension values, association check, batch export, query preview, dimension freezing, relationship preview and other operations, corresponding to the aforementioned add dimension button, convert dimension button, add dimension value button, association check button, batch export button, query preview button, dimension freeze button and relationship mapping button.

[0032] Click the "Data Application Center-Indicator Factory-Dimension Management" menu in the top navigation of the system to enter the dimension management page.

[0033] 1. Add a new dimension. Click the "Add Dimension" button to enter the Add Dimension page. Existing dimension codes and dimension names cannot be added. Fields with a red "*" are required. Select Basic Dimension as the dimension type and fill in different dimension data. After filling in the data according to the form information, click "Save" to save this dimension. The status of the added dimension is "Unpublished" and the synchronization status is "Not Synchronized".

[0034] 2. Convert dimension. Click the "Add dimension" button to enter the add dimension page. Existing dimension codes and dimension names cannot be added. Fields with a red "*" are required. Select the conversion dimension as the dimension type, and fill in different dimension data. After filling in the data according to the form information, click "Save" to save this dimension. The status of the newly added dimension is "Unpublished" and the synchronization status is "Not Synchronized".

[0035] 3. Add dimension value. You can add dimension value only when the dimension type is conversion dimension. You can use manual maintenance and batch import. Manual dimension value code and dimension value description, click the "+" button to add dimension value items, click the "-" button to delete dimension value items.

[0036] 4. Association check. Check a single dimension and click the "Association check" button to view the assets related to the dimension. You can list the number of references to basic item indicators, composite item indicators, APIs, visualization-Report, and visualization-BI, and display the specific references downwards; if the basic item indicator is referenced once, expand it downwards to list the referenced indicator names.

[0037] 5. Batch export. Check one or more dimensions and click the "Batch Export" button. You can export one or more dimensions, and export them in batches according to attributes or dimension values. The exported dimensions are displayed on different Sheet pages in the document. The exported dimension values ​​are dimension codes and dimension descriptions; the exported attributes are all attributes of the dimension. Note: Only dimensions with a synchronization status of "Successful Synchronization" can be exported.

[0038] 6. Query Preview. Click the "Query Preview" button in the dimension operation column to open the dimension details page and display the detailed information of the dimension. The page fields are grayed out and cannot be modified. Click the "Preview" button in the dimension operation column to display the data of this dimension in a pop-up window. This pop-up window supports fuzzy queries based on dimension value descriptions or dimension codes, and can export data.

[0039] 7. Dimension Freeze. Click the "Dimension Freeze" button in the dimension operation column to freeze the dimension that is not in use temporarily. After freezing, the dimension status is "Frozen". Only published dimensions can be frozen. After freezing, it will no longer support references and data synchronization functions by other assets such as indicators and APIs. If you need to reuse it in the future, click the "Unfreeze" button of the dimension to unfreeze it. After unfreezing, the dimension status will be "Unpublished".

[0040] 8. Relationship mapping. Click the "Relationship mapping" button in the dimension operation column to pop up the relationship mapping operation window. You can establish a non-standard dimension mapping relationship based on the standard dimension, save it and push it to BW. Import dimension information into Excel according to the dimension attribute template. The basic dimension uses field mapping to map the dimension value relationship, and the conversion dimension uses conversion mapping to map the dimension value relationship. You can enter or select the search conditions "mapping object name, mapping method", click the "query" button to query the corresponding information that matches the conditions. If there is no data matching the conditions, it will prompt "no data"; click the "reset" button to clear all search conditions and query all dimensions. Click the "add relationship mapping" button to enter the add relationship mapping page. Fields with a red "*" are mandatory. Different dimension value data needs to be filled in according to the selected mapping method (conversion mapping, field mapping). After filling in the data according to the form information, click "save" to save this dimension. Click the "view" button in the operation column to open the mapping details page to display the detailed information of the relationship mapping. The page fields are grayed out and cannot be modified. Click the "Edit" button in the dimension operation column to open the mapping editing page and edit the relationship mapping information. Click the "Delete" button in the operation column to delete the mapping.

[0041] Through the above implementation methods, a rich range of operation options are provided to users on the VUE front end, making the dimension management display more personalized and meeting the different operations and different needs of users.

[0042] In some embodiments of the present invention, the metadata collection of the preset data warehouse uniformly adopts a remote function call interface; the metadata collection of the data warehouse uniformly adopts an RFC (Remote Function Call) interface. The remote function call interface can be determined according to the collection object, for example, including at least one of: information object collection interface ZIOBJ_GET_DETAIL, ADSO collection interface ZADSO_GET_DETAIL, table collection interface ZTABLE_GET_DETAIL, metadata object lineage collection interface ZTRFN_GET_DETAIL and metadata object data preview interface ZPROVIDER_GET_CONTENT. The input parameters of the remote function call interface include: object code and object description. The parameter name of the object code is "I_ZO_ID", which transmits the code of the collection object. According to the different types of collection objects, the corresponding technical name is input. The parameter name of the object description is "I_ZO_NAME", which transmits the description of the collection object. According to the different types of collection objects, the corresponding description is input. The output parameters of the remote function call interface include: metadata object basic information and metadata object detailed information. The parameter name of the metadata object basic information is "T_VIEW", which outputs the basic information of the collection object, such as the creator, creation date, information range, etc. The parameter name of the metadata object detailed information is "T_DETAIL", which outputs the detailed information of the collection object, such as the background table, table structure, etc. T_DETAIL detailed structure. This implementation method provides a unified interface for the front end and the back end to call through the metadata interface design.

[0043] In some embodiments of the present invention, the JAVA backend defines the dimension as one of the basic dimension, the conversion dimension and the newly added dimension value dimension according to whether the dimension can directly map the standard information object in the preset data warehouse, including: if the dimension can directly correspond to the standard information object in the preset data warehouse without logical processing, the dimension is defined as the basic dimension; if the dimension cannot directly map the standard information object in the preset data warehouse, it needs to be recombined and classified based on the basic dimension, then the dimension is defined as the conversion dimension; if the dimension needs to be configured with a new dimension value, calculation logic or associated indicators before it can directly correspond to the standard information object in the preset data warehouse, then the dimension is defined as the newly added dimension value dimension. The preset data warehouse is preferably BW / 4HANA. For example, the newly added dimension value dimension in the source system C22 is a plate, and the plate dimension already has a field in C22, such as storage in the local plate, and there is a dimension value list. However, in subsequent analysis applications, new dimension values ​​need to be added to meet the subtotal summary analysis requirements of different levels of the plate. The newly added dimension value source system in the source system PC22 is identified as C2Z. The newly added dimension value involves the data of the distribution indicator. During the extraction process of the source system, the data related to the plate is also added. The source system of the newly added dimension value needs to be re-identified.

[0044] In some embodiments of the present invention, the basic dimension, conversion dimension and newly added dimension value dimension are stored in separate tables and the mapping relationship between the basic dimension, conversion dimension and newly added dimension value dimension and the value is stored through the table, including: the basic dimension, conversion dimension and newly added dimension value dimension are stored in the basic dimension master table, conversion dimension master table and newly added dimension value dimension master table respectively; the mapping relationship between the basic dimension, conversion dimension and newly added dimension value dimension is stored in multiple mapping relationship tables respectively; the mapping relationship between the value of the basic dimension, conversion dimension and newly added dimension value dimension is stored in multiple value mapping relationship tables respectively. All of the above tables are operation objects of step S04. The conversion dimension belongs to the newly added dimension in the data service management system, and the design of the background storage table of its processing logic (based on the basic dimension) is described as follows. The following is only an example, and not all tables are listed. The basic dimension master table stores the basic information of the basic dimension and the corresponding standard information object related information of the preset data warehouse. The conversion dimension master data table stores the dimension value list of the conversion dimension. The conversion dimension relationship definition table stores the mapping relationship between the conversion dimension and the basic dimension. The common dimension value maintenance table stores the value mapping relationship between the conversion dimension and the basic dimension. The extraction layer model in the basic data warehouse stores the original data extracted from the business source system, so the extraction layer model only contains basic dimension fields. In the subsequent P layer model, the conversion dimension is added to lay a solid foundation for the subsequent generation of basic indicator data.

[0045] Based on the same inventive concept, an embodiment of the present invention also provides a dimension management and display system. Figure 2The schematic diagram of the architecture of the dimension management and display system according to the embodiment of the present invention is shown schematically. Figure 2 As shown, the system includes: a VUE front end, the VUE front end displays a dimension management menu; dimension operation buttons are displayed on the dimension management menu, and the dimension operation buttons include: at least one of a new dimension button, a conversion dimension button, a new dimension value button, an association check button, a batch export button, a query preview button, a dimension freeze button and a relationship mapping button; a JAVA back end, the JAVA back end includes: a dimension judgment module, which is used to define the dimension as one of a basic dimension, a conversion dimension and a new dimension value dimension according to whether the dimension can directly map the standard information object in the preset data warehouse; a dimension storage module, which is used to store the basic dimension, the conversion dimension and the new dimension value dimension in separate tables and store the mapping relationship between the basic dimension, the conversion dimension and the new dimension value dimension and the value through the table; and an execution feedback module, which is used to perform corresponding operations on the table based on the operation of the dimension operation button obtained by the VUE front end, and return the operation result to the VUE front end as feedback on the operation of the dimension operation button.

[0046] In some optional embodiments of the present invention, a remote function call interface is uniformly used for metadata collection of the preset data warehouse; the remote function call interface includes: at least one of: an information object collection interface, an ADSO collection interface, a table collection interface, a metadata object lineage collection interface and a metadata object data preview interface; the input parameters of the remote function call interface include: an object code and an object description; the output parameters of the remote function call interface include: metadata object basic information and metadata object detailed information.

[0047] In some optional embodiments of the present invention, the JAVA backend defines the dimension as one of a basic dimension, a conversion dimension, and a newly added dimension value dimension according to whether the dimension can directly map the standard information object in the preset data warehouse, including: if the dimension can directly correspond to the standard information object in the preset data warehouse without logical processing, the dimension is defined as a basic dimension; if the dimension cannot directly map the standard information object in the preset data warehouse and needs to be recombined and classified based on the basic dimension, the dimension is defined as a conversion dimension; if the dimension needs to be configured with a new dimension value, calculation logic or related indicators before it can directly correspond to the standard information object in the preset data warehouse, the dimension is defined as a newly added dimension value dimension.

[0048] In some optional embodiments of the present invention, the basic dimensions, conversion dimensions and newly added dimension value dimensions are stored in separate tables and the mapping relationships between the basic dimensions, conversion dimensions and newly added dimension value dimensions and values ​​are stored through tables, including: the basic dimensions, conversion dimensions and newly added dimension value dimensions are stored in the basic dimension master table, the conversion dimension master table and the newly added dimension value dimension master table respectively; the mapping relationships between the basic dimensions, conversion dimensions and newly added dimension value dimensions are stored in multiple mapping relationship tables respectively; the mapping relationships between the values ​​of the basic dimensions, conversion dimensions and newly added dimension value dimensions are stored in multiple value mapping relationship tables respectively.

[0049] The specific limitations of each functional module in the above-mentioned dimension management and display system can be found in the limitations of the dimension management and display method above, and will not be repeated here. Each module in the above-mentioned system can be implemented in whole or in part through 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 corresponding operations of each of the above modules. It also realizes comprehensive and unified dimension attribute definition and flexible and convenient dimension logic configuration, which solves the problems of inconsistent dimension analysis results of business users, inability to convert dimensions, and inability to flexibly expand dimension values.

[0050] In some embodiments of the present invention, 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 executes the aforementioned dimension 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 calls the corresponding program unit from the memory. One or more kernels can be set, and the aforementioned method is implemented by adjusting the kernel parameters. The memory may include non-permanent memory in a computer-readable medium, random access memory (RAM) and / or non-volatile memory, such as a read-only memory (ROM) or a flash memory (flash RAM), and the memory includes at least one storage chip.

[0051] In one embodiment of the present invention, a machine-readable storage medium is provided, on which instructions are stored. When the instructions are executed by a processor, the processor is configured to execute the aforementioned dimension management and display method.

[0052] In one embodiment of the present invention, a computer program product is provided, including a computer program, which implements the aforementioned dimension management and display method when executed by a processor.

[0053] 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.

[0054] 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.

[0055] 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.

[0056] 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 in the computer or other programmable device. Figure 1 A process or multiple processes and / or boxes Figure 1 The steps for the functions specified in one or more boxes.

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

[0058] 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.

[0059] 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.

[0060] 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.

[0061] 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 dimension management display method, characterized in that: The method includes: Display the dimension management menu on the VUE front end; The dimension management menu displays dimension operation buttons, which include: at least one of a new dimension button, a convert dimension button, a new dimension value button, an association check button, a batch export button, a query preview button, a dimension freeze button, and a relationship mapping button; The JAVA backend defines the dimension as one of the basic dimension, the conversion dimension, and the newly added dimension value dimension according to whether the dimension can be directly mapped to the standard information object in the preset data warehouse; The basic dimension, the conversion dimension and the newly added dimension value dimension are stored in separate tables and the mapping relationship between the basic dimension, the conversion dimension and the newly added dimension value dimension and the values ​​are stored in the table; The JAVA backend performs corresponding operations on the table based on the operations on the dimension operation buttons obtained by the VUE front end, and returns the operation results to the VUE front end as feedback on the operations on the dimension operation buttons.

2. The method according to claim 1, characterized in that The metadata collection of the preset data warehouse uniformly adopts the remote function call interface; The remote function call interface includes: at least one of an information object acquisition interface, an ADSO acquisition interface, a table acquisition interface, a metadata object lineage acquisition interface, and a metadata object data preview interface; The input parameters of the remote function call interface include: object code and object description; The output parameters of the remote function call interface include: metadata object basic information and metadata object detailed information.

3. The method according to claim 1, characterized in that The JAVA backend defines the dimension as one of the basic dimension, conversion dimension, and newly added dimension value dimension according to whether the dimension can directly map the standard information object in the preset data warehouse, including: If the dimension can directly correspond to a standard information object in a preset data warehouse without logic processing, the dimension is defined as a basic dimension; If the dimension cannot directly map to the standard information object in the preset data warehouse and needs to be re-classified based on the basic dimension, the dimension is defined as a transformation dimension; If the dimension needs to be configured with a new dimension value, calculation logic or associated indicators before it can directly correspond to the standard information object in the preset data warehouse, the dimension is defined as a new dimension value dimension.

4. The method according to claim 1, characterized in that The basic dimension, the conversion dimension and the newly added dimension value dimension are stored in separate tables, and the mapping relationship between the basic dimension, the conversion dimension and the newly added dimension value dimension and the values ​​is stored in the table, including: The basic dimension, the conversion dimension and the newly added dimension value dimension are stored in the basic dimension master table, the conversion dimension master table and the newly added dimension value dimension master table respectively; The mapping relationships among the basic dimension, the conversion dimension and the newly added dimension value dimension are stored in a plurality of mapping relationship tables respectively; The mapping relationships among the values ​​of the basic dimension, the conversion dimension and the newly added dimension value dimension are respectively stored in a plurality of value mapping relationship tables.

5. A dimension management and display system, characterized in that: The system includes: VUE front end, the VUE front end displays a dimension management menu; the dimension management menu displays dimension operation buttons, and the dimension operation buttons include: at least one of a new dimension button, a conversion dimension button, a new dimension value button, an association check button, a batch export button, a query preview button, a dimension freeze button, and a relationship mapping button; JAVA backend, the JAVA backend includes: A dimension judgment module, used to define a dimension as one of a basic dimension, a conversion dimension and a newly added dimension value dimension according to whether the dimension can directly map a standard information object in a preset data warehouse; A dimension storage module is used to store the basic dimension, conversion dimension and newly added dimension value dimension in separate tables and store the mapping relationship between the basic dimension, conversion dimension and newly added dimension value dimension and values ​​through tables; and An execution feedback module is used to perform corresponding operations on the table based on the operation of the dimension operation button obtained by the VUE front end, and return the operation results to the VUE front end as feedback on the operation of the dimension operation button.

6. The system according to claim 5, characterized in that The metadata collection of the preset data warehouse uniformly adopts the remote function call interface; The remote function call interface includes: at least one of an information object acquisition interface, an ADSO acquisition interface, a table acquisition interface, a metadata object lineage acquisition interface, and a metadata object data preview interface; The input parameters of the remote function call interface include: object code and object description; The output parameters of the remote function call interface include: metadata object basic information and metadata object detailed information.

7. The system according to claim 5, characterized in that The JAVA backend defines the dimension as one of the basic dimension, conversion dimension, and newly added dimension value dimension according to whether the dimension can directly map the standard information object in the preset data warehouse, including: If the dimension can directly correspond to a standard information object in a preset data warehouse without logic processing, the dimension is defined as a basic dimension; If the dimension cannot directly map to the standard information object in the preset data warehouse and needs to be re-classified based on the basic dimension, the dimension is defined as a transformation dimension; If the dimension needs to be configured with a new dimension value, calculation logic or associated indicators before it can directly correspond to the standard information object in the preset data warehouse, the dimension is defined as a new dimension value dimension.

8. The system according to claim 5, characterized in that The basic dimension, the conversion dimension and the newly added dimension value dimension are stored in separate tables, and the mapping relationship between the basic dimension, the conversion dimension and the newly added dimension value dimension and the values ​​is stored in the table, including: The basic dimension, the conversion dimension and the newly added dimension value dimension are stored in the basic dimension master table, the conversion dimension master table and the newly added dimension value dimension master table respectively; The mapping relationships among the basic dimension, the conversion dimension and the newly added dimension value dimension are stored in a plurality of mapping relationship tables respectively; The mapping relationships among the values ​​of the basic dimension, the conversion dimension and the newly added dimension value dimension are respectively stored in a plurality of value mapping relationship tables.

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 dimension management and display method described in any one of claims 1 to 4 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 dimension management and display method described in any one of claims 1 to 4 are implemented.

Images