CN113885859A - Low-code report implementation method based on SIS production operation data - Google Patents
Low-code report implementation method based on SIS production operation data Download PDFInfo
- Publication number
- CN113885859A CN113885859A CN202111218829.5A CN202111218829A CN113885859A CN 113885859 A CN113885859 A CN 113885859A CN 202111218829 A CN202111218829 A CN 202111218829A CN 113885859 A CN113885859 A CN 113885859A
- Authority
- CN
- China
- Prior art keywords
- data
- report
- sis
- production operation
- dimension
- 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.)
- Granted
Links
- 238000004519 manufacturing process Methods 0.000 title claims abstract description 29
- 238000000034 method Methods 0.000 title claims abstract description 23
- 230000000007 visual effect Effects 0.000 claims abstract description 13
- 238000004458 analytical method Methods 0.000 claims description 11
- 230000006870 function Effects 0.000 claims description 9
- 238000005259 measurement Methods 0.000 claims description 8
- 238000004220 aggregation Methods 0.000 claims description 5
- 230000002776 aggregation Effects 0.000 claims description 5
- 238000004364 calculation method Methods 0.000 claims description 5
- 238000012545 processing Methods 0.000 claims description 4
- 230000000903 blocking effect Effects 0.000 claims description 3
- 238000006243 chemical reaction Methods 0.000 claims description 3
- 238000004140 cleaning Methods 0.000 claims description 3
- 238000004141 dimensional analysis Methods 0.000 claims description 3
- 238000005553 drilling Methods 0.000 claims description 3
- 238000005065 mining Methods 0.000 claims description 3
- 230000003068 static effect Effects 0.000 claims description 3
- 230000001131 transforming effect Effects 0.000 claims description 3
- 238000012800 visualization Methods 0.000 claims description 3
- 230000000737 periodic effect Effects 0.000 claims description 2
- 238000011084 recovery Methods 0.000 claims description 2
- 230000004931 aggregating effect Effects 0.000 claims 2
- 238000013461 design Methods 0.000 abstract description 7
- 239000000446 fuel Substances 0.000 description 4
- 238000007405 data analysis Methods 0.000 description 2
- 230000007547 defect Effects 0.000 description 2
- 238000011161 development Methods 0.000 description 2
- 238000010586 diagram Methods 0.000 description 2
- 230000000694 effects Effects 0.000 description 2
- 238000009472 formulation Methods 0.000 description 2
- 239000000203 mixture Substances 0.000 description 2
- 230000009286 beneficial effect Effects 0.000 description 1
- 230000005540 biological transmission Effects 0.000 description 1
- 239000003086 colorant Substances 0.000 description 1
- 150000001875 compounds Chemical class 0.000 description 1
- 230000003203 everyday effect Effects 0.000 description 1
- 238000001914 filtration Methods 0.000 description 1
- 230000002452 interceptive effect Effects 0.000 description 1
- 230000008520 organization Effects 0.000 description 1
- 238000012163 sequencing technique Methods 0.000 description 1
- 238000003860 storage Methods 0.000 description 1
- 239000013589 supplement Substances 0.000 description 1
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F8/00—Arrangements for software engineering
- G06F8/30—Creation or generation of source code
- G06F8/34—Graphical or visual programming
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/22—Indexing; Data structures therefor; Storage structures
- G06F16/2282—Tablespace storage structures; Management thereof
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F40/00—Handling natural language data
- G06F40/10—Text processing
- G06F40/166—Editing, e.g. inserting or deleting
- G06F40/186—Templates
-
- Y—GENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
- Y02—TECHNOLOGIES OR APPLICATIONS FOR MITIGATION OR ADAPTATION AGAINST CLIMATE CHANGE
- Y02P—CLIMATE CHANGE MITIGATION TECHNOLOGIES IN THE PRODUCTION OR PROCESSING OF GOODS
- Y02P90/00—Enabling technologies with a potential contribution to greenhouse gas [GHG] emissions mitigation
- Y02P90/30—Computing systems specially adapted for manufacturing
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Software Systems (AREA)
- General Engineering & Computer Science (AREA)
- Physics & Mathematics (AREA)
- General Physics & Mathematics (AREA)
- Data Mining & Analysis (AREA)
- Databases & Information Systems (AREA)
- Health & Medical Sciences (AREA)
- Artificial Intelligence (AREA)
- Audiology, Speech & Language Pathology (AREA)
- Computational Linguistics (AREA)
- General Health & Medical Sciences (AREA)
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
A low-code report realization method based on SIS production operation data is characterized in that a data warehouse is constructed based on SIS production operation data, the scope and data positioning of a data table are defined according to a layered concept design, a data access port is standardized and unified, a B/S structure is adopted, a Web visual form designer is used for realizing data binding, zero coding and dragging operation of a report data set and a form grid, and a Chinese-style complex data report is easily completed; and the method can be separated from the technical developers, provides online visual design reports for users, improves the report generation efficiency and reduces the learning cost of the configuration reports.
Description
Technical Field
The invention relates to the technical field of industrial power station production and operation, in particular to a low-code report implementation method based on SIS production and operation data.
Background
At present, most of report systems in the market query and sort data sets of forms and graphs through a program background, then design and develop report templates through a form designer with a C/S structure, and arbitrarily make required display effects (forms, pie charts, bar charts, line charts, radar charts, compound charts and the like) to configure reports. The specific data table generation process comprises the following steps:
step a1, configuring data connection, in order to read data from the internal data source and the external relational database through the query language SQL, and configure the query task in the software system to be executed at a fixed period (such as every day, every hour, etc.), and refreshing data synchronously at full or incremental amount.
And step A2, obtaining data from the database which is connected in the step A1 through SQL query statements, performing data association, arrangement, combination, aggregation and other operations, and storing and displaying the result data in a two-dimensional table form as a data set required by the report.
A3, designing a report template through a form designer with a C/S structure, inserting a form or a graph into the report template, and adjusting fonts, styles, borders, colors and the like of static display data through the form designer; and D, data binding is carried out on the dynamically changed data through the data set generated in the step A2, and the design of the report display template content is completed.
Step A4, in the data set generated in step A2, selecting and extracting a certain column in the two-dimensional table of the specified data set as a report parameter, and setting the display type (text box, radio box, check box, drop-down box, date control, etc.) of the report parameter for storage; and after the form designer with the C/S structure finishes the design of the report template, saving the report template into file transmission report software such as xml and json for analysis and compilation to finally generate an Html file, and finally displaying the report effect in the browser.
It can be seen from the above report generation process that a report developer needs to set and configure a report data set, and specifically define which report parameters can be used as query conditions of the data set, and configure the row ordinate axis and data items in the diagram. And (4) running debugging for multiple times, selecting an appropriate data set and report parameters according to experience, and generating a report template. Therefore, the method of applying the report system has the following defects:
(1) the report configuration process is complex.
(2) The report data set has high difficulty and can be completed by professional technical developers.
(3) The report data statistics and debugging efficiency is low, and the learning cost is high.
Disclosure of Invention
In order to overcome the defects of the prior art and combine with SIS production operation data of a power plant, the invention aims to provide a low-code report realization method based on the SIS production operation data, which is based on an enterprise-level data warehouse, adopts a B/S structure, and develops a report through a Web visual form designer, a custom function, a data visual chart, zero coding, dragging operation and low coding; the method can be separated from the technical developers and provide online visual design reports for users, thereby improving the report generation efficiency and reducing the learning cost of the configuration reports.
In order to achieve the purpose, the technical scheme of the invention is as follows:
a low code report realization method based on SIS production operation data comprises the following steps:
step 1: classifying according to business data based on SIS production operation data, analyzing, counting, deciding and mining aiming at the data to determine subject data, and constructing a data warehouse of SIS production operation;
step 2: taking a data warehouse of enterprise-level SIS production operation as a data source, selecting single subject data in the data warehouse as the content of multi-dimensional analysis of the report, and determining the subject of the report;
and step 3: searching out a related public dimension set in a data warehouse according to the selected report topic, and selecting one or more dimensions from the dimension set as report parameters;
and 4, step 4: selecting a field element set of a multidimensional fact data summary table in a data warehouse as a report data set according to a report theme;
and 5: dragging the report data set collection element through a web client designer to realize data binding with the cell; configuring report style, layout and color matching; visual operations including charts, pictures, tables and the like are inserted to realize the configuration of the report template;
step 6: analyzing the report template content, dynamically constructing and loading a json text, generating an online report, changing the dimension level through report parameters, and transforming the analysis granularity of chart data to realize the report scrolling and drilling operation functions; meanwhile, when other dimension element values in the parameters are modified, the report slicing or blocking function is realized; a multi-dimensional data report and presentation analysis are interactively queried from multiple perspectives.
The invention has the beneficial effects that:
the method solves the problems of complex configuration process of the enterprise data report of the power plant, high learning cost of the function formula, high difficulty in SQL spelling and time consumption of data statistics; by using the method and the system, a user can immediately obtain a multi-dimensional theme fact data source from a power plant enterprise data warehouse only by selecting the theme content of report analysis; dragging the report data set through an online visual form to realize unit cell data binding and quickly making a required personalized report template; analyzing the template content, inquiring fact data according to the bound data set elements to dynamically replace the bound characters, forming report content, loading the report content into a Web designer, and easily realizing multidimensional data analysis and report inquiry along with the continuous switching and changing of report parameters.
Drawings
FIG. 1 is a diagram of a low code report development system.
FIG. 2 is a report formulation flow chart.
FIG. 3 is a report parameter graph.
Detailed Description
The present invention will be described in further detail with reference to the accompanying drawings.
The core content of the invention is as follows: a method for developing, configuring and displaying a low-code report based on an SIS data warehouse is characterized in that a visual form designer is organically combined with a data set, and a data report is easily, efficiently and inexpensively completed through zero-coding and dragging operations.
A low code report realization method based on SIS production operation data specifically comprises the following operations:
step 1, classifying according to business data by developers based on SIS production operation data, analyzing, counting, deciding, mining and establishing theme data aiming at the data, and constructing a data warehouse of SIS production operation.
The step is to construct a report data source, namely a multidimensional fact data summary table, and the specific operations are as follows:
(1) as shown in fig. 1, theme data (measuring points, indexes, fuels, etc.) are subjected to data denoising from a service table by an ETL tool from various service systems (such as SIS real-time data systems, production operation data systems, fuel overall process data systems and other service data systems), cleaned, and subjected to data conversion of service data associated tables, and then introduced into a data warehouse HDFS file system in a paradigm modeling and periodic increment manner, and the associated data between different service systems are uniformly and normatively stored as fact data detail.
(2) And periodically extracting all public dimension data (organization, personnel, equipment and time) from each business system through an ETL tool, for example, in a second step shown in FIG. 1, forming a dimension layer data table which is used for uniformly managing the dimension tables and is a designed dimension set. The core design of the dimension table is to determine that dimension attributes (filtering conditions, grouping conditions, sequencing and the like during later-stage OLAP query) are as rich as possible and are designed in a flat mode; and determining which tables and main dimension tables have association relations, and selecting some attributes of the tables for the dimension attributes of the main dimension tables.
(3) As shown in fig. 1, the service data (index multidimensional data summary table, overhaul multidimensional data summary table, fuel multidimensional data summary table, work order multidimensional data summary table, and the like) oriented to a topic domain is summarized by performing clear conversion, data cleaning, field merging, null value processing, dirty data processing according to dimensionality elements and performing minimum granularity summary aggregation or measurement aggregation on each dimensionality element based on basic data, namely a fact data detail table, on a data detail layer and stored in a data summarization layer in a data warehouse; and continuously iterating and optimizing the service data according to the requirements of the service layer, and finishing more and more service requirements of the report data through the data of the data summarizing layer along with the passage of time.
And 2, taking the data warehouse of enterprise-level SIS production operation as a data source, selecting single subject data in the data warehouse as the content of multi-dimensional analysis of the report, and determining the report subject.
(1) And combining a report formulation flow chart 2, connecting a data warehouse of SIS production operation to a data source of a report system, beginning to formulate a report, selecting and reading all multi-dimensional fact summary table sets (an index multi-dimensional data summary table, an overhaul multi-dimensional data summary table, a fuel multi-dimensional data summary table, a work ticket multi-dimensional data summary table and the like) in a data summary layer of the data warehouse, storing the sets into a system memory, using the sets as a report analysis data theme, and selecting one set as a report theme of the report.
(2) If the fact summary table is selected not to exist in the data warehouse of SIS production operation, for example, in a flow chart, a program calls a statistical calculation engine in the data warehouse to carry out measurement aggregation according to dimensionality, and carries out a statistical calculation off-line (historical) data multidimensional summary recovery task to establish the multidimensional fact summary table.
And 3, searching out the associated public dimension set in the data warehouse according to the selected report topic, and selecting one or more dimensions from the dimension set as report parameters.
As shown in fig. 2, the specific operation of step 3 is: the report back-end service autonomously loads the public dimension set and the measurement set associated with the report back-end service according to the report theme, report parameters can be set from the dimension set and the measurement set, one or more dimension element sets are selected as the report parameters, as shown in fig. 3, the report parameters (such as a unit #1#2#3, a time, a year, a month, a day, and the like) and the display types of a drop-down box, a unit box, a check box, a date type are designated as the header of the report, the report parameters are the contents of the report operation area, and the numerical values of the adjustable parameters achieve the purpose of updating the data contents of the report.
And 4, selecting a field element set of the multidimensional fact data summary table in the data warehouse as a report data set according to the report theme.
As shown in fig. 2, the key point of this step is to extract the dimension set, the data set and the measurement set in the fact summary table to form a report data set; selecting multi-column data from a multi-dimensional fact summary table (wide table) selected from a data warehouse as report data; the back-end service automatically loads all default column names in a multidimensional fact summary table (wide table) as a report data set according to the report theme, and can also select the column names as report data set elements.
Step 5, dragging the report data set collection element to realize data binding with the cell through a web client designer as shown in FIG. 2; configuring report style, layout and color matching; and inserting visualization operations including charts, pictures, tables and the like to realize the configuration of the report template.
The step visually configures the report template through the combination of the designer and the report dataset, and the specific operation comprises two parts:
(1) and static content: report styles, layouts, color matching, charts, pictures, tables, fonts and the like are directly edited and stored by an online visualization designer.
(2) And dynamic content: the designer loads a report data set, performs data binding with a grid in a form by dragging elements of the report data set, generates placeholders, specifies the expansion direction of the placeholders to be transverse expansion or longitudinal expansion, forms special placeholders, and stores the placeholders in a report template.
As shown in fig. 2, the visual configuration and display of the report data set are easily realized by the 2 steps of visual chart, zero coding and dragging operation.
Step 6, analyzing the report template content, dynamically constructing and loading json text, generating an online report, changing the dimension level through report parameters, and transforming the analysis granularity of chart data to realize the report scrolling and drilling operation functions; meanwhile, when other dimension element values in the parameters are modified, the report slicing or blocking function is realized; the interactive query of the multi-dimensional data report and the display analysis from multiple visual angles are easily realized.
In the step, the report back-end service analyzes the report template content to obtain the elements and the display position of the binding data set; and then dynamically inquiring a data binding placeholder on a data replacement display position by combining report parameters, performing iterative supplement of a dynamic data set in the position according to the placeholder expansion direction, finally generating a json text by a back-end service, transmitting the json text to a front-end UI, automatically loading report parameters on a header operation area for performing multi-dimensional data analysis by the front-end UI of the report system, loading the json text content, and displaying the report content in a web visual designer, thereby completing the functions of customized report development and display.
By using the invention, not only can the customization of the report be easily realized, but also the OLAP multidimensional analysis can be carried out on the report, the heavy participation of system developers is liberated, and the first user can formulate a professional data chart.
Claims (5)
1. A low code report realization method based on SIS production operation data is characterized by comprising the following steps:
step 1: classifying according to business data based on SIS production operation data, analyzing, counting, deciding and mining aiming at the data to determine subject data, and constructing a data warehouse of SIS production operation;
step 2: taking a data warehouse of enterprise-level SIS production operation as a data source, selecting single subject data in the data warehouse as the content of multi-dimensional analysis of the report, and determining the subject of the report;
and step 3: searching out a related public dimension set in a data warehouse according to the selected report topic, and selecting one or more dimensions from the dimension set as report parameters;
and 4, step 4: according to the report theme, selecting a field element set of a multidimensional fact data summary table in a data warehouse as a report data set;
and 5: dragging the report data set collection element through a web client designer to realize data binding with the cell; configuring report style, layout and color matching; visual operations including charts, pictures, tables and the like are inserted to realize the configuration of the report template;
step 6: analyzing the report template content, dynamically constructing and loading a json text, generating an online report, changing the dimension level through report parameters, and transforming the analysis granularity of chart data to realize the report scrolling and drilling operation functions; meanwhile, when other dimension element values in the parameters are modified, the report slicing or blocking function is realized; a multi-dimensional data report and presentation analysis are interactively queried from multiple perspectives.
2. The method for realizing the low-code report based on the SIS production operation data as claimed in claim 1, wherein the specific operation of the step 1 is as follows:
(1) carrying out data denoising on the theme data from the service table through an ETL tool in the service system, cleaning, converting the data of the service data association table, introducing the data into a data warehouse HDFS file system in a normal modeling and periodic increment mode, and uniformly and standardly storing the association data among different service systems as detailed fact data;
(2) extracting public dimensional data periodically and totally by an ETL tool from a business system to form a dimensional layer data table and determine dimensional attributes; determining which tables and main dimension tables have incidence relations, and determining the dimension attributes of the main dimension tables;
(3) clear conversion, data cleaning, field merging, null value processing and dirty data processing are carried out according to dimensions through a statistical calculation engine based on basic data, namely a fact data detail table, on a data detail layer, minimum granularity summarizing and aggregating or measuring and aggregating are carried out according to all dimension elements to obtain service data facing a subject domain, and the service data are stored in a data summarizing layer in a data warehouse; and continuously iterating and optimizing the service data according to the requirements of the service layer, and finishing more and more service requirements of the report data through the data of the data summarizing layer along with the passage of time.
3. The method for realizing the low-code report based on the SIS production operation data according to claim 1, wherein the specific operation in the step 2 is as follows:
(1) connecting a data warehouse in SIS production operation as a data source of a report system, starting to configure a report, selecting and reading all multi-dimensional fact summary table sets in a data summary layer of the data warehouse, storing the multi-dimensional fact summary table sets in a system memory as a set of report analysis data subjects, and selecting one report subject determined as the report from the set;
(2) and if the fact summary table is selected not to exist in the data warehouse of the SIS production operation, calling statistics in the data warehouse by a program, carrying out measurement aggregation according to the dimensionality by a calculation engine, carrying out statistics calculation on an off-line data multidimensional summary recovery task, and establishing the multidimensional fact summary table.
4. The method for realizing the low-code report based on the SIS production operation data according to claim 1, wherein the step 3 specifically comprises the following operations:
the report back-end service autonomously loads the public dimension set and the measurement set which are associated with the report theme according to the report theme, sets report parameters from the dimension set and the measurement set, selects one or more dimension element sets as the report parameters, and specifies that the display type is a drop-down box, a unit box, a check box and a date type as the header of the report.
5. The method for realizing the low-code report based on the SIS production operation data as claimed in claim 1, wherein the specific operation of the step 5 is as follows:
the step is to visually configure the report template by combining the designer and the report dataset, and the specific operation comprises two parts:
(1) and static content: the report style, layout, color matching, chart, picture, table, font and the like are directly edited and stored by an online visualization designer;
(2) and dynamic content: the designer loads a report data set, performs data binding with a grid in a form by dragging elements of the report data set, generates placeholders, specifies the expansion direction of the placeholders to be transverse expansion or longitudinal expansion, forms special placeholders, and stores the placeholders in a report template.
Priority Applications (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN202111218829.5A CN113885859B (en) | 2021-10-20 | 2021-10-20 | Low-code report implementation method based on SIS production operation data |
Applications Claiming Priority (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN202111218829.5A CN113885859B (en) | 2021-10-20 | 2021-10-20 | Low-code report implementation method based on SIS production operation data |
Publications (2)
Publication Number | Publication Date |
---|---|
CN113885859A true CN113885859A (en) | 2022-01-04 |
CN113885859B CN113885859B (en) | 2024-02-23 |
Family
ID=79003776
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
CN202111218829.5A Active CN113885859B (en) | 2021-10-20 | 2021-10-20 | Low-code report implementation method based on SIS production operation data |
Country Status (1)
Country | Link |
---|---|
CN (1) | CN113885859B (en) |
Cited By (2)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN114925665A (en) * | 2022-06-08 | 2022-08-19 | 杭州比智科技有限公司 | Graph data editing method and system based on web table |
CN115826936A (en) * | 2023-02-16 | 2023-03-21 | 江苏瑞中数据股份有限公司 | Electric power business expandable development framework based on low code and visual dragging |
Citations (6)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US5918232A (en) * | 1997-11-26 | 1999-06-29 | Whitelight Systems, Inc. | Multidimensional domain modeling method and system |
US20060085742A1 (en) * | 1999-05-28 | 2006-04-20 | Microstrategy, Incorporated | System and method for network user interface OLAP report formatting |
CN101110863A (en) * | 2007-08-16 | 2008-01-23 | 南京联创科技股份有限公司 | Analyzing method for value-added service general settlement |
US20160103886A1 (en) * | 2014-10-10 | 2016-04-14 | Salesforce.Com, Inc. | Declarative Specification of Visualization Queries, Display Formats and Bindings |
CN110415831A (en) * | 2019-07-18 | 2019-11-05 | 天宜(天津)信息科技有限公司 | A kind of medical treatment big data cloud service analysis platform |
CN111178023A (en) * | 2019-12-30 | 2020-05-19 | 广东飞企互联科技股份有限公司 | Visual self-defined report design system |
-
2021
- 2021-10-20 CN CN202111218829.5A patent/CN113885859B/en active Active
Patent Citations (6)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US5918232A (en) * | 1997-11-26 | 1999-06-29 | Whitelight Systems, Inc. | Multidimensional domain modeling method and system |
US20060085742A1 (en) * | 1999-05-28 | 2006-04-20 | Microstrategy, Incorporated | System and method for network user interface OLAP report formatting |
CN101110863A (en) * | 2007-08-16 | 2008-01-23 | 南京联创科技股份有限公司 | Analyzing method for value-added service general settlement |
US20160103886A1 (en) * | 2014-10-10 | 2016-04-14 | Salesforce.Com, Inc. | Declarative Specification of Visualization Queries, Display Formats and Bindings |
CN110415831A (en) * | 2019-07-18 | 2019-11-05 | 天宜(天津)信息科技有限公司 | A kind of medical treatment big data cloud service analysis platform |
CN111178023A (en) * | 2019-12-30 | 2020-05-19 | 广东飞企互联科技股份有限公司 | Visual self-defined report design system |
Non-Patent Citations (3)
Title |
---|
吴莹莹;: "浅议企业数据仓库的实现模式", 电脑知识与技术, no. 08, 15 March 2010 (2010-03-15) * |
孙四虎;张国圆;: "基于AI的广电大数据处理平台建设", 广播电视信息, no. 08, 15 August 2018 (2018-08-15) * |
高晓俊;朱琛刚;: "江苏有线经营数据可视化门户的设计与实现", 有线电视技术, no. 11, 15 November 2018 (2018-11-15) * |
Cited By (3)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN114925665A (en) * | 2022-06-08 | 2022-08-19 | 杭州比智科技有限公司 | Graph data editing method and system based on web table |
CN115826936A (en) * | 2023-02-16 | 2023-03-21 | 江苏瑞中数据股份有限公司 | Electric power business expandable development framework based on low code and visual dragging |
CN115826936B (en) * | 2023-02-16 | 2023-11-07 | 江苏瑞中数据股份有限公司 | Electric power business expandable development framework based on low codes and visual drag |
Also Published As
Publication number | Publication date |
---|---|
CN113885859B (en) | 2024-02-23 |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
CN109101652B (en) | Label creating and managing system | |
US9092467B2 (en) | Systems and methods for displaying data in split dimension levels | |
KR101169096B1 (en) | Diagrammatic access and arrangement of data | |
US7800613B2 (en) | Computer systems and methods for visualizing data with generation of marks | |
US7089266B2 (en) | Computer systems and methods for the query and visualization of multidimensional databases | |
US7698349B2 (en) | Dimension member sliding in online analytical processing | |
CN111542813A (en) | Using object models of heterogeneous data to facilitate building data visualizations | |
CN102841938A (en) | Method and system for generating parameterized report | |
US9075859B2 (en) | Parameterized database drill-through | |
US8190620B2 (en) | Apparatus and method for visualizing data within a decomposition graph | |
CN110955717A (en) | Visual dynamic display method and system based on big data | |
CN103019728B (en) | Effective complex report parsing engine and parsing method thereof | |
US20040039736A1 (en) | OLAP query generation engine | |
CN101944082A (en) | Excel-like report processing method | |
CN113885859B (en) | Low-code report implementation method based on SIS production operation data | |
CN103984755A (en) | Multidimensional model based oil and gas resource data key system implementation method and system | |
US8880459B2 (en) | Navigation across datasets from multiple data sources based on a common reference dimension | |
Dolk | Integrated model management in the data warehouse era | |
CN101452485A (en) | Method and device for generating multidimensional cubic based on relational database | |
CN111026801A (en) | Method and system for assisting operation quick decision-making work of insurance type e-commerce | |
CN105405069A (en) | Electricity purchase operating decision analysis and data processing method | |
CN116468010A (en) | Report generation method, device, terminal and storage medium | |
CN101187929A (en) | Formula definition assembly for flexible mathematical aiming at large data of database table | |
CN202433952U (en) | General network reporting system | |
CN113126849B (en) | Spreadsheet interactive mapping virtual system based on database and interactive mapping method |
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 | ||
GR01 | Patent grant | ||
GR01 | Patent grant |