CN112685365A - Data report exporting method, device, equipment and storage medium - Google Patents
Data report exporting method, device, equipment and storage medium Download PDFInfo
- Publication number
- CN112685365A CN112685365A CN202011591900.XA CN202011591900A CN112685365A CN 112685365 A CN112685365 A CN 112685365A CN 202011591900 A CN202011591900 A CN 202011591900A CN 112685365 A CN112685365 A CN 112685365A
- Authority
- CN
- China
- Prior art keywords
- export
- field
- data
- report
- initial
- 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
- 238000000034 method Methods 0.000 title claims abstract description 40
- 230000015654 memory Effects 0.000 claims description 23
- 238000004422 calculation algorithm Methods 0.000 claims description 19
- 238000001514 detection method Methods 0.000 claims description 7
- 238000005516 engineering process Methods 0.000 abstract description 3
- 238000010586 diagram Methods 0.000 description 7
- 230000006870 function Effects 0.000 description 7
- 238000004364 calculation method Methods 0.000 description 5
- 238000009795 derivation Methods 0.000 description 3
- 238000013500 data storage Methods 0.000 description 2
- 230000008569 process Effects 0.000 description 2
- 230000001960 triggered effect Effects 0.000 description 2
- 238000004458 analytical method Methods 0.000 description 1
- 230000005540 biological transmission Effects 0.000 description 1
- 230000010365 information processing Effects 0.000 description 1
- 230000003993 interaction Effects 0.000 description 1
- 230000002452 interceptive effect Effects 0.000 description 1
- 230000007246 mechanism Effects 0.000 description 1
- 238000012986 modification Methods 0.000 description 1
- 230000004048 modification Effects 0.000 description 1
- 230000003287 optical effect Effects 0.000 description 1
- 238000006467 substitution reaction Methods 0.000 description 1
Images
Landscapes
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
The invention relates to data processing and provides a method, a device, equipment and a storage medium for exporting a datagram table. The method can obtain an export field, if the export field does not exist in a configuration table, an initial field of the export field and a request user are determined, if the request user has export authority over the initial field, initial data are obtained, a generation strategy is determined according to the export field and the initial field, the initial data are processed by the generation strategy to obtain the export data, a file type is obtained, an export template is obtained according to the file type, the export data are written into the export template to obtain a data report, and a preset plug-in is called to export the data report from the business intelligent system. The invention can safely export data from a commercial intelligent system without a background export interface. In addition, the invention also relates to a block chain technology, and the data report can be stored in the block chain.
Description
Technical Field
The present invention relates to the field of data processing technologies, and in particular, to a method, an apparatus, a device, and a storage medium for exporting a datagram table.
Background
The business intelligence system assists the user in making appropriate decisions by processing and converting existing data in the enterprise into knowledge, analysis and conclusions. However, current business intelligence systems do not have a background export interface and thus do not support background data export. In addition, the existing field data in the system can only be exported in the current report export mode, and the custom field data cannot be exported.
Therefore, how to export the custom field data of the background in the business intelligent system becomes a problem which needs to be solved urgently.
Disclosure of Invention
In view of the foregoing, there is a need for a method, apparatus, device and storage medium for exporting a datagram table, which can securely export data from a business intelligence system without a background export interface.
On one hand, the invention provides a data report exporting method, which is applied to electronic equipment, wherein the electronic equipment comprises a business intelligent system, and the data report exporting method comprises the following steps:
receiving a report export request, and acquiring an export field from the report export request;
detecting whether the export field exists in a configuration table of the business intelligence system;
if the export field does not exist in the configuration table, determining an initial field of the export field from the configuration table, and determining a requesting user of the report export request;
detecting whether the requesting user has derived rights to the initial field;
if the requesting user has the export right to the initial field, acquiring initial data corresponding to the initial field from the business intelligent system;
determining a generation strategy of the derived field according to the derived field and the initial field, and processing the initial data by using the generation strategy to obtain derived data;
acquiring a file type from the report export request, and acquiring an export template according to the file type;
and writing the export data into the export template to obtain a data report, and calling a preset plug-in to export the data report from the business intelligent system.
According to the preferred embodiment of the present invention, the obtaining of the export field from the report export request includes:
analyzing the report of the report export request to obtain the data information carried by the report;
acquiring information indicating a demand from the data information as an export demand;
and extracting the indexes in the export requirement as the export field.
According to a preferred embodiment of the present invention, the determining the initial field of the derived field from the configuration table comprises:
extracting information with part of speech being a preset part of speech from the export requirement as a requirement field;
comparing all configuration fields in the configuration table with the requirement field;
determining a configuration field identical to the requirement field as the initial field.
According to the preferred embodiment of the present invention, after the preset plug-in is called to export the data report from the business intelligence system, the data report export method further includes:
generating a report name according to the export demand, and naming the data report by the report name;
acquiring information for indicating a path from the data information as an export path;
and storing the named data report in the export path.
According to a preferred embodiment of the present invention, said detecting whether the export field is present in the configuration table of the business intelligence system comprises:
traversing all configuration fields in the configuration table;
comparing the traversed configuration field with the derived field;
if the traversed configuration field is the same as the export field, determining that the export field exists in the configuration table; or
And if the traversed configuration field is different from the derived field, determining that the derived field does not exist in the configuration table.
According to a preferred embodiment of the present invention, the obtaining initial data corresponding to the initial field from the business intelligence system comprises:
calculating the total field amount of the initial field;
extracting idle threads from a preset thread pool according to the total field amount;
writing the initial field into a preset query template by using the idle thread to obtain at least one query statement;
and utilizing the at least one query statement to parallelly screen the business intelligence system to obtain the initial data.
According to a preferred embodiment of the present invention, the determining the generation policy of the derived field according to the derived field and the initial field includes:
acquiring a target algorithm corresponding to the export field;
acquiring a strategy template corresponding to the target algorithm;
and writing the initial field into the strategy template to obtain the generation strategy.
On the other hand, the invention also provides a data report exporting apparatus, which runs on an electronic device, wherein the electronic device comprises a business intelligent system, and the data report exporting apparatus comprises:
the acquisition unit is used for receiving a report export request and acquiring an export field from the report export request;
a detection unit for detecting whether the export field exists in a configuration table of the business intelligence system;
the determining unit is used for determining an initial field of the export field from the configuration table and determining a requesting user of the report export request if the export field does not exist in the configuration table;
the detection unit is further used for detecting whether the requesting user has the export authority of the initial field;
the obtaining unit is further configured to obtain initial data corresponding to the initial field from the business intelligence system if the requesting user has the export right to the initial field;
the processing unit is used for determining a generation strategy of the derived field according to the derived field and the initial field, and processing the initial data by using the generation strategy to obtain derived data;
the obtaining unit is further configured to obtain a file type from the report export request, and obtain an export template according to the file type;
and the export unit is used for writing the export data into the export template to obtain a data report, and calling a preset plug-in to export the data report from the business intelligent system.
In another aspect, the present invention further provides an electronic device, including:
a memory storing computer readable instructions; and
and the processor executes the computer readable instructions stored in the memory to realize the data report export method.
In another aspect, the present invention further provides a computer-readable storage medium, where computer-readable instructions are stored in the computer-readable storage medium, and the computer-readable instructions are executed by a processor in an electronic device to implement the data report exporting method.
According to the technical scheme, when the export field does not exist in the configuration table, the export data can be determined by determining the initial field of the export field, the export of the export data is facilitated, meanwhile, whether the requesting user has export authority over the initial field or not is detected, so that the requesting user who exports the data report can be ensured to have the export authority, the export safety is improved, and in addition, the data report can be exported from a business intelligent system without a background export interface by calling a preset plug-in.
Drawings
FIG. 1 is a flowchart illustrating a data report exporting method according to a preferred embodiment of the present invention.
FIG. 2 is a flow chart of one embodiment of the present invention for obtaining initial data.
FIG. 3 is a flow diagram of one embodiment of the present invention for determining a generation policy for an export field.
FIG. 4 is a functional block diagram of the data report exporting apparatus according to the preferred embodiment of the present invention.
FIG. 5 is a schematic structural diagram of an electronic device implementing a data report exporting method according to a preferred embodiment of the present invention.
Detailed Description
In order to make the objects, technical solutions and advantages of the present invention more apparent, the present invention will be described in detail with reference to the accompanying drawings and specific embodiments.
FIG. 1 is a flowchart illustrating a data report exporting method according to a preferred embodiment of the present invention. The order of the steps in the flow chart may be changed and some steps may be omitted according to different needs.
The data report exporting method is applied to one or more electronic devices, wherein the electronic devices are devices capable of automatically performing numerical calculation and/or information processing according to computer readable instructions which are set or stored in advance, and hardware of the electronic devices includes but is not limited to a microprocessor, an Application Specific Integrated Circuit (ASIC), a Programmable Gate Array (FPGA), a Digital Signal Processor (DSP), an embedded device and the like.
The electronic device may be any electronic product capable of performing human-computer interaction with a user, for example, a Personal computer, a tablet computer, a smart phone, a Personal Digital Assistant (PDA), a game machine, an interactive Internet Protocol Television (IPTV), a smart wearable device, and the like.
The electronic device may include a network device and/or a user device. Wherein the network device includes, but is not limited to, a single network electronic device, an electronic device group consisting of a plurality of network electronic devices, or a Cloud Computing (Cloud Computing) based Cloud consisting of a large number of hosts or network electronic devices.
The network in which the electronic device is located includes, but is not limited to: the internet, a wide area Network, a metropolitan area Network, a local area Network, a Virtual Private Network (VPN), and the like.
The electronic device includes a business intelligence system.
S10, receiving report export request and obtaining export field from the report export request.
In at least one embodiment of the present invention, the data information carried in the report export request includes, but is not limited to: export requirements, user identification codes, export paths, etc. The report export request may be triggered by any user.
The export field refers to field data needing to be exported in the report export request.
In at least one embodiment of the present invention, the electronic device obtaining an export field from the report export request includes:
analyzing the report of the report export request to obtain the data information carried by the report;
acquiring information indicating a demand from the data information as an export demand;
and extracting the indexes in the export requirement as the export field.
The export requirement refers to a requirement for exporting data, for example, the export requirement may be: total sales of products in region a of this month.
Taking the above example in mind, the derived field is: the total sales.
Through the embodiment, the whole report export request does not need to be analyzed, so that the data information acquisition efficiency can be improved, and the export field can be quickly acquired.
S11, detecting whether the export field exists in the configuration table of the business intelligence system.
In at least one embodiment of the invention, the configuration table stores fields corresponding to all data in the business intelligence system.
In at least one embodiment of the invention, the electronic device detecting whether the export field is present in a configuration table of the business intelligence system comprises:
traversing all configuration fields in the configuration table;
comparing the traversed configuration field with the derived field;
if the traversed configuration field is the same as the export field, determining that the export field exists in the configuration table; or
And if the traversed configuration field is different from the derived field, determining that the derived field does not exist in the configuration table.
Through the embodiment, all the configuration fields in the configuration table are compared with the derived fields one by one, and whether the derived fields exist in the configuration table can be accurately determined.
S12, if the export field does not exist in the configuration table, determining the initial field of the export field from the configuration table, and determining the requesting user of the report export request.
In at least one embodiment of the present invention, the initial field refers to a field stored in the configuration table, that is, the initial field refers to a data field existing in the business intelligence system.
The requesting user refers to a triggering user of the report exporting request.
In at least one embodiment of the invention, the electronic device determining an initial field of the derived field from the configuration table comprises:
extracting information with part of speech being a preset part of speech from the export requirement as a requirement field;
comparing all configuration fields in the configuration table with the requirement field;
determining a configuration field identical to the requirement field as the initial field.
Wherein, the predetermined part of speech may be a noun.
For example, the configuration table stores month, region, and product sales, and the derived demand may be: the total sales of the products in district A in this month is confirmed that the demand field is: the initial fields of the product, the total sale amount in this month and the area A are as follows: this month, area A, product A.
By determining the initial field from the configuration table, it can be ensured that the determined initial field belongs to an existing field of the business intelligence system, thereby facilitating determination of the derived data.
In at least one embodiment of the present invention, the electronic device determining the requesting user of the report exporting request comprises:
acquiring information indicating a user from the data information as a user identification code;
and determining the user corresponding to the user identification code as the requesting user.
Because the user identification code can uniquely identify the user identity, the requesting user can be accurately determined through the user identification code.
S13, detecting whether the requesting user has the derivation authority to the initial field.
In at least one embodiment of the present invention, the electronic device detecting whether the requesting user has export rights to the initial field comprises:
acquiring a permission configuration table;
comparing the user identification code with the authority configuration table;
if the user identification code exists in the authority configuration table, determining that the requesting user has the export authority for the initial field; or
And if the user identification code does not exist in the permission configuration table, determining that the requesting user does not have the derived permission of the initial field.
Wherein the authority configuration table stores users having the derived authority for the initial field.
And whether the requesting user has a derived field of the initial field or not can be accurately determined through the permission configuration table.
S14, if the requesting user has the export right to the initial field, acquiring initial data corresponding to the initial field from the business intelligence system.
In at least one embodiment of the invention, the initial data refers to data corresponding to the initial field in the business intelligence system.
Referring to fig. 2, fig. 2 is a flow chart of an embodiment of the present invention for acquiring initial data. In at least one embodiment of the invention, the electronic device obtaining initial data corresponding to the initial field from the business intelligence system comprises:
s140, calculating the total field amount of the initial field;
the field total amount refers to the total amount of the initial field.
S141, extracting an idle thread from a preset thread pool according to the total field amount;
the method comprises the steps that a plurality of threads defined in advance are stored in a preset thread pool, and the threads defined in advance comprise idle threads and non-idle threads.
S142, writing the initial field into a preset query template by using the idle thread to obtain at least one query statement;
each preset query template includes a field location.
S143, the business intelligence system is parallelly screened by utilizing the at least one query statement to obtain the initial data.
Through the implementation mode, the appropriate idle thread can be determined according to the total field amount, so that the configuration library can be screened in parallel by using the idle thread, and the acquisition efficiency of the initial data is improved.
And S15, determining the generation strategy of the derived field according to the derived field and the initial field, and processing the initial data by using the generation strategy to obtain derived data.
In at least one embodiment of the present invention, the generation policy refers to a calculation manner for generating the derived data from the initial data.
In at least one embodiment of the present invention, the export data refers to data corresponding to the export field.
Referring to fig. 3, fig. 3 is a flow diagram of one embodiment of the present invention for determining a generation policy for an export field. In at least one embodiment of the present invention, the electronic device determining the generation policy of the derived field according to the derived field and the initial field includes:
s150, acquiring a target algorithm corresponding to the export field;
the target algorithm refers to a calculation mode.
S151, obtaining a strategy template corresponding to the target algorithm;
the policy template is a template corresponding to the target algorithm.
S152, writing the initial field into the strategy template to obtain the generation strategy.
For example: the export field is: total sales, the initial field including: the products in this month, area A and area A are determined, and the target algorithm is as follows: and the generation strategy is to calculate the sale sum of the A products in the region A in the month.
By the implementation method, the target algorithm can be accurately determined according to the derived field, and the generation strategy can be accurately generated according to the target algorithm.
S16, obtaining the file type from the report export request, and obtaining the export template according to the file type.
In at least one embodiment of the present invention, the file types include, but are not limited to: excel file type, Pdf file type, Word file type, etc.
The export template refers to a pre-configured template corresponding to the file type.
In at least one embodiment of the present invention, the electronic device obtaining the file type from the report export request includes:
and acquiring information indicating the type from the data information as the file type.
The file type can be accurately acquired from the data information through the label indicating the type.
In at least one embodiment of the present invention, the electronic device obtaining an export template according to the file type includes:
and acquiring a template corresponding to the file type from a template library as the export template.
And S17, writing the export data into the export template to obtain a data report, and calling a preset plug-in to export the data report from the business intelligent system.
It should be emphasized that, in order to further ensure the privacy and security of the data report, the data report may also be stored in a node of a block chain.
In at least one embodiment of the present invention, the data report refers to a report generated after the export data is written into the export template.
The preset plug-in is a pre-configured export plug-in. The business intelligent system can export the data report form from the background of the business intelligent system by calling the preset plug-in.
In at least one embodiment of the present invention, after the preset plug-in is called to export the data report from the business intelligence system, the data report export method further includes:
generating a report name according to the export demand, and naming the data report by the report name;
acquiring information for indicating a path from the data information as an export path;
and storing the named data report in the export path.
The data report is named by the report name generated by the export demand, so that the requesting user can conveniently learn the report corresponding to the report export request, and the requesting user can conveniently and quickly acquire the data report by storing the data report in the export path.
According to the technical scheme, when the export field does not exist in the configuration table, the export data can be determined by determining the initial field of the export field, the export of the export data is facilitated, meanwhile, whether the requesting user has export authority over the initial field or not is detected, so that the requesting user who exports the data report can be ensured to have the export authority, the export safety is improved, and in addition, the data report can be exported from a business intelligent system without a background export interface by calling a preset plug-in.
FIG. 4 is a functional block diagram of a data report exporting apparatus according to a preferred embodiment of the present invention. The data report exporting apparatus 11 includes an obtaining unit 110, a detecting unit 111, a determining unit 112, a processing unit 113, an exporting unit 114, a generating unit 115, and a storing unit 116. The module/unit referred to herein is a series of computer readable instruction segments that can be accessed by the processor 13 and perform a fixed function and that are stored in the memory 12. In the present embodiment, the functions of the modules/units will be described in detail in the following embodiments.
The obtaining unit 110 receives the report export request and obtains the export field from the report export request.
In at least one embodiment of the present invention, the data information carried in the report export request includes, but is not limited to: export requirements, user identification codes, export paths, etc. The report export request may be triggered by any user.
The export field refers to field data needing to be exported in the report export request.
In at least one embodiment of the present invention, the obtaining unit 110 obtains the export field from the report export request includes:
analyzing the report of the report export request to obtain the data information carried by the report;
acquiring information indicating a demand from the data information as an export demand;
and extracting the indexes in the export requirement as the export field.
The export requirement refers to a requirement for exporting data, for example, the export requirement may be: total sales of products in region a of this month.
Taking the above example in mind, the derived field is: the total sales.
Through the embodiment, the whole report export request does not need to be analyzed, so that the data information acquisition efficiency can be improved, and the export field can be quickly acquired.
The detection unit 111 detects whether the export field is present in the configuration table of the business intelligence system.
In at least one embodiment of the invention, the configuration table stores fields corresponding to all data in the business intelligence system.
In at least one embodiment of the present invention, the detecting unit 111 detecting whether the export field exists in the configuration table of the business intelligence system comprises:
traversing all configuration fields in the configuration table;
comparing the traversed configuration field with the derived field;
if the traversed configuration field is the same as the export field, determining that the export field exists in the configuration table; or
And if the traversed configuration field is different from the derived field, determining that the derived field does not exist in the configuration table.
Through the embodiment, all the configuration fields in the configuration table are compared with the derived fields one by one, and whether the derived fields exist in the configuration table can be accurately determined.
If the export field does not exist in the configuration table, the determining unit 112 determines the initial field of the export field from the configuration table, and determines the requesting user of the report export request.
In at least one embodiment of the present invention, the initial field refers to a field stored in the configuration table, that is, the initial field refers to a data field existing in the business intelligence system.
The requesting user refers to a triggering user of the report exporting request.
In at least one embodiment of the present invention, the determining unit 112 determines the initial field of the derived field from the configuration table includes:
extracting information with part of speech being a preset part of speech from the export requirement as a requirement field;
comparing all configuration fields in the configuration table with the requirement field;
determining a configuration field identical to the requirement field as the initial field.
Wherein, the predetermined part of speech may be a noun.
For example, the configuration table stores month, region, and product sales, and the derived demand may be: the total sales of the products in district A in this month is confirmed that the demand field is: the initial fields of the product, the total sale amount in this month and the area A are as follows: this month, area A, product A.
By determining the initial field from the configuration table, it can be ensured that the determined initial field belongs to an existing field of the business intelligence system, thereby facilitating determination of the derived data.
In at least one embodiment of the present invention, the determining unit 112 determines the requesting user of the report export request includes:
acquiring information indicating a user from the data information as a user identification code;
and determining the user corresponding to the user identification code as the requesting user.
Because the user identification code can uniquely identify the user identity, the requesting user can be accurately determined through the user identification code.
The detection unit 111 detects whether the requesting user has derived rights to the initial field.
In at least one embodiment of the present invention, the detecting unit 111 detects whether the requesting user has the derived right to the initial field, including:
acquiring a permission configuration table;
comparing the user identification code with the authority configuration table;
if the user identification code exists in the authority configuration table, determining that the requesting user has the export authority for the initial field; or
And if the user identification code does not exist in the permission configuration table, determining that the requesting user does not have the derived permission of the initial field.
Wherein the authority configuration table stores users having the derived authority for the initial field.
And whether the requesting user has a derived field of the initial field or not can be accurately determined through the permission configuration table.
If the requesting user has the export right to the initial field, the obtaining unit 110 obtains the initial data corresponding to the initial field from the business intelligence system.
In at least one embodiment of the invention, the initial data refers to data corresponding to the initial field in the business intelligence system.
In at least one embodiment of the present invention, the obtaining unit 110 obtains the initial data corresponding to the initial field from the business intelligence system includes:
calculating the total field amount of the initial field;
the field total amount refers to the total amount of the initial field.
Extracting idle threads from a preset thread pool according to the total field amount;
the method comprises the steps that a plurality of threads defined in advance are stored in a preset thread pool, and the threads defined in advance comprise idle threads and non-idle threads.
Writing the initial field into a preset query template by using the idle thread to obtain at least one query statement;
each preset query template includes a field location.
And utilizing the at least one query statement to parallelly screen the business intelligence system to obtain the initial data.
Through the implementation mode, the appropriate idle thread can be determined according to the total field amount, so that the configuration library can be screened in parallel by using the idle thread, and the acquisition efficiency of the initial data is improved.
The processing unit 113 determines a generation policy of the derived field according to the derived field and the initial field, and processes the initial data by using the generation policy to obtain derived data.
In at least one embodiment of the present invention, the generation policy refers to a calculation manner for generating the derived data from the initial data.
In at least one embodiment of the present invention, the export data refers to data corresponding to the export field.
In at least one embodiment of the present invention, the processing unit 113 determining the generation policy of the derived field according to the derived field and the initial field includes:
acquiring a target algorithm corresponding to the export field;
the target algorithm refers to a calculation mode.
Acquiring a strategy template corresponding to the target algorithm;
the policy template is a template corresponding to the target algorithm.
And writing the initial field into the strategy template to obtain the generation strategy.
For example: the export field is: total sales, the initial field including: the products in this month, area A and area A are determined, and the target algorithm is as follows: and the generation strategy is to calculate the sale sum of the A products in the region A in the month.
By the implementation method, the target algorithm can be accurately determined according to the derived field, and the generation strategy can be accurately generated according to the target algorithm.
The obtaining unit 110 obtains a file type from the report export request, and obtains an export template according to the file type.
In at least one embodiment of the present invention, the file types include, but are not limited to: excel file type, Pdf file type, Word file type, etc.
The export template refers to a pre-configured template corresponding to the file type.
In at least one embodiment of the present invention, the obtaining unit 110 obtains the file type from the report export request, including:
and acquiring information indicating the type from the data information as the file type.
The file type can be accurately acquired from the data information through the label indicating the type.
In at least one embodiment of the present invention, the obtaining unit 110 obtains an export template according to the file type, including:
and acquiring a template corresponding to the file type from a template library as the export template.
The export unit 114 writes the export data into the export template to obtain a data report, and invokes a preset plug-in to export the data report from the business intelligent system.
It should be emphasized that, in order to further ensure the privacy and security of the data report, the data report may also be stored in a node of a block chain.
In at least one embodiment of the present invention, the data report refers to a report generated after the export data is written into the export template.
The preset plug-in is a pre-configured export plug-in. The business intelligent system can export the data report form from the background of the business intelligent system by calling the preset plug-in.
In at least one embodiment of the present invention, after a preset plug-in is called to export the data report from the business intelligence system, the generating unit 115 generates a report name according to the export requirement, and names the data report with the report name;
the acquisition unit 110 acquires information indicating a path from the data information as an derived path;
the storage unit 116 stores the named data report in the export path.
The data report is named by the report name generated by the export demand, so that the requesting user can conveniently learn the report corresponding to the report export request, and the requesting user can conveniently and quickly acquire the data report by storing the data report in the export path.
According to the technical scheme, when the export field does not exist in the configuration table, the export data can be determined by determining the initial field of the export field, the export of the export data is facilitated, meanwhile, whether the requesting user has export authority over the initial field or not is detected, so that the requesting user who exports the data report can be ensured to have the export authority, the export safety is improved, and in addition, the data report can be exported from a business intelligent system without a background export interface by calling a preset plug-in.
Fig. 5 is a schematic structural diagram of an electronic device implementing a data report exporting method according to a preferred embodiment of the present invention.
In one embodiment of the present invention, the electronic device 1 includes, but is not limited to, a memory 12, a processor 13, and computer readable instructions, such as a data report derivation program, stored in the memory 12 and executable on the processor 13.
It will be appreciated by a person skilled in the art that the schematic diagram is only an example of the electronic device 1 and does not constitute a limitation of the electronic device 1, and that it may comprise more or less components than shown, or some components may be combined, or different components, e.g. the electronic device 1 may further comprise an input output device, a network access device, a bus, etc.
The Processor 13 may be a Central Processing Unit (CPU), other general purpose Processor, a Digital Signal Processor (DSP), an Application Specific Integrated Circuit (ASIC), a Field Programmable Gate Array (FPGA) or other Programmable logic device, discrete Gate or transistor logic device, discrete hardware component, etc. The processor 13 is an operation core and a control center of the electronic device 1, and is connected to each part of the whole electronic device 1 by various interfaces and lines, and executes an operating system of the electronic device 1 and various installed application programs, program codes, and the like.
Illustratively, the computer readable instructions may be partitioned into one or more modules/units that are stored in the memory 12 and executed by the processor 13 to implement the present invention. The one or more modules/units may be a series of computer readable instruction segments capable of performing specific functions, which are used for describing the execution process of the computer readable instructions in the electronic device 1. For example, the computer readable instructions may be divided into an acquisition unit 110, a detection unit 111, a determination unit 112, a processing unit 113, a derivation unit 114, a generation unit 115, and a storage unit 116.
The memory 12 may be used for storing the computer readable instructions and/or modules, and the processor 13 implements various functions of the electronic device 1 by executing or executing the computer readable instructions and/or modules stored in the memory 12 and invoking data stored in the memory 12. The memory 12 may mainly include a program storage area and a data storage area, wherein the program storage area may store an operating system, an application program required by at least one function (such as a sound playing function, an image playing function, etc.), and the like; the storage data area may store data created according to use of the electronic device, and the like. The memory 12 may include non-volatile and volatile memories, such as: a hard disk, a memory, a plug-in hard disk, a Smart Media Card (SMC), a Secure Digital (SD) Card, a Flash memory Card (Flash Card), at least one magnetic disk storage device, a Flash memory device, or other storage device.
The memory 12 may be an external memory and/or an internal memory of the electronic device 1. Further, the memory 12 may be a memory having a physical form, such as a memory stick, a TF Card (Trans-flash Card), or the like.
The integrated modules/units of the electronic device 1 may be stored in a computer-readable storage medium if they are implemented in the form of software functional units and sold or used as separate products. Based on such understanding, all or part of the flow of the method according to the above embodiments may be implemented by hardware that is configured to be instructed by computer readable instructions, which may be stored in a computer readable storage medium, and when the computer readable instructions are executed by a processor, the steps of the method embodiments may be implemented.
Wherein the computer readable instructions comprise computer readable instruction code which may be in source code form, object code form, an executable file or some intermediate form, and the like. The computer-readable medium may include: any entity or device capable of carrying said computer readable instruction code, recording medium, U-disk, removable hard disk, magnetic disk, optical disk, computer Memory, Read-Only Memory (ROM), Random Access Memory (RAM).
The block chain is a novel application mode of computer technologies such as distributed data storage, point-to-point transmission, a consensus mechanism, an encryption algorithm and the like. A block chain (Blockchain), which is essentially a decentralized database, is a series of data blocks associated by using a cryptographic method, and each data block contains information of a batch of network transactions, so as to verify the validity (anti-counterfeiting) of the information and generate a next block. The blockchain may include a blockchain underlying platform, a platform product service layer, an application service layer, and the like.
With reference to fig. 1, the memory 12 in the electronic device 1 stores computer-readable instructions to implement a datagram table derivation method, and the processor 13 can execute the computer-readable instructions to implement:
receiving a report export request, and acquiring an export field from the report export request;
detecting whether the export field exists in a configuration table of the business intelligence system;
if the export field does not exist in the configuration table, determining an initial field of the export field from the configuration table, and determining a requesting user of the report export request;
detecting whether the requesting user has derived rights to the initial field;
if the requesting user has the export right to the initial field, acquiring initial data corresponding to the initial field from the business intelligent system;
determining a generation strategy of the derived field according to the derived field and the initial field, and processing the initial data by using the generation strategy to obtain derived data;
acquiring a file type from the report export request, and acquiring an export template according to the file type;
and writing the export data into the export template to obtain a data report, and calling a preset plug-in to export the data report from the business intelligent system.
Specifically, the processor 13 may refer to the description of the relevant steps in the embodiment corresponding to fig. 1 for a specific implementation method of the computer readable instructions, which is not described herein again.
In the embodiments provided in the present invention, it should be understood that the disclosed system, apparatus and method may be implemented in other ways. For example, the above-described apparatus embodiments are merely illustrative, and for example, the division of the modules is only one logical functional division, and other divisions may be realized in practice.
The computer readable storage medium has computer readable instructions stored thereon, wherein the computer readable instructions when executed by the processor 13 are configured to implement the steps of:
receiving a report export request, and acquiring an export field from the report export request;
detecting whether the export field exists in a configuration table of the business intelligence system;
if the export field does not exist in the configuration table, determining an initial field of the export field from the configuration table, and determining a requesting user of the report export request;
detecting whether the requesting user has derived rights to the initial field;
if the requesting user has the export right to the initial field, acquiring initial data corresponding to the initial field from the business intelligent system;
determining a generation strategy of the derived field according to the derived field and the initial field, and processing the initial data by using the generation strategy to obtain derived data;
acquiring a file type from the report export request, and acquiring an export template according to the file type;
and writing the export data into the export template to obtain a data report, and calling a preset plug-in to export the data report from the business intelligent system.
The modules described as separate parts may or may not be physically separate, and parts displayed as modules may or may not be physical units, may be located in one place, or may be distributed on a plurality of network units. Some or all of the modules may be selected according to actual needs to achieve the purpose of the solution of the present embodiment.
In addition, functional modules in the embodiments of the present invention may be integrated into one processing unit, or each unit may exist alone physically, or two or more units are integrated into one unit. The integrated unit can be realized in a form of hardware, or in a form of hardware plus a software functional module.
The present embodiments are therefore to be considered in all respects as illustrative and not restrictive, the scope of the invention being indicated by the appended claims rather than by the foregoing description, and all changes which come within the meaning and range of equivalency of the claims are therefore intended to be embraced therein. Any reference signs in the claims shall not be construed as limiting the claim concerned.
Furthermore, it is obvious that the word "comprising" does not exclude other elements or steps, and the singular does not exclude the plural. The plurality of units or devices may also be implemented by one unit or device through software or hardware. The terms first, second, etc. are used to denote names, but not any particular order.
Finally, it should be noted that the above embodiments are only for illustrating the technical solutions of the present invention and not for limiting, and although the present invention is described in detail with reference to the preferred embodiments, it should be understood by those skilled in the art that modifications or equivalent substitutions may be made on the technical solutions of the present invention without departing from the spirit and scope of the technical solutions of the present invention.
Claims (10)
1. A data report exporting method is applied to electronic equipment, the electronic equipment comprises a business intelligent system, and the data report exporting method is characterized by comprising the following steps:
receiving a report export request, and acquiring an export field from the report export request;
detecting whether the export field exists in a configuration table of the business intelligence system;
if the export field does not exist in the configuration table, determining an initial field of the export field from the configuration table, and determining a requesting user of the report export request;
detecting whether the requesting user has derived rights to the initial field;
if the requesting user has the export right to the initial field, acquiring initial data corresponding to the initial field from the business intelligent system;
determining a generation strategy of the derived field according to the derived field and the initial field, and processing the initial data by using the generation strategy to obtain derived data;
acquiring a file type from the report export request, and acquiring an export template according to the file type;
and writing the export data into the export template to obtain a data report, and calling a preset plug-in to export the data report from the business intelligent system.
2. The data report export method of claim 1 wherein said obtaining an export field from said report export request comprises:
analyzing the report of the report export request to obtain the data information carried by the report;
acquiring information indicating a demand from the data information as an export demand;
and extracting the indexes in the export requirement as the export field.
3. The data report export method of claim 2, wherein said determining an initial field of the export field from the configuration table comprises:
extracting information with part of speech being a preset part of speech from the export requirement as a requirement field;
comparing all configuration fields in the configuration table with the requirement field;
determining a configuration field identical to the requirement field as the initial field.
4. The data report export method of claim 2, wherein after invoking a preset plug-in to export the data report from the business intelligence system, the data report export method further comprises:
generating a report name according to the export demand, and naming the data report by the report name;
acquiring information for indicating a path from the data information as an export path;
and storing the named data report in the export path.
5. The data report export method of claim 1 wherein said detecting the presence of the export field in the configuration table of the business intelligence system comprises:
traversing all configuration fields in the configuration table;
comparing the traversed configuration field with the derived field;
if the traversed configuration field is the same as the export field, determining that the export field exists in the configuration table; or
And if the traversed configuration field is different from the derived field, determining that the derived field does not exist in the configuration table.
6. The data report export method of claim 1 wherein said obtaining initial data corresponding to said initial field from said business intelligence system comprises:
calculating the total field amount of the initial field;
extracting idle threads from a preset thread pool according to the total field amount;
writing the initial field into a preset query template by using the idle thread to obtain at least one query statement;
and utilizing the at least one query statement to parallelly screen the business intelligence system to obtain the initial data.
7. The data report export method of claim 1, wherein said determining a generation policy for the export field based on the export field and the initial field comprises:
acquiring a target algorithm corresponding to the export field;
acquiring a strategy template corresponding to the target algorithm;
and writing the initial field into the strategy template to obtain the generation strategy.
8. A data report exporting device, which runs on an electronic device, wherein the electronic device comprises a business intelligence system, and the data report exporting device comprises:
the acquisition unit is used for receiving a report export request and acquiring an export field from the report export request;
a detection unit for detecting whether the export field exists in a configuration table of the business intelligence system;
the determining unit is used for determining an initial field of the export field from the configuration table and determining a requesting user of the report export request if the export field does not exist in the configuration table;
the detection unit is further used for detecting whether the requesting user has the export authority of the initial field;
the obtaining unit is further configured to obtain initial data corresponding to the initial field from the business intelligence system if the requesting user has the export right to the initial field;
the processing unit is used for determining a generation strategy of the derived field according to the derived field and the initial field, and processing the initial data by using the generation strategy to obtain derived data;
the obtaining unit is further configured to obtain a file type from the report export request, and obtain an export template according to the file type;
and the export unit is used for writing the export data into the export template to obtain a data report, and calling a preset plug-in to export the data report from the business intelligent system.
9. An electronic device, characterized in that the electronic device comprises:
a memory storing computer readable instructions; and
a processor executing computer readable instructions stored in the memory to implement the data report exporting method according to any one of claims 1 to 7.
10. A computer-readable storage medium characterized by: the computer readable storage medium stores therein computer readable instructions to be executed by a processor in an electronic device to implement the data report exporting method according to any one of claims 1 to 7.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202011591900.XA CN112685365A (en) | 2020-12-29 | 2020-12-29 | Data report exporting method, device, equipment and storage medium |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202011591900.XA CN112685365A (en) | 2020-12-29 | 2020-12-29 | Data report exporting method, device, equipment and storage medium |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN112685365A true CN112685365A (en) | 2021-04-20 |
Family
ID=75454913
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202011591900.XA Pending CN112685365A (en) | 2020-12-29 | 2020-12-29 | Data report exporting method, device, equipment and storage medium |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN112685365A (en) |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN113609226A (en) * | 2021-08-09 | 2021-11-05 | 平安国际智慧城市科技股份有限公司 | Data export method and device, computer equipment and storage medium |
Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101071416A (en) * | 2007-07-02 | 2007-11-14 | 华为技术有限公司 | Report template generating system, development tool, development method and report client end |
| US20180165724A1 (en) * | 2016-12-13 | 2018-06-14 | International Business Machines Corporation | Method and system for contextual business intelligence report generation and display |
| CN109471890A (en) * | 2018-10-16 | 2019-03-15 | 深圳壹账通智能科技有限公司 | Generation method, terminal device and the medium of report file |
| CN110059305A (en) * | 2019-03-04 | 2019-07-26 | 广州市辉海计算机科技有限公司 | Method and apparatus derived from data |
| CN111428458A (en) * | 2020-03-03 | 2020-07-17 | 中国平安人寿保险股份有限公司 | Universal report generation method and device and computer readable storage medium |
-
2020
- 2020-12-29 CN CN202011591900.XA patent/CN112685365A/en active Pending
Patent Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101071416A (en) * | 2007-07-02 | 2007-11-14 | 华为技术有限公司 | Report template generating system, development tool, development method and report client end |
| US20180165724A1 (en) * | 2016-12-13 | 2018-06-14 | International Business Machines Corporation | Method and system for contextual business intelligence report generation and display |
| CN109471890A (en) * | 2018-10-16 | 2019-03-15 | 深圳壹账通智能科技有限公司 | Generation method, terminal device and the medium of report file |
| CN110059305A (en) * | 2019-03-04 | 2019-07-26 | 广州市辉海计算机科技有限公司 | Method and apparatus derived from data |
| CN111428458A (en) * | 2020-03-03 | 2020-07-17 | 中国平安人寿保险股份有限公司 | Universal report generation method and device and computer readable storage medium |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN113609226A (en) * | 2021-08-09 | 2021-11-05 | 平安国际智慧城市科技股份有限公司 | Data export method and device, computer equipment and storage medium |
| CN113609226B (en) * | 2021-08-09 | 2024-05-14 | 深圳平安智慧医健科技有限公司 | Data export method and device, computer equipment and storage medium |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN112669138B (en) | Data processing method and related equipment | |
| CN112632163B (en) | Big data report export method and related equipment | |
| CN113050900A (en) | Screen sharing method, device, equipment and storage medium | |
| CN112948418A (en) | Dynamic query method, device, equipment and storage medium | |
| CN112632098A (en) | Dynamic generation method of structured query statement and related equipment | |
| CN112711398A (en) | Method, device and equipment for generating buried point file and storage medium | |
| CN112819305A (en) | Service index analysis method, device, equipment and storage medium | |
| CN114372060A (en) | Data storage method, device, equipment and storage medium | |
| CN114510487A (en) | Data table merging method, device, equipment and storage medium | |
| CN113900955A (en) | Automatic testing method, device, equipment and storage medium | |
| CN112685365A (en) | Data report exporting method, device, equipment and storage medium | |
| CN112784566A (en) | Document generation method, device, equipment and storage medium | |
| CN113065947A (en) | Data processing method, device, equipment and storage medium | |
| CN112947911A (en) | Interface script generation method, device, equipment and storage medium | |
| CN111680483A (en) | Document template updating method and device, electronic equipment and medium | |
| CN114692204A (en) | Data query method, device, equipment and storage medium | |
| CN113283677B (en) | Index data processing method, device, equipment and storage medium | |
| CN112950154B (en) | Flow information matching method, device, equipment and storage medium | |
| CN112667721A (en) | Data analysis method, device, equipment and storage medium | |
| CN114925033A (en) | Information uplink method, device, system and storage medium | |
| CN111857883B (en) | Page data checking method and device, electronic equipment and storage medium | |
| CN112308440B (en) | Work order processing method, device, computer equipment and computer readable storage medium | |
| CN114238296A (en) | Product index data display method, device, equipment and storage medium | |
| CN114187050A (en) | Card and ticket issuing monitoring method, device, equipment and storage medium | |
| CN113282218A (en) | Multi-dimensional report generation method, device, equipment and storage medium |
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 |