Formula field and report configuration method and computer storage medium

A configuration method and field technology, applied in computing, digital data processing, digital data information retrieval, etc., can solve the problems of single report configuration effect, poor versatility and flexibility, and achieve the effect of ensuring accuracy and enriching data

Active Publication Date: 2022-04-29
重庆允丰科技有限公司
View PDF15 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0004] In view of this, the object of the present invention is to provide a formula field, a report configuration method and a computer storage medium to solve the problem of single report configuration effect, poor versatility and flexibility in the prior art

Method used

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
View more

Image

Smart Image Click on the blue labels to locate them in the text.
Viewing Examples
Smart Image
  • Formula field and report configuration method and computer storage medium
  • Formula field and report configuration method and computer storage medium
  • Formula field and report configuration method and computer storage medium

Examples

Experimental program
Comparison scheme
Effect test

Embodiment 1

[0059] Such as figure 1 Shown is a flow chart of a method for configuring a formula field in this embodiment. The configuration of the formula field in this embodiment is realized based on the industrial Internet platform, and the source data fields uploaded by each user and the corresponding source data are stored in the cloud database of the industrial Internet platform according to the user, and the cloud database is configured to be based on The user's request implements the call of the source data field and the corresponding source data. This embodiment specifically includes the following steps:

[0060] S1: Obtain source data fields and built-in functions.

[0061] Get source data fields based on a list of fields and get built-in functions based on a list of functions. The field list displays source data fields corresponding to all source data uploaded by the user in the cloud database. In this embodiment, in order to facilitate user selection, the source data fields...

Embodiment 2

[0178] Such as Figure 6 As shown, it is a flow chart of a formula field-based report configuration method according to Embodiment 2 of the present invention. The formula field in the formula field-based report configuration method of this embodiment can be implemented based on the formula field configuration method in Embodiment 1. Specifically, this embodiment includes the following steps:

[0179] P1: Configure report statistical dimensions and load optional fields.

[0180] First, configure the statistical dimensions of the report; in this embodiment, the statistical dimensions include product names, personnel names, and so on.

[0181] Then, the optional fields corresponding to each data in the cloud database are loaded based on the cloud database. In this embodiment, the optional fields include a source data field carrying a first field identifier and a formula field carrying a second field identifier, and the first field identifier and the second field identifier can...

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More

PUM

No PUM Login to View More

Abstract

The invention discloses a formula field and report configuration method and a computer storage medium. The formula field and report configuration method comprises the steps of obtaining a source data field based on a field list and obtaining a built-in function based on a function list; configuring a corresponding calculation rule for the obtained source data field based on the built-in function to form an agreed function, and configuring a corresponding formula field name; legality verification is carried out on the agreed function and the formula field name, and the legality of the agreed function comprises the legality of a built-in function and the legality of a calculation rule; according to the method, the formula field name passing the legality verification is associated with the agreed function to generate the formula field, and the formula field is updated to the field list, so that the formula field with user characteristics can be configured, the user can obtain expected data display, a cloud database can be enriched, and the universality and the flexibility are high.

Description

technical field [0001] The invention relates to the technical field of industrial Internet platforms, in particular to a formula field, a report configuration method and a computer storage medium. Background technique [0002] In the field of industrial Internet platform, based on the company's business, the basic data generated by each user's daily work and production can be sorted out and stored in a cloud database. When users need to view these data, the Industrial Internet platform can call the corresponding data based on the user's request and display it to the user in the form of a report; Different customers configure reports based on the fields of existing source data. [0003] Since the source data in the existing cloud database is mostly based on the monitoring equipment installed at each business site or uploaded by the user, when configuring the report, the user can only select the source data field for report configuration, which cannot satisfy the user's need ...

Claims

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More

Application Information

Patent Timeline
no application Login to View More
Patent Type & AuthorityApplications(China)
IPC IPC(8): G06F16/248G06F16/242G06F16/25
CPCG06F16/248G06F16/242G06F16/252
Inventor朱帅黄传林滕德谊涂娅
Owner重庆允丰科技有限公司