CN114372189A - Processing method and device of user-defined report, storage medium and electronic equipment - Google Patents
Processing method and device of user-defined report, storage medium and electronic equipment Download PDFInfo
- Publication number
- CN114372189A CN114372189A CN202111678345.9A CN202111678345A CN114372189A CN 114372189 A CN114372189 A CN 114372189A CN 202111678345 A CN202111678345 A CN 202111678345A CN 114372189 A CN114372189 A CN 114372189A
- Authority
- CN
- China
- Prior art keywords
- service
- dimension index
- index data
- preset
- query request
- 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.)
- Pending
Links
- 238000003672 processing method Methods 0.000 title claims description 7
- 238000000034 method Methods 0.000 claims description 42
- 230000006870 function Effects 0.000 claims description 30
- 238000012545 processing Methods 0.000 claims description 24
- 230000004048 modification Effects 0.000 claims description 10
- 238000012986 modification Methods 0.000 claims description 10
- 230000008569 process Effects 0.000 description 16
- 238000010586 diagram Methods 0.000 description 10
- 238000011161 development Methods 0.000 description 5
- 230000009471 action Effects 0.000 description 3
- 241000208340 Araliaceae Species 0.000 description 2
- 235000005035 Panax pseudoginseng ssp. pseudoginseng Nutrition 0.000 description 2
- 235000003140 Panax quinquefolius Nutrition 0.000 description 2
- 238000004364 calculation method Methods 0.000 description 2
- 235000008434 ginseng Nutrition 0.000 description 2
- 238000012423 maintenance Methods 0.000 description 2
- 238000006243 chemical reaction Methods 0.000 description 1
- 238000005516 engineering process Methods 0.000 description 1
- 239000000284 extract Substances 0.000 description 1
- 238000000605 extraction Methods 0.000 description 1
- 230000003993 interaction Effects 0.000 description 1
- 238000004519 manufacturing process Methods 0.000 description 1
- 230000008506 pathogenesis Effects 0.000 description 1
- 230000000750 progressive effect Effects 0.000 description 1
Images
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/90—Details of database functions independent of the retrieved data types
- G06F16/95—Retrieval from the web
- G06F16/953—Querying, e.g. by the use of web search engines
-
- 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/22—Indexing; Data structures therefor; Storage structures
- G06F16/2282—Tablespace storage structures; Management thereof
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/90—Details of database functions independent of the retrieved data types
- G06F16/95—Retrieval from the web
- G06F16/953—Querying, e.g. by the use of web search engines
- G06F16/9538—Presentation of query results
Landscapes
- Engineering & Computer Science (AREA)
- Databases & Information Systems (AREA)
- Theoretical Computer Science (AREA)
- Data Mining & Analysis (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Software Systems (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
When a business query request is received, querying preset dimension index data configured in advance in a database to obtain business dimension index data corresponding to the business query request in the database, splicing the business dimension index data through preset splicing logic to obtain a custom report corresponding to the business query request, and displaying the custom report in a preset display mode. Based on the above, the dimension index data related to the personalized report is configured in the database in advance, the dimension index data in the database is queried through the service query request, and the self-defined report corresponding to the service query request, namely the personalized report, is obtained without developing the logic code of the personalized report again, so that the efficiency of obtaining the personalized report is improved.
Description
Technical Field
The present application relates to the field of report processing technologies, and in particular, to a method and an apparatus for processing a custom report, a storage medium, and an electronic device.
Background
With the application of World Wide Web (Web) Management applications in the financial industry, especially in Customer Relationship Management (CRM) systems, for futures companies, because the futures companies have different businesses, some self-defined reports are needed to count data corresponding to the businesses of the futures companies.
At present, when the personalized reports are developed, the personalized reports need to be developed repeatedly each time, for the personalized reports with fixed logic, because the number of the report fields or the sequence of the fields used by each futures company is different, the logic codes of the personalized reports need to be re-developed when the personalized reports are developed, and thus the acquisition efficiency of the personalized reports is reduced.
Disclosure of Invention
In view of this, the application discloses a method and an apparatus for processing a custom report, a storage medium, and an electronic device, and aims to improve efficiency of obtaining a personalized report.
In order to achieve the purpose, the technical scheme is as follows:
the first aspect of the application discloses a method for processing a custom report, which comprises the following steps:
when a service query request is received, querying preset dimension index data configured in advance in a database to obtain service dimension index data corresponding to the service query request; the service dimension index data is used for representing preset dimension index data corresponding to the dimension index query data in the service query request;
and splicing the service dimension index data through preset splicing logic to obtain a self-defined report corresponding to the service inquiry request and displaying the self-defined report.
Preferably, when receiving a service query request, querying preset dimension index data configured in advance in a database to obtain service dimension index data corresponding to the service query request, where the querying includes:
when a service query request is received, acquiring dimension index query data in the service query request;
matching the dimension index query data with preset dimension index data configured in advance in a database;
and when the dimension index query data is consistent with the preset dimension index data, obtaining service dimension index data corresponding to the service query request.
Preferably, the splicing the service dimension index data through a preset splicing logic to obtain and display a custom report corresponding to the service query request includes:
determining an input parameter corresponding to the service dimension index data and an output parameter corresponding to the service dimension index data;
splicing the input parameters and the output parameters through a dynamic structured query language sql to obtain a splicing result; the splicing result is used for representing the corresponding relation between the input parameters and the output parameters;
storing the splicing result in a database;
and determining and displaying a custom report corresponding to the service query request based on the splicing result in the database.
Preferably, the process of configuring the preset dimension index data includes:
acquiring the business requirements of each futures company;
extracting preset service indexes from the service requirements of each futures company; the preset service index is a service index with the same service type under different dimensionalities;
and configuring the preset service index in a database to obtain preset dimension index data.
Preferably, the method further comprises the following steps:
and carrying out self-defining modification operation on the preset dimension index data.
Preferably, the method further comprises the following steps:
and generating a front-end function corresponding to the self-defined report.
The second aspect of the present application discloses a processing apparatus of a custom report, the apparatus includes:
the service query device comprises a determining unit, a searching unit and a processing unit, wherein the determining unit is used for querying preset dimension index data configured in advance in a database when a service query request is received to obtain service dimension index data corresponding to the service query request; the service dimension index data is used for representing preset dimension index data corresponding to the dimension index query data in the service query request;
and the splicing unit is used for splicing the service dimension index data through preset splicing logic to obtain a self-defined report corresponding to the service query request and displaying the self-defined report.
Preferably, the determining unit includes:
the service query system comprises a first acquisition module, a second acquisition module and a third acquisition module, wherein the first acquisition module is used for acquiring dimension index query data in a service query request when the service query request is received;
the matching module is used for matching the dimension index query data with preset dimension index data which is configured in advance in a database;
and the second acquisition module is used for acquiring service dimension index data corresponding to the service query request when the dimension index query data is consistent with the preset dimension index data.
The third aspect of the present application discloses a storage medium, where the storage medium includes stored instructions, and when the instructions are executed, the device where the storage medium is located is controlled to execute the processing method of the custom report form according to any one of the first aspect.
A fourth aspect of the present application discloses an electronic device, which includes a memory, and one or more instructions, where the one or more instructions are stored in the memory and configured to be executed by one or more processors to perform the method for processing a custom report according to any one of the first aspect.
According to the technical scheme, when a service query request is received, preset dimension index data configured in advance in a database are queried to obtain service dimension index data corresponding to the service query request, the service dimension index data are used for representing the preset dimension index data corresponding to the dimension index query data in the service query request, and the service dimension index data are spliced through preset splicing logic to obtain a custom report corresponding to the service query request and displayed. According to the scheme, the dimension index data related to the personalized report is configured in the database in advance, the dimension index data in the database is inquired through the service inquiry request, the self-defined report corresponding to the service inquiry request, namely the personalized report, is obtained, and the logic code of the personalized report does not need to be developed again, so that the efficiency of obtaining the personalized report is improved.
Drawings
In order to more clearly illustrate the embodiments of the present application or the technical solutions in the prior art, the drawings needed to be used in the description of the embodiments or the prior art will be briefly introduced below, it is obvious that the drawings in the following description are only embodiments of the present application, and for those skilled in the art, other drawings can be obtained according to the provided drawings without creative efforts.
FIG. 1 is a schematic structural diagram of a system for processing a custom report according to an embodiment of the present disclosure;
FIG. 2 is a flowchart illustrating a method for processing a custom report according to an embodiment of the present application;
FIG. 3 is a schematic diagram of a display interface of a custom report disclosed in an embodiment of the present application;
FIG. 4 is a schematic diagram of a display interface of another custom report disclosed in the embodiments of the present application;
FIG. 5 is an exemplary diagram of an initially newly added module disclosed in an embodiment of the present application;
fig. 6 is a schematic structural diagram of a processing apparatus for custom reports disclosed in the embodiment of the present application;
fig. 7 is a schematic structural diagram of an electronic device disclosed in an embodiment of the present application.
Detailed Description
The technical solutions in the embodiments of the present application will be clearly and completely described below with reference to the drawings in the embodiments of the present application, and it is obvious that the described embodiments are only a part of the embodiments of the present application, and not all of the embodiments. All other embodiments, which can be derived by a person skilled in the art from the embodiments given herein without making any creative effort, shall fall within the protection scope of the present application.
In this application, the terms "comprises," "comprising," or any other variation thereof, are intended to cover a non-exclusive inclusion, such that a process, method, article, or apparatus that comprises a list of elements does not include only those elements but may include other elements not expressly listed or inherent to such process, method, article, or apparatus. Without further limitation, an element defined by the phrase "comprising an … …" does not exclude the presence of other identical elements in a process, method, article, or apparatus that comprises the element.
As can be seen from the background art, when developing personalized reports, development work needs to be repeated for each time of individually developing personalized reports, and for some personalized reports with fixed logic, because the number of report fields or the sequence of the fields used by each futures company is different, logic codes of the personalized reports need to be re-developed when developing the personalized reports, thereby reducing the efficiency of acquiring the personalized reports.
In order to solve the above problems, the present application discloses a method, an apparatus, a storage medium, and an electronic device for processing a customized report, wherein dimension index data related to a personalized report is configured in a database in advance, the dimension index data in the database is queried through a service query request, and the customized report corresponding to the service query request, i.e., the personalized report, is obtained without newly developing a logic code of the personalized report, thereby improving efficiency of obtaining the personalized report. The specific implementation is illustrated by the following examples.
First, an architecture diagram of a processing system of a self-defined report applicable to the method and apparatus for processing a self-defined report of the present application is described below, and specifically, referring to fig. 1, the processing system of a self-defined report includes a client 11, a server 12, and a database 13. The client 11 includes a self-defined report module function, and the server 12 includes a dimension index maintenance and logic development function and a report foreground function.
The dimension index maintenance and logic development function is the core of the self-defined report foreground function, because all fields and indexes of the automatically generated report are business data of each futures company abstracted in advance.
Logic development and data landing are carried out according to the index logic of each dimension index, for example, the index of the daily dimension of a client generally comprises transaction data of the client dimension, such as indexes of end-of-term equity, current day profit and loss, cash amount, income amount and the like, corresponding index data generation logic is written in advance, and then corresponding logic is executed through daily tasks, so that landing data of the dimension index can be generated. And the dimension index supports extension and modification. This portion of the logic is performed on the server.
The self-defined report module function is a function of displaying and self-defining selection and modification of the foreground according to the dimension indexes generated by the background. The report display is divided into a search condition and a display field, so that a condition index and a display index can be added in a self-defined module. This part of the implementation is performed on the client 11.
The report foreground function is a module generated according to the self-defined report module function, and then the foreground function of the report is generated by using the module generation function carried by the frame. The function of generating the foreground report is executed on the client, and the function of generating the background logic of the self-defined report is executed on the server 12.
The data interaction process among the specific client 11, the server 12 and the database 13 is as follows:
when the server 12 receives a service query request sent by the client 11, the server 12 queries preset dimension index data configured in advance in a database to obtain service dimension index data corresponding to the service query request in the database 13; the service dimension index data is used for representing preset dimension index data corresponding to the dimension index query data in the service query request.
The process of configuring the preset dimension index data in the database by the server 12 is as follows:
the server 12 acquires each service requirement; the business requirements are requirements corresponding to business types of all companies.
The server 12 extracts a preset service index from the service requirement; the preset service index is a service index with the same service type under different dimensions.
The server 12 configures the preset service index in the database to obtain preset dimension index data.
The server 12 performs a custom modification operation on the preset dimension index data.
Specifically, the process of obtaining the service dimension index data corresponding to the service query request in the database 13 is as follows:
when the server 12 receives a service query request sent by the client 11, the server 12 obtains dimension index query data in the service query request.
The server 12 matches the dimension index query data with preset dimension index data configured in advance in the database.
When the dimension index query data is consistent with the preset dimension index data, the service end 12 obtains service dimension index data corresponding to the service query request.
The service end 12 splices the service dimension index data through a preset splicing logic to obtain a self-defined report corresponding to the service query request.
The process of splicing the service dimension index data by the specific server 12 through the preset splicing logic to obtain the user-defined report corresponding to the service query request is as follows:
the server 12 determines an input parameter corresponding to the service dimension index data and an output parameter corresponding to the service dimension index data.
The server 12 splices the input parameters and the output parameters through the dynamic structured query language sql to obtain a splicing result, and stores the splicing result in the database.
The server 12 determines a custom report corresponding to the service query request based on the splicing result in the database.
The client 11 displays the custom report form in a preset display mode.
In the embodiment of the application, the dimension index data related to the personalized report is configured in the database in advance, the dimension index data in the database is queried through the service query request, and the self-defined report corresponding to the service query request, namely the personalized report, is obtained without developing the logic code of the personalized report again, so that the efficiency of obtaining the personalized report is improved.
Referring to fig. 2, a flow diagram of a method for processing a self-defined report disclosed in an embodiment of the present application is shown, where the method for processing a self-defined report mainly includes the following steps:
s201: when a service query request is received, querying preset dimension index data configured in advance in a database to obtain service dimension index data corresponding to the service query request; the service dimension index data is used for representing preset dimension index data corresponding to the dimension index query data in the service query request.
In S201, the service query request may be obtained through the client, or may be obtained through other data information sources. The service query request acquisition mode is not specifically limited in this application.
The process of configuring the preset dimension index data is shown as A1-A3.
A1: acquiring each service requirement; the business requirements are requirements corresponding to business types of all companies.
The method comprises the steps of firstly collecting service requirements of each futures company, extracting common service fields in the service requirements, and maintaining indexes and index logics required by each dimension in an Oracle database, wherein the specific service requirements comprise customer dimensions, business department dimensions, variety exchange dimensions, customer variety dimensions, fund account number dimensions and the like if the specific service requirements are distinguished according to different statistical dimensions.
A2: extracting a preset service index from the service requirement; the preset service index is a service index with the same service type under different dimensions.
The preset service index, i.e. the common service field, refers to the same service logic of different futures companies, such as the same service fields of customer end equity, amount of bargaining, number of taken positions, etc., which have the same service logic and can be abstracted out as the common service field.
For example, from the service requirements of futures company a, the service requirements of futures company B and the service requirements of futures company C, the transaction amount requirement of futures company a, the transaction amount requirement of futures company B and the transaction amount requirement of futures company C are extracted, and the transaction amount requirement is a preset service index (common service field).
A3: and configuring the preset service index in a database to obtain preset dimension index data.
And performing self-defined modification operation on the preset dimension index data.
Specifically, when a service query request is received, based on preset dimension index data configured in advance in a database, a process of determining service dimension index data corresponding to the service query request is as follows:
firstly, when a service query request is received, dimension index query data in the service query request is obtained.
And analyzing the service query request to obtain dimension index query data in the service query request.
The dimension index query data is used for querying preset dimension index data corresponding to the dimension index query data in the database.
And then, matching the dimension index query data with preset dimension index data configured in advance in a database, and obtaining service dimension index data corresponding to the service query request when the dimension index query data is consistent with the preset dimension index data.
S202: and splicing the service dimension index data through preset splicing logic to obtain a self-defined report corresponding to the service query request.
In S202, the generated custom report is composed of input parameters (input parameters), output parameters (output parameters) and data sources.
Wherein, the output parameter is the report display field.
The code for the concrete entry, exit and data sources is as follows:
(1) ginseng introduction:
title: "query condition set",
items:[{
fieldLabel: "service month",
itemId:"I_BUSI_MONTH"，
owner:"CF_STAT.T_M_CLIENT"，
value:"{#sys.nowCurrentMonth#}"
}，{
fieldLabel: "coin type",
itemId:"I_MONEY_TYPE"，
keyName:"money_type_1101"，
owner:"CF_STAT.T_M_CLIENT"
},{
fieldLabel: "customer number",
itemId:"I_CLIENT_ID"，
owner:"CF_STAT.T_M_CLIENT"
},{
fieldLabel: "Business department code",
itemId:"I_BRANCH_ID"，
owner:"CF_STAT.T_M_CLIENT"
}],
(2) ginseng production:
(3) a data source:
bindModule:
"mxwl＝Index_management/index_report/D_IDX_admin14990/select"，
iconCls:"seek_icon"，
itemId:"seekBtn"，
text: "query".
And generating a custom report under the path requires calling database logic to realize the calling of a data source.
The specific database logic is as follows:
firstly, input parameters corresponding to business dimension index data and output parameters corresponding to the business dimension index data are determined.
Then, the input parameters and the output parameters are spliced through a dynamic structured query language sql to obtain a splicing result, and the splicing result is stored in a database.
The service logic is spliced through the preset dimension service index logic, and the participation is spliced through the dynamic sql.
The logic is as follows: through the dimension indexes of the background which are maintained in advance, the business logic is spliced through row-to-column conversion, and the source code is as follows:
the abstracted dimension business logic can be repeatedly used, the report development efficiency and the data utilization rate are improved, the concrete data of the dimension business logic is maintained in an index table, and the index table stores the index name, the index field name, the index calculation process, the index state, the calculation formula and the like of the dimension business logic.
And the whole dynamic sql is used as a database storage process of the self-defined report, namely a database storage process of a background is generated.
The logic of the specific storage process is as follows:
1) and splicing the background sql, and logically splicing the selected parameter field by using a loop operation.
2) And logically splicing the selected parameter fields.
3) And logically splicing the stored process queries.
4) And generating a storage process of the self-defined report.
The specific logic is as follows, and the logic in the background is simplified as follows:
and finally, determining a self-defined report corresponding to the service query request based on the splicing result in the database and displaying the self-defined report.
And generating a front-end function corresponding to the self-defined report. The generated foreground function is a self-defined report form which can be used and inquired by business personnel.
S203: and displaying the self-defined report form in a preset display mode.
The preset display mode is divided into a search condition and a display field, so that a user-defined module can add condition indexes and display indexes.
Different fields in the business requirement are required fields, the different fields are configured and maintained in a database, different dimensional indexes are dispersed in different statistical dimensions, and display fields (such as position-taking amount) of a generated report form are selected in different dimensions.
For convenience of understanding, the customized report is presented in a preset presentation manner, and is described by way of example with reference to fig. 3 and 4.
In fig. 3, the preset dimension index data includes a day dimension exchange table, a product, a contract, a month dimension customer table, a month dimension business department table, a month dimension customer category table, a month dimension exchange table, a month dimension variety table, a day dimension customer table, a customer information table, a branch office, a day dimension business department table, a day dimension variety table, a day dimension customer category table, and a low dimension customer category table. The preset dimension index data can be modified in a self-defining way.
For example, in fig. 3, a dimension set in advance, such as a daily dimension customer table, is newly selected, and a service date, a business department, a customer number, and a currency are selected as search conditions (dimension index query data).
In fig. 4, the date of business, the department of business, the client number, the currency, the income of the right amount, and the expenditure of the right amount are selected as report presentation fields (output parameters).
The default state of the initially added module is the initial state, and referring to fig. 5, fig. 5 shows an exemplary diagram of the initially added module.
FIG. 5 includes functions such as adding, generating function points, modifying presentation and conditional pathogenesis, modifying function records, deleting, function number, function name, data source script, status, update date, updater and function path.
In fig. 5, the generated modules have 2 states, an initial state and a generation function point, only the initial state can generate a report, the "generation function point" indicates that the generated report cannot be generated again, a newly-added custom module is selected, a module with a framework automatic generation function is called to generate a foreground report function point, and the generated report function is placed in a specified directory.
According to the account authority of the login user, only the current account can be queried and used by the generated function.
In the embodiment of the application, the dimension index data related to the personalized report is configured in the database in advance, the dimension index data in the database is queried through the service query request, and the self-defined report corresponding to the service query request, namely the personalized report, is obtained without developing the logic code of the personalized report again, so that the efficiency of obtaining the personalized report is improved.
Based on the method for processing a self-defined report disclosed in the embodiment of fig. 2, the embodiment of the present application also discloses a device for processing a self-defined report, and as shown in fig. 6, the device for processing a self-defined report includes a determining unit 601, a splicing unit 602, and a displaying unit 603.
A determining unit 601, configured to query preset dimension index data configured in advance in a database when a service query request is received, to obtain service dimension index data corresponding to the service query request; the service dimension index data is used for representing preset dimension index data corresponding to the dimension index query data in the service query request.
The splicing unit 602 is configured to splice the service dimension index data through a preset splicing logic, so as to obtain a custom report corresponding to the service query request.
The display unit 603 is configured to display the user-defined report in a preset display manner.
Further, the determining unit 601 includes a first obtaining module, a matching module and a second obtaining module.
The first acquisition module is used for acquiring the dimension index query data in the service query request when the service query request is received.
And the matching module is used for matching the dimension index query data with preset dimension index data which is configured in advance in the database.
And the second acquisition module is used for acquiring service dimension index data corresponding to the service query request when the dimension index query data is consistent with the preset dimension index data.
Further, the splicing unit 602 includes a first determining module, a storing module and a second determining module.
And the first determining module is used for determining the input parameters corresponding to the service dimension index data and the output parameters corresponding to the service dimension index data.
And the splicing module is used for splicing the input parameters and the output parameters through the dynamic structured query language sql to obtain a splicing result, and storing the splicing result in the database.
And the second determining module is used for determining and displaying the self-defined report corresponding to the service query request based on the splicing result in the database.
Further, the determining unit 601 for configuring the preset dimension index data includes an obtaining module, an extracting module, and a configuring module.
And the acquisition module is used for acquiring the business requirements of each futures company.
The extraction module is used for extracting preset service indexes from the service requirements of each futures company; the preset service index is a service index with the same service type under different dimensions.
And the configuration module is used for configuring the preset service index in the database to obtain preset dimension index data.
Furthermore, the processing device for the user-defined report further comprises an operation unit.
And the operation unit is used for carrying out self-defining modification operation on the preset dimension index data.
Further, the processing device for the user-defined report further comprises a generating unit.
And generating a front-end function corresponding to the self-defined report.
In the embodiment of the application, the dimension index data related to the personalized report is configured in the database in advance, the dimension index data in the database is queried through the service query request, and the self-defined report corresponding to the service query request, namely the personalized report, is obtained without developing the logic code of the personalized report again, so that the efficiency of obtaining the personalized report is improved.
The embodiment of the application also provides a storage medium, wherein the storage medium comprises a stored instruction, and when the instruction runs, the device where the storage medium is located is controlled to execute the processing method of the user-defined report.
The embodiment of the present application further provides an electronic device, a schematic structural diagram of which is shown in fig. 7, specifically including a memory 701 and one or more instructions 702, where the one or more instructions 702 are stored in the memory 701, and are configured to be executed by the one or more processors 703 to execute the one or more instructions 702 to execute the processing method of the self-defined report.
While, for purposes of simplicity of explanation, the foregoing method embodiments have been described as a series of acts or combination of acts, it will be appreciated by those skilled in the art that the present application is not limited by the illustrated ordering of acts, as some steps may occur in other orders or concurrently depending on the application. Further, those skilled in the art should also appreciate that the embodiments described in the specification are preferred embodiments and that the acts and modules referred to are not necessarily required in this application.
It should be noted that, in the present specification, the embodiments are all described in a progressive manner, each embodiment focuses on differences from other embodiments, and the same and similar parts among the embodiments may be referred to each other. For the system-like embodiment, since it is basically similar to the method embodiment, the description is simple, and for the relevant points, reference may be made to the partial description of the method embodiment.
The steps in the method of the embodiments of the present application may be sequentially adjusted, combined, and deleted according to actual needs.
Finally, it should also be noted that, herein, relational terms such as first and second, and the like may be used solely to distinguish one entity or action from another entity or action without necessarily requiring or implying any actual such relationship or order between such entities or actions.
The previous description of the disclosed embodiments is provided to enable any person skilled in the art to make or use the present application. Various modifications to these embodiments will be readily apparent to those skilled in the art, and the generic principles defined herein may be applied to other embodiments without departing from the spirit or scope of the application. Thus, the present application is not intended to be limited to the embodiments shown herein but is to be accorded the widest scope consistent with the principles and novel features disclosed herein.
The foregoing is only a preferred embodiment of the present application and it should be noted that, for a person skilled in the art, several modifications and improvements can be made without departing from the principle of the present application, and these modifications and improvements should also be considered as the protection scope of the present application.
Claims (10)
1. A processing method of a self-defined report is characterized by comprising the following steps:
when a service query request is received, querying preset dimension index data configured in advance in a database to obtain service dimension index data corresponding to the service query request; the service dimension index data is used for representing preset dimension index data corresponding to the dimension index query data in the service query request;
splicing the service dimension index data through preset splicing logic to obtain a self-defined report corresponding to the service query request;
and displaying the self-defined report form in a preset display mode.
2. The method according to claim 1, wherein when receiving a service query request, querying preset dimension index data configured in advance in a database to obtain service dimension index data corresponding to the service query request, comprises:
when a service query request is received, acquiring dimension index query data in the service query request;
matching the dimension index query data with preset dimension index data configured in advance in a database;
and when the dimension index query data is consistent with the preset dimension index data, obtaining service dimension index data corresponding to the service query request.
3. The method according to claim 1, wherein the splicing the service dimension index data through a preset splicing logic to obtain a custom report corresponding to the service query request comprises:
determining an input parameter corresponding to the business dimension index data and an output parameter corresponding to the business dimension index data;
splicing the input parameters and the output parameters through a dynamic structured query language sql to obtain a splicing result, and storing the splicing result in a database;
and determining a self-defined report corresponding to the service query request based on the splicing result in the database.
4. The method of claim 1, wherein the step of configuring the preset dimension index data in the database comprises:
acquiring each service requirement; the business requirements are requirements corresponding to business types of all companies;
extracting preset service indexes from the service requirements; the preset service index is a service index with the same service type under different dimensionalities;
and configuring the preset service index in a database to obtain preset dimension index data.
5. The method of claim 1, further comprising:
and carrying out self-defining modification operation on the preset dimension index data.
6. The method of claim 1, further comprising:
and generating a front-end function corresponding to the self-defined report.
7. An apparatus for processing a custom report, the apparatus comprising:
the service query device comprises a determining unit, a searching unit and a processing unit, wherein the determining unit is used for querying preset dimension index data configured in advance in a database when a service query request is received to obtain service dimension index data corresponding to the service query request; the service dimension index data is used for representing preset dimension index data corresponding to the dimension index query data in the service query request;
the splicing unit is used for splicing the service dimension index data through preset splicing logic to obtain a self-defined report corresponding to the service query request;
and the display unit is used for displaying the self-defined report form in a preset display mode.
8. The apparatus of claim 7, wherein the determining unit comprises:
the service query system comprises a first acquisition module, a second acquisition module and a third acquisition module, wherein the first acquisition module is used for acquiring dimension index query data in a service query request when the service query request is received;
the matching module is used for matching the dimension index query data with preset dimension index data which is configured in advance in a database;
and the second acquisition module is used for acquiring service dimension index data corresponding to the service query request when the dimension index query data is consistent with the preset dimension index data.
9. A storage medium, characterized in that the storage medium includes stored instructions, wherein when the instructions are executed, the apparatus on which the storage medium is located is controlled to execute the processing method of the custom report according to any one of claims 1 to 6.
10. An electronic device comprising a memory and one or more instructions, wherein the one or more instructions are stored in the memory and configured to be executed by the one or more processors to perform the method of processing the custom report according to any one of claims 1 to 6.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202111678345.9A CN114372189A (en) | 2021-12-31 | 2021-12-31 | Processing method and device of user-defined report, storage medium and electronic equipment |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202111678345.9A CN114372189A (en) | 2021-12-31 | 2021-12-31 | Processing method and device of user-defined report, storage medium and electronic equipment |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN114372189A true CN114372189A (en) | 2022-04-19 |
Family
ID=81143103
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202111678345.9A Pending CN114372189A (en) | 2021-12-31 | 2021-12-31 | Processing method and device of user-defined report, storage medium and electronic equipment |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN114372189A (en) |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN117151555A (en) * | 2023-11-01 | 2023-12-01 | 青岛文达通科技股份有限公司 | Smart city service system |
Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN111159157A (en) * | 2019-12-31 | 2020-05-15 | 远光软件股份有限公司 | Method and device for indexing processing of enterprise report data |
| CN111813804A (en) * | 2019-04-11 | 2020-10-23 | 百度在线网络技术（北京）有限公司 | Data query method and device, electronic equipment and storage medium |
| WO2020259155A1 (en) * | 2019-06-27 | 2020-12-30 | 深圳前海微众银行股份有限公司 | Method and apparatus for generating alarm data report |
| CN113590607A (en) * | 2021-09-29 | 2021-11-02 | 国网江苏省电力有限公司营销服务中心 | Electric power marketing report realization method and system based on report factor |
-
2021
- 2021-12-31 CN CN202111678345.9A patent/CN114372189A/en active Pending
Patent Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN111813804A (en) * | 2019-04-11 | 2020-10-23 | 百度在线网络技术（北京）有限公司 | Data query method and device, electronic equipment and storage medium |
| WO2020259155A1 (en) * | 2019-06-27 | 2020-12-30 | 深圳前海微众银行股份有限公司 | Method and apparatus for generating alarm data report |
| CN111159157A (en) * | 2019-12-31 | 2020-05-15 | 远光软件股份有限公司 | Method and device for indexing processing of enterprise report data |
| CN113590607A (en) * | 2021-09-29 | 2021-11-02 | 国网江苏省电力有限公司营销服务中心 | Electric power marketing report realization method and system based on report factor |
Non-Patent Citations (1)
| Title |
|---|
| 张华中: "大型企业的多维度动态报表生成系统的研究", 《中国优秀硕士学位论文全文数据库 信息科技辑》, no. 2, 15 February 2017 (2017-02-15), pages 138 - 2001 * |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN117151555A (en) * | 2023-11-01 | 2023-12-01 | 青岛文达通科技股份有限公司 | Smart city service system |
| CN117151555B (en) * | 2023-11-01 | 2024-02-02 | 青岛文达通科技股份有限公司 | Smart city service system |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US11409904B2 (en) | User interface for building a data privacy pipeline and contractual agreement to share data | |
| US5630127A (en) | Program storage device and computer program product for managing an event driven management information system with rule-based application structure stored in a relational database | |
| US10845962B2 (en) | Specifying user interface elements | |
| CN111177231A (en) | Report generation method and report generation device | |
| CN110795509A (en) | Method and device for constructing index blood relationship graph of data warehouse and electronic equipment | |
| US10795901B2 (en) | Generic entry and exit network interface system and method | |
| US20070192113A1 (en) | IVR system manager | |
| CN111639480A (en) | Text labeling method based on artificial intelligence, electronic device and storage medium | |
| US20120158757A1 (en) | Inherited Entity Storage Model | |
| CN111414376A (en) | Data early warning method and device | |
| CN111382279A (en) | Order examination method and device | |
| US20200250745A1 (en) | System and methods for consolidating account data | |
| US8260772B2 (en) | Apparatus and method for displaying documents relevant to the content of a website | |
| CN110807016A (en) | Data warehouse construction method and device applied to financial business and electronic equipment | |
| CN111651262B (en) | Batch task generation method and device | |
| CN114372189A (en) | Processing method and device of user-defined report, storage medium and electronic equipment | |
| US20090199158A1 (en) | Apparatus and method for building a component to display documents relevant to the content of a website | |
| CN110781235A (en) | Big data based purchase data processing method and device, terminal and storage medium | |
| US20190197453A1 (en) | Aggregating computer functions across different computer applications | |
| CN115495513A (en) | Event standardization method and device | |
| CN115409014A (en) | Document template generation method and device, computer equipment and storage medium | |
| CN115686447A (en) | Intelligent recommendation method for application creation, and creation method, device and system for application | |
| CN114880387A (en) | Data integration script generation method and device, storage medium and electronic equipment | |
| CN113934801B (en) | Data blood relationship processing method and device and electronic equipment | |
| CN118227674B (en) | Report generation method and device and electronic equipment |
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 |