Data drilling device and data drilling method

Abstract

The invention provides a data drilling device and a data drilling method. The data drilling device comprises a data setting unit, a parameter processing unit and an inquiry processing unit. The data setting unit is used for grouping fields in a report, selecting a main field in each group, setting a page address and a fixed parameter for each field; the parameter processing unit is used for obtaining the value of the main field in the field group with a field selected by a user as a dynamic parameter corresponding to the field selected by the user after the user selects the value of any field in the report and sends a drilling request; and the inquiry processing unit is used for generating inquiring conditions according to the fixed parameter and the dynamic parameter corresponding to the field selected by the user, and inquiring the report with the page address corresponding to the field selected by the user, thereby completing drilling. By adopting the technical scheme, different field data can be drilled, the association with the fields in other reports can be realized through the main field in the field group, and the report drilling can be simplified.

Description

technical field [0001] The present invention relates to the field of computer technology, in particular to a data drilling device and a data drilling method. Background technique [0002] Drilling is one of the special functions in the report. By using the drilling function, users can click a link in a report to directly open other related reports. For example, in an intelligent system of online data analysis, there is such a result: the product category with the highest purchase rate of customer groups aged 30 to 40. Now users also need to know more detailed results, such as which products they mainly purchased. To use technical terms, it is necessary to know which data this conclusion is based on. At this time, it can be realized by using report drill. But when the user clicks on the result, a separate report opens to show details supporting the result. It can be seen that report drilling is also essential in business intelligence systems. [0003] In the management i...

AI Technical Summary

Problems solved by technology

[0009] 3. The parameter name is fixed, and the parameter cannot be self-checked;

[0010] 4. The drill function involves a lot of additional development;

[0011] 5. It is not safe to support drilling reports;

[0012] 6. The drilling process uses a lot of temporary tables, but the temporary table data processed in the middle is far from the target drilling data

[0013] 7. The browser's maximum URL length limit restricts the transmission of drill information

Images