CN107357923A - The cubical method of the tax is generated based on FreeMarker - Google Patents
The cubical method of the tax is generated based on FreeMarker Download PDFInfo
- Publication number
- CN107357923A CN107357923A CN201710600663.0A CN201710600663A CN107357923A CN 107357923 A CN107357923 A CN 107357923A CN 201710600663 A CN201710600663 A CN 201710600663A CN 107357923 A CN107357923 A CN 107357923A
- Authority
- CN
- China
- Prior art keywords
- tax
- generation
- cubical
- freemarker
- template
- 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
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/80—Information retrieval; Database structures therefor; File system structures therefor of semi-structured data, e.g. markup language structured data such as SGML, XML or HTML
- G06F16/83—Querying
- G06F16/838—Presentation of query results
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/80—Information retrieval; Database structures therefor; File system structures therefor of semi-structured data, e.g. markup language structured data such as SGML, XML or HTML
- G06F16/83—Querying
- G06F16/835—Query processing
Abstract
The present invention is disclosed based on the FreeMarker generation cubical methods of the tax, it is related to the on-line analytical processing field of data analysis, according to the dimension and index designed in the page, tax cube template is obtained from database, dimension and index are inserted into specified location, and utilize the FreeMarker template engines generation cubical configuration file of the tax.Pass through the present invention, required tax cube can flexibly be produced, the Operations Analyst such as tax staff can be drilled through according to the tax cube of generation, be cut into slices, stripping and slicing and rotation, data are checked from multiple dimensions, many levels, it was found that different data characteristic, tax rule is summarized, advantageous information is provided for tax decision-making.
Description
Technical field
The present invention relates to the on-line analytical processing field of data analysis, specifically generates the tax based on FreeMarker
Cubical method.
Background technology
With the extensive use of database technology, tax system generates substantial amounts of business datum, how from these magnanimity
Business datum in extract the information useful to tax Analysis of Policy Making, turn into the important difficulty that tax office decision-making management personnel are faced
Topic.
Tax staff gradually attempts to reprocess the data in relevant database, generates multidimensional data, Ran Houjian
Vertical tax cube, from multiple dimensions, a point a variety of levels are summarized analysis to tax data.It is but more due to tax demand
Sample, the tax cube of static state is set in advance, can not meet the needs of revenue department.Therefore, with users such as revenue departments
Various demands, can flexibly produce tax cube, turn into current extremely urgent urgent problem.
The content of the invention
Demand and weak point of the present invention for the development of current technology, there is provided the tax cube is generated based on FreeMarker
The method of body.
It is of the present invention that the cubical method of the tax is generated based on FreeMarker, solve the skill that above-mentioned technical problem uses
Art scheme is as follows：It is described based on the FreeMarker generation cubical methods of the tax, according to the dimension and index designed in the page,
By the configuration template in database, the related configuration text of tax cube is automatically generated by FreeMarker template engines
Part；
Its specific steps includes：1）The dimension and index that the formation of dragging field needs in the page, 2）The tax is obtained from database
Cube template, template splicing dimension and index, 3）Utilize the cubical configuration text of the Freemarker modules engine generation tax
Part, 4）Configuration file is read, various dimensions, multi-layer are analyzed data.
Preferably, step 1）Refer to, needed in the page using association analysis between jsplumb lines storehouse progress table, generation
Dimension and index.
Preferably, step 2）Refer to, XML configuration file template is inquired from database, then fills out dimension and index
Enter the specified location of template, generate associated profile.
Preferably, step 3）Refer to, the associated profile content of generation in step 2) is write into XML file, generates tax
It is engaged in cubical XML configuration file；
Preferably, step 4）Refer to, according to the tax cube of generation, the cubical XML configuration file of the tax is read, to same
Categorical data carries out the inquiry of various dimensions, multi-layer, finds data characteristic, summarizes tax rule.
Of the present invention to generate the cubical method of the tax based on FreeMarker, what is had compared with prior art is beneficial
Effect is：The present invention on the page by pulling generation dimension and index, relatively flexibly and easily；According to the dimension configured in the page
And index, automatically generate the configuration file required for tax cube；, can be to same type data by going to read configuration file
The inquiry of various dimensions, multi-layer is carried out, finds different data characteristics, summarizes tax rule, favourable letter is provided for tax decision-making
Breath；When tax staff changes tax cube, related drag operation only need to be carried out in the page, it is not necessary to XML configuration file
In label understood, you can complete the cubical configuration file of the tax modification, can flexibly establish tax cube,
Meet revenue department's variation needs.
Brief description of the drawings
Accompanying drawing 1 is the flow chart that the cubical method of the tax is generated based on FreeMarker.
Embodiment
For the object, technical solutions and advantages of the present invention are more clearly understood, below in conjunction with specific embodiment, to this hair
It is bright described based on the cubical method further description of the FreeMarker generations tax.
The present invention proposes generates the cubical method of the tax based on FreeMarker, and being can by Freemarker generations
For the tax cube of multidimensional analysis, according to the dimension and index designed in the page, the spirit of Freemarker modules engine is utilized
Tax cube required for generation living, it then can be drilled through, be cut into slices according to the tax cube of generation, stripping and slicing and rotation
Deng Operations Analyst, data are checked from multiple dimensions, many levels, find different data characteristics, summarize tax rule,
Support decision-making.
Embodiment：
Based on the FreeMarker generation cubical methods of the tax described in the present embodiment, according to the dimension designed in the page and refer to
Mark is related by the flexible automatic generation tax cube of FreeMarker template engines by the configuration template in database
Configuration file.
As shown in Figure 1, should be included based on the specific steps of the FreeMarker generation cubical methods of the tax：1）In page
The dimension and index that the formation of dragging field needs in face, 2）From database obtain tax cube template, template splicing dimension and
Index, 3）Using Freemarker modules engine generate the cubical configuration file of the tax, 4）Reading configuration file, various dimensions,
Multi-layer is analyzed data.
FreeMarker is a template engine：It is i.e. a kind of based on template and the data to be changed, and for generate it is defeated
Go out text（Html web page, Email, configuration file, source code etc.）General utility tool, be a JAVA class libraries, can be embedded in
In current project.
Step 1）Field is pulled in the page and forms the dimension and index needed, is specifically included in the page and utilizes
Jsplumb lines storehouse carries out association analysis between table, generates the dimension and index of needs.
Step 2）Tax cube template, template splicing dimension and index are obtained from database, is specifically included from database
In inquire XML configuration file template, then dimension and index inserted to the specified location of template, generate associated profile.
Step 3）The cubical configuration file of the tax is generated using Freemarker modules engine, is specifically included step 2)
The associated profile content write-in XML file of middle generation, generates the cubical XML configuration file of the tax；
Step 4）Configuration file is read, various dimensions, multi-layer are analyzed data, specifically include and stood according to the tax of generation
Cube, the cubical XML configuration file of the tax is read, same type data are carried out with the inquiry of various dimensions, multi-layer, find number
According to characteristic, tax rule is summarized.
It is embodied, comes further below by the FreeMarker generations cubical method of the tax is based on to this
Its technical scheme is solved, specific implementation step is as follows：
1）Jsplumb lines storehouse is utilized in the page, completes the simple association analysis of data, and the modification of dimension, index；
2）Take a fancy in database and read XML configuration file template, the specified location generation that dimension and index are inserted to template is matched somebody with somebody
Put file；
3）XML configuration file is generated according to the configuration file content of correlation；
4）The data query of various dimensions, multi-layer is carried out by the XML configuration file of generation.
Using the FreeMarker generation cubical methods of the tax are based on described in the present embodiment, tax staff changes the tax and stood
During cube, related drag operation only need to be carried out in the page, it is not necessary to which the label in XML configuration file is understood, you can
Complete the modification of the cubical configuration file of the tax；After the completion of modification, tax staff can carry out various dimensions, more to same data
The analysis of level.
Embodiment is only the specific case of the present invention, and scope of patent protection of the invention is including but not limited to above-mentioned
Embodiment, any person of an ordinary skill in the technical field that meet claims of the present invention and any is to it
The appropriate change or replacement done, it should all fall into the scope of patent protection of the present invention.
Claims (5)
1. based on the FreeMarker generation cubical methods of the tax, it is characterised in that according to the dimension designed in the page and refer to
Mark, by the configuration template in database, matching somebody with somebody for tax cube correlation is automatically generated by FreeMarker template engines
Put file；
Its specific steps includes：1）The dimension and index that the formation of dragging field needs in the page, 2）The tax is obtained from database
Cube template, template splicing dimension and index, 3）Utilize the cubical configuration text of the Freemarker modules engine generation tax
Part, 4）Configuration file is read, various dimensions, multi-layer are analyzed data.
2. according to claim 1 based on the FreeMarker generation cubical methods of the tax, it is characterised in that in the page
Association analysis between table is carried out using jsplumb lines storehouse, generates the dimension and index of needs.
3. according to claim 2 based on the FreeMarker generation cubical methods of the tax, it is characterised in that from database
In inquire XML configuration file template, dimension and index inserted to the specified location of XML configuration file template, generation correlation is matched somebody with somebody
Put file.
4. according to claim 3 based on the FreeMarker generation cubical methods of the tax, it is characterised in that by generation
The associated profile content writes XML file, generates the cubical XML configuration file of the tax.
5. according to claim 4 based on the FreeMarker generation cubical methods of the tax, it is characterised in that according to generation
The tax cube, read the cubical XML configuration file of the tax, to same type data carry out various dimensions, multi-layer
Inquiry.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201710600663.0A CN107357923A (en) | 2017-07-21 | 2017-07-21 | The cubical method of the tax is generated based on FreeMarker |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201710600663.0A CN107357923A (en) | 2017-07-21 | 2017-07-21 | The cubical method of the tax is generated based on FreeMarker |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN107357923A true CN107357923A (en) | 2017-11-17 |
Family
ID=60286063
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201710600663.0A Pending CN107357923A (en) | 2017-07-21 | 2017-07-21 | The cubical method of the tax is generated based on FreeMarker |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN107357923A (en) |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN108255479A (en) * | 2017-12-08 | 2018-07-06 | 平安科技（深圳）有限公司 | Creation method, device, storage medium and the terminal of cube files |
| CN109739940A (en) * | 2018-12-29 | 2019-05-10 | 东软集团股份有限公司 | On-line analytical processing method, apparatus, storage medium and electronic equipment |
Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101111835A (en) * | 2004-11-30 | 2008-01-23 | 科格洛斯公司 | Automated default dimension selection within a multidimensional enterprise software system |
| CN104778241A (en) * | 2015-04-08 | 2015-07-15 | 北京京东尚科信息技术有限公司 | Report generation method and system |
| CN105426434A (en) * | 2015-11-04 | 2016-03-23 | 北京航天金盾科技有限公司 | Multi-dimension-based population information statistical analysis system |
| CN105528400A (en) * | 2015-12-02 | 2016-04-27 | 浪潮通用软件有限公司 | Web-based multidimensional analysis system and method |
| CN105740368A (en) * | 2016-01-27 | 2016-07-06 | 浪潮通信信息系统有限公司 | Method and device for generating report form |
-
2017
- 2017-07-21 CN CN201710600663.0A patent/CN107357923A/en active Pending
Patent Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101111835A (en) * | 2004-11-30 | 2008-01-23 | 科格洛斯公司 | Automated default dimension selection within a multidimensional enterprise software system |
| CN104778241A (en) * | 2015-04-08 | 2015-07-15 | 北京京东尚科信息技术有限公司 | Report generation method and system |
| CN105426434A (en) * | 2015-11-04 | 2016-03-23 | 北京航天金盾科技有限公司 | Multi-dimension-based population information statistical analysis system |
| CN105528400A (en) * | 2015-12-02 | 2016-04-27 | 浪潮通用软件有限公司 | Web-based multidimensional analysis system and method |
| CN105740368A (en) * | 2016-01-27 | 2016-07-06 | 浪潮通信信息系统有限公司 | Method and device for generating report form |
Non-Patent Citations (2)
| Title |
|---|
| 匿名: "Putting the XML into the data-model", 《FREEMARKER官网》 * |
| 朱永光: "Power BI入门教程", 《博客园》 * |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN108255479A (en) * | 2017-12-08 | 2018-07-06 | 平安科技（深圳）有限公司 | Creation method, device, storage medium and the terminal of cube files |
| CN109739940A (en) * | 2018-12-29 | 2019-05-10 | 东软集团股份有限公司 | On-line analytical processing method, apparatus, storage medium and electronic equipment |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN108460014B (en) | Enterprise entity identification method and device, computer equipment and storage medium | |
| US10521464B2 (en) | Method and system for extracting, verifying and cataloging technical information from unstructured documents | |
| US10740429B2 (en) | Apparatus and method for acquiring, managing, sharing, monitoring, analyzing and publishing web-based time series data | |
| CN108089843B (en) | Intelligent bank enterprise-level demand management system | |
| US20120136862A1 (en) | System and method for presenting comparisons of electronic documents | |
| US11640583B2 (en) | Generation of user profile from source code | |
| US9483452B2 (en) | Generating document content from application data | |
| CN108492028A (en) | Demand data standardized method and standardized system | |
| CN106294520B (en) | Carry out identified relationships using the information extracted from document | |
| KR20140048154A (en) | Automatic task extraction and calendar entry | |
| CN102855532B (en) | Based on the method and apparatus of communication information management work task | |
| CN112183036B (en) | Format document generation method, device, equipment and storage medium | |
| US20070185907A1 (en) | Method and apparatus for displaying information on personal relationship, and computer product | |
| CN107704512A (en) | Financial product based on social data recommends method, electronic installation and medium | |
| CN106934069A (en) | Data retrieval method and system | |
| CN105095436B (en) | Data source data method for automatic modeling | |
| CN102968698A (en) | Method and system for establishing enterprise employee learning data model | |
| CN112634056A (en) | Method, equipment and storage medium for rapidly calculating and updating enterprise share right structure | |
| CN107357923A (en) | The cubical method of the tax is generated based on FreeMarker | |
| CN113220885A (en) | Text processing method and system | |
| CN103593812A (en) | Network-based courseware design method in aviation training field | |
| CN104699753A (en) | Intellectual property inquiry system based on cloud database | |
| CN110348714A (en) | Based on code log to the method for the output level evaluation of research staff | |
| US20210365408A1 (en) | Methods and systems for depiction of project data via transmogrification using fractal-based structures | |
| JP5277185B2 (en) | Information processing system |
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: 20171117 |
|
| RJ01 | Rejection of invention patent application after publication |