CN110633267B - Method and system capable of supporting multi-service report function - Google Patents
Method and system capable of supporting multi-service report function Download PDFInfo
- Publication number
- CN110633267B CN110633267B CN201910931427.6A CN201910931427A CN110633267B CN 110633267 B CN110633267 B CN 110633267B CN 201910931427 A CN201910931427 A CN 201910931427A CN 110633267 B CN110633267 B CN 110633267B
- Authority
- CN
- China
- Prior art keywords
- service
- data
- business
- organization
- report
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Active
Links
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/21—Design, administration or maintenance of databases
- G06F16/211—Schema design and management
- G06F16/212—Schema design and management with details for data modelling support
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/24—Querying
- G06F16/248—Presentation of query results
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q10/00—Administration; Management
- G06Q10/10—Office automation; Time management
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q40/00—Finance; Insurance; Tax strategies; Processing of corporate or income taxes
- G06Q40/12—Accounting
- G06Q40/125—Finance or payroll
Abstract
The invention discloses a method and a system capable of supporting multi-service report function, relating to the technical field of report data management; establishing a business data index system model with dimensions and indexes as attributes, establishing a business context model for providing basic information for a report, forming a mapping relation between business data and the business data index system model as well as between the business data index system model and the business context model, and forming a business report by utilizing the business data index system model and the business context model according to the mapping relation and business requirements; the method of the invention abstracts the context of each service into a general service context model, abstracts the data of different services into a service data index system model, can split the complete report function into different functional components, facilitates each service to flexibly expand different reports according to the characteristics of the service, satisfies the report requirements of different services, and simultaneously wildly matches different services, and simplifies the development process of service reports.
Description
Technical Field
The invention discloses a method and a system capable of supporting multi-service report function, and relates to the technical field of report data management.
Background
ERP is an abbreviation for enterprise resource planning systems, which include subsystems such as supply chain management, finance, budget, manpower, etc., typically developed in a modular manner, each of which is an independent module.
The business report is one of the most common situations for displaying and analyzing data, and the business data can provide valuable information for management through report display, so that management and decision-making can be performed. The ERP system has various report forms, such as financial report forms, budget report forms, and the data query of each business system can be regarded as a report form. The basic functions of the report form have extremely high similarity, but the data structure of the business has extremely high variability, and the variability brings difficulty to the development of the report form and is not easy to maintain. The invention discloses a method and a system capable of supporting multi-service report function, which are used for providing a report function framework for each service module on the basis of an ERP system, dividing the complete report function into different functional components by abstraction, abstracting the context of each service into a universal context model, abstracting the data of different services into a universal index model, and being capable of flexibly expanding different reports according to the characteristics of the service per se by each service module and meeting the report requirements of different service modules.
Disclosure of Invention
Aiming at the problems in the prior art, the invention provides a method and a system capable of supporting multi-service report function, which can facilitate each service module to flexibly expand different reports according to the characteristics of the service and meet the report requirements of different service modules.
The specific scheme provided by the invention is as follows:
a method for supporting multi-service report function: establishing a business data index system model with dimensions and indexes as attributes,
a business context model is established that provides the basis information for the report,
forming a mapping relation between the service data and the service data index system model and the service context model,
and forming a service report by using the service data index system model and the service context model according to the mapping relation and the service requirements.
In the method, a physical storage structure in which service data is arranged is used as a data source, the service data obtained by the data source is arranged into structured data, and the structured data is pushed to a service data index system model and a service context model.
In the method, fields in the structured data form a mapping relation with indexes and dimensions.
In the method, indexes in the service data index system model are attribute information for describing service meaning and data type of data, dimensions are attribute information for a time set, a space set and a service information set of service occurrence, and a group of indexes and dimensions form an index system of the service.
In the method, the attribute information of the business system and the attribute information of part of dimensions in the business context model form the basic information of the report.
In the method, the business context model controls the organization category, organization structure and organization of business in report context by using an organization tree.
In the method, the service data and the corresponding fields of the organization tree form a mapping relation.
A system capable of supporting multi-service report function comprises a model building module, a mapping module and a report generating module,
the model building module builds a business data index system model with dimensions and indexes as attributes,
simultaneously, a business context model for providing basic information for the report forms is established,
the mapping module forms a mapping relation between the service data and the service data index system model and between the service data and the service context model,
and the report generating module forms a service report by utilizing the service data index system model and the service context model according to the mapping relation and the service requirement.
The system also comprises a configuration module, wherein the configuration module configures a physical storage structure where the service data is located as a data source, sorts the service data obtained by the data source into structured data, and then pushes the structured data to the mapping module and the report generation module respectively.
The fields in the structured data received by the mapping module in the system and indexes and dimensions in the service data index system model form a mapping relation.
The invention has the advantages that:
the invention provides a method capable of supporting multi-service report function, which comprises the steps of establishing a service data index system model with dimension and index as attributes, establishing a service context model for providing basic information for a report, forming a mapping relation between service data and the service data index system model as well as between the service data and the service context model, and forming a service report by utilizing the service data index system model and the service context model according to the mapping relation and service requirements; the method of the invention abstracts the context of each service into a general service context model, abstracts the data of different services into a service data index system model, can split the complete report function into different functional components, facilitates each service to flexibly expand different reports according to the characteristics of the service, satisfies the report requirements of different services, and simultaneously wildly matches different services, and simplifies the development process of service reports.
Drawings
FIG. 1 is a schematic flow chart of the method of the present invention;
FIG. 2 is a diagram of a report interface of the system of the present invention;
FIG. 3 is a diagram illustrating a report interface of the system of the present invention.
Detailed Description
The invention provides a method capable of supporting multi-service report function: establishing a business data index system model with dimensions and indexes as attributes,
a business context model is established that provides the basis information for the report,
forming a mapping relation between the service data and the service data index system model and the service context model,
and forming a service report by using the service data index system model and the service context model according to the mapping relation and the service requirements.
Simultaneously, a system which can support the multi-service report function and corresponds to the method is provided, which comprises a model building module, a mapping module and a report generating module,
the model building module builds a business data index system model with dimensions and indexes as attributes,
simultaneously, a business context model for providing basic information for the report forms is established,
the mapping module forms a mapping relation between the service data and the service data index system model and between the service data and the service context model,
and the report generating module forms a service report by utilizing the service data index system model and the service context model according to the mapping relation and the service requirement.
The present invention will be further described with reference to the accompanying drawings and specific examples, which are not intended to be limiting, so that those skilled in the art will better understand the invention and practice it.
The method of the invention can support the multi-service report function aiming at the ERP service system, and comprises the following specific processes:
establishing a business data index system model with dimensions and indexes as attributes, wherein the business data index system model represents all business data by using dimensions and indexes, wherein the indexes describe business meaning and data types of the data, the dimensions are attribute information of a time set, a space set and a business information set for business occurrence, a group of indexes and dimensions form an index system of the business, and the initial and future balances of bank deposit are taken as an example in fig. 3: the bank deposit is an index, the business meaning is money stored in a bank, the data type is that the currency unit is the element, the precision is 2 bits after the decimal point, and the dimension is: organizing, annual, during, accounting cycle, lending direction; any explicit business data can be modeled;
establishing a business context model for providing basic information for a report, wherein the attribute information of an ERP business system and the attribute information of a part of dimensions in the business context model form the basic information of the report, the attribute information belonging to the dimensions is organized, the information of year, period and the like, the attribute information belonging to the ERP system is organized, the information of an accounting calendar configuration, period type, business configuration and the like, and an extensible attribute and the like, in FIG. 3, the dimension of an accounting cycle lending direction is in the table, organized, the year, the period then belongs to the context of the report, the report system is except for a part of the dimension of data, and system attributes such as organization structure information so as to summarize the data, the accounting calendar configuration is used for processing the difference between accounting period and natural period, the period type information is used for switching period and the like,
the business context model uses the organizational tree to control the organization category, organization structure and organization of business in the report context,
configuring a physical storage structure where service data is located as a data source, sorting the service data obtained by the data source into structured data, pushing the structured data to a service data index system model and a service context model to enable the structured data, the service data index system model and the service context model to form a mapping relation, wherein fields in the structured data, indexes and dimensions form a one-to-one mapping relation, and the structured data and corresponding fields of an organization tree form a mapping relation;
and forming a service report by using the service data index system model and the service context model according to the mapping relation and the service requirements.
In the above procedure, the business context model controls the organization category, organization structure, organization tree in the context using an organization tree that defines several canonical fields containing: the method comprises the steps of carrying out corresponding field mapping on an organization tree used by each business in ERP, wherein the organization hierarchy code and the father node are used for representing a tree structure, one field can be selected for mapping, the other fields are mapped one by one, then a business report is formed by utilizing a business data index system model and a business context model according to a mapping relation and according to business requirements, the business context model and the business data index system model can be stored for reuse, the business data index system model can be stored by adopting a relational database, each dimension and index in a data index system can be a single column, and if the total number of dimensions and indexes in the system exceeds 300, the sub-table storage can be carried out.
The system can support the multi-service report function based on the ERP service system, and comprises the following specific processes:
the model building module builds a business data index system model with dimensions and indexes as attributes, the business data index system model represents all business data by using dimensions and indexes, wherein the indexes describe business meaning and data types of the data, the dimensions are attribute information of a time set, a space set and a business information set of business occurrence, a group of indexes and the dimensions form an index system of the business, and the initial and final balance of bank deposit is taken as an example in fig. 3: the bank deposit is an index, the business meaning is money stored in a bank, the data type is that the currency unit is the element, the precision is 2 bits after the decimal point, and the dimension is: organizing, annual, during, accounting cycle, lending direction; any explicit business data can be modeled;
establishing a business context model for providing basic information for a report, wherein the attribute information of an ERP business system and the attribute information of a part of dimensions in the business context model form the basic information of the report, the attribute information belonging to the dimensions is organized, the information of year, period and the like, the attribute information belonging to the ERP system is organized, the information of an accounting calendar configuration, period type, business configuration and the like, and an extensible attribute and the like, in FIG. 3, the dimension of an accounting cycle lending direction is in the table, organized, the year, the period then belongs to the context of the report, the report system is except for a part of the dimension of data, and system attributes such as organization structure information so as to summarize the data, the accounting calendar configuration is used for processing the difference between accounting period and natural period, the period type information is used for switching period and the like,
the business context model uses the organizational tree to control the organization category, organization structure and organization of business in the report context,
the configuration module configures a physical storage structure where the service data is located as a data source, sorts the service data obtained by the data source into structured data, and then pushes the structured data to the mapping module and the report generation module, wherein the mapping module enables the structured data, the service data index system model and the service context model to form a mapping relation, fields in the structured data, indexes and dimensions form a one-to-one mapping relation, and the structured data and corresponding fields of an organization tree form a mapping relation;
and the report generating module forms a service report by utilizing the service data index system model and the service context model according to the mapping relation and the service requirement.
In the above process, the model building module may form a report context by a component framework, so that the business context model controls an organization category, an organization structure, and an organization in the context by using an organization tree, where the organization tree defines several specification fields including: the system comprises a unique identification, a number, a name, an organization grading code, a father node, whether details, an organization type and the like, wherein the organization grading code and the father node are used for representing a tree structure, one field can be selected for mapping, the other fields can be mapped one by one, a report generating module forms a business report by utilizing a business data index system model and a business context model according to a business requirement according to a mapping relation, the business context model and the business data index system model are stored for reuse, the business storage module stores the business data index system model by utilizing a relational database, each dimension and index in a data index system can be a single column, and if the total number of the dimensions and indexes in the system exceeds 300, the business data index system can be stored in a sub-table.
The above-described embodiments are merely preferred embodiments for fully explaining the present invention, and the scope of the present invention is not limited thereto. Equivalent substitutions and modifications will occur to those skilled in the art based on the present invention, and are intended to be within the scope of the present invention. The protection scope of the invention is subject to the claims.
Claims (2)
1. A method for supporting multi-service report function is characterized by establishing a service data index system model with dimension and index as attributes for ERP service system, wherein the index describes service meaning and data type of data, the dimension is attribute information of time set, space set and service information set for service occurrence, a group of indexes and dimension form an index system of service,
establishing a business context model for providing basic information for the report, wherein the attribute information of the ERP business system and the attribute information of part of dimensions in the business context model form the basic information of the report, the attribute information of the dimensions comprises organization, year and period information, the attribute information of the ERP system comprises an organization structure, accounting calendar configuration, period type, business configuration information and an extensible attribute,
forming a mapping relation between the service data and a service data index system model and between the service data and a service context model, wherein the service context model controls the organization category, organization structure and organization of the service in the report context by using an organization tree,
configuring a physical storage structure of service data as a data source, sorting the service data obtained by the data source into structured data, pushing the structured data to a service data index system model and a service context model, forming a one-to-one mapping relation between fields in the structured data and indexes and dimensions, forming a mapping relation between the structured data and corresponding fields of an organization tree, wherein the canonical fields defined by the organization tree comprise unique identifiers, numbers, names, organization grading codes, father nodes and organization types, mapping the corresponding fields of the organization tree used by each service in the ERP service system, using the organization grading codes and the father nodes to represent a tree structure, optionally mapping one of the fields, mapping the other canonical fields one by one,
and forming a service report by using the service data index system model and the service context model according to the mapping relation and the service requirements.
2. A system capable of supporting multi-service report function is characterized by comprising a model building module, a mapping module and a report generating module,
the model building module builds a business data index system model with dimension and index as attributes, wherein the index describes business meaning and data type of data, the dimension is attribute information of time set, space set and business information set of business occurrence, a group of index and dimension form an index system of business,
simultaneously establishing a business context model for providing basic information for the report, wherein the attribute information of the ERP business system and the attribute information of part of dimensions in the business context model form the basic information of the report, the attribute information of the dimensions comprises organization, year and period information, the attribute information of the ERP system comprises an organization structure, accounting calendar configuration, period type, business configuration information and an extensible attribute,
the mapping module forms a mapping relation between the service data, the service data index system model and the service context model, controls the organization category, the organization structure and the organization of the service in the report context by using the organization tree through the service context model,
configuring a physical storage structure of service data as a data source, sorting the service data obtained by the data source into structured data, pushing the structured data to a service data index system model and a service context model, forming a one-to-one mapping relation between fields in the structured data and indexes and dimensions, forming a mapping relation between the structured data and corresponding fields of an organization tree, wherein the canonical fields defined by the organization tree comprise unique identifiers, numbers, names, organization grading codes, father nodes and organization types, mapping the corresponding fields of the organization tree used by each service in the ERP service system, representing a tree structure by using the organization grading codes and the father nodes, optionally mapping one of the fields, mapping the other canonical fields one by one,
and the report generating module forms a service report by utilizing the service data index system model and the service context model according to the mapping relation and the service requirement.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201910931427.6A CN110633267B (en) | 2019-09-29 | 2019-09-29 | Method and system capable of supporting multi-service report function |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201910931427.6A CN110633267B (en) | 2019-09-29 | 2019-09-29 | Method and system capable of supporting multi-service report function |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN110633267A CN110633267A (en) | 2019-12-31 |
| CN110633267B true CN110633267B (en) | 2023-09-29 |
Family
ID=68973270
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201910931427.6A Active CN110633267B (en) | 2019-09-29 | 2019-09-29 | Method and system capable of supporting multi-service report function |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN110633267B (en) |
Families Citing this family (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN112053058A (en) * | 2020-09-02 | 2020-12-08 | 平安银行股份有限公司 | Index model generation method and device |
| CN112905631A (en) * | 2020-12-08 | 2021-06-04 | 江苏苏宁云计算有限公司 | Report development method and device based on extensive indexes |
Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| WO2007072501A2 (en) * | 2005-12-19 | 2007-06-28 | Mphasis Bfl Limited | A system and a methodology for providing integrated business performance management platform |
| CN103678590A (en) * | 2013-12-12 | 2014-03-26 | 用友软件股份有限公司 | Report collecting device and report collecting method based on OLAP |
| CN104361137A (en) * | 2014-12-10 | 2015-02-18 | 用友软件股份有限公司 | Device and method for generating data fetching conditions of report form |
| CN108664638A (en) * | 2018-05-15 | 2018-10-16 | 口碑(上海)信息技术有限公司 | Report form generation method based on index system and device |
Family Cites Families (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20060112104A1 (en) * | 2004-11-23 | 2006-05-25 | Lianjun An | Apparatus and method of hosting on-demand business context information |
-
2019
- 2019-09-29 CN CN201910931427.6A patent/CN110633267B/en active Active
Patent Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| WO2007072501A2 (en) * | 2005-12-19 | 2007-06-28 | Mphasis Bfl Limited | A system and a methodology for providing integrated business performance management platform |
| CN103678590A (en) * | 2013-12-12 | 2014-03-26 | 用友软件股份有限公司 | Report collecting device and report collecting method based on OLAP |
| CN104361137A (en) * | 2014-12-10 | 2015-02-18 | 用友软件股份有限公司 | Device and method for generating data fetching conditions of report form |
| CN108664638A (en) * | 2018-05-15 | 2018-10-16 | 口碑(上海)信息技术有限公司 | Report form generation method based on index system and device |
Non-Patent Citations (1)
| Title |
|---|
| 大型企业报表引擎的优化设计与实现;何拥军等;《计算机技术与发展》;20130422(第08期);全文 * |
Also Published As
| Publication number | Publication date |
|---|---|
| CN110633267A (en) | 2019-12-31 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN100568237C (en) | Report form template in the multidimensional enterprise software system generates method and system | |
| CN101111838B (en) | Automated relational schema generation within a multidimensional enterprise software system | |
| CN101111835B (en) | Automated default dimension selection method within a multidimensional enterprise software system | |
| US7970795B2 (en) | Data model development tool | |
| US7979475B2 (en) | Coherent data identification method and apparatus for database table development | |
| US9218409B2 (en) | Method for generating and using a reusable custom-defined nestable compound data type as database qualifiers | |
| US20060259442A1 (en) | System method and program product to estimate cost of integrating and utilizing heterogeneous data sources | |
| US20110231359A1 (en) | Synchronization of relational databases with olap cubes | |
| AU5154500A (en) | Method and apparatus for selecting aggregate levels and cross product levels for a data warehouse | |
| CN101504672A (en) | Method and system for dynamically configuring physical data table | |
| Li et al. | Entity-relationship diagram | |
| CN102346744B (en) | Device for processing materialized table in multi-tenancy (MT) application system | |
| CN110633267B (en) | Method and system capable of supporting multi-service report function | |
| CN115374329B (en) | Method and system for managing enterprise business metadata and technical metadata | |
| CN106372044A (en) | Method for generating typed dimension XBRL (Extensible Business Reporting Language) report based on report form | |
| US5809296A (en) | Method and structure for clustering database tables into classes and presenting each class as an E-R model | |
| KR20050061597A (en) | System and method for generating reports for a versioned database | |
| CN101706818A (en) | Report dynamic filtering method and device | |
| Marotta et al. | Data warehouse design: A schema-transformation approach | |
| US20070255730A1 (en) | Data requirements methodology | |
| CN112100181A (en) | Data resource management method based on sand table | |
| CN111913962A (en) | Multi-dimensional annual detailed fund planning system and method | |
| CN112860899B (en) | Label generation method and device, computer equipment and computer readable storage medium | |
| CN114443779A (en) | Data resource management method and system based on data directory | |
| Katz et al. | Glossary of software reuse terms |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| TA01 | Transfer of patent application right |
Effective date of registration: 20230830 Address after: No. 1036, Shandong high tech Zone wave road, Ji'nan, Shandong Applicant after: Inspur Genersoft Co.,Ltd. Address before: 250100 No. 2877 Kehang Road, Sun Village Town, Jinan High-tech District, Shandong Province Applicant before: SHANDONG INSPUR GENESOFT INFORMATION TECHNOLOGY Co.,Ltd. |
|
| TA01 | Transfer of patent application right | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |