CN102799658B - A kind of multi-dimensional data methodology - Google Patents
A kind of multi-dimensional data methodology Download PDFInfo
- Publication number
- CN102799658B CN102799658B CN201210232458.0A CN201210232458A CN102799658B CN 102799658 B CN102799658 B CN 102799658B CN 201210232458 A CN201210232458 A CN 201210232458A CN 102799658 B CN102799658 B CN 102799658B
- Authority
- CN
- China
- Prior art keywords
- dimension
- data
- shared
- budget
- dimensional data
- 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.)
- Active
Links
Landscapes
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
- Financial Or Insurance-Related Operations Such As Payment And Settlement (AREA)
Abstract
The present invention relates to a kind of multi-dimensional data methodology, specifically include following steps: step 1: create multidimensional budget list;Step 2: according to the dimension member of row or column in budget list, carries out data and shares;Step 3: dimension is shared in switching.The present invention shares by using dimension handoff technique to realize data multidimensional degree in budget compilation, solves existing comprehensive budget and realizes in technology, it is impossible to automatically share financial data by level, maybe financial data cannot be carried out various dimensions Allocation.User need not definition and shares formula and upper DBMS can be decomposed to subordinate, and can switch by sharing dimension, it is achieved data multidimensional degree is shared.
Description
Technical field
The present invention relates to a kind of multi-dimensional data methodology, belong to computer application field.
Background technology
In existing Comprehensive Budget Management software, do not use multidimensional data warehouse technology, at finance number
Cannot realize according to hierarchical structure automatic classifying according to when decomposing, but need definition complicated share formula.
Create complexity, and when basic data structure changes, it is impossible to automatically adapting to, maintenance workload is big.
Use the Comprehensive Budget Management software of multidimensional data warehouse technology, such as the Related product of the inscriptions on bones or tortoise shells, only
The data supporting single period dimension are shared, and as shared for 4 season from the whole year, and then share
12 months.The data to different dimensions cannot be realized in compilation process and share requirement.Such as: pre-in reality
Calculate in compilation process, be frequently encountered budget target and divide along dimensions such as tissue, subject, product or areas
Stand.As parent company of group need to complete the sale index in next year 10000000000, so need to decompose each branch company,
Each sales department etc..
Summary of the invention
The present invention is directed to prior art and do not share the deficiency of function, it is provided that be a kind of based on multidimensional data displaying
On the basis of, meet the multi-dimensional data methodology of amortization of data on various dimensions direction.
The technical scheme is that a kind of multi-dimensional data methodology,
Specifically include following steps:
Step 1: create multidimensional budget list;
Step 2: according to the dimension member of row or column in budget list, carries out data and shares;
Step 3: dimension is shared in switching.
The invention has the beneficial effects as follows: the present invention realizes number in budget compilation by using dimension handoff technique
Share according to various dimensions, solve existing comprehensive budget and realize in technology, it is impossible to automatically share finance by level
Data, maybe cannot carry out various dimensions Allocation to financial data.User need not definition and shares formula i.e.
Upper DBMS can be decomposed to subordinate, and can switch by sharing dimension, it is achieved data multidimensional degree is shared.
On the basis of technique scheme, the present invention can also do following improvement.
Further, described step 1 specifically includes following steps:
Step 1.1: row member in budget list is set;
Step 1.2: row member in budget list is set;
Step 1.3: budget table single-page dimension member is set;
Step 1.4: budget table single view dimension member is set.
Further, described step 2 specifically includes following steps:
Step 2.1: the dimension that system judges in budget list in row or column has been set to share dimension the most
Degree;
Step 2.2: judge whether the dimension member shared is father node;
Step 2.3: cell be can editing mode, edit cell lattice content;
Step 2.4: share lower DBMS;
Step 2.5: judge whether to share leaf node.
Further, described step 2.1 includes following two situation, if it is determined that dimension member can be shared,
Carry out step 2.2;If it is determined that dimension member can not be shared, cell is read-only status, and returns step
Rapid 1.
Further, described step 2.2 includes following two situation, if dimension member is father node, and number
According to input father node, carry out step 2.3;If dimension member is not father node, cell is read-only shape
State, and return step 1.
Further, described step 2.5 includes following two situation, if having shared leaf node, and number
According to being input to leaf node, proceed step 3;If not sharing leaf node, then return execution
Step 2.4.
Accompanying drawing explanation
Fig. 1 is the flow chart of a kind of multi-dimensional data methodology described in the specific embodiment of the invention 1;
Fig. 2 is the step 1 in a kind of multi-dimensional data methodology described in the specific embodiment of the invention 1
Particular flow sheet;
Fig. 3 is multidimensional budget table in a kind of multi-dimensional data methodology described in the specific embodiment of the invention 2
Single layout;
Fig. 4 is that in a kind of multi-dimensional data methodology described in the specific embodiment of the invention 2 data are by period
Dimension shares schematic diagram automatically;
Fig. 5 is to share dimension in a kind of multi-dimensional data methodology described in the specific embodiment of the invention 2 to cut
Change schematic diagram;
Fig. 6 be in a kind of multi-dimensional data methodology described in the specific embodiment of the invention 2 data by subject
Dimension shares schematic diagram automatically.
Detailed description of the invention
Being described principle and the feature of the present invention below in conjunction with accompanying drawing, example is served only for explaining this
Invention, is not intended to limit the scope of the present invention.
As it is shown in figure 1, a kind of multi-dimensional data methodology described in the embodiment of the present invention 1, specifically wrap
Include following steps:
Step 1: create multidimensional budget list;
Step 2: whether the dimension member that system judges in budget list in row or column can be shared, if
Judge that dimension member can be shared, carry out step 3;If it is determined that dimension member can not be shared, cell is
Read-only status, and return step 1;
Step 3: judge whether the dimension member shared is father node, if dimension member is father node,
Data are input to father node, carry out step 4;If dimension member is not father node, cell is read-only
State, and return step 1;
Step 4: cell be can editing mode, edit cell lattice content;
Step 5: share lower DBMS;
Step 6: judge whether to share leaf node, if having shared leaf node, data are defeated
Enter and proceed step 7 to leaf node;If not sharing leaf node, then return and perform step 5;
Step 7: dimension is shared in switching.
As in figure 2 it is shown, step 1 of the present invention specifically includes following steps:
Step 1.1: row member in budget list is set;
Step 1.2: row member in budget list is set;
Step 1.3: budget table single-page dimension member is set;
Step 1.4: budget table single view dimension member is set.
As shown in Fig. 3,4,5,6, described in the specific embodiment of the invention 2, a kind of multi-dimensional data is shared
Method, specifically includes following steps:
Step 1. creates multidimensional budget form layout:
By row, row, the page, dimension and member's layout on each axle of viewpoint in definition budget list, it is achieved
Multidimensional data representing in two dimension budget list, and support to switch between page dimension member, it is achieved multilayer
Representing of face financial data.
As it is shown on figure 3, illustrate how to create multidimensional budget list: on the row of form layout, arrange year
Dimension member: 2013;Period dimension member: annual total, 1-4 season, the 1-12 month.On being expert at
Organization dimensionality member is set: project entity's tissue, Finance Department, Synthesis Department, one-tenth our department;Subject dimension becomes
Member: project objective income, production marketing, soil are sold, other.On the page, scene set dimension becomes
Member: budget, plan, reality;Version member: establishment version, strategy version;Industry situation member: common
House, villa.
The upper DBMS that step 2. selection need to be shared:
Dimension member in row or column in budget form layout, may participate in data and shares.As period dimension is fixed
Justice is on row, and comprises annual total, and in 1-4 season, the 1-12 month each period dimension, then user inputs entirely
During annual data, data can be shared in 4 season, and then shares 12 middle of the month.On cell
Do not have data, then acquiescence is shared out equally.If any data, then pro rata distribution.Such as: the first quarter, 1,2,3
The data of the moon are 600,100,200,300 respectively.If the data in the first quarter are changed into 1200, then, 1,2,3
The data of the moon become 200,400,600 accordingly.Thus realize pro rata distribution.Ratio is realized when no data
Share, ratio data need to be inserted in respective cells.As inserted 1,2,3 in 1,2,3 months,
The most again the first quarter inserts 1200, then 1,2, data in March become 200,400,600.
Specific algorithm is:
Default mode (averagely)
January, February, season/3, March=1
Ratio mode (such as: January, February, ratio in March be: 1:2:3):
January=1 season * 1/6;February=1 season * 2/6;March=1 season * 3/6;
Dimension is shared in step 3. switching
In budget form layout, the dimension being defined on row and column, can be as sharing dimension.Under by
Draw frame to switch to another and can share dimension.It is achieved in that: the dimension on row and column is put into one
Can share in dimension array, as a example by the data in Fig. 4 share demonstration meter, on row in a organized way, subject two
Individual dimension;Year and two dimensions of period are had on row.Then can share dimension and include year, period, tissue and section
Mesh.Selected by drop-down menu by user.As completed sharing in period dimension by Fig. 4, then can pass through
Combobox selects share dimension, be switched to subject and share, such as Fig. 5 Fig. 6.
The foregoing is only presently preferred embodiments of the present invention, not in order to limit the present invention, all in the present invention
Spirit and principle within, any modification, equivalent substitution and improvement etc. made, should be included in this
Within bright protection domain.
Claims (5)
1. a multi-dimensional data methodology, it is characterised in that specifically include following steps:
Step 1: create multidimensional budget list;
Step 2: whether the dimension member that system judges in budget list in row or column can be shared;
Step 3: judge whether the dimension member shared is father node;
Step 4: cell be can editing mode, edit cell lattice content;
Step 5: share lower DBMS;Do not have data as on cell, then acquiescence is shared out equally;If any number
According to, then pro rata distribution;Realize pro rata distribution when no data, ratio need to be inserted in respective cells
Data;
Step 6: judge whether to share leaf node;
Step 7: dimension is shared in switching.
Multi-dimensional data methodology the most according to claim 1, it is characterised in that described step
Rapid 1 specifically includes following steps:
Step 1.1: row member in budget list is set;
Step 1.2: row member in budget list is set;
Step 1.3: budget table single-page dimension member is set;
Step 1.4: budget table single view dimension member is set.
Multi-dimensional data methodology the most according to claim 1, it is characterised in that described step
Rapid 2 include following two situation, if it is determined that dimension member can be shared, carry out step 3;If it is determined that
Dimension member can not be shared, and cell is read-only status, and returns step 1.
Multi-dimensional data methodology the most according to claim 1, it is characterised in that described step
Rapid 3 include following two situation, if dimension member is father node, and data input father node, walk
Rapid 4;If dimension member is not father node, cell is read-only status, and returns step 1.
Multi-dimensional data methodology the most according to claim 1, it is characterised in that described step
Rapid 6 include following two situation, if having shared leaf node, data are input to leaf node, continue
Continue and carry out step 7;If not sharing leaf node, then return and perform step 5.
Priority Applications (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201210232458.0A CN102799658B (en) | 2012-07-05 | 2012-07-05 | A kind of multi-dimensional data methodology |
Applications Claiming Priority (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201210232458.0A CN102799658B (en) | 2012-07-05 | 2012-07-05 | A kind of multi-dimensional data methodology |
Publications (2)
Publication Number | Publication Date |
---|---|
CN102799658A CN102799658A (en) | 2012-11-28 |
CN102799658B true CN102799658B (en) | 2016-09-07 |
Family
ID=47198768
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
CN201210232458.0A Active CN102799658B (en) | 2012-07-05 | 2012-07-05 | A kind of multi-dimensional data methodology |
Country Status (1)
Country | Link |
---|---|
CN (1) | CN102799658B (en) |
Families Citing this family (8)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN103778247B (en) * | 2014-02-17 | 2017-02-22 | 华为技术有限公司 | Data apportion method, device and equipment |
CN107291678A (en) * | 2016-03-31 | 2017-10-24 | 北大方正集团有限公司 | Form method for splitting and system |
CN106681977B (en) * | 2017-02-20 | 2020-04-28 | 浪潮通用软件有限公司 | Report editing method and device |
CN108764661A (en) * | 2018-05-14 | 2018-11-06 | 浪潮通用软件有限公司 | A kind of various dimensions cost sharing configuration method Internet-based |
CN109034900A (en) * | 2018-07-26 | 2018-12-18 | 阿里巴巴集团控股有限公司 | A kind of processing method, system and the terminal device of the multi-dimensional data of business |
CN111783406A (en) * | 2019-10-12 | 2020-10-16 | 北京沃东天骏信息技术有限公司 | Table data operation method and device |
CN111209073B (en) * | 2020-01-07 | 2023-06-02 | 北京唐颐惠康生物医学技术有限公司 | Form construction method and system based on multidimensional model |
CN111639913B (en) * | 2020-05-29 | 2023-06-02 | 远光软件股份有限公司 | Multi-batch decomposition issuing method based on hierarchical management |
Citations (3)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN1790397A (en) * | 2005-12-28 | 2006-06-21 | 浙江工业大学 | Third party logistics data processing method based on online analysis |
CN101261622A (en) * | 2008-05-12 | 2008-09-10 | 金蝶软件(中国)有限公司 | Data dividing method and apparatus |
US7610294B2 (en) * | 2007-05-31 | 2009-10-27 | International Business Machines Corporation | Multidimensional data cube validation |
-
2012
- 2012-07-05 CN CN201210232458.0A patent/CN102799658B/en active Active
Patent Citations (3)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN1790397A (en) * | 2005-12-28 | 2006-06-21 | 浙江工业大学 | Third party logistics data processing method based on online analysis |
US7610294B2 (en) * | 2007-05-31 | 2009-10-27 | International Business Machines Corporation | Multidimensional data cube validation |
CN101261622A (en) * | 2008-05-12 | 2008-09-10 | 金蝶软件(中国)有限公司 | Data dividing method and apparatus |
Non-Patent Citations (1)
Title |
---|
财务报表数据多维分析系统的研究;陈海耘;《CNKI中国优秀硕士学位论文全文数据库》;20030615;全文 * |
Also Published As
Publication number | Publication date |
---|---|
CN102799658A (en) | 2012-11-28 |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
CN102799658B (en) | A kind of multi-dimensional data methodology | |
Ordway et al. | Deforestation risk due to commodity crop expansion in sub-Saharan Africa | |
Quentin et al. | Global inequality chains: Integrating mechanisms of value distribution into analyses of global production | |
Phalan et al. | Crop expansion and conservation priorities in tropical countries | |
Odior | Government expenditure on health, economic growth and long waves in A CGE micro-simulation analysis: the case of Nigeria | |
Desmet et al. | Resistance to technology adoption: The rise and decline of guilds | |
Heilmayr | Conservation through intensification? The effects of plantations on natural forests | |
Boje et al. | Policy and practice: The relationship between family policy regime and women's labour market participation in Europe | |
Pérez-Sánchez et al. | The international division of labor and embodied working time in trade for the US, the EU and China | |
Fraser et al. | Simulating stand-level harvest prescriptions across landscapes: LANDIS PRO harvest module design | |
Walz et al. | Experience from downscaling IPCC-SRES scenarios to specific national-level focus scenarios for ecosystem service management | |
Nakajima et al. | A method to maximise forest profitability through optimal rotation period selection under various economic, site and silvicultural conditions | |
Brown et al. | Responses to climate and economic risks and opportunities across national and ecological boundaries: changing household strategies on the Mongolian plateau | |
Batra et al. | Is a typology for planted forests feasible, or even relevant? | |
Mohammadi et al. | Multiple criteria decision-making approaches for forest sustainability (Case study: Iranian Caspian Forests) | |
Mapila et al. | A partial equilibrium model of the Malawi maize commodity market | |
Louw et al. | Small millers’ and bakers’ perceptions of the limitations of agro-processing development in the wheat-milling and baking industries in rural areas in South Africa | |
Lee et al. | Three billion new trees in the EU’s biodiversity strategy: low ambition, but better environmental outcomes? | |
Russek | Differential labour mobility and agglomeration | |
Sharaunga et al. | The dis-incentive effects of food aid and agricultural policies on local land allocation in developing countries: The case of Malawi | |
Sacchelli | Social, economic, and environmental impacts of biomass and biofuel supply chains | |
Çelik et al. | Competitive analysis of outdoor ornamental plants sector: a case study of Konya province, Turkey | |
Alaimo et al. | Did covid-19 enlarge spatial disparities in population dynamics? a comparative, multivariate approach for italy | |
Cockburn et al. | Trade liberalization and poverty: A CGE analysis of the 1990s experience in Africa and Asia | |
Wicaksono et al. | Analysis of area typology and stakeholders’ interaction in the sustainable food agricultural land (SFAL) policy implementation |
Legal Events
Date | Code | Title | Description |
---|---|---|---|
C06 | Publication | ||
PB01 | Publication | ||
C10 | Entry into substantive examination | ||
SE01 | Entry into force of request for substantive examination | ||
C14 | Grant of patent or utility model | ||
GR01 | Patent grant |