Data dimension processing method

A processing method and data dimension technology, applied in the direction of electronic digital data processing, special data processing applications, digital data information retrieval, etc., can solve the problems of long time spent on reprocessing, increased cost, and inflexible query, etc., to achieve simple Process and generate simple and flexible viewing effects

Active Publication Date: 2019-01-29
GUANGZHOU KINTH NETWORK TECH CO LTD
View PDF4 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

When querying and analyzing, the combination of indicators and dimensions is used, but because there are usually many types and quantities of dimensions, the query is not flexible enough when generating complex reports
[0003] However, although some existing BI tools also provide users with tools to directly edit dimensions, once the dimensions are processed, once the physical model is generated from the data cube, the cost of dimension modification will increase greatly
The main reasons are: 1. The data cube is generally completed by a dedicated data analysis engineer. Ordinary users will not directly touch the modification of the original dimension. 2. Every time the data cube is modified, reprocessing will take a long time

Method used

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

Image

Smart Image Click on the blue labels to locate them in the text.
Viewing Examples
Smart Image
  • Data dimension processing method
  • Data dimension processing method

Examples

Experimental program
Comparison scheme
Effect test

specific Embodiment

[0078] In this example, the original dimensions generated are as follows:

[0079] a) Cities, whose details include all cities in Guangdong Province; custom dimension: Pearl River Delta

[0080] b) Customs, whose details include all customs; custom dimension: Northern Customs

[0081] Then, in order to facilitate retrieval, users can customize dimensions through the following steps:

[0082] a) Select the city dimension in the original dimension: By setting filter conditions, select 9 cities in the Pearl River Delta and define them as the first set of custom dimensions "Pearl River Delta".

[0083] b) Select the Customs dimension in the original dimension: By setting filter conditions, select Beijing Customs and Tianjin Customs, which are defined as the second group of custom dimensions "Northern Customs".

[0084] Users perform data query based on the above custom dimensions

[0085] A) query

example 1

[0087] 1) Query "Pearl River Delta City Sales Summary Amount"

[0088] 2) When querying, the statement only contains custom dimensions, and when translating, it is extracted. Since there are only custom dimensions, use the sub-dimensions (Guangzhou, Shenzhen, Zhuhai...) in the "Pearl River Delta" custom dimension to construct the query MDX

example 2

[0090] 1) Query "summary sales amount of all cities, among which the Pearl River Delta cities are separately summed up",

[0091] 2) When querying, the statement contains a custom dimension. When translating, take it out. In addition to the custom dimension "Pearl River Delta", the query also includes other details in the city dimension. The MDX statement of the query does not change

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

PUM

No PUM Login to view more

Abstract

The present invention provides a data dimension processing method, and provides a business intelligence data dimension processing method, so that a user may define a dimension to perform query processing. Therefore, business intelligence data may be processed simply when a data cube is built, and it is unnecessary to consider multiple combination possibilities of dimension or dimension data in advance. The user can fast and randomly perform dimension or dimension data combination when using the data. Further, an objective of flexibly checking combination dimension data is implemented, and it is ensured that report data is generated more simply in a case of defined dimension.

Description

technical field [0001] The invention relates to the field of computer data processing, in particular to a data dimension processing method. Background technique [0002] For On-Line Analytical Processing (OLAP) presentation, the dimensions of the data presentation are established when the data cube is processed. In popular business intelligence (BI—Business Intelligence) tools, the dimensions are directly generated according to the dimension tables of the database, and the dimension data members in the data cube are in one-to-one correspondence with the dimension records in the database dimension tables. When querying and analyzing, the combination of indicators and dimensions is used, but because there are usually many types and quantities of dimensions, the query is not flexible enough when generating complex reports. [0003] However, although some existing BI tools also provide users with tools to directly edit dimensions, after the dimensions are processed, once the ph...

Claims

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

Application Information

Patent Timeline
no application Login to view more
Patent Type & Authority Patents(China)
IPC IPC(8): G06F16/9032
CPCG06F16/9032
Inventor 邓健爽
Owner GUANGZHOU KINTH NETWORK TECH CO LTD
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Try Eureka
PatSnap group products

Browse by: Latest US Patents, China's latest patents, Technical Efficacy Thesaurus, Application Domain, Technology Topic.

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap