CN111797125A - Report creating method and device, electronic equipment and computer readable storage medium - Google Patents
Report creating method and device, electronic equipment and computer readable storage medium Download PDFInfo
- Publication number
- CN111797125A CN111797125A CN202010538299.1A CN202010538299A CN111797125A CN 111797125 A CN111797125 A CN 111797125A CN 202010538299 A CN202010538299 A CN 202010538299A CN 111797125 A CN111797125 A CN 111797125A
- Authority
- CN
- China
- Prior art keywords
- data
- user
- report
- target
- specified
- 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 46
- 238000005259 measurement Methods 0.000 claims abstract description 22
- 238000004590 computer program Methods 0.000 claims description 4
- 238000010276 construction Methods 0.000 claims description 4
- 238000012545 processing Methods 0.000 abstract description 9
- 230000008569 process Effects 0.000 abstract description 8
- 238000013461 design Methods 0.000 description 7
- 238000010586 diagram Methods 0.000 description 7
- 230000006870 function Effects 0.000 description 7
- 238000012986 modification Methods 0.000 description 3
- 230000004048 modification Effects 0.000 description 3
- 230000003287 optical effect Effects 0.000 description 3
- 235000008708 Morus alba Nutrition 0.000 description 2
- 240000000249 Morus alba Species 0.000 description 2
- 238000005034 decoration Methods 0.000 description 2
- 238000011161 development Methods 0.000 description 2
- 238000011022 operating instruction Methods 0.000 description 2
- 238000012216 screening Methods 0.000 description 2
- 230000003068 static effect Effects 0.000 description 2
- 230000009286 beneficial effect Effects 0.000 description 1
- 230000008859 change Effects 0.000 description 1
- 238000013499 data model Methods 0.000 description 1
- 235000019800 disodium phosphate Nutrition 0.000 description 1
- 238000005516 engineering process Methods 0.000 description 1
- 238000001914 filtration Methods 0.000 description 1
- 230000002093 peripheral 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/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/24—Querying
- G06F16/245—Query processing
- G06F16/2457—Query processing with adaptation to user needs
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/24—Querying
- G06F16/248—Presentation of query results
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- 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/28—Databases characterised by their database models, e.g. relational or object models
- G06F16/284—Relational databases
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Databases & Information Systems (AREA)
- Data Mining & Analysis (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Computational Linguistics (AREA)
- User Interface Of Digital Computer (AREA)
Abstract
The embodiment of the application provides a report creating method and device, electronic equipment and a computer readable storage medium. The method comprises the following steps: acquiring target data from a target database; constructing target data into a data set based on the specified dimensionality and the specified measurement submitted by a user; and creating a report based on the report format information selected by the user and the data set. Based on the scheme, because the user specifies the dimension and the measurement and selects the report format, the user can directly define the report and automatically create the report according to the definition content, thereby simplifying the creation process of the report and improving the processing efficiency.
Description
Technical Field
The present application relates to the field of data processing technologies, and in particular, to a report creation method, an apparatus, an electronic device, and a computer-readable storage medium.
Background
The report forms are important components in the information system, and the report forms can visually display the statistical results of the data, so that the centralized check and comparison are facilitated.
In the development and presentation of the report forms, the display requirements of different clients on the report forms are possibly different, developers need to communicate and negotiate with the clients so as to determine the report form display interface capable of meeting the requirements of the clients, and once the report forms change, the developers need to repeatedly communicate and adjust, so that the report form display interface is complex, a large amount of time is wasted, and the report form display interface is inconvenient to use. If the report creating method can be provided, the client directly defines the report and automatically completes the creation of the report, the report creating process can be simplified, and the processing efficiency can be improved.
Disclosure of Invention
The present application aims to solve at least one of the above technical drawbacks. The technical scheme adopted by the application is as follows:
in a first aspect, an embodiment of the present application provides a report creating method, where the method includes:
acquiring target data from a target database;
constructing target data into a data set based on the specified dimensionality and the specified measurement submitted by a user;
and creating a report based on the report format information selected by the user and the data set.
Optionally, obtaining the target field data from the target database includes:
displaying the data fields in the target database to a user so that the user can select the data fields;
and determining a target data field selected by a user, and acquiring target data corresponding to the target data field from a target database.
Optionally, determining a specified dimension and a specified metric submitted by the user, including;
displaying the field name of the target data field to a user;
determining whether the field name corresponding to the dimension selected by the user and the field name corresponding to the metric selected by the user meet preset conditions;
and if so, determining the dimension selected by the user as the designated dimension, and determining the metric selected by the user as the designated metric.
Optionally, creating a report based on the report format information and the data set selected by the user, including:
determining data to be displayed selected by a user in the data to be selected in the data set;
and creating a report based on the data to be displayed and the report format information selected by the user.
Optionally, the method further includes:
determining a data selection interface corresponding to data to be selected in a data set;
and displaying the data selection interface to enable a user to complete selection of the data to be selected corresponding to the data selection interface based on the data selection interface.
Optionally, the target database is determined based on a user selection operation on the database.
Optionally, the method further includes:
and displaying the report in the designated area.
In a second aspect, an embodiment of the present application provides a report creating apparatus, where the apparatus includes:
the data acquisition module is used for acquiring target data from a target database;
the data set construction module is used for constructing target data into a data set based on the specified dimensionality and the specified measurement submitted by the user;
and the report creating module is used for creating a report based on the report format information and the data set selected by the user.
Optionally, the data obtaining module is specifically configured to:
displaying the data fields in the target database to a user so that the user can select the data fields;
and determining a target data field selected by a user, and acquiring target data corresponding to the target data field from a target database.
Optionally, the data set construction module is specifically configured to determine the specified dimension and the specified metric submitted by the user;
displaying the field name of the target data field to a user;
determining whether the field name corresponding to the dimension selected by the user and the field name corresponding to the metric selected by the user meet preset conditions;
and if so, determining the dimension selected by the user as the designated dimension, and determining the metric selected by the user as the designated metric.
Optionally, the report creating module is specifically configured to:
determining data to be displayed selected by a user in the data to be selected in the data set;
and creating a report based on the data to be displayed and the report format information selected by the user.
Optionally, the apparatus further includes a data selection module, where the data selection module is configured to:
determining a data selection interface corresponding to data to be selected in a data set;
and displaying the data selection interface to enable a user to complete selection of the data to be selected corresponding to the data selection interface based on the data selection interface.
Optionally, the target database is determined based on a user selection operation on the database.
Optionally, the apparatus further includes a report display module, configured to:
and displaying the report in the designated area.
In a third aspect, an embodiment of the present application provides an electronic device, including: a processor and a memory;
a memory for storing operating instructions;
the processor is used for executing the report creating method shown in any implementation mode of the first aspect of the present application by calling the operation instruction.
In a fourth aspect, an embodiment of the present application provides a computer-readable storage medium, on which a computer program is stored, where the computer program, when executed by a processor, implements a method for creating a report as shown in any implementation manner of the first aspect of the present application.
The technical scheme provided by the embodiment of the application has the following beneficial effects:
according to the scheme provided by the embodiment of the application, the target data are acquired from the target database and are constructed into the data set based on the specified dimensionality and the specified measurement submitted by the user, so that the report is created based on the report format information and the data set selected by the user. Based on the scheme, because the user specifies the dimension and the measurement and selects the report format, the user can directly define the report and automatically create the report according to the definition content, thereby simplifying the creation process of the report and improving the processing efficiency.
Drawings
In order to more clearly illustrate the technical solutions in the embodiments of the present application, the drawings used in the description of the embodiments of the present application will be briefly described below.
Fig. 1 is a schematic flowchart of a report creating method according to an embodiment of the present application;
FIG. 2 is a report display interface provided in an embodiment of the present application;
fig. 3 is a diagram of a hierarchical structure after a table structure is split into multiple layers according to an embodiment of the present application;
FIG. 4 is a schematic diagram of report creation logic according to an embodiment of the present application;
fig. 5 is a schematic structural diagram of a report creating apparatus according to an embodiment of the present application;
fig. 6 is a schematic structural diagram of an electronic device according to an embodiment of the present application.
Detailed Description
Reference will now be made in detail to embodiments of the present application, examples of which are illustrated in the accompanying drawings, wherein like or similar reference numerals refer to the same or similar elements or elements having the same or similar function throughout. The embodiments described below with reference to the drawings are exemplary only for the purpose of explaining the present application and are not to be construed as limiting the present invention.
As used herein, the singular forms "a", "an", "the" and "the" are intended to include the plural forms as well, unless the context clearly indicates otherwise. It will be further understood that the terms "comprises" and/or "comprising," when used in this specification, specify the presence of stated features, integers, steps, operations, elements, and/or components, but do not preclude the presence or addition of one or more other features, integers, steps, operations, elements, components, and/or groups thereof. It will be understood that when an element is referred to as being "connected" or "coupled" to another element, it can be directly connected or coupled to the other element or intervening elements may also be present. Further, "connected" or "coupled" as used herein may include wirelessly connected or wirelessly coupled. As used herein, the term "and/or" includes all or any element and all combinations of one or more of the associated listed items.
To make the objects, technical solutions and advantages of the present application more clear, embodiments of the present application will be described in further detail below with reference to the accompanying drawings.
The following describes the technical solutions of the present application and how to solve the above technical problems with specific embodiments. The following several specific embodiments may be combined with each other, and details of the same or similar concepts or processes may not be repeated in some embodiments. Embodiments of the present application will be described below with reference to the accompanying drawings.
Fig. 1 shows a flowchart of a report creating method provided in an embodiment of the present application, and as shown in fig. 1, the method mainly includes:
step S110: acquiring target data from a target database;
step S120: constructing target data into a data set based on the specified dimensionality and the specified measurement submitted by a user;
step S130: and creating a report based on the report format information selected by the user and the data set.
In the embodiment of the application, development and modification can be performed based on CBoard to realize the corresponding functions of the method.
In the embodiment of the present application, the system can be connected to data sources such as JDBC, Kylin, TextFile, and Saiku, and as an example, a mode of JDBC connecting to MySQL database may be adopted. In the interface, a user can select the type of a data source, set a driving class and a connection string, and finally input a user name and a password of the database to realize successful connection to the database.
In the embodiment of the application, after the target data is obtained from the target database, a user can select the specified dimension and the specified measurement from the field of the target data, and the target data is converted into the target data set according to the specified dimension and the specified measurement.
In the embodiment of the application, reports in various formats can be provided for a user to select, and after the user selects the report which needs to be used for showing the data set, the report can be created based on the report format information and the data set selected by the user. Because the user directly selects the data in the report and the report presenting mode, the report is automatically created, and the workload of developers is reduced.
According to the method provided by the embodiment of the application, the target data are acquired from the target database and are constructed into the data set based on the specified dimensionality and the specified measurement submitted by the user, so that the report is created based on the report format information and the data set selected by the user. Based on the scheme, because the user specifies the dimension and the measurement and selects the report format, the user can directly define the report and automatically create the report according to the definition content, thereby simplifying the creation process of the report and improving the processing efficiency.
In an optional manner of the embodiment of the present application, acquiring target field data from a target database includes:
displaying the data fields in the target database to a user so that the user can select the data fields;
and determining a target data field selected by a user, and acquiring target data corresponding to the target data field from a target database.
In the embodiment of the application, a user can select a table type, select a table from all tables under the selected table type, select a target data field from the selected table, and then obtain target data corresponding to the target data field.
In actual use, a user can select a table type, a table and a target data field in a checking mode, after the checking is finished, the user can click a 'submit' virtual button, and the system can automatically generate a query statement and query target data from a target database.
In the implementation of the application, the target data may be service data such as telephone data and work order data.
In an optional mode of the embodiment of the application, determining the specified dimension and the specified measurement submitted by a user comprises the following steps;
displaying the field name of the target data field to a user;
determining whether the field name corresponding to the dimension selected by the user and the field name corresponding to the metric selected by the user meet preset conditions;
and if so, determining the dimension selected by the user as the designated dimension, and determining the metric selected by the user as the designated metric.
In the embodiment of the application, the field names of the target data can be displayed, and the user can select the dimension and the measurement from the field names.
In the embodiment of the application, a field name set of field names capable of being used as a designated dimension and field names capable of being used as a designated metric can be designated, whether the field name corresponding to the dimension selected by the user and the field name corresponding to the metric selected by the user belong to the field name set is determined, if the field names belong to the field name set, the dimension selected by the user is determined as the designated dimension, and the metric selected by the user is determined as the designated metric.
The user can set the designated dimension and the designated measurement according to the needs of the user, so that the user can check the data required to be checked after the report is produced.
As an example, the field names may be displayed as selectable columns in a designated area of the page, and the Schema empty tree is displayed at the same time, and the user may add the designated dimension or the designated metric to the Schema empty tree to construct the Schema tree by dragging the selectable columns or clicking the selectable columns. After generating the Schema tree, the user may also add hierarchy, modify hierarchy names, and add corresponding columns under the hierarchy group nodes.
In an optional mode of the embodiment of the application, creating a report based on report format information and a data set selected by a user includes:
determining data to be displayed selected by a user in the data to be selected in the data set;
and creating a report based on the data to be displayed and the report format information selected by the user.
In the embodiment of the application, the data to be selected in the data set can be filtered to obtain the data to be displayed, and the report is created based on the data to be displayed.
In an optional mode of the embodiment of the application, a data selection interface corresponding to data to be selected in a data set is determined;
and displaying the data selection interface to enable a user to complete selection of the data to be selected corresponding to the data selection interface based on the data selection interface.
In the embodiment of the application, different data to be selected can be configured to correspond to different data selection interfaces, so that a user can select the data. As an example, the data selection interface corresponding to the time data (such as date) may be an interface in the form of a scroll bar, and the user may select the time range of the time data by sliding the scroll bar. As another example, the data selection interface corresponding to the user identifier may be a drop-down display interface, and the user may expand the drop-down display interface by clicking on the drop-down display interface and select the corresponding data from the drop-down list.
In an alternative manner of the embodiment of the present application, the target database is determined based on a selection operation of the database by the user.
In the embodiment of the application, each target database can be displayed for the user to select.
In an optional manner of the embodiment of the present application, the method further includes:
and displaying the report in the designated area.
In the embodiment of the application, after the report is created, the report can be displayed in the designated area of the screen of the terminal equipment so as to be viewed by a user.
In actual use, a report display interface can be designed by a user, and as an example, the report display interface can be as shown in fig. 2, and the interface mainly comprises three areas of a right column, a query area, a design area and a preview display area. The query area can selectively show the established chart, and can also select the previously established data set to design a new chart. In the design area, a user can select report data to be defined in a simple checking mode, such as a specified dimension, data filtering information, report types and the like, wherein the report types comprise a table chart, a column chart, a pie chart, a KPI (key performance indicator) chart, a funnel chart, a mulberry chart, a radar chart, a bubble chart and the like. A preview button can also be displayed in the design area, and a user can enter a preview/display area after clicking the preview button, and the area can preview the design result.
In actual use, the report parameter controller can be arranged to split the table structure related to the report display in multiple levels to form a set of standard analysis model with multiple levels of table structures, and the model is the core of report driving parameter control. The report parameter controller can be of a four-layer structure. Such as the table structure shown in fig. 3, after multi-level splitting. The first layer takes the client as a boundary, and separates report data through user identification. The second layer divides the data of each client into different business modules, and the purpose of the layer is to classify the tenant data according to the report display requirements, so that the business logic boundary of the data is clearer. The third layer is data model division, and different database table models related to the service are assigned to the same service module through the third layer. The fourth layer is a field analysis layer of the database table structure, and the purpose of the layer is to analyze the characteristics of the fields in the table, such as multi-value characteristics, time characteristics and the like.
FIG. 4 shows a report creation logic diagram provided by the present application, and as shown in FIG. 4, the data source may support multiple types, such as JDBC, Kylin, TextFile, Saiku, and the like.
And establishing a data input set, namely establishing a data set of target data after a user selects the table type, selects the table and checks the table field. A selectable filter, i.e., a form of selectable filter, such as a drop-down display interface that can be displayed for data of a drop-down property to select a filter item; such as data for a time attribute, a time range may be selected by sliding the scroll bar. The fields may be treated as a dimension column and an index column, i.e., a specified dimension is selected and a metric is specified.
In the chart design, report types such as a table chart, a column chart, a pie chart, a funnel chart, a mulberry chart, a bubble chart and the like can be selected in the chart area. And the preview area can be used for previewing a graph corresponding to the report or previewing a query statement. The design area can be used for checking and selecting the filter items, the designated dimensions in the rows, the designated dimensions in the columns and the index columns.
And the billboard is designed and used for setting report control parameters. And adding ROWs, namely adopting a simple ROW and Column layout mode, setting the total height of each ROW, corresponding to one chart for each Column, wherein the ROW height can be used as an adjusting unit through pixels, and the adjusting unit of the Column height can inherit the self height. In the parameter adding row, the field value can be used as a pull-down option, the component can be screened by a user in result display, namely, the data selection interface format corresponding to the field attribute of the added data is used, and the screening of the data is completed through the corresponding data selection interface format. The field of the date type can be used as a screening field of the date type, and a monthly report, a quarterly report and a yearly report can be screened.
Based on the same principle as the method shown in fig. 1, fig. 5 shows a schematic structural diagram of a report creation apparatus provided in an embodiment of the present application, and as shown in fig. 5, the report creation apparatus 20 may include:
a data obtaining module 210, configured to obtain target data from a target database;
a data set constructing module 220, configured to construct target data into a data set based on a specified dimension and a specified metric submitted by a user;
and a report creating module 230 for creating a report based on the report format information and the data set selected by the user.
According to the device provided by the embodiment of the application, the target data are acquired from the target database and are constructed into the data set based on the specified dimensionality and the specified measurement submitted by the user, so that the report is created based on the report format information and the data set selected by the user. Based on the scheme, because the user specifies the dimension and the measurement and selects the report format, the user can directly define the report and automatically create the report according to the definition content, thereby simplifying the creation process of the report and improving the processing efficiency.
Optionally, the data obtaining module is specifically configured to:
displaying the data fields in the target database to a user so that the user can select the data fields;
and determining a target data field selected by a user, and acquiring target data corresponding to the target data field from a target database.
Optionally, the data set construction module is specifically configured to determine the specified dimension and the specified metric submitted by the user;
displaying the field name of the target data field to a user;
determining whether the field name corresponding to the dimension selected by the user and the field name corresponding to the metric selected by the user meet preset conditions;
and if so, determining the dimension selected by the user as the designated dimension, and determining the metric selected by the user as the designated metric.
Optionally, the report creating module is specifically configured to:
determining data to be displayed selected by a user in the data to be selected in the data set;
and creating a report based on the data to be displayed and the report format information selected by the user.
Optionally, the apparatus further includes a data selection module, where the data selection module is configured to:
determining a data selection interface corresponding to data to be selected in a data set;
and displaying the data selection interface to enable a user to complete selection of the data to be selected corresponding to the data selection interface based on the data selection interface.
Optionally, the target database is determined based on a user selection operation on the database.
Optionally, the apparatus further includes a report display module, configured to:
and displaying the report in the designated area.
It can be understood that the above modules of the report creation apparatus in this embodiment have functions of implementing the corresponding steps of the report creation method in the embodiment shown in fig. 1. The function can be realized by hardware, and can also be realized by executing corresponding software by hardware. The hardware or software includes one or more modules corresponding to the functions described above. The modules can be software and/or hardware, and each module can be implemented independently or by integrating a plurality of modules. For the functional description of each module of the report creating apparatus, reference may be specifically made to the corresponding description of the report creating method in the embodiment shown in fig. 1, and details are not described here again.
The embodiment of the application provides an electronic device, which comprises a processor and a memory;
a memory for storing operating instructions;
and the processor is used for executing the report creating method provided by any embodiment of the application by calling the operation instruction.
As an example, fig. 6 shows a schematic structural diagram of an electronic device to which an embodiment of the present application is applicable, and as shown in fig. 6, the electronic device 2000 includes: a processor 2001 and a memory 2003. Wherein the processor 2001 is coupled to a memory 2003, such as via a bus 2002. Optionally, the electronic device 2000 may also include a transceiver 2004. It should be noted that the transceiver 2004 is not limited to one in practical applications, and the structure of the electronic device 2000 is not limited to the embodiment of the present application.
The processor 2001 is applied to the embodiment of the present application to implement the method shown in the above method embodiment. The transceiver 2004 may include a receiver and a transmitter, and the transceiver 2004 is applied to the embodiments of the present application to implement the functions of the electronic device of the embodiments of the present application to communicate with other devices when executed.
The Processor 2001 may be a CPU (Central Processing Unit), general Processor, DSP (Digital Signal Processor), ASIC (Application specific integrated Circuit), FPGA (Field Programmable Gate Array) or other Programmable logic device, transistor logic device, hardware component, or any combination thereof. Which may implement or perform the various illustrative logical blocks, modules, and circuits described in connection with the disclosure. The processor 2001 may also be a combination of computing functions, e.g., comprising one or more microprocessors, DSPs and microprocessors, and the like.
The Memory 2003 may be a ROM (Read Only Memory) or other type of static storage device that can store static information and instructions, a RAM (Random Access Memory) or other type of dynamic storage device that can store information and instructions, an EEPROM (Electrically erasable programmable Read Only Memory), a CD-ROM (Compact disk Read Only Memory) or other optical disk storage, optical disk storage (including Compact disk, laser disk, optical disk, digital versatile disk, blu-ray disk, etc.), a magnetic disk storage medium or other magnetic storage device, or any other medium that can be used to carry or store desired program code in the form of instructions or data structures and that can be accessed by a computer, but is not limited to these.
Optionally, the memory 2003 is used for storing application program code for performing the disclosed aspects, and is controlled in execution by the processor 2001. The processor 2001 is configured to execute the application program code stored in the memory 2003 to implement the report creating method provided in any embodiment of the present application.
The electronic device provided by the embodiment of the application is applicable to any embodiment of the method, and is not described herein again.
Compared with the prior art, the electronic equipment has the advantages that the target data are acquired from the target database and constructed into the data set based on the specified dimensionality and the specified measurement submitted by the user, so that the report is created based on the report format information and the data set selected by the user. Based on the scheme, because the user specifies the dimension and the measurement and selects the report format, the user can directly define the report and automatically create the report according to the definition content, thereby simplifying the creation process of the report and improving the processing efficiency.
The embodiment of the application provides a computer-readable storage medium, wherein a computer program is stored on the computer-readable storage medium, and when the program is executed by a processor, the program realizes the report creating method shown in the above method embodiment.
The computer-readable storage medium provided in the embodiments of the present application is applicable to any of the embodiments of the foregoing method, and is not described herein again.
Compared with the prior art, the embodiment of the application provides a computer-readable storage medium, the target data are acquired from the target database and constructed into the data set based on the specified dimensionality and the specified measurement submitted by the user, and the report is created based on the report format information and the data set selected by the user. Based on the scheme, because the user specifies the dimension and the measurement and selects the report format, the user can directly define the report and automatically create the report according to the definition content, thereby simplifying the creation process of the report and improving the processing efficiency.
It should be understood that, although the steps in the flowcharts of the figures are shown in order as indicated by the arrows, the steps are not necessarily performed in order as indicated by the arrows. The steps are not performed in the exact order shown and may be performed in other orders unless explicitly stated herein. Moreover, at least a portion of the steps in the flow chart of the figure may include multiple sub-steps or multiple stages, which are not necessarily performed at the same time, but may be performed at different times, which are not necessarily performed in sequence, but may be performed alternately or alternately with other steps or at least a portion of the sub-steps or stages of other steps.
The foregoing is only a partial embodiment of the present invention, and it should be noted that, for those skilled in the art, various modifications and decorations can be made without departing from the principle of the present invention, and these modifications and decorations should also be regarded as the protection scope of the present invention.
Claims (10)
1. A report creating method is characterized by comprising the following steps:
acquiring target data from a target database;
constructing the target data into a data set based on the specified dimensionality and the specified measurement submitted by the user;
and creating a report based on the report format information selected by the user and the data set.
2. The method of claim 1, wherein obtaining the target field data from the target database comprises:
displaying the data fields in the target database to the user so that the user can select the data fields;
and determining the target data field selected by the user, and acquiring the target data corresponding to the target data field from the target database.
3. The method of claim 1, wherein determining a specified dimension and a specified metric of the user submission comprises;
displaying the field name of the target data field to the user;
determining whether the field name corresponding to the dimension selected by the user and the field name corresponding to the metric selected by the user meet preset conditions;
and if so, determining the dimension selected by the user as a specified dimension, and determining the metric selected by the user as a specified metric.
4. The method of claim 1, wherein creating a report based on the user-selected report format information and the dataset comprises:
determining the data to be displayed selected by the user in the data to be selected in the data set;
and creating a report based on the data to be displayed and the report format information selected by the user.
5. The method of claim 4, further comprising:
determining a data selection interface corresponding to the data to be selected in the data set;
and displaying a data selection interface so that the user can complete the selection of the data to be selected corresponding to the data selection interface based on the data selection interface.
6. The method of claim 1, wherein the target database is determined based on a user selection of a database.
7. The method according to any one of claims 1-6, further comprising:
and displaying the report in a specified area.
8. A report creation apparatus, comprising:
the data acquisition module is used for acquiring target data from a target database;
the data set construction module is used for constructing the target data into a data set based on the specified dimensionality and the specified measurement submitted by the user;
and the report creating module is used for creating a report based on the report format information selected by the user and the data set.
9. An electronic device comprising a processor and a memory;
the memory is used for storing operation instructions;
the processor is used for executing the method of any one of claims 1-7 by calling the operation instruction.
10. A computer-readable storage medium, characterized in that the storage medium has stored thereon a computer program which, when being executed by a processor, carries out the method of any one of claims 1-7.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202010538299.1A CN111797125A (en) | 2020-06-12 | 2020-06-12 | Report creating method and device, electronic equipment and computer readable storage medium |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202010538299.1A CN111797125A (en) | 2020-06-12 | 2020-06-12 | Report creating method and device, electronic equipment and computer readable storage medium |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN111797125A true CN111797125A (en) | 2020-10-20 |
Family
ID=72804133
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202010538299.1A Pending CN111797125A (en) | 2020-06-12 | 2020-06-12 | Report creating method and device, electronic equipment and computer readable storage medium |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN111797125A (en) |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN112765159A (en) * | 2020-12-30 | 2021-05-07 | 医渡云（北京）技术有限公司 | Report generation method, system, computer equipment and storage medium |
Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US5721903A (en) * | 1995-10-12 | 1998-02-24 | Ncr Corporation | System and method for generating reports from a computer database |
| CN109543162A (en) * | 2018-10-17 | 2019-03-29 | 金蝶软件（中国）有限公司 | More diagrammatic representation method, apparatus, computer equipment and the storage medium of data |
| CN109684387A (en) * | 2018-12-24 | 2019-04-26 | 成都四方伟业软件股份有限公司 | Report generation method and device |
| CN109753643A (en) * | 2018-12-05 | 2019-05-14 | 平安科技（深圳）有限公司 | Report style creation method, device, equipment and computer readable storage medium |
| CN110807002A (en) * | 2019-11-05 | 2020-02-18 | 杭州安恒信息技术股份有限公司 | Report generation method, system and equipment based on workflow and storage medium |
-
2020
- 2020-06-12 CN CN202010538299.1A patent/CN111797125A/en active Pending
Patent Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US5721903A (en) * | 1995-10-12 | 1998-02-24 | Ncr Corporation | System and method for generating reports from a computer database |
| CN109543162A (en) * | 2018-10-17 | 2019-03-29 | 金蝶软件（中国）有限公司 | More diagrammatic representation method, apparatus, computer equipment and the storage medium of data |
| CN109753643A (en) * | 2018-12-05 | 2019-05-14 | 平安科技（深圳）有限公司 | Report style creation method, device, equipment and computer readable storage medium |
| CN109684387A (en) * | 2018-12-24 | 2019-04-26 | 成都四方伟业软件股份有限公司 | Report generation method and device |
| CN110807002A (en) * | 2019-11-05 | 2020-02-18 | 杭州安恒信息技术股份有限公司 | Report generation method, system and equipment based on workflow and storage medium |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN112765159A (en) * | 2020-12-30 | 2021-05-07 | 医渡云（北京）技术有限公司 | Report generation method, system, computer equipment and storage medium |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN108228169B (en) | Chart making method, device, equipment and medium based on eCharts tool | |
| US9727836B2 (en) | Systems and methods for generating data visualization dashboards | |
| KR101665152B1 (en) | Extending collaboration capabilities to external data | |
| US10579678B2 (en) | Dynamic hierarchy generation based on graph data | |
| US20070260582A1 (en) | Method and System for Visual Query Construction and Representation | |
| US20070192724A1 (en) | Method and Apparatus for Custom Display of 3-D Information in Reporting | |
| US11868406B2 (en) | Smart interactions for a digital duplicate | |
| US10192330B2 (en) | Rendering data visualizations in different analytical applications | |
| US20080086716A1 (en) | Method and apparatus for information display with intermediate datasource access | |
| US11693873B2 (en) | Systems and methods for using entity/relationship model data to enhance user interface engine | |
| US20200342029A1 (en) | Systems and methods for querying databases using interactive search paths | |
| CN115544183B (en) | Data visualization method, device, computer equipment and storage medium | |
| CN106250110B (en) | Method and device for establishing model | |
| WO2014138945A1 (en) | Recommendation engine | |
| CN115840567A (en) | Application editing method and related equipment | |
| CN113722289A (en) | Method, device, electronic equipment and medium for constructing data service | |
| CN114741079B (en) | Software development method, platform, electronic device and computer readable storage medium | |
| CN113076103A (en) | Custom template generation method and system | |
| CN111797125A (en) | Report creating method and device, electronic equipment and computer readable storage medium | |
| US20130124484A1 (en) | Persistent flow apparatus to transform metrics packages received from wireless devices into a data store suitable for mobile communication network analysis by visualization | |
| CN112579664A (en) | Processing method and device for chart linkage | |
| CN114238724A (en) | Data visualization method and device | |
| US20140033089A1 (en) | Integration of transactional actions into analytical reports | |
| CN117194704B (en) | Method, device and equipment for inquiring attribute of component-level live-action three-dimensional model | |
| CN114462362A (en) | Report file generation method and device, computer 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 | ||
| TA01 | Transfer of patent application right | ||
| TA01 | Transfer of patent application right |
Effective date of registration: 20220919 Address after: 12 / F, 15 / F, 99 Yincheng Road, Pudong New Area pilot Free Trade Zone, Shanghai, 200120 Applicant after: Jianxin Financial Science and Technology Co.,Ltd. Address before: 25 Financial Street, Xicheng District, Beijing 100033 Applicant before: CHINA CONSTRUCTION BANK Corp. Applicant before: Jianxin Financial Science and Technology Co.,Ltd. |
|
| RJ01 | Rejection of invention patent application after publication | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20201020 |