Data analysis method capable of achieving self-defining of complex service computational logic on basis of OLAP

Abstract

The invention relates to a data analysis method capable of achieving self-defining of complex service computational logic on the basis of the OLAP. The method comprises the following steps that S1, BI data reports of various services needing data analysis are collected; S2, a service attribute combined configuration information table is established according to the BI data reports, and data in the information table are bound to an SQL inquiring module for inquiring; S3, various attribute data reports are established according to the BI data reports of various services and the service attribute combined configuration information table, and parameter inquiring conditions are set for inquiring of data in the various attribute data reports; S4, the various attribute data reports are counted, and exhibition result reports of various services are established; S5, coding is carried out on various attributes in the service attribute combined configuration information table; S6, a displaying platform receives service names and attribute combinations input for inquiring by users, and the displaying results are collected on the displaying platform to be displayed to the users. The data analysis method capable of achieving self-defining of complex service computational logic on the basis of the OLAP has the advantages of being flexible and easy to operate, and having dynamic restriction indexes.

Description

technical field [0001] The invention relates to a data analysis method capable of customizing complex business calculation logic based on OLAP. Background technique [0002] The concept of business intelligence (Business Intelligence, abbreviated as BI) was first proposed by the Gartner Group in 1996. The Gartner Group defined business intelligence as: business intelligence describes a series of concepts and methods, through the application Fact-based support systems to aid in business decision-making. Business intelligence technology provides technologies and methods that enable enterprises to quickly analyze data, including collecting, managing and analyzing data, transforming these data into useful information, and then distributing them throughout the enterprise. Business intelligence is generally understood as a tool that converts existing data in an enterprise into knowledge and helps the enterprise make informed business decisions. In order to transform data into kn...

AI Technical Summary

Problems solved by technology

If there are products and time dimensions, and the sales amount is used as an indicator, put the product on the row, put the time dimension year on the column, and put the sales amount below the year on the column, so that the report can display the annual sales amount of each product. But we can't get a growth rate this year compared to last year

If such an indicator is added during design, it is required that the indicator must be placed together with the time dimension, which means that the maintenance level on the column must be fixed and cannot be drilled down, and the calculation on other dimensions needs to be added. ,Very inconvenient

Images