技术领域technical field
本发明属于大数据领域，尤其涉及一种报表生成方法、装置、计算机设备及存储介质。The invention belongs to the field of big data, and in particular relates to a report generation method, device, computer equipment and storage medium.
背景技术Background technique
OLAP(On-line Analytical Processing，联机分析处理)是在基于数据仓库多维模型的基础上实现的面向分析的各类操作的集合，它使分析人员能够迅速、一致、交互地从各个方面观察信息，以达到深入理解数据的目的。许多企业利用关系型数据库来存储和管理业务数据，并建立相应的应用系统来支持日常的业务运作。这种应用以支持业务处理为主要目的，被称为联机事务处理(On line Transaction Processing，OLTP)应用，它所存储的数据被称为操作数据或者业务数据。OLAP (On-line Analytical Processing) is a collection of various analysis-oriented operations based on the multidimensional model of the data warehouse. It enables analysts to quickly, consistently and interactively observe information from all aspects. In order to achieve the purpose of in-depth understanding of the data. Many enterprises use relational databases to store and manage business data, and establish corresponding application systems to support daily business operations. Such an application mainly aims at supporting business processing, and is called an online transaction processing (On line Transaction Processing, OLTP) application, and the data stored in it is called operation data or business data.
随着数据库技术的广泛应用，企业信息系统产生了大量的业务数据，从这些海量的业务数据中提取出对企业决策分析有用的信息，需要设计指标，生成报表。每次报表的生成，通常由业务人员提出需求，开发人员进行相应的开发，时效性不高，报表生成不够灵活。With the wide application of database technology, enterprise information systems have produced a large amount of business data. To extract useful information for enterprise decision-making analysis from these massive business data, it is necessary to design indicators and generate reports. Every time a report is generated, the business personnel usually put forward the requirements, and the developers carry out the corresponding development. The timeliness is not high, and the report generation is not flexible enough.
发明内容Contents of the invention
本发明提供一种报表生成方法、装置、计算机设备及存储介质，以解决报表生成时效性不高，不够灵活的问题。The invention provides a report generation method, device, computer equipment and storage medium to solve the problems of low timeliness and inflexibility of report generation.
为解决上述技术问题，本发明提出一种报表生成方法，包括如下步骤：In order to solve the above-mentioned technical problems, the present invention proposes a method for generating a report, comprising the following steps:
获取待生成报表的指标；Obtain the indicators of the report to be generated;
根据所述指标在预设的配置文件库中查询与所述指标具有映射关系的配置文件，其中所述配置文件至少定义了所述指标的数据源、计算方式和展示样式；Querying a configuration file having a mapping relationship with the indicator in a preset configuration file library according to the indicator, wherein the configuration file at least defines the data source, calculation method and display style of the indicator;
根据所述配置文件定义的数据源在预设的数据库中查询与所述指标具有映射关系的数据，将所述数据按照所述配置文件中定义的计算方式计算所述指标的值；According to the data source defined in the configuration file, query the data having a mapping relationship with the indicator in a preset database, and calculate the value of the indicator according to the calculation method defined in the configuration file for the data;
将所述指标的值按照所述配置文件中定义的展示样式，生成所述指标的报表。The value of the indicator is generated according to the display style defined in the configuration file to generate a report of the indicator.
可选地，在所述将所述指标的值按照所述配置文件中定义的展示样式，生成所述指标的报表的步骤之后，还包括下述步骤：Optionally, after the step of generating the report of the indicator according to the display style defined in the configuration file, the following steps are further included:
将所述配置文件与所述指标的报表绑定，生成所述指标的报表卡片。The configuration file is bound to the report of the indicator, and the report card of the indicator is generated.
可选地，所述配置文件定义了所述指标的权限信息，在所述根据所述配置文件定义的数据源在预设的数据库中查询与所述指标具有映射关系的数据，将所述数据按照所述配置文件中定义的计算方式计算所述指标的值的步骤中，包括下述步骤：Optionally, the configuration file defines the permission information of the indicator, and the data that has a mapping relationship with the indicator is queried in the preset database according to the data source defined in the configuration file, and the data is The step of calculating the value of the indicator according to the calculation method defined in the configuration file includes the following steps:
获取待验证的权限信息；Obtain permission information to be verified;
将所述待验证的权限信息与所述指标的权限信息比对；Comparing the permission information to be verified with the permission information of the indicator;
当所述待验证的权限信息与所述指标的权限信息匹配时，根据所述配置文件定义的数据源在预设的数据库中查询与所述指标具有映射关系的数据，将所述数据按照所述配置文件中定义的计算方式计算所述指标的值，否则，返回数据获取失败消息。When the permission information to be verified matches the permission information of the indicator, query the data that has a mapping relationship with the indicator in the preset database according to the data source defined in the configuration file, and store the data according to the specified The calculation method defined in the above configuration file is used to calculate the value of the indicator, otherwise, a data acquisition failure message is returned.
可选地，所述预设的数据库为基于多维数据模型的数据库，其中保存在所述数据库中的数据源包括多维数据，在所述将所述指标的值按照所述配置文件中定义的展示样式，生成所述指标的报表的步骤中，包括下述步骤：Optionally, the preset database is a database based on a multidimensional data model, wherein the data source stored in the database includes multidimensional data, and the value of the indicator is displayed according to the definition in the configuration file style, the step of generating the report of the indicator includes the following steps:
获取所述指标的再处理指令，所述再处理指令包括对所述指标的钻取、上卷；Acquiring reprocessing instructions of the indicators, the reprocessing instructions including drilling and scrolling of the indicators;
根据对所述指标的钻取、上卷的再处理指令，将所述多维数据输入到预设的再处理模型中，获取再处理后的数据；According to the reprocessing instructions for drilling and rolling up the indicators, input the multi-dimensional data into a preset reprocessing model to obtain reprocessed data;
将所述再处理后的数据按照所述配置文件中定义的展示样式，生成所述指标的再处理报表，所述再处理报表为所述指标的报表的细节图表或者统计图表。The reprocessed data is generated according to the display style defined in the configuration file to generate a reprocessing report of the index, and the reprocessing report is a detailed chart or a statistical chart of the report of the index.
可选地，所述获取待生成报表的指标的步骤之前，还包括下述步骤：Optionally, before the step of obtaining the indicators of the report to be generated, the following steps are further included:
接收待存储的数据；receive data to be stored;
将接收到的数据按照时间段、类别、产生平台维度进行分类、筛选和统计，构成多维数据，存储到预设的数据库中。Classify, filter and count the received data according to the time period, category and generation platform dimensions to form multi-dimensional data and store them in the preset database.
为解决上述问题，本发明还提供一种报表生成装置，包括：In order to solve the above problems, the present invention also provides a report generating device, including:
获取模块，用于获取待生成报表的指标；The obtaining module is used to obtain the indicators of the report to be generated;
查询模块，用于根据所述指标在预设的配置文件库中查询与所述指标具有映射关系的配置文件，其中所述配置文件至少定义了所述指标的数据源、计算公式和展示样式；A query module, configured to query a configuration file that has a mapping relationship with the indicator in a preset configuration file library according to the indicator, wherein the configuration file at least defines the data source, calculation formula and display style of the indicator;
处理模块，用于根据所述配置文件定义的数据源在预设的数据库中查询与所述指标具有映射关系的数据，将所述数据按照所述配置文件中定义的计算方式计算所述指标的值；A processing module, configured to query a preset database for data that has a mapping relationship with the indicator according to the data source defined in the configuration file, and calculate the value of the indicator based on the calculation method defined in the configuration file for the data value;
生成模块，用于将所述指标的值按照所述配置文件中定义的展示样式，生成所述指标的报表。A generating module, configured to generate a report of the indicator according to the display style defined in the configuration file by the value of the indicator.
可选地，所述报表生成装置还包括：Optionally, the report generation device also includes:
绑定模块，用于将所述配置文件与所述指标的报表绑定，生成所述指标的报表卡片。The binding module is configured to bind the configuration file with the indicator report, and generate the indicator report card.
可选地，所述处理模块中还包括：Optionally, the processing module also includes:
第一获取子模块，用于获取待验证的权限信息；The first acquisition sub-module is used to acquire permission information to be verified;
第一比对子模块，用于将所述待验证的权限信息与所述指标的权限信息比对；A first comparison submodule, configured to compare the authority information to be verified with the authority information of the indicator;
第一处理子模块，用于当所述待验证的权限信息与所述指标的权限信息匹配时，根据所述配置文件定义的数据源在预设的数据库中查询与所述指标具有映射关系的数据，将所述数据按照所述配置文件中定义的计算方式计算所述指标的值，否则，返回数据获取失败消息。The first processing sub-module is configured to, when the authority information to be verified matches the authority information of the indicator, query the preset database for the information that has a mapping relationship with the indicator according to the data source defined in the configuration file. Data, calculate the value of the indicator according to the calculation method defined in the configuration file, otherwise, return a data acquisition failure message.
可选地，所述预设的数据库为基于多维数据模型的数据库，其中保存在所述数据库中的数据源包括多维数据，所述生成模块包括：Optionally, the preset database is a database based on a multidimensional data model, wherein the data sources stored in the database include multidimensional data, and the generating module includes:
第二获取子模块，用于获取所述指标的再处理指令，所述再处理指令包括对所述指标的钻取、上卷；The second acquisition sub-module is used to acquire the reprocessing instructions of the indicators, and the reprocessing instructions include drilling and scrolling of the indicators;
第二处理子模块，用于根据对所述指标的钻取、上卷的再处理指令，将所述多维数据输入到预设的再处理模型中，获取再处理后的数据；The second processing sub-module is used to input the multi-dimensional data into a preset reprocessing model according to the reprocessing instruction of drilling and rolling up the indicators, and obtain the reprocessed data;
第一生成子模块，用于将所述再处理后的数据按照所述配置文件中定义的展示样式，生成所述指标的再处理报表，所述再处理报表为所述指标的报表的细节图表或者统计图表。The first generation sub-module is used to generate a reprocessing report of the indicator according to the display style defined in the configuration file with the reprocessed data, and the reprocessing report is a detailed chart of the report of the indicator Or statistical graphs.
可选地，所述报表生成装置，还包括：Optionally, the report generation device also includes:
接收模块，用于接收待存储的数据；A receiving module, configured to receive data to be stored;
存储模块，用于将接收到的数据按照时间段、类别、产生平台维度进行分类、筛选和统计，构成多维数据，存储到预设的数据库中。The storage module is used to classify, filter and count the received data according to the time period, category and generation platform dimensions to form multi-dimensional data and store it in a preset database.
为解决上述技术问题，本发明实施例还提供一种计算机设备，包括存储器和处理器，所述存储器中存储有计算机可读指令，所述计算机可读指令被所述处理器执行时，使得所述处理器执行上述所述报表生成方法的步骤。In order to solve the above-mentioned technical problems, an embodiment of the present invention also provides a computer device, including a memory and a processor, where computer-readable instructions are stored in the memory, and when the computer-readable instructions are executed by the processor, the The processor executes the steps of the report generating method described above.
为解决上述技术问题，本发明实施例还提供一种计算机可读存储介质，所述计算机可读存储介质上存储有计算机可读指令，所述计算机可读指令被处理器执行时，使得所述处理器执行上述所述报表生成方法的步骤。In order to solve the above technical problems, an embodiment of the present invention also provides a computer-readable storage medium, on which computer-readable instructions are stored, and when the computer-readable instructions are executed by a processor, the The processor executes the steps of the report generation method described above.
本发明实施例的有益效果为：通过获取待生成报表的指标；根据所述指标在预设的配置文件库中查询与所述指标具有映射关系的配置文件，其中所述配置文件至少定义了所述指标的数据源、计算方式和展示样式；根据所述配置文件定义的数据源在预设的数据库中查询与所述指标具有映射关系的数据，将所述数据按照所述配置文件中定义的计算方式计算所述指标的值；将所述指标的值按照所述配置文件中定义的展示样式，生成所述指标的报表。通过指标调用配置文件，使报表的生成更灵活。The beneficial effects of the embodiments of the present invention are: by acquiring the indicators of the reports to be generated; querying the configuration files that have a mapping relationship with the indicators in the preset configuration file library according to the indicators, wherein the configuration files at least define the The data source, calculation method, and display style of the above-mentioned indicators; query the data that has a mapping relationship with the above-mentioned indicators in the preset database according to the data source defined in the configuration file, and store the data according to the data defined in the configuration file The calculation method calculates the value of the indicator; generates the report of the indicator according to the display style defined in the configuration file. Call configuration files through indicators to make report generation more flexible.
附图说明Description of drawings
为了更清楚地说明本发明实施例中的技术方案，下面将对实施例描述中所需要使用的附图作简单地介绍，显而易见地，下面描述中的附图仅仅是本发明的一些实施例，对于本领域技术人员来讲，在不付出创造性劳动的前提下，还可以根据这些附图获得其他的附图In order to more clearly illustrate the technical solutions in the embodiments of the present invention, the drawings that need to be used in the description of the embodiments will be briefly introduced below. Obviously, the drawings in the following description are only some embodiments of the present invention. For those skilled in the art, on the premise of not paying creative work, other drawings can also be obtained according to these drawings
图1为本发明实施例一种报表生成方法基本流程示意图；FIG. 1 is a schematic diagram of a basic flow chart of a method for generating a report according to an embodiment of the present invention;
图2为图1中步骤S103一实施方式的流程示意图；FIG. 2 is a schematic flow chart of an embodiment of step S103 in FIG. 1;
图3为本发明实施例指标的再处理报表生成流程示意图；Fig. 3 is a schematic diagram of the flow chart of reprocessing report generation of indicators in an embodiment of the present invention;
图4为本发明实施例一种报表生成装置基本结构框图；4 is a basic structural block diagram of a report generation device according to an embodiment of the present invention;
图5为本发明实施计算机设备基本结构框图。Fig. 5 is a block diagram of the basic structure of computer equipment for implementing the present invention.
具体实施方式Detailed ways
为了使本技术领域的人员更好地理解本发明方案，下面将结合本发明实施例中的附图，对本发明实施例中的技术方案进行清楚、完整地描述。In order to enable those skilled in the art to better understand the solutions of the present invention, the technical solutions in the embodiments of the present invention will be clearly and completely described below in conjunction with the drawings in the embodiments of the present invention.
在本发明的说明书和权利要求书及上述附图中的描述的一些流程中，包含了按照特定顺序出现的多个操作，但是应该清楚了解，这些操作可以不按照其在本文中出现的顺序来执行或并行执行，操作的序号如101、102等，仅仅是用于区分开各个不同的操作，序号本身不代表任何的执行顺序。另外，这些流程可以包括更多或更少的操作，并且这些操作可以按顺序执行或并行执行。需要说明的是，本文中的“第一”、“第二”等描述，是用于区分不同的消息、设备、模块等，不代表先后顺序，也不限定“第一”和“第二”是不同的类型。In some processes described in the specification and claims of the present invention and the above-mentioned drawings, a plurality of operations appearing in a specific order are contained, but it should be clearly understood that these operations may not be performed in the order in which they appear herein Execution or parallel execution, the serial numbers of the operations, such as 101, 102, etc., are only used to distinguish different operations, and the serial numbers themselves do not represent any execution order. Additionally, these processes can include more or fewer operations, and these operations can be performed sequentially or in parallel. It should be noted that the descriptions of "first" and "second" in this article are used to distinguish different messages, devices, modules, etc. are different types.
下面将结合本发明实施例中的附图，对本发明实施例中的技术方案进行清楚、完整地描述，显然，所描述的实施例仅仅是本发明一部分实施例，而不是全部的实施例。基于本发明中的实施例，本领域技术人员在没有作出创造性劳动前提下所获得的所有其他实施例，都属于本发明保护的范围。The following will clearly and completely describe the technical solutions in the embodiments of the present invention with reference to the accompanying drawings in the embodiments of the present invention. Obviously, the described embodiments are only some of the embodiments of the present invention, not all of them. Based on the embodiments of the present invention, all other embodiments obtained by those skilled in the art without creative efforts fall within the protection scope of the present invention.
实施例Example
本技术领域技术人员可以理解，这里所使用的“终端”、“终端设备”既包括无线信号接收器的设备，其仅具备无发射能力的无线信号接收器的设备，又包括接收和发射硬件的设备，其具有能够在双向通信链路上，执行双向通信的接收和发射硬件的设备。这种设备可以包括：蜂窝或其他通信设备，其具有单线路显示器或多线路显示器或没有多线路显示器的蜂窝或其他通信设备；PCS(Personal Communications Service，个人通信系统)，其可以组合语音、数据处理、传真和/或数据通信能力；PDA(Personal Digital Assistant，个人数字助理)，其可以包括射频接收器、寻呼机、互联网/内联网访问、网络浏览器、记事本、日历和/或GPS(Global Positioning System，全球定位系统)接收器；常规膝上型和/或掌上型计算机或其他设备，其具有和/或包括射频接收器的常规膝上型和/或掌上型计算机或其他设备。这里所使用的“终端”、“终端设备”可以是便携式、可运输、安装在交通工具(航空、海运和/或陆地)中的，或者适合于和/或配置为在本地运行，和/或以分布形式，运行在地球和/或空间的任何其他位置运行。这里所使用的“终端”、“终端设备”还可以是通信终端、上网终端、音乐/视频播放终端，例如可以是PDA、MID(Mobile Internet Device，移动互联网设备)和/或具有音乐/视频播放功能的移动电话，也可以是智能电视、机顶盒等设备。Those skilled in the art can understand that the "terminal" and "terminal equipment" used here not only include wireless signal receiver equipment, which only has wireless signal receiver equipment without transmission capabilities, but also include receiving and transmitting hardware. A device having receiving and transmitting hardware capable of performing bi-directional communication over a bi-directional communication link. Such equipment may include: cellular or other communication equipment, which has a single-line display or a multi-line display or a cellular or other communication equipment without a multi-line display; PCS (Personal Communications Service, personal communication system), which can combine voice, data Processing, facsimile and/or data communication capabilities; PDA (Personal Digital Assistant, Personal Digital Assistant), which may include radio frequency receiver, pager, Internet/Intranet access, web browser, notepad, calendar and/or GPS (Global Positioning System (Global Positioning System) receiver; a conventional laptop and/or palmtop computer or other device having and/or including a radio frequency receiver. As used herein, a "terminal", "terminal device" may be portable, transportable, installed in a vehicle (air, sea, and/or land), or adapted and/or configured to operate locally, and/or In distributed form, the operation operates at any other location on Earth and/or in space. The "terminal" and "terminal equipment" used here can also be communication terminals, Internet terminals, music/video playback terminals, such as PDAs, MIDs (Mobile Internet Devices, mobile Internet devices) and/or with music/video playback terminals. Functional mobile phones, smart TVs, set-top boxes and other devices.
本实施方式中的终端即为上述的终端。The terminal in this embodiment is the above-mentioned terminal.
具体地，请参阅图1，图1为本实施例一种报表生成方法的基本流程示意图。Specifically, please refer to FIG. 1 . FIG. 1 is a schematic flowchart of a method for generating a report in this embodiment.
如图1所示，一种报表生成方法，包括下述步骤：As shown in Figure 1, a report generation method includes the following steps:
S101、获取待生成报表的指标；S101. Obtain indicators of reports to be generated;
用户通过在可交互的界面上拖拽指标来选择满足自身业务需求的数据，系统通过读取用户在可交互界面上的选择的指标来获取用户的业务需求。指标是衡量事物的数据，例如年度营业收入、年度利润率等。这里提到的指标包含多个维度，例如年度营业收入至少包含营业收入金额和时间两个维度，所以这里获取的待生成报表的指标还可以包含对各个维度取值范围的指定。例如指定的时间维度的取值范围为2010～2018，也就是说生成2010～2018年年度营业收入的报表。Users select the data that meets their own business needs by dragging indicators on the interactive interface, and the system obtains the user's business needs by reading the indicators selected by the user on the interactive interface. Metrics are data that measure things, such as annual revenue, annual profit margin, and so on. The indicators mentioned here include multiple dimensions. For example, the annual operating income includes at least two dimensions: the amount of operating income and the time. Therefore, the indicators obtained here to generate the report can also include the specification of the value range of each dimension. For example, the value range of the specified time dimension is from 2010 to 2018, that is to say, the annual operating income report from 2010 to 2018 is generated.
S102、根据所述指标在预设的配置文件库中查询与所述指标具有映射关系的配置文件，其中所述配置文件至少定义了所述指标的数据源、计算方式和展示样式；S102. Query a preset configuration file library for a configuration file that has a mapping relationship with the indicator according to the indicator, wherein the configuration file at least defines the data source, calculation method, and display style of the indicator;
指标为预先设计的，与预先设计的配置文件具有映射关系，配置文件定义了指标的数据源，即报表中指标的具体值通过配置文件中定义的数据源和计算方式计算。同时预设的配置文件定义指标生成报表的样式。The indicator is pre-designed and has a mapping relationship with the pre-designed configuration file. The configuration file defines the data source of the indicator, that is, the specific value of the indicator in the report is calculated through the data source and calculation method defined in the configuration file. At the same time, the preset configuration file defines the style of the report generated by the indicator.
S103、根据所述配置文件定义的数据源在预设的数据库中查询与所述指标具有映射关系的数据，将所述数据按照所述配置文件中定义的计算方式计算所述指标的值；S103. Query the data having a mapping relationship with the indicator in a preset database according to the data source defined in the configuration file, and calculate the value of the indicator according to the calculation method defined in the configuration file for the data;
同样以生成2010～2018年度营业收入这一指标的报表为例，首先确定数据源，通常数据库中保存的数据颗粒度较小，例如记录的为月度营业收入或季度营业收入，要得到年度营业收入的报表，首先根据前述步骤获取的指标确定计算的范围，即在数据库中查询属于2010年1月到2018年12月这一范围的营业收入数据，然后按照年度营业收入的计算方式计算每年总的营业收入，计算方式同样须在与指标对应的配置文件中定义。Also take the report of the indicator of operating income from 2010 to 2018 as an example. First, determine the data source. Usually, the data stored in the database has a small granularity. For example, the records are monthly operating income or quarterly operating income. To get the annual operating income For the report, first determine the scope of calculation based on the indicators obtained in the previous steps, that is, query the operating income data in the database from January 2010 to December 2018, and then calculate the total annual operating income according to the calculation method of annual operating income For operating income, the calculation method must also be defined in the configuration file corresponding to the indicator.
S104、将所述指标的值按照所述配置文件中定义的展示样式，生成所述指标的报表。S104. Generate a report of the indicator based on the value of the indicator according to the display style defined in the configuration file.
预设的配置文件定义了指标生成报表的样式，为了使报表更直观，通常对指标进行图像化的展示，包括柱状图、折线图、饼图等。这里配置文件中可以通过调用第三方软件的方式，将指标的值按照设定的方式展示。The preset configuration file defines the style of the report generated by the indicator. In order to make the report more intuitive, the indicator is usually displayed graphically, including histograms, line charts, pie charts, etc. In the configuration file here, the value of the indicator can be displayed according to the set method by calling the third-party software.
现有的OLAP报表通常由业务分析人员根据业务需求选择要展示的数据维度开发相应的脚本或利用开源工具生成报表。通常情况下，这样产生报表不方便被其他业务人员再利用，需要业务分析人员提取当前数据生成报表。本申请通过预先设计指标并设定指标的配置文件，使报表生成智能化。Existing OLAP reports are usually developed by business analysts according to business needs to select the data dimensions to display corresponding scripts or use open source tools to generate reports. Usually, the reports generated in this way are inconvenient to be reused by other business personnel, and business analysts are required to extract current data to generate reports. This application makes the report generation intelligent by pre-designing the indicators and setting the configuration files of the indicators.
一些实施方式在步骤S104之后，还包括下述步骤：Some implementations also include the following steps after step S104:
S111、将所述配置文件与所述指标的报表绑定，生成所述指标的报表卡片。S111. Bind the configuration file with the indicator report, and generate the indicator report card.
所生成的报表在计算机系统中保存为报表文件，报表文件中包含数据和格式，通常为静态的，当报表分享给其他人员时，如果指标的数据源的数据发生的变化，报表不能体现出来。为使报表可以随着数据的改变而动态的发生改变，使业务决策人员看到的是最新的报表，将所生成的报表与指标的配置文件绑定，即将报表文件与指标的配置文件集成，生成指标的报表卡片。将报表文件与配置文件集成生成报表卡片的好处在于，当向其他人分享报表卡片时，报表内容会根据数据变化实时更新，而且只有当数据源发生变更时，需要调用配置文件中定义的数据源和计算方式重新计算指标的值，用重新计算的指标值更新报表文件中数据，从而更新报表，而数据源没有变化时，不需要对报表进行更新，这样既能保证报表是最新的，又避免了计算资源的浪费。The generated report is saved as a report file in the computer system. The report file contains data and format, which is usually static. When the report is shared with other personnel, if the data of the data source of the indicator changes, the report cannot reflect it. In order to make the report dynamically change with the change of data, so that business decision makers see the latest report, bind the generated report with the configuration file of the indicator, that is, integrate the report file with the configuration file of the indicator, Report card that generates metrics. The advantage of integrating the report file with the configuration file to generate the report card is that when the report card is shared with others, the report content will be updated in real time according to the data change, and only when the data source changes, the data source defined in the configuration file needs to be called Recalculate the value of the indicator with the calculation method, and update the data in the report file with the recalculated indicator value, thereby updating the report. When the data source does not change, there is no need to update the report, which can ensure that the report is up to date and avoid waste of computing resources.
如图2所示，在一些实施方式中，指标的配置文件中定义了指标的权限信息，在步骤S103中，包括下述步骤：As shown in FIG. 2 , in some implementations, the permission information of the indicator is defined in the configuration file of the indicator. In step S103, the following steps are included:
S121、获取待验证的权限信息；S121. Obtain permission information to be verified;
在一些业务场景中，指标及报表的可获取需要做限定，所以预先在指标的配置文件中定义指标的权限信息。当接收到用户的报表生成请求，进行数据查询时，先验证请求生成报表的用户是否具有指标的可获取权限。获取待验证的权限信息通常通过可交互的界面接收用户输入的凭证，可以是用户名+密码，也可以是用户名+指纹、用户名+人脸等信息。In some business scenarios, the availability of indicators and reports needs to be limited, so the permission information of indicators is defined in the indicator configuration file in advance. When receiving a user's report generation request and performing data query, first verify whether the user who requests to generate the report has the permission to obtain the indicator. Obtaining the permission information to be verified usually receives the credential input by the user through an interactive interface, which can be user name + password, or user name + fingerprint, user name + face and other information.
S122、将所述待验证的权限信息与所述指标的权限信息比对；S122. Compare the authority information to be verified with the authority information of the indicator;
将获取的待验证的权限信息与指标的权限信息进行比对，如果权限信息是用户名+密码，通过字符串对比的方式比对两者是否一致。如果权限信息为用户名+指纹或用户名+人脸等包含图像信息的形式，则通过字符串对比+图像对比的方式来比对。其中图像对比可以使用图像特征比对算法(ORB)来实现。Compare the obtained permission information to be verified with the permission information of the indicator. If the permission information is user name + password, compare the two strings to see if they are consistent. If the permission information is in the form of user name + fingerprint or user name + face, etc., which contains image information, the comparison is performed by string comparison + image comparison. The image comparison can be realized by using the image feature comparison algorithm (ORB).
S123、当所述待验证的权限信息与所述指标的权限信息匹配时，根据所述配置文件定义的数据源在预设的数据库中查询与所述指标具有映射关系的数据，将所述数据按照所述配置文件中定义的计算方式计算所述指标的值，否则，返回数据获取失败消息。S123. When the permission information to be verified matches the permission information of the indicator, query the data in the preset database for the data that has a mapping relationship with the indicator according to the data source defined in the configuration file, and store the data Calculate the value of the indicator according to the calculation method defined in the configuration file, otherwise, return a data acquisition failure message.
当待验证的权限信息与该指标的权限信息匹配时，从数据库中查询相应的数据，并计算该指标的具体值，否则，返回数据获取失败消息，提示用户没有获取该指标报表的权限。When the permission information to be verified matches the permission information of the indicator, query the corresponding data from the database and calculate the specific value of the indicator; otherwise, return a data acquisition failure message, prompting the user to not have permission to obtain the indicator report.
如图3所示，预设的数据库为基于多维数据模型的数据库，其中保存在数据库中的数据源包括多维数据，在步骤S104之后，还包括下述步骤：As shown in Figure 3, the preset database is a database based on a multidimensional data model, wherein the data sources stored in the database include multidimensional data, and after step S104, the following steps are also included:
S131、获取所述指标的再处理指令，所述再处理指令包括对所述指标的钻取、上卷；S131. Obtain a reprocessing instruction of the index, where the reprocessing instruction includes drilling and scrolling of the index;
报表文件预设有可交互的接口，通过可交互的接口获取对指标的再处理指令。这里的再处理指令指对指标的钻取、上卷、切片、切块、旋转、过滤或基本的数理统计等。保存在数据库中的数据源为多维数据，也就是说每个数据具有多个维度属性，例如部门A在2010年一季度上海地区的营业收入这一数据，则具有4个维度的属性，分别为所属的部门、时间、地区、营业收入。The report file is preset with an interactive interface, and the reprocessing instructions for the indicators can be obtained through the interactive interface. The reprocessing instructions here refer to drilling, scrolling, slicing, dicing, rotating, filtering or basic mathematical statistics of indicators. The data source stored in the database is multi-dimensional data, that is to say, each data has multiple dimensional attributes. For example, the business income of department A in Shanghai in the first quarter of 2010 has 4 dimensional attributes, namely The department, time, region, and operating income to which it belongs.
其中多维数据需要在数据存储时，标记其各个维度属性，例如数据产生的时间，所属的类别，产生的平台等。Among them, multi-dimensional data needs to mark its various dimension attributes when data is stored, such as the time when the data was generated, the category it belongs to, and the platform it was generated on.
其中，钻取为在维的不同层次间的变化，从上层降到下一层，或者说是将汇总数据拆分到更细节的数据，比如通过对2010年第二季度的总销售数据进行钻取来查看2010年第二季度4、5、6每个月的销售数据。上卷，钻取的逆操作，即从细粒度数据向高层的聚合，如将江苏省、上海市和浙江省的销售数据进行汇总来查看江浙沪地区的销售数据。切片，选择特定的值进行分析，比如只选择电子产品的销售数据，或者2010年第二季度的数据。切块，选择特定区间的数据或者某批特定值进行分析，比如选择2010年第一季度到2010年第二季度的销售数据，或者是电子产品和日用品的销售数据。旋转，即维的位置的互换，就像是二维表的行列转换。Among them, drilling refers to the change between different levels of the dimension, from the upper level to the lower level, or splitting the summary data into more detailed data, for example, by drilling the total sales data in the second quarter of 2010 Take it to view the monthly sales data of April, May, and June in the second quarter of 2010. Roll up, the inverse operation of drilling, that is, the aggregation from fine-grained data to high-level, such as summarizing the sales data of Jiangsu Province, Shanghai City, and Zhejiang Province to view the sales data of Jiangsu, Zhejiang and Shanghai. Slicing, select a specific value for analysis, such as selecting only the sales data of electronic products, or the data of the second quarter of 2010. Cut into pieces, select a specific range of data or a specific batch of values for analysis, such as selecting sales data from the first quarter of 2010 to the second quarter of 2010, or sales data of electronic products and daily necessities. Rotation, that is, the exchange of the positions of dimensions, is like the conversion of rows and columns in a two-dimensional table.
S132、根据对所述指标的钻取、上卷的再处理指令，将所述多维数据输入到预设的再处理模型中，获取再处理后的数据；S132. Input the multi-dimensional data into a preset reprocessing model according to the reprocessing instructions for drilling and scrolling the indicators, and obtain reprocessed data;
通过钻取、上卷等操作实现单图表到多图表的联动。数据分析的过程、结果，通常无法通过一个单独的图表来完全展示的，需要多个图表配合才能将事情的前因后果解释清楚。如果图表太多也存在弊端，在有限的空间内将图表之间的关系展示清楚是比较难的，影响对整体数据的理解，通过对报表中预设的接口调用再处理模型，对数据进行钻取或上卷，生成下一层级体现细节的图表或上一层级体现统计值的图表，使报表层次化，图表关系更容易被理解。Through operations such as drilling and scrolling, the linkage from a single chart to multiple charts is realized. The process and results of data analysis usually cannot be fully displayed through a single chart, and the cooperation of multiple charts is needed to explain the cause and effect of things clearly. If there are too many charts, there are also disadvantages. It is difficult to clearly display the relationship between the charts in a limited space, which will affect the understanding of the overall data. By calling the pre-set interface in the report and reprocessing the model, the data can be drilled Fetch or scroll up to generate a chart showing details at the next level or a chart showing statistical values at the previous level, making the report hierarchical and the relationship between the charts easier to understand.
预设的再处理模型定义了每一个再处理指令的计算方式，例如接收到的再处理指令为时间维度的钻取，则计算该指标在时间维度的下一层次的数据。例如通过对2010年第二季度的总销售数据进行钻取来查看2010年第二季度4、5、6每个月的销售数据。The preset reprocessing model defines the calculation method of each reprocessing instruction. For example, if the received reprocessing instruction is a drill in the time dimension, then the data of the indicator at the next level of the time dimension is calculated. For example, by drilling the total sales data in the second quarter of 2010, you can view the sales data of each month in the second quarter of 2010, 4th, 5th, and 6th.
S133、将所述再处理后的数据按照所述配置文件中定义的展示样式，生成所述指标的再处理报表，所述再处理报表为所述指标的报表的细节图表或者统计图表。S133. Generate a reprocessing report of the indicator according to the presentation style defined in the configuration file on the reprocessed data, where the reprocessing report is a detailed chart or a statistical chart of the report of the indicator.
获得了再处理后的数据同样根据配置文件中定义的展示样式，生成再处理后的报表。展示样式包括柱状图、折线图、饼图等。这里配置文件中可以通过调用第三方软件的方式，将再处理后的数据按照设定的方式展示。After obtaining the reprocessed data, a reprocessed report is also generated according to the display style defined in the configuration file. Display styles include bar chart, line chart, pie chart, etc. In the configuration file here, the reprocessed data can be displayed according to the set method by calling the third-party software.
为解决上述技术问题本发明实施例还提供一种报表生成装置。具体请参阅图4，图4为本实施例报表生成装置的基本结构框图。In order to solve the above technical problem, the embodiment of the present invention also provides a report generation device. Please refer to FIG. 4 for details. FIG. 4 is a basic structural block diagram of the report generation device of this embodiment.
如图4所示，一种报表生成装置，包括：获取模块210、查询模块220、处理模块230、生成模块240，其中获取模块210，用于获取待生成报表的指标；查询模块220，用于根据所述指标在预设的配置文件库中查询与所述指标具有映射关系的配置文件，其中所述配置文件至少定义了所述指标的数据源、计算公式和展示样式；处理模块230，用于根据所述配置文件定义的数据源在预设的数据库中查询与所述指标具有映射关系的数据，将所述数据按照所述配置文件中定义的计算方式计算所述指标的值；生成模块240，用于将所述指标的值按照所述配置文件中定义的展示样式，生成所述指标的报表。As shown in Figure 4, a report generation device includes: an acquisition module 210, a query module 220, a processing module 230, and a generation module 240, wherein the acquisition module 210 is used to obtain the indicators of the report to be generated; the query module 220 is used to Query the configuration file with the mapping relationship with the indicator in the preset configuration file library according to the indicator, wherein the configuration file at least defines the data source, calculation formula and display style of the indicator; the processing module 230 uses According to the data source defined in the configuration file, the data having a mapping relationship with the index is queried in a preset database, and the data is calculated according to the calculation method defined in the configuration file. The value of the index; the generation module 240, configured to generate a report of the indicator according to the display style defined in the configuration file based on the value of the indicator.
本发明实施例通过获取待生成报表的指标；根据所述指标在预设的配置文件库中查询与所述指标具有映射关系的配置文件，其中所述配置文件至少定义了所述指标的数据源、计算方式和展示样式；根据所述配置文件定义的数据源在预设的数据库中查询与所述指标具有映射关系的数据，将所述数据按照所述配置文件中定义的计算方式计算所述指标的值；将所述指标的值按照所述配置文件中定义的展示样式，生成所述指标的报表。通过指标调用配置文件，使报表的生成更灵活。In the embodiment of the present invention, by acquiring the indicators of the reports to be generated; querying the configuration files that have a mapping relationship with the indicators in the preset configuration file library according to the indicators, wherein the configuration files at least define the data sources of the indicators , calculation method and display style; query the data that has a mapping relationship with the indicator in the preset database according to the data source defined in the configuration file, and calculate the data according to the calculation method defined in the configuration file. The value of the indicator; the value of the indicator is generated according to the display style defined in the configuration file to generate the report of the indicator. Call configuration files through indicators to make report generation more flexible.
在一些实施方式中，所述报表生成装置还包括：绑定模块，用于将所述配置文件与所述指标的报表绑定，生成所述指标的报表卡片。In some embodiments, the report generation device further includes: a binding module, configured to bind the configuration file with the indicator report, and generate the indicator report card.
在一些实施方式中，所述处理模块230中还包括：第一获取子模块、第一比对子模块和第一处理子模块。其中，第一获取子模块，用于获取待验证的权限信息；第一比对子模块，用于将所述待验证的权限信息与所述指标的权限信息比对；第一处理子模块，用于当所述待验证的权限信息与所述指标的权限信息匹配时，根据所述配置文件定义的数据源在预设的数据库中查询与所述指标具有映射关系的数据，将所述数据按照所述配置文件中定义的计算方式计算所述指标的值，否则，返回数据获取失败消息。In some embodiments, the processing module 230 further includes: a first acquisition submodule, a first comparison submodule and a first processing submodule. Wherein, the first obtaining submodule is used to obtain the permission information to be verified; the first comparison submodule is used to compare the permission information to be verified with the permission information of the index; the first processing submodule is When the permission information to be verified matches the permission information of the indicator, query the data that has a mapping relationship with the indicator in a preset database according to the data source defined in the configuration file, and convert the data to Calculate the value of the indicator according to the calculation method defined in the configuration file, otherwise, return a data acquisition failure message.
在一些实施方式中，所述预设的数据库为基于多维数据模型的数据库，其中保存在所述数据库中的数据源包括多维数据，所述生成模块240中还包括：第二获取子模块、第二处理子模块和第一生成子模块，其中，第二获取子模块，用于获取所述指标的再处理指令，所述再处理指令包括对所述指标的钻取、上卷；第二处理子模块，用于根据对所述指标的钻取、上卷的再处理指令，将所述多维数据输入到预设的再处理模型中，获取再处理后的数据；第一生成子模块，用于将所述再处理后的数据按照所述配置文件中定义的展示样式，生成所述指标的再处理报表，所述再处理报表为所述指标的报表的细节图表或者统计图表。In some embodiments, the preset database is a database based on a multidimensional data model, wherein the data sources stored in the database include multidimensional data, and the generation module 240 also includes: a second acquisition submodule, a second Two processing sub-modules and a first generating sub-module, wherein the second acquiring sub-module is used to acquire the reprocessing instruction of the index, and the reprocessing instruction includes drilling and scrolling of the index; the second processing The sub-module is used to input the multi-dimensional data into the preset re-processing model according to the re-processing instructions of drilling and rolling up the indicators, and obtain the re-processed data; the first generation sub-module is used to The reprocessed data is generated according to the display style defined in the configuration file to generate a reprocessing report of the index, and the reprocessing report is a detailed chart or a statistical chart of the report of the index.
在一些实施方式中，所述报表生成装置还包括：接收模块和存储模块。其中，接收模块，用于接收待存储的数据；存储模块，用于将接收到的数据按照时间段、类别、产生平台维度进行分类、筛选和统计，构成多维数据，存储到预设的数据库中。In some embodiments, the report generation device further includes: a receiving module and a storage module. Among them, the receiving module is used to receive the data to be stored; the storage module is used to classify, filter and count the received data according to the time period, category and generation platform dimension to form multi-dimensional data and store it in the preset database .
为解决上述技术问题，本发明实施例还提供计算机设备。具体请参阅图5，图5为本实施例计算机设备基本结构框图。In order to solve the above technical problems, the embodiment of the present invention further provides computer equipment. Please refer to FIG. 5 for details. FIG. 5 is a block diagram of the basic structure of the computer device in this embodiment.
如图5所示，计算机设备的内部结构示意图。如图5所示，该计算机设备包括通过系统总线连接的处理器、非易失性存储介质、存储器和网络接口。其中，该计算机设备的非易失性存储介质存储有操作系统、数据库和计算机可读指令，数据库中可存储有控件信息序列，该计算机可读指令被处理器执行时，可使得处理器实现一种报表生成的方法。该计算机设备的处理器用于提供计算和控制能力，支撑整个计算机设备的运行。该计算机设备的存储器中可存储有计算机可读指令，该计算机可读指令被处理器执行时，可使得处理器执行一种报表生成的方法。该计算机设备的网络接口用于与终端连接通信。本领域技术人员可以理解，图5中示出的结构，仅仅是与本申请方案相关的部分结构的框图，并不构成对本申请方案所应用于其上的计算机设备的限定，具体的计算机设备可以包括比图中所示更多或更少的部件，或者组合某些部件，或者具有不同的部件布置。As shown in FIG. 5 , a schematic diagram of the internal structure of the computer equipment. As shown in FIG. 5, the computer device includes a processor, a non-volatile storage medium, a memory, and a network interface connected through a system bus. Wherein, the non-volatile storage medium of the computer device stores an operating system, a database, and computer-readable instructions, and the database can store control information sequences, and when the computer-readable instructions are executed by the processor, the processor can realize a A method of report generation. The processor of the computer equipment is used to provide computing and control capabilities, and supports the operation of the entire computer equipment. Computer-readable instructions may be stored in the memory of the computer device, and when the computer-readable instructions are executed by the processor, the processor may execute a report generation method. The network interface of the computer device is used for connecting and communicating with the terminal. Those skilled in the art can understand that the structure shown in Figure 5 is only a block diagram of a part of the structure related to the solution of this application, and does not constitute a limitation to the computer equipment on which the solution of this application is applied. The specific computer equipment can be More or fewer components than shown in the figures may be included, or certain components may be combined, or have a different arrangement of components.
本实施方式中处理器用于执行图4中获取模块210、查询模块220、处理模块230、生成模块240的具体内容，存储器存储有执行上述模块所需的程序代码和各类数据。网络接口用于向用户终端或服务器之间的数据传输。本实施方式中的存储器存储有报表生成方法中执行所有子模块所需的程序代码及数据，服务器能够调用服务器的程序代码及数据执行所有子模块的功能。In this embodiment, the processor is used to execute the specific content of the acquisition module 210, the query module 220, the processing module 230, and the generation module 240 in FIG. 4, and the memory stores program codes and various data required for executing the above modules. The network interface is used for data transmission between user terminals or servers. The memory in this embodiment stores the program codes and data needed to execute all submodules in the report generation method, and the server can call the server's program codes and data to execute the functions of all submodules.
计算机设备通过获取待生成报表的指标；根据所述指标在预设的配置文件库中查询与所述指标具有映射关系的配置文件，其中所述配置文件至少定义了所述指标的数据源、计算方式和展示样式；根据所述配置文件定义的数据源在预设的数据库中查询与所述指标具有映射关系的数据，将所述数据按照所述配置文件中定义的计算方式计算所述指标的值；将所述指标的值按照所述配置文件中定义的展示样式，生成所述指标的报表。通过指标调用配置文件，使报表的生成更灵活。The computer device obtains the indicators of the reports to be generated; according to the indicators, it queries the configuration files that have a mapping relationship with the indicators in the preset configuration file library, wherein the configuration files at least define the data sources and calculations of the indicators. method and display style; according to the data source defined in the configuration file, query the data that has a mapping relationship with the indicator in the preset database, and calculate the value of the indicator according to the calculation method defined in the configuration file. value; the value of the indicator is generated according to the display style defined in the configuration file, and the report of the indicator is generated. Call configuration files through indicators to make report generation more flexible.
本发明还提供一种存储有计算机可读指令的存储介质，所述计算机可读指令被一个或多个处理器执行时，使得一个或多个处理器执行上述任一实施例所述报表生成方法的步骤。The present invention also provides a storage medium storing computer-readable instructions. When the computer-readable instructions are executed by one or more processors, one or more processors execute the report generation method described in any of the above-mentioned embodiments. A step of.
本领域普通技术人员可以理解实现上述实施例方法中的全部或部分流程，是可以通过计算机程序来指令相关的硬件来完成，该计算机程序可存储于一计算机可读取存储介质中，该程序在执行时，可包括如上述各方法的实施例的流程。其中，前述的存储介质可为磁碟、光盘、只读存储记忆体(Read-Only Memory，ROM)等非易失性存储介质，或随机存储记忆体(Random Access Memory，RAM)等。Those of ordinary skill in the art can understand that realizing all or part of the processes in the methods of the above embodiments can be completed by instructing related hardware through a computer program, and the computer program can be stored in a computer-readable storage medium. During execution, it may include the processes of the embodiments of the above-mentioned methods. Wherein, the aforementioned storage medium may be a nonvolatile storage medium such as a magnetic disk, an optical disk, a read-only memory (Read-Only Memory, ROM), or a random access memory (Random Access Memory, RAM).
应该理解的是，虽然附图的流程图中的各个步骤按照箭头的指示依次显示，但是这些步骤并不是必然按照箭头指示的顺序依次执行。除非本文中有明确的说明，这些步骤的执行并没有严格的顺序限制，其可以以其他的顺序执行。而且，附图的流程图中的至少一部分步骤可以包括多个子步骤或者多个阶段，这些子步骤或者阶段并不必然是在同一时刻执行完成，而是可以在不同的时刻执行，其执行顺序也不必然是依次进行，而是可以与其他步骤或者其他步骤的子步骤或者阶段的至少一部分轮流或者交替地执行。It should be understood that although the various steps in the flow chart of the accompanying drawings are displayed sequentially according to the arrows, these steps are not necessarily executed sequentially in the order indicated by the arrows. Unless otherwise specified herein, there is no strict order restriction on the execution of these steps, and they can be executed in other orders. Moreover, at least some of the steps in the flowcharts of the accompanying drawings may include multiple sub-steps or multiple stages, and these sub-steps or stages are not necessarily executed at the same time, but may be executed at different times, and the order of execution is also It is not necessarily performed sequentially, but may be performed alternately or alternately with at least a part of other steps or sub-steps or stages of other steps.
以上所述仅是本发明的部分实施方式，应当指出，对于本技术领域的普通技术人员来说，在不脱离本发明原理的前提下，还可以做出若干改进和润饰，这些改进和润饰也应视为本发明的保护范围。The above descriptions are only part of the embodiments of the present invention. It should be pointed out that those skilled in the art can make some improvements and modifications without departing from the principles of the present invention. It should be regarded as the protection scope of the present invention.
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201910442209.6ACN110335009A (en) | 2019-05-24 | 2019-05-24 | Report generation method, device, computer equipment and storage medium |
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201910442209.6ACN110335009A (en) | 2019-05-24 | 2019-05-24 | Report generation method, device, computer equipment and storage medium |
| Publication Number | Publication Date |
|---|---|
| CN110335009Atrue CN110335009A (en) | 2019-10-15 |
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201910442209.6APendingCN110335009A (en) | 2019-05-24 | 2019-05-24 | Report generation method, device, computer equipment and storage medium |
| Country | Link |
|---|---|
| CN (1) | CN110335009A (en) |
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN110852053A (en)* | 2019-10-18 | 2020-02-28 | 平安医疗健康管理股份有限公司 | Report generation method and device based on suffix stack technology |
| CN110929491A (en)* | 2019-10-30 | 2020-03-27 | 贝壳技术有限公司 | Data report generation method, device, server and storage medium |
| CN111159164A (en)* | 2020-01-16 | 2020-05-15 | 四川天翼网络服务有限公司 | Report data access authority control method based on parametric transfer |
| CN112183041A (en)* | 2020-09-28 | 2021-01-05 | 建信金融科技有限责任公司 | An indicator-based report adjustment method, device, equipment and storage medium |
| CN112612923A (en)* | 2020-12-30 | 2021-04-06 | 深圳奥哲网络科技有限公司 | Statistical analysis graph construction method, system, electronic device and storage medium |
| CN112632108A (en)* | 2020-12-30 | 2021-04-09 | 深圳艾灵网络有限公司 | Rendering method and device of graph and report interface and electronic equipment |
| CN112905631A (en)* | 2020-12-08 | 2021-06-04 | 江苏苏宁云计算有限公司 | Report development method and device based on extensive indexes |
| CN113282218A (en)* | 2021-06-29 | 2021-08-20 | 中国平安人寿保险股份有限公司 | Multi-dimensional report generation method, device, equipment and storage medium |
| CN113627144A (en)* | 2021-08-20 | 2021-11-09 | 平安国际智慧城市科技股份有限公司 | Chart generation method and device based on artificial intelligence, electronic equipment and medium |
| CN113836882A (en)* | 2021-11-24 | 2021-12-24 | 深圳小库科技有限公司 | Method and device for generating economic index statistical table, computing equipment and storage medium |
| CN115510130A (en)* | 2022-09-29 | 2022-12-23 | 金蝶软件（中国）有限公司 | Report generating method, device, computer equipment and storage medium |
| CN116301871A (en)* | 2023-05-23 | 2023-06-23 | 南京海泰医疗信息系统有限公司 | Method and system for developing functional page by adopting index legend |
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN105989082A (en)* | 2015-02-10 | 2016-10-05 | 腾讯科技（深圳）有限公司 | Report view generation method and apparatus |
| CN109117467A (en)* | 2018-07-27 | 2019-01-01 | 广东讯飞启明科技发展有限公司 | Generation method, system, equipment and the medium of configurable dynamic data report |
| CN109241197A (en)* | 2018-06-21 | 2019-01-18 | 深圳市彬讯科技有限公司 | Data processing method, server and the storage medium that index is shown |
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN105989082A (en)* | 2015-02-10 | 2016-10-05 | 腾讯科技（深圳）有限公司 | Report view generation method and apparatus |
| CN109241197A (en)* | 2018-06-21 | 2019-01-18 | 深圳市彬讯科技有限公司 | Data processing method, server and the storage medium that index is shown |
| CN109117467A (en)* | 2018-07-27 | 2019-01-01 | 广东讯飞启明科技发展有限公司 | Generation method, system, equipment and the medium of configurable dynamic data report |
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN110852053A (en)* | 2019-10-18 | 2020-02-28 | 平安医疗健康管理股份有限公司 | Report generation method and device based on suffix stack technology |
| CN110929491A (en)* | 2019-10-30 | 2020-03-27 | 贝壳技术有限公司 | Data report generation method, device, server and storage medium |
| CN111159164A (en)* | 2020-01-16 | 2020-05-15 | 四川天翼网络服务有限公司 | Report data access authority control method based on parametric transfer |
| CN111159164B (en)* | 2020-01-16 | 2024-01-30 | 四川天翼网络股份有限公司 | Report data access right control method based on parameterization transfer |
| CN112183041A (en)* | 2020-09-28 | 2021-01-05 | 建信金融科技有限责任公司 | An indicator-based report adjustment method, device, equipment and storage medium |
| CN112905631A (en)* | 2020-12-08 | 2021-06-04 | 江苏苏宁云计算有限公司 | Report development method and device based on extensive indexes |
| CN112905631B (en)* | 2020-12-08 | 2024-12-24 | 江苏苏宁云计算有限公司 | Report development method and device based on generic indicators |
| CN112632108A (en)* | 2020-12-30 | 2021-04-09 | 深圳艾灵网络有限公司 | Rendering method and device of graph and report interface and electronic equipment |
| CN112612923A (en)* | 2020-12-30 | 2021-04-06 | 深圳奥哲网络科技有限公司 | Statistical analysis graph construction method, system, electronic device and storage medium |
| CN113282218A (en)* | 2021-06-29 | 2021-08-20 | 中国平安人寿保险股份有限公司 | Multi-dimensional report generation method, device, equipment and storage medium |
| CN113627144A (en)* | 2021-08-20 | 2021-11-09 | 平安国际智慧城市科技股份有限公司 | Chart generation method and device based on artificial intelligence, electronic equipment and medium |
| CN113836882A (en)* | 2021-11-24 | 2021-12-24 | 深圳小库科技有限公司 | Method and device for generating economic index statistical table, computing equipment and storage medium |
| CN115510130A (en)* | 2022-09-29 | 2022-12-23 | 金蝶软件（中国）有限公司 | Report generating method, device, computer equipment and storage medium |
| CN116301871A (en)* | 2023-05-23 | 2023-06-23 | 南京海泰医疗信息系统有限公司 | Method and system for developing functional page by adopting index legend |
| CN116301871B (en)* | 2023-05-23 | 2023-08-08 | 南京海泰医疗信息系统有限公司 | Method and system for developing functional page by adopting index legend |
| Publication | Publication Date | Title |
|---|---|---|
| CN110335009A (en) | Report generation method, device, computer equipment and storage medium | |
| JP7273045B2 (en) | Dimensional Context Propagation Techniques for Optimizing SQL Query Plans | |
| KR102522274B1 (en) | User grouping method, apparatus thereof, computer, computer-readable recording medium and computer program | |
| US20250028736A1 (en) | Systems and methods for combining data analyses | |
| US8825649B2 (en) | Smart defaults for data visualizations | |
| US9037579B2 (en) | Generating dynamic hierarchical facets from business intelligence artifacts | |
| US9031992B1 (en) | Analyzing big data | |
| US11163735B2 (en) | Database capacity estimation for database sizing | |
| EP2963570A1 (en) | Dynamic selection of source table for db rollup aggregation and query rewrite based on model driven definitions and cardinality estimates | |
| US20220004529A1 (en) | Automated audit balance and control processes for data stores | |
| US7809748B2 (en) | Extended cell information in multidimensional data models | |
| CN113986933A (en) | Materialized view creating method and device, storage medium and electronic equipment | |
| CN107092701A (en) | The data processing method and device of a kind of Multidimensional Data Model | |
| CN115641019A (en) | Index anomaly analysis method and device, computer equipment and storage medium | |
| CN114004542A (en) | Enterprise task management method, system, computer equipment and storage medium | |
| CN113312410B (en) | Data map construction method, data query method and terminal equipment | |
| CN115640300A (en) | Big data management method, system, electronic equipment and storage medium | |
| CN111611230A (en) | Method and device for establishing main data system, computer equipment and storage medium | |
| US11893069B2 (en) | Platform, method, and system for a search engine of time series data | |
| US20160379148A1 (en) | System and Methods for Interest-Driven Business Intelligence Systems with Enhanced Data Pipelines | |
| CN117609362A (en) | Data processing method, device, computer equipment and storage medium | |
| CN115203000A (en) | Method, apparatus, computer equipment for verifying search recall quality | |
| CN115759742A (en) | Enterprise risk assessment method and device, computer equipment and storage medium | |
| CN114820011A (en) | User group clustering method, apparatus, computer equipment and storage medium | |
| CN118838700B (en) | Distributed data mining task scheduling method and system |
| 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 | ||
| RJ01 | Rejection of invention patent application after publication | Application publication date:20191015 | |
| RJ01 | Rejection of invention patent application after publication |