CN108572995A - A kind of data processing method, device and electronic equipment - Google Patents
A kind of data processing method, device and electronic equipment Download PDFInfo
- Publication number
- CN108572995A CN108572995A CN201710149865.8A CN201710149865A CN108572995A CN 108572995 A CN108572995 A CN 108572995A CN 201710149865 A CN201710149865 A CN 201710149865A CN 108572995 A CN108572995 A CN 108572995A
- Authority
- CN
- China
- Prior art keywords
- goal
- dimension
- target
- griven metric
- measurement
- 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
Abstract
Disclosed herein is a kind of data processing method, device and electronic equipments.The data processing method, including:Obtain cube;Dimension and measurement, query set of the structure dimension to measurement contribution degree are determined according to the cube;After getting querying condition input by user, obtains target dimension with query set described in the query composition of target dimension per a pair of of goal-griven metric according in the querying condition and influence the influence factor of goal-griven metric, the influence factor is shown.The technical solution of this paper can provide a kind of function of influence factor assistant analysis for business intelligence system, improve the efficiency of decision-making of user.
Description
Technical field
The present invention relates to computer technology, espespecially a kind of data processing method, device and electronic equipment.
Background technology
Business intelligence (Business Intelligence, abbreviation BI) refers to modern data REPOSITORY TECHNOLOGY, on-line analysis
Treatment technology, data mining and data exhibiting technology carry out data analysis to realize commercial value.With business intelligence
(Business Intelligence, abbreviation BI) tool is widely used, and policymaker will be easier that data are inquired and divided
Analysis.
One multidimensional data concentration generally comprises a large amount of field, and some of which field belongs to the dimension (angle of observation data
Degree), some fields belong to measurement (quantitative value specifically investigated), and user is when in face of cube, due to measurement and dimension
Quantity it is very much, one measurement one dimensionally go to search the influence factor for being hidden in data behind one by one, efficiency is very low.
Invention content
This application provides a kind of data processing method, device and electronic equipments, can provide one for business intelligence system
The function of kind influence factor assistant analysis, improves the efficiency of decision-making of user.
The application adopts the following technical scheme that.
The embodiment of the present application provides a kind of data processing method, including:
Obtain cube;
Dimension and measurement, query set of the structure dimension to measurement contribution degree are determined according to the cube;
After getting querying condition input by user, according to every a pair of of the goal-griven metric and target in the querying condition
Described in the query composition of dimension query set obtain target dimension influence goal-griven metric influence factor, to the influence factor into
Row displaying.
Optionally, the querying condition input by user, including it is following any one:
One or more goal-griven metrics and target complete dimension;
One or more target dimensions and target complete measurement;
One or more goal-griven metrics, and one or more target dimensions.
Optionally, it is described structure dimension to measure contribution degree query set, including:
Determine that the multidimensional data concentrates the combination of all dimensions and measurement;
Combination to any pair of dimension and measurement calculates each dimension member under the dimension to the measurement
Contribution degree;
Query set is built, the query set includes every a pair of of measurement contribution number of degrees corresponding with the combination of dimension
According to.
Optionally, described in the query composition according to every a pair of of goal-griven metric and target dimension in the querying condition
Query set, which obtains target dimension, influences the influence factor of goal-griven metric, including:
Combination to any pair of goal-griven metric and target dimension will be greater than or equal to the contribution rate of the goal-griven metric
The target dimension member of threshold value is determined as influencing the principal element of the goal-griven metric, and the contribution rate to the goal-griven metric is small
It is determined as influencing the non-principal factor of the goal-griven metric in the target dimension member of threshold value;And/or
Combination to any pair of goal-griven metric and target dimension, before being come to the contribution rate ranking of the goal-griven metric
Target dimension member within N is determined as influencing the principal element of the goal-griven metric, by the contribution to the goal-griven metric
Target dimension member other than N is determined as influencing the non-principal factor of the goal-griven metric before rate ranking comes.
Optionally, the influence factor is shown, including:
Pie chart is drawn to the contribution degree of the goal-griven metric according to the member of the target dimension, is shown by the pie chart
The target dimension influences the influence factor of the goal-griven metric;And/or
The maximum target dimension member of the contribution rate of the goal-griven metric will be determined as influencing the goal-griven metric most
Principal element generates the main factor analysis opinion for influencing the goal-griven metric and shows.
The embodiment of the present application provides a kind of data processing equipment, including:
Data source acquisition module, for obtaining cube;
Query set builds module, and for determining dimension and measurement according to the cube, structure dimension is to measurement
The query set of contribution degree;
Analysis of Influential Factors module, for after getting querying condition input by user, according in the querying condition
The query composition per a pair of of goal-griven metric with target dimension described in query set obtain target dimension and influence the shadow of goal-griven metric
The factor of sound, is shown the influence factor.
Optionally, the querying condition input by user, including it is following any one:
One or more goal-griven metrics and target complete dimension;
One or more target dimensions and target complete measurement;
One or more goal-griven metrics, and one or more target dimensions.
Optionally, query set builds module, for structure dimension in the following ways to the query set of measurement contribution degree
It closes:
Determine that the multidimensional data concentrates the combination of all dimensions and measurement;
Combination to any pair of dimension and measurement calculates each dimension member under the dimension to the measurement
Contribution degree;
Query set is built, the query set includes every a pair of of measurement contribution number of degrees corresponding with the combination of dimension
According to.
Optionally, analysis of Influential Factors module, in the following ways according to every a pair of of mesh in the querying condition
Query set described in the query composition of scale amount and target dimension, which obtains target dimension, influences the influence factor of goal-griven metric:
Combination to any pair of goal-griven metric and target dimension will be greater than or equal to the contribution rate of the goal-griven metric
The target dimension member of threshold value is determined as influencing the principal element of the goal-griven metric, and the contribution rate to the goal-griven metric is small
It is determined as influencing the non-principal factor of the goal-griven metric in the target dimension member of threshold value;And/or
Combination to any pair of goal-griven metric and target dimension, before being come to the contribution rate ranking of the goal-griven metric
Target dimension member within N is determined as influencing the principal element of the goal-griven metric, by the contribution to the goal-griven metric
Target dimension member other than N is determined as influencing the non-principal factor of the goal-griven metric before rate ranking comes.
The application provides a kind of electronic equipment for data processing, including:Memory and processor;
The memory is used to preserve the program for data processing, and the program for data processing is by the place
When managing device reading execution, following operation is executed:
Obtain cube;
Dimension and measurement, query set of the structure dimension to measurement contribution degree are determined according to the cube;
After getting querying condition input by user, according to every a pair of of the goal-griven metric and target in the querying condition
Described in the query composition of dimension query set obtain target dimension influence goal-griven metric influence factor, to the influence factor into
Row displaying.
The application includes following advantages:
At least one embodiment of the application determines dimension and measurement according to the cube got, builds dimension pair
The query set for measuring contribution degree, after getting querying condition input by user, according to every a pair of in the querying condition
Query set described in goal-griven metric and the query composition of target dimension, which obtains target dimension, influences the influence factor of goal-griven metric, right
The influence factor is shown.It is auxiliary that the technical solution of above-described embodiment can provide a kind of influence factor for business intelligence system
The function of helping analysis improves the efficiency of decision-making of user.
Certainly, any product for implementing the application is not necessarily required to reach all the above advantage simultaneously.
Description of the drawings
Attached drawing is used for providing further understanding technical solution of the present invention, and a part for constitution instruction, with this
The embodiment of application technical solution for explaining the present invention together, does not constitute the limitation to technical solution of the present invention.
Fig. 1 is a kind of flow chart of data processing method of the embodiment of the present invention one;
Fig. 2 is flow chart of the present invention using a kind of data processing method of example 1;
Fig. 3-a are the present invention using the pie chart of example 1 and the schematic diagram of the analysis opinion of main factor;
Fig. 3-b are the schematic diagram of prompt message when user selects focus to fall some sector in the pie chart in Fig. 3-a;
Fig. 4 is a kind of data processing equipment schematic diagram of the embodiment of the present invention two.
Specific implementation mode
To make the objectives, technical solutions, and advantages of the present invention clearer, below in conjunction with attached drawing to the present invention
Embodiment be described in detail.It should be noted that in the absence of conflict, in the embodiment and embodiment in the application
Feature mutually can arbitrarily combine.
Step shown in the flowchart of the accompanying drawings can be in the computer system of such as a group of computer-executable instructions
It executes.Also, although logical order is shown in flow charts, and it in some cases, can be with suitable different from herein
Sequence executes shown or described step.
Embodiment one
As shown in Figure 1, a kind of data processing method, including:
S110 obtains cube;
S120 determines dimension and measurement, query set of the structure dimension to measurement contribution degree according to the cube;
S130, after getting querying condition input by user, according to every a pair of of goal-griven metric in the querying condition
Query set described in query composition with target dimension, which obtains target dimension, influences the influence factor of goal-griven metric, on the influence
Factor is shown.
In the present embodiment, dimension and measurement are determined according to the cube, including:
The data type for the field concentrated according to the multidimensional data distinguishes dimension and measurement;
Wherein it is possible to which numeric type field is judged to measuring, the other kinds of field outside divider value type-word section is judged
For dimension;
Wherein, system can determine dimension and measurement according to user-defined setting;Or it is selected in system Automatic sieve
After dimension and measurement, final dimension, measurement are determined after the confirmation or modification for receiving user;
In one embodiment, the querying condition input by user, including it is following any one:
One or more goal-griven metrics and target complete dimension;
One or more target dimensions and target complete measurement;
One or more goal-griven metrics, and one or more target dimensions.
Wherein, user is after the one or more goal-griven metrics of selection, if there is no selection target dimension, system default institute
Some dimensions are target dimension;Similarly, user is after the one or more target dimensions of selection, if not having selection target degree
Amount, then all measurements of system default are goal-griven metric;In addition, for can voluntarily select one or more goal-griven metrics, with
And one or more target dimensions;Particularly, user can disposably choose whole measurement and dimension, then all measurements are all
It is goal-griven metric, all dimensions are all target dimensions.
In the present embodiment, it is described structure dimension to measure contribution degree query set, including:
Determine that the multidimensional data concentrates the combination of all dimensions and measurement;
Combination to any pair of dimension and measurement calculates each dimension member under the dimension to the measurement
Contribution degree;
Query set is built, the query set includes every a pair of of measurement contribution number of degrees corresponding with the combination of dimension
According to.
In the present embodiment, the contribution degree data include:Contribution margin and/or contribution rate;
Wherein, some dimension member is quantity of the dimension member to the measurement contribution to the contribution margin of measurement;Certain
A dimension member is that the dimension member accounts for all members couple of the dimension to the quantity of the measurement contribution to the contribution rate of measurement
The ratio of the total amount of the measurement contribution;
In one embodiment, described to determine dimension with after measurement according to the cube, the method is also
Including:
Show dimension menu and measurement menu;
The dimension menu is used to show that the dimension option in the query set, the measurement menu to be described for showing
Measurement option in query set;
In one embodiment, the group per a pair of of goal-griven metric and target dimension according in the querying condition
It closes and inquires the influence factor that the query set obtains target dimension influence goal-griven metric, including:
Combination to any pair of goal-griven metric and target dimension will be greater than or equal to the contribution rate of the goal-griven metric
The target dimension member of threshold value is determined as influencing the principal element of the goal-griven metric, and the contribution rate to the goal-griven metric is small
It is determined as influencing the non-principal factor of the goal-griven metric in the target dimension member of threshold value;And/or
Combination to any pair of goal-griven metric and target dimension, before being come to the contribution rate ranking of the goal-griven metric
Target dimension member within N is determined as influencing the principal element of the goal-griven metric, by the contribution to the goal-griven metric
Target dimension member other than N is determined as influencing the non-principal factor of the goal-griven metric before rate ranking comes.
For example, the threshold value could be provided as 30%;
For example, the N can be with value for 3;
In one embodiment, the influence factor is shown, including:
Pie chart is drawn to the contribution degree of the goal-griven metric according to the member of the target dimension, is shown by the pie chart
The target dimension influences the influence factor of the goal-griven metric;And/or
The maximum target dimension member of the contribution rate of the goal-griven metric will be determined as influencing the goal-griven metric most
Principal element generates the main factor analysis opinion for influencing the goal-griven metric and shows.
Wherein, in the pie chart, each principal element for influencing the goal-griven metric can respectively occupy a fan
Area, the non-principal factor for having an impact the goal-griven metric can occupy a sector jointly.
In other examples, the contribution degree of the goal-griven metric can also be painted according to the member of the target dimension
Histogram processed, block diagram etc..The present invention does not limit the exhibition method of influence factor.
In one embodiment, the influence factor is shown, further includes:
In detecting that user chooses the pie chart some sector or will selection focus to the sector when, pop up
The prompt message of the corresponding influence factor in the sector;The prompt message includes:The title of dimension member and to the target
The contribution degrees of data of measurement;
Illustrate the present embodiment with an example (applying example 1) below.As shown in Fig. 2, in this example, it is assumed that user wishes
Analysis of Influential Factors is carried out to order fact table in business intelligence BI systems, data processing method using the present invention can be with
Include the following steps S201~S205:
Step S201 determines dimension and measurement from multidimensional data concentration;
For example, the order fact table that the cube, which is some Xian Shang supermarket month, to be sold goods, wrapped in the table
Multiple fields are included, for example, sales volume, sales volume, discount, income, transportation types, product type etc.;The data type of field can
To be:Character type, date type, numeric type etc.;
The attribute area fractional dimension and measurement for the field that system can be concentrated according to the multidimensional data, for example, by numeric type
Field is judged to measuring, and the other kinds of field outside divider value type-word section is determined as dimension;Therefore the measurement judged can
With for example:Sales volume, sales volume, discount, income;Dimension can be such as:Transportation types, product type etc..
Wherein, by taking product type dimension as an example, the dimension may include following member:Office appliance, daily necessities, food
Product, books, clothes, shoes and hats, toy, furniture, electric appliance etc..
Step S202, display dimension menu and measurement menu;
Dimension and measurement are selected in order to facilitate user, dimension menu can be provided and measurement menu is selected for user;
Step S203, it is arbitrary to combine dimension and measurement, by dimension member under the combination of dimension and measurement and the combination
Query set is constituted to the contribution degrees of data of the measurement;
Wherein, may include the combination of various dimensions and measurement in query set, for example, transportation types (dimension) and sale
Volume (measurement), product type (dimension) and sales volume (measurement) etc..
Querying condition is " dimension+measurement ", and inquiry record includes tribute of the dimension member to the measurement under the combination
Offer degrees of data.
As shown in table 1 below, by dimension be " product type " and measurement be " sales volume " combination for, illustrated in table 1
Contribution degrees of data (for example, contribution margin and contribution rate) of the portioned product type to sales volume.
Table 1
As shown in Table 1, office appliance is 8516 to the contribution margin of sales volume, and the contribution rate to sales volume is 35.05%;
Daily necessities are 5491 to the contribution margin of sales volume, and the contribution rate to sales volume is 22.6%;
Step S204 detects that user selects one or more dimension options from dimension menu, and from measurement menu
After selecting one or more measurement options, the combination of the one or more target dimensions and goal-griven metric to be analyzed is generated.
For example, detecting that user has selected all measurement and dimension, then all measurements are all goal-griven metrics, all
Dimension is all target dimension, generates the arbitrary combination of all goal-griven metrics and all dimensions;
Step S205, the combination to each group of goal-griven metric and target dimension are obtained according to the inquiry query set
Degrees of data is contributed to determine the influence factor for influencing the goal-griven metric;
For example, by taking the combination of one group of goal-griven metric and target dimension as an example, tieed up according to goal-griven metric (sales volume) and target
Query set described in the query composition of (product type) is spent, contribution degrees of data (contribution margin and the tribute of each product type are obtained
Offer rate), if the contribution rate ranking of product type and sales volume to the contribution rate of sales volume more than or equal to 30% existed
The product type of front three is determined as influencing the principal element of the sales volume, will be less than 30% to the contribution rate of the sales volume
Product type and product type of the contribution rate ranking after fourth and fourth of sales volume be determined as described in influence
The non-principal factor of sales volume, then can determine:Influence sales volume principal element include:Office appliance, daily necessities, food
Product;Influence sales volume non-principal factor include:Books, clothes, shoes and hats, toy, electric appliance, furniture etc..
Step S206, the influence factor that the goal-griven metric is influenced on target dimension are shown;
For example, as shown in Fig. 3-a, the contribution degree of goal-griven metric (sales volume) is drawn according to target dimension (product type)
Pie chart;It can also will be to the maximum target dimension member of the contribution rate of the goal-griven metric (sales volume) (for example, office appliance)
It is determined as influencing the main factor of the goal-griven metric (sales volume), by the maximum target of contribution rate to the goal-griven metric
Dimension member is determined as influencing the main factor of the goal-griven metric, generates the main factor point for influencing the goal-griven metric
Analysis opinion is simultaneously shown;As shown in Fig. 3-a, the main factor analysis opinion that the product type influences sales volume can be:Production
Category type:Majority in office appliance accounting product type;
As shown in Fig. 3-b, office appliance sector in detecting that user chooses the pie chart or focus will be selected
When to the office appliance sector, the corresponding principal element prompt message in the office appliance sector is popped up;The prompt message
Including:The title of dimension member and contribution degrees of data to the goal-griven metric, such as:Classification:Office appliance;Quantity:8516
(35.05%).
Above application example can automatically determine the dimension that the multidimensional data is concentrated after user determines cube
And measurement, the group for building various dimensions and measurement merge generation query set, each dimension are recorded in the query set
With each dimension member under the combination of measurement to the contribution degrees of data of the measurement;Generate the corresponding dimension dish of the query set
Single and measurement menu selects the combination of one or more dimensions and measurement for user, in user's selected target measurement and target dimension
Combination after, the influence factor for influencing the goal-griven metric is determined according to the contribution degree size of each member of the target dimension
And feed back to user.Above-mentioned technical proposal human-computer interaction is simple, and user can be helped to be concentrated from complicated multidimensional data and quickly divided
Influence factor is precipitated, simplifies the interactive process of analysis of Influential Factors.
Embodiment two
As shown in figure 4, a kind of data processing equipment, including:
Data source acquisition module 401, for obtaining cube;
Query set builds module 402, and for determining dimension and measurement according to the cube, structure dimension is to degree
Measure the query set of contribution degree;
Analysis of Influential Factors module 403, for after getting querying condition input by user, according to the querying condition
In the query composition per a pair of of goal-griven metric with target dimension described in query set obtain target dimension and influence goal-griven metric
Influence factor is shown the influence factor.
In the present embodiment, query set builds module, for being determined in the following ways according to the cube
Dimension and measurement:
The data type for the field concentrated according to the multidimensional data distinguishes dimension and measurement;
Wherein it is possible to which numeric type field is judged to measuring, the other kinds of field outside divider value type-word section is judged
For dimension;
Wherein, system can determine dimension and measurement according to user-defined setting;Or it is selected in system Automatic sieve
After dimension and measurement, final dimension, measurement are determined after the confirmation or modification for receiving user;
In one embodiment, the querying condition input by user, including it is following any one:
One or more goal-griven metrics and target complete dimension;
One or more target dimensions and target complete measurement;
One or more goal-griven metrics, and one or more target dimensions.
In the present embodiment, the query set builds module, is contributed measurement to build dimension in the following ways
The query set of degree:
Determine that the multidimensional data concentrates the combination of all dimensions and measurement;
Combination to any pair of dimension and measurement calculates each dimension member under the dimension to the measurement
Contribution degree;
Query set is built, the query set includes every a pair of of measurement contribution number of degrees corresponding with the combination of dimension
According to.
In the present embodiment, the contribution degree data include:Contribution margin and/or contribution rate;
Wherein, some dimension member is quantity of the dimension member to the measurement contribution to the contribution margin of measurement;Certain
A dimension member is that the dimension member accounts for all members couple of the dimension to the quantity of the measurement contribution to the contribution rate of measurement
The ratio of the total amount of the measurement contribution;
In one embodiment, the query set builds module, is additionally operable to determine according to the cube
After dimension and measurement, display dimension menu and measurement menu;
The dimension menu is used to show that the dimension option in the query set, the measurement menu to be described for showing
Measurement option in query set;
In one embodiment, the analysis of Influential Factors module, in the following ways according to the inquiry item
Obtaining target dimension with query set described in the query composition of target dimension per a pair of of goal-griven metric and influencing goal-griven metric in part
Influence factor:
Combination to any pair of goal-griven metric and target dimension will be greater than or equal to the contribution rate of the goal-griven metric
The target dimension member of threshold value is determined as influencing the principal element of the goal-griven metric, and the contribution rate to the goal-griven metric is small
It is determined as influencing the non-principal factor of the goal-griven metric in the target dimension member of threshold value;And/or
Combination to any pair of goal-griven metric and target dimension, before being come to the contribution rate ranking of the goal-griven metric
Target dimension member within N is determined as influencing the principal element of the goal-griven metric, by the contribution to the goal-griven metric
Target dimension member other than N is determined as influencing the non-principal factor of the goal-griven metric before rate ranking comes.
For example, the threshold value could be provided as 30%;
For example, the N can be with value for 3;
In one embodiment, analysis of Influential Factors module, for being carried out in the following ways to the influence factor
Displaying:
Pie chart is drawn to the contribution degree of the goal-griven metric according to the member of the target dimension, is shown by the pie chart
The target dimension influences the influence factor of the goal-griven metric;And/or
The maximum target dimension member of the contribution rate of the goal-griven metric will be determined as influencing the goal-griven metric most
Principal element generates the main factor analysis opinion for influencing the goal-griven metric and shows.
Wherein, in the pie chart, each principal element for influencing the goal-griven metric can respectively occupy a fan
Area, the non-principal factor for having an impact the goal-griven metric can occupy a sector jointly.
In other examples, the contribution degree of the goal-griven metric can also be painted according to the member of the target dimension
Histogram processed, block diagram etc..The present invention does not limit the exhibition method of influence factor.
In one embodiment, analysis of Influential Factors module, be additionally operable in the following ways to the influence factor into
Row displaying:In detecting that user chooses the pie chart some sector or will selection focus to the sector when, pop up
The prompt message of the corresponding influence factor in the sector;The prompt message includes:The title of dimension member and to the target
The contribution degrees of data of measurement;
Embodiment three
A kind of electronic equipment for data processing, including:Memory and processor;
The memory is used to preserve the program for data processing, and the program for data processing is by the place
When managing device reading execution, following operation is executed:
Obtain cube;
Dimension and measurement, query set of the structure dimension to measurement contribution degree are determined according to the cube;
After getting querying condition input by user, according to every a pair of of the goal-griven metric and target in the querying condition
Described in the query composition of dimension query set obtain target dimension influence goal-griven metric influence factor, to the influence factor into
Row displaying.
In the present embodiment for the program of data processing when being read out by the processor execution, performed operation corresponds to real
Apply step S110~S130 of example one;Other details of operation performed by the program can be found in embodiment one.
Although disclosed herein embodiment it is as above, the content only for ease of understanding the present invention and use
Embodiment is not limited to the present invention.Technical staff in any fields of the present invention is taken off not departing from the present invention
Under the premise of the spirit and scope of dew, any modification and variation, but the present invention can be carried out in the form and details of implementation
Scope of patent protection, still should be subject to the scope of the claims as defined in the appended claims.
Claims (10)
1. a kind of data processing method, including:
Obtain cube;
Dimension and measurement, query set of the structure dimension to measurement contribution degree are determined according to the cube;
After getting querying condition input by user, according to every a pair of of the goal-griven metric and target dimension in the querying condition
Query composition described in query set obtain target dimension influence goal-griven metric influence factor, the influence factor is opened up
Show.
2. according to the method described in claim 1, it is characterized in that:
The querying condition input by user, including it is following any one:
One or more goal-griven metrics and target complete dimension;
One or more target dimensions and target complete measurement;
One or more goal-griven metrics, and one or more target dimensions.
3. method according to claim 1 or 2, it is characterised in that:
It is described structure dimension to measure contribution degree query set, including:
Determine that the multidimensional data concentrates the combination of all dimensions and measurement;
Combination to any pair of dimension and measurement calculates contribution of each dimension member to the measurement under the dimension
Degree;
Query set is built, the query set includes every a pair of of measurement contribution degrees of data corresponding with the combination of dimension.
4. according to the method described in claim 3, it is characterized in that:
It is described to be obtained with query set described in the query composition of target dimension per a pair of of goal-griven metric according in the querying condition
Obtaining target dimension influences the influence factor of goal-griven metric, including:
Combination to any pair of goal-griven metric and target dimension will be greater than or equal to threshold value to the contribution rate of the goal-griven metric
Target dimension member be determined as influencing the principal element of the goal-griven metric, will to the contribution rate of the goal-griven metric be less than threshold
The target dimension member of value is determined as influencing the non-principal factor of the goal-griven metric;And/or
Combination to any pair of goal-griven metric and target dimension, N before being come to the contribution rate ranking of the goal-griven metric
Within target dimension member be determined as influencing the principal element of the goal-griven metric, will to the contribution rate of the goal-griven metric arrange
Target dimension member other than N is determined as influencing the non-principal factor of the goal-griven metric before name comes.
5. according to the method described in claim 1, it is characterized in that:
The influence factor is shown, including:
Pie chart is drawn to the contribution degree of the goal-griven metric according to the member of the target dimension, described in pie chart displaying
Target dimension influences the influence factor of the goal-griven metric;And/or
The maximum target dimension member of the contribution rate of the goal-griven metric will be determined as influencing the main of the goal-griven metric
Factor generates the main factor analysis opinion for influencing the goal-griven metric and shows.
6. a kind of data processing equipment, including:
Data source acquisition module, for obtaining cube;
Query set builds module, for determining that dimension and measurement, structure dimension contribute measurement according to the cube
The query set of degree;
Analysis of Influential Factors module, for after getting querying condition input by user, according to every in the querying condition
Twin target measure and target dimension query composition described in query set obtain target dimension influence goal-griven metric influence because
Element is shown the influence factor.
7. data processing equipment according to claim 6, it is characterised in that:
The querying condition input by user, including it is following any one:
One or more goal-griven metrics and target complete dimension;
One or more target dimensions and target complete measurement;
One or more goal-griven metrics, and one or more target dimensions.
8. the data processing equipment described according to claim 6 or 7, it is characterised in that:
Query set builds module, for structure dimension in the following ways to the query set of measurement contribution degree:
Determine that the multidimensional data concentrates the combination of all dimensions and measurement;
Combination to any pair of dimension and measurement calculates contribution of each dimension member to the measurement under the dimension
Degree;
Query set is built, the query set includes every a pair of of measurement contribution degrees of data corresponding with the combination of dimension.
9. data processing equipment according to claim 8, it is characterised in that:
Analysis of Influential Factors module, in the following ways according to every a pair of of the goal-griven metric and target in the querying condition
Query set described in the query composition of dimension, which obtains target dimension, influences the influence factor of goal-griven metric:
Combination to any pair of goal-griven metric and target dimension will be greater than or equal to threshold value to the contribution rate of the goal-griven metric
Target dimension member be determined as influencing the principal element of the goal-griven metric, will to the contribution rate of the goal-griven metric be less than threshold
The target dimension member of value is determined as influencing the non-principal factor of the goal-griven metric;And/or
Combination to any pair of goal-griven metric and target dimension, N before being come to the contribution rate ranking of the goal-griven metric
Within target dimension member be determined as influencing the principal element of the goal-griven metric, will to the contribution rate of the goal-griven metric arrange
Target dimension member other than N is determined as influencing the non-principal factor of the goal-griven metric before name comes.
10. a kind of electronic equipment for data processing, including:Memory and processor;
It is characterized in that:
The memory is used to preserve the program for data processing, and the program for data processing is by the processor
When reading execution, following operation is executed:
Obtain cube;
Dimension and measurement, query set of the structure dimension to measurement contribution degree are determined according to the cube;
After getting querying condition input by user, according to every a pair of of the goal-griven metric and target dimension in the querying condition
Query composition described in query set obtain target dimension influence goal-griven metric influence factor, the influence factor is opened up
Show.
Priority Applications (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201710149865.8A CN108572995A (en) | 2017-03-14 | 2017-03-14 | A kind of data processing method, device and electronic equipment |
Applications Claiming Priority (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201710149865.8A CN108572995A (en) | 2017-03-14 | 2017-03-14 | A kind of data processing method, device and electronic equipment |
Publications (1)
Publication Number | Publication Date |
---|---|
CN108572995A true CN108572995A (en) | 2018-09-25 |
Family
ID=63577551
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
CN201710149865.8A Pending CN108572995A (en) | 2017-03-14 | 2017-03-14 | A kind of data processing method, device and electronic equipment |
Country Status (1)
Country | Link |
---|---|
CN (1) | CN108572995A (en) |
Cited By (1)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN111612303A (en) * | 2020-04-18 | 2020-09-01 | 青岛奥利普智能制造研究院有限公司 | Data processing method and equipment based on business intelligence BI |
Citations (3)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
JP2001282870A (en) * | 2000-03-30 | 2001-10-12 | Hitachi Plant Eng & Constr Co Ltd | Excecution drawing preparation support method |
CN105095473A (en) * | 2015-08-11 | 2015-11-25 | 北京思特奇信息技术股份有限公司 | Method and system for analyzing discrepant data |
CN105488048A (en) * | 2014-09-16 | 2016-04-13 | 中兴通讯股份有限公司 | Data query method and device |
-
2017
- 2017-03-14 CN CN201710149865.8A patent/CN108572995A/en active Pending
Patent Citations (3)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
JP2001282870A (en) * | 2000-03-30 | 2001-10-12 | Hitachi Plant Eng & Constr Co Ltd | Excecution drawing preparation support method |
CN105488048A (en) * | 2014-09-16 | 2016-04-13 | 中兴通讯股份有限公司 | Data query method and device |
CN105095473A (en) * | 2015-08-11 | 2015-11-25 | 北京思特奇信息技术股份有限公司 | Method and system for analyzing discrepant data |
Non-Patent Citations (2)
Title |
---|
何冰等: "《数据可视化应用与实践》", 31 December 2015, 企业管理出版社 * |
黄鑫等: "《毕艾艾升职记》", 31 May 2012, 天津社会科学出版社 * |
Cited By (1)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN111612303A (en) * | 2020-04-18 | 2020-09-01 | 青岛奥利普智能制造研究院有限公司 | Data processing method and equipment based on business intelligence BI |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
CN107451894B (en) | Data processing method, device and computer readable storage medium | |
CA3057073C (en) | Determining product placement compliance | |
CN109559208A (en) | A kind of information recommendation method, server and computer-readable medium | |
US10474762B2 (en) | Methods and systems to communicate information | |
CN111984837B (en) | Commodity data processing method, device and equipment | |
CN104809637B (en) | Computer-implemented commodity recommendation method and system | |
US11176586B2 (en) | Data analysis method and system thereof | |
CN105138690B (en) | The method and apparatus for determining keyword | |
WO2016188277A1 (en) | Method and device for providing business object collocation information | |
CN111144874B (en) | Payment mode recommendation method, device and equipment | |
CN111899047A (en) | Resource recommendation method and device, computer equipment and computer-readable storage medium | |
CN112488863A (en) | Dangerous seed recommendation method and related equipment in user cold start scene | |
CN115496566A (en) | Regional specialty recommendation method and system based on big data | |
CN107093122B (en) | Object classification method and device | |
CN114238308A (en) | Cross perspective table generation method and device, electronic equipment and readable storage medium | |
CN114140193A (en) | Commodity recommendation method and device | |
CN108572995A (en) | A kind of data processing method, device and electronic equipment | |
CN112132660A (en) | Commodity recommendation method, system, device and storage medium | |
CN110020135B (en) | Demand determination method, resource recommendation method and related device | |
CN110969491B (en) | Commodity pushing method, system and equipment based on network path | |
CN111292126B (en) | Supply and demand analysis method, device, equipment and readable storage medium | |
CN114780865A (en) | Information recommendation method and device, computer equipment and storage medium | |
Karimian et al. | Surveying of Criteria for Purchasing Television Set and Recognizing Customers' Decision Making Styles in Isfahen | |
WO2020156306A1 (en) | Clothing collocation information processing method, system and device, and data object processing method, system and device | |
CN114155051A (en) | Article display method and device, electronic equipment and storage medium |
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: 20180925 |
|
RJ01 | Rejection of invention patent application after publication |