Shulou(Shulou.com)06/02 Report--

In this issue, Xiaobian will bring you a discussion on how to carry out the tabulation ability of report tools in big data. The article is rich in content and analyzes and narrates from a professional perspective. After reading this article, I hope you can gain something.

The core and essential function of the so-called report tool is its tabulation ability, that is, whether it can make various reports that it needs without writing code. However, users often pay attention to peripheral factors such as printout, drawing scheme, management scheduling, etc., while ignoring the most essential tabulation ability of report tools. Admittedly, these peripheral features are important metrics for a reporting tool, but the primary purpose of reporting tools is to produce reports. At present, only FineReport and Dry Report are the mainstream products on the market that can handle complex reports.

Through the study of these two products, we believe that the ability of report tools to process complex reports should be reflected in the following aspects:

The first is multi-source fragmentation.

Traditional report tools only support single-source reports. Even if the data comes from multiple physical data tables or physical databases, it is necessary to convert multiple sources into single-source processing by writing SQL and stored procedures before report design.

Multiple sources often lead to fragmentation. It is precisely because of fragmentation that report design must be based on multiple sources directly, and multiple sources cannot be converted into single sources first. A considerable number of fragmented reports cannot be converted to single-source processing in any case, and some reports that can be converted to single-source processing are also very complicated.

Second, there is the irregular division mechanism.

Traditional grouping is completely regular division, that is, the division standard is consistent and regular (generally according to a certain field or expression), all fields must appear and only appear once, and the grouping value order is consistent with the original data record order.

However, corresponding to complete division, irregular division is often needed in report summary, that is, the division standard does not see the rule (often only exhaustive), all facts may not appear in the grouping results, individual facts may also appear repeatedly, and the order has nothing to do with the original data records. [@more@] And then there's the ability to do dynamic cell arithmetic.

All report tools provide some column calculation functions, and calculate some other column values or statistical values on the basis of original data. This is an indispensable function in report presentation.

General report tools generally only provide inter-cell operations within the same line and set operations for a group (or all). For common cross-line group operations such as accumulation and taking the first place, it is quite difficult.

In addition to regular cross-row group operations, there may also be some random independent cell operations in the report, whose values may be calculated from any of several other cell operations in the report, and may even refer to data outside the report (such as re-operation with data in the database). Therefore, the naming mechanism of report data items after operation is very important. Traditional tools can only name data units in the design stage with column names, and random independent cell operations will make traditional tools unable to handle them. Data references outside the report can only be used by scripts or peripheral applications, resulting in extremely confusing codes.

In addition, all the above discussion also runs through one point, namely, the symmetry of rows and columns. The ability to automatically replicate extensions in the vertical direction needs to be fully implemented in the horizontal direction. Reports can be grouped horizontally and segmented horizontally. For reports with horizontal column changes, cross-column group operations can be defined.

Therefore, I personally think that the commercial consideration of this product is greater than the actual value of the product. Because the same company will not provide two products with the same function but more than ten times the price difference. It is nothing more than attracting the attention of users with a low-priced product and then strongly recommending another high-priced product.

The above is a small series of discussions on how to carry out the tabulation ability of report tools in big data shared by everyone. If there are similar doubts, please refer to the above analysis for understanding. If you want to know more about it, please pay attention to the industry information channel.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.