CN109299450A - Dynamic statement method for exhibiting data in a kind of business management software - Google Patents
Dynamic statement method for exhibiting data in a kind of business management software Download PDFInfo
- Publication number
- CN109299450A CN109299450A CN201811292408.5A CN201811292408A CN109299450A CN 109299450 A CN109299450 A CN 109299450A CN 201811292408 A CN201811292408 A CN 201811292408A CN 109299450 A CN109299450 A CN 109299450A
- Authority
- CN
- China
- Prior art keywords
- dimension
- data
- report
- attribute
- dimension element
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Pending
Links
- 238000000034 method Methods 0.000 title claims abstract description 17
- 230000001747 exhibiting effect Effects 0.000 title claims abstract description 12
- 241001269238 Data Species 0.000 abstract description 3
- 238000010586 diagram Methods 0.000 description 4
- 238000012423 maintenance Methods 0.000 description 2
- 238000012986 modification Methods 0.000 description 1
- 230000004048 modification Effects 0.000 description 1
- 238000006467 substitution reaction Methods 0.000 description 1
Classifications
-
- 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/177—Editing, e.g. inserting or deleting of tables; using ruled lines
- G06F40/18—Editing, e.g. inserting or deleting of tables; using ruled lines of spreadsheets
-
- 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
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Health & Medical Sciences (AREA)
- Artificial Intelligence (AREA)
- Audiology, Speech & Language Pathology (AREA)
- Computational Linguistics (AREA)
- General Health & Medical Sciences (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
The present invention relates to computer software fields, and in particular to dynamic statement method for exhibiting data in a kind of business management software.Dynamic statement method for exhibiting data in a kind of business management software, comprising steps of A) creation X-dimension tables of data；B Y dimension data table) is created；C Data dimension data table) is created.The present invention is designed by the way that report is split into three dimensions, that is X-dimension, Y dimension and Data dimension, with X-dimension element representation gauge outfit pattern, Y dimension element indicates table body pattern, Data dimension element indicates the report data to be shown, this design is suitable for most report style, it is capable of the various report datas of displaying of fast and flexible, method by carrying out row turn column to Data dimension element can be with the most statement form of Dynamic Display, and does not need the physical data table of creation different-format.
Description
Technical field
The present invention relates to computer software fields, and in particular, to dynamic statement data exhibition in a kind of business management software
Show method.
Background technique
Enterprise management software system generally can all carry out display data point after the acquisition of numerous data using report mode
The result of analysis.Therefore, there is Report form application module in most business management software, and create and generate report and displaying report
The mode of data is generally based primarily upon backstage creation physical data table and is completed to show report data by software developer, no
The displaying of same statement form and report data needs to be completed with the different physical data table in backstage.In face of there is numerous reports to need
For the enterprise asked, software developer is corresponding to show in order to which meet demand can constantly create more and more physical data tables
Report data, but this mode flexibly can not rapidly show report acquisition data, higher cost.
Summary of the invention
The object of the present invention is to provide dynamic statement method for exhibiting data in a kind of business management software, with solve it is above-mentioned extremely
A few technical problem.
In order to achieve the above object, the present invention adopts the following technical solutions:
Dynamic statement method for exhibiting data in a kind of business management software, which is characterized in that comprising steps of
A X-dimension tables of data) is created, by the gauge outfit pattern of X-dimension element representation report, X-dimension element is set and is defined
X-dimension attribute of an element stores X-dimension element to X-dimension tables of data；
B Y dimension data table) is created, the table body pattern of report is indicated by Y dimension element, is quoted when Y dimension element is set
X-dimension element and the attribute for defining Y dimension element store Y dimension element to Y dimension data table；
C Data dimension data table) is created, the report data to be shown are indicated by Data dimension element, Data is tieed up
Degree element is stored to Data dimension data table；
D) according to the Data dimension data table report collected data information to be shown, by Data dimension element according to X
The attribute of dimension element and the attribute of Y dimension element show report data.
In the step B, the attribute of Y dimension element is defined according to X-dimension attribute of an element.
In the step B, at least one Y dimension element quotes same X-dimension element.
In the step D, the Data dimension element is stored in the Data dimension data table in capable mode, according to
Data dimension element is shown report data in such a way that row turns column by the attribute of X-dimension attribute of an element and Y dimension element.
X-dimension attribute of an element includes that data type, display/hide, width, display format, statistics/such as summarize at the attributes.
The present invention is designed by the way that report is split into three dimensions, i.e. X-dimension, Y dimension and Data dimension, uses X-dimension
Element representation gauge outfit pattern, Y dimension element indicate table body pattern, and Data dimension element indicates the report data to be shown, this
Design is suitable for most report style, is capable of the various report datas of displaying of fast and flexible, by Data dimension element
The method for carrying out row turn column can be with the most statement form of Dynamic Display, and does not need the entity number of creation different-format
According to table.
Detailed description of the invention
Fig. 1 is the flow chart that report data is shown in the present invention；
Fig. 2 is the dimension schematic diagram of report in the present invention；
Fig. 3 is the schematic diagram of the X-dimension tables of data in the present invention；
Fig. 4 is the schematic diagram of the Y dimension data table in the present invention；
Fig. 5 is the schematic diagram of the Data dimension data table in the present invention.
Specific embodiment
A specific embodiment of the invention is further described below in conjunction with attached drawing.
As shown in Figure 1, dynamic statement method for exhibiting data in a kind of business management software, comprising steps of A) creation X-dimension
Tables of data is arranged X-dimension element and defines X-dimension attribute of an element, by X by the gauge outfit pattern of X-dimension element representation report
Dimension element is stored to X-dimension tables of data；B Y dimension data table) is created, the table body sample of report is indicated by Y dimension element
Formula quotes X-dimension element when Y dimension element is arranged and defines the attribute of Y dimension element, Y dimension element is stored to Y number of dimensions
According in table；C Data dimension data table) is created, the report data to be shown are indicated by Data dimension element, by Data dimension
Element is stored to Data dimension data table；D) believed according to the Data dimension data table report collected data to be shown
Data dimension element is shown report data according to the attribute of X-dimension attribute of an element and Y dimension element by breath.The present invention pass through by
Report splits into three dimensions to design, i.e. X-dimension, Y dimension and Data dimension, with X-dimension element representation gauge outfit pattern, Y dimension
Element representation table body pattern is spent, Data dimension element indicates the report data to be shown, this design is suitable for most report
Table sample formula is capable of the various report datas of displaying of fast and flexible, by Data dimension element carry out row turn the methods of column can be with
The most statement form of Dynamic Display, and do not need the physical data table of creation different-format.
In the step B, the attribute of Y dimension element is defined according to X-dimension attribute of an element.In the step B, at least one
A Y dimension element quotes same X-dimension element.Identical X-dimension can be designed that identical gauge outfit cited in different Y dimensions
The pattern of different table bodies.
In the step D, the Data dimension element is stored in the Data dimension data table in capable mode, according to
Data dimension element is shown report data in such a way that row turns column by the attribute of X-dimension attribute of an element and Y dimension element.X dimension
Degree attribute of an element includes that data type, display/hide, width, display format, statistics/such as summarize at the attributes.
As shown in Figure 2-5, it will include " coding ", " budget title ", " budget analysis ", " current budget ", " actually hold
Row ", " budget ratio ", " same period last year " gauge outfit pattern be used as X-dimension element, setting " 101 ", " 102 ", " 103 ",
" coding ", " the budget title ", " budget analysis ", " current period of " 10301 ", " 10302 ", " 10303 ", " 104 " to X-dimension element
Budget ", " practical to execute ", " budget ratio ", " same period last year " are encoded and are stored in X-dimension tables of data, define X-dimension element
Attribute, including data type, display/hide, width, display format, statistics/attributes such as summarize；Will comprising " administration fee ",
" administrative expenses ", " transportation expenses ", " rental charge ", " maintenance cost " table body pattern as Y dimension element, be arranged " 1001 ",
" 100101 ", " 100102 ", " 100103 ", " 100104 " to " administration fee " of Y dimension element, " administrative expenses ", " transportation expenses ",
" rental charge ", " maintenance cost " are encoded and are stored in Y dimension data table；Will comprising " 1001 ", " administration fee ", " 6,
000.00 ", " 5,000.00 ", " 83.33% ", " 6,500.00 ", " 100101 ", " administrative expenses " " 1,000.00 ", " 1,
000.00 ", the report data to be shown of " 100.00% " " 900.00 " are as Data dimension element, be arranged " 1-row ",
The Y dimension ID such as " 2-row " and " 1-column ", " 2-column ", " 3-column ", " 4-column ", " 5-column ", " 6-
The X-dimensions such as column " ID is stored in Data dimension data table, i.e., will according to the attribute of X-dimension attribute of an element and Y dimension element
Data dimension element carries out row and turns column, and then dynamically shows the report data to be shown.
It is discussed in detail although the contents of the present invention have passed through above preferred embodiment, but it should be appreciated that above-mentioned
Description is not considered as limitation of the present invention.After those skilled in the art have read above content, for of the invention
A variety of modifications and substitutions all will be apparent.Therefore, protection scope of the present invention should be limited to the appended claims.
Claims (5)
1. dynamic statement method for exhibiting data in a kind of business management software, which is characterized in that comprising steps of
A X-dimension tables of data) is created, by the gauge outfit pattern of X-dimension element representation report, X-dimension element is set and defines X dimension
Attribute of an element is spent, X-dimension element is stored to X-dimension tables of data；
B Y dimension data table) is created, the table body pattern of report is indicated by Y dimension element, reference X dimension when Y dimension element is set
Degree element and the attribute for defining Y dimension element, Y dimension element is stored to Y dimension data table；
C Data dimension data table) is created, the report data to be shown are indicated by Data dimension element, by Data dimension member
In element storage to Data dimension data table；
D) according to the Data dimension data table report collected data information to be shown, by Data dimension element according to X-dimension
The attribute of attribute of an element and Y dimension element shows report data.
2. dynamic statement method for exhibiting data in a kind of business management software as described in claim 1, which is characterized in that described
In step B, the attribute of Y dimension element is defined according to X-dimension attribute of an element.
3. dynamic statement method for exhibiting data in a kind of business management software as described in claim 1, which is characterized in that described
In step B, at least one Y dimension element quotes same X-dimension element.
4. dynamic statement method for exhibiting data in a kind of business management software as described in claim 1, which is characterized in that described
In step D, the Data dimension element is stored in the Data dimension data table in capable mode, according to X-dimension element
Data dimension element is shown report data in such a way that row turns column by attribute and the attribute of Y dimension element.
5. dynamic statement method for exhibiting data in a kind of business management software as described in claim 1, which is characterized in that X dimension
Degree attribute of an element includes that data type, display/hiding, width, display format, statistics/summarize attribute.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201811292408.5A CN109299450A (en) | 2018-10-31 | 2018-10-31 | Dynamic statement method for exhibiting data in a kind of business management software |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201811292408.5A CN109299450A (en) | 2018-10-31 | 2018-10-31 | Dynamic statement method for exhibiting data in a kind of business management software |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN109299450A true CN109299450A (en) | 2019-02-01 |
Family
ID=65145609
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201811292408.5A Pending CN109299450A (en) | 2018-10-31 | 2018-10-31 | Dynamic statement method for exhibiting data in a kind of business management software |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN109299450A (en) |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN110688826A (en) * | 2019-08-14 | 2020-01-14 | 中国平安人寿保险股份有限公司 | Disordered row-column transposition method and device, computer equipment and storage medium |
Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102184099A (en) * | 2011-04-15 | 2011-09-14 | 北京高森明晨信息科技有限公司 | Method, device and system used for configuring and generating application software report forms |
| CN103064689A (en) * | 2013-01-04 | 2013-04-24 | 大唐软件技术股份有限公司 | Implementation method and system for dynamically generating report pages |
| CN103729713A (en) * | 2013-11-06 | 2014-04-16 | 远光软件股份有限公司 | Audit result display configuration method and device |
| CN106372044A (en) * | 2016-09-13 | 2017-02-01 | 济南浪潮高新科技投资发展有限公司 | Method for generating typed dimension XBRL (Extensible Business Reporting Language) report based on report form |
-
2018
- 2018-10-31 CN CN201811292408.5A patent/CN109299450A/en active Pending
Patent Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102184099A (en) * | 2011-04-15 | 2011-09-14 | 北京高森明晨信息科技有限公司 | Method, device and system used for configuring and generating application software report forms |
| CN103064689A (en) * | 2013-01-04 | 2013-04-24 | 大唐软件技术股份有限公司 | Implementation method and system for dynamically generating report pages |
| CN103729713A (en) * | 2013-11-06 | 2014-04-16 | 远光软件股份有限公司 | Audit result display configuration method and device |
| CN106372044A (en) * | 2016-09-13 | 2017-02-01 | 济南浪潮高新科技投资发展有限公司 | Method for generating typed dimension XBRL (Extensible Business Reporting Language) report based on report form |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN110688826A (en) * | 2019-08-14 | 2020-01-14 | 中国平安人寿保险股份有限公司 | Disordered row-column transposition method and device, computer equipment and storage medium |
| CN110688826B (en) * | 2019-08-14 | 2023-07-25 | 中国平安人寿保险股份有限公司 | Disorder rank transposition method, device, computer equipment and storage medium |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN103106188B (en) | The graphical analytic system of data model and graphical analytical approach | |
| Mukhiya et al. | Hands-On Exploratory Data Analysis with Python: Perform EDA techniques to understand, summarize, and investigate your data | |
| CN102541867A (en) | Data dictionary generating method and system | |
| US20040205450A1 (en) | Method for visualizing large volumes of multiple-attribute data without aggregation using a pixel bar chart | |
| US8185817B2 (en) | Utilizing spreadsheet references with grouped aggregate views | |
| US20040135782A1 (en) | System and method for the visual display of data in an interactive zebra chart | |
| CN105653507A (en) | Chart generation method and device | |
| US9041726B2 (en) | Analyzing large data sets using digital images | |
| CN101751379A (en) | Method and equipment for manufacturing electronic newspaper document | |
| CN103729713A (en) | Audit result display configuration method and device | |
| Zhao et al. | Sketcholution: Interaction histories for sketching | |
| US20180330534A1 (en) | Data plot processing | |
| US20020163541A1 (en) | System and method for organizing and presenting information relating to the interpretation of multiple information elements, such as patent claim elements, in at least one reference source and graphical user interface incorporating the same | |
| CN109299450A (en) | Dynamic statement method for exhibiting data in a kind of business management software | |
| Hlawatsch et al. | Scale‐Stack Bar Charts | |
| Burch | Visual analytics of large dynamic digraphs | |
| US8051107B2 (en) | Method and device for creating relation-type form database | |
| CN102866985B (en) | For data formatter and the method for on-line analysing processing system | |
| Latif et al. | Visually augmenting documents with data | |
| Kilb et al. | Visualizing collections data: Why pie charts aren't always the answer | |
| CN114155037A (en) | Work result visualization method and system | |
| US9679498B2 (en) | Method and apparatus for providing a presentation model for an exercise | |
| Sarasan | A system for analysing museum documentation | |
| Egbert | The design and evaluation of an interactive choropleth map exploration system | |
| Wilkinson | Visualization |
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 | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20190201 |