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

This article mainly analyzes the big data report how to dynamically select the relevant knowledge points of the data source, the content is detailed and easy to understand, the operation details are reasonable, and has a certain reference value. If you are interested, you might as well follow the editor to have a look, and follow the editor to learn more about "how to dynamically select data sources for big data reports".

Suppose an enterprise with a large volume of business stores each year's data in a separate server. When a report queries data on an annual basis, it is necessary to dynamically connect the corresponding database (that is, dynamic data source).

There are two types of report tools, open source and commercial, which can actually realize the function of dynamic data source. But no matter which one, it is very troublesome to operate.

For example, the commonly used open source report Birt needs to be hard-coded in the "beforeopen" of the data source configuration, and the process is very complex. There are examples of how birt cooperates with dynamic data sources.

Business report tools do not do well, almost all through api, according to the condition value to dynamically change the data source of the report template before calculating the report, such as the introduction of how to dynamically switch the data source of the report.

However, the dry report solves this problem better, using a scripted dataset, done in one sentence, as follows

Among them, "connect (dataSource)" is to obtain the database connection, "dataSource" is the report parameter, and the corresponding database connection can be obtained in which year. The example can refer to the dynamic switching data source-to realize the dynamic data source through parameters.

In addition, the above scenario can only be regarded as the simplest fetch requirement under the sub-database, which is even more troublesome if it involves the mixed operation of the data of each sub-database (cross-year fetch, association summary, or even the case that the sub-database is heterogeneous). For drying up the report script dataset, it is still easy to deal with these problems. It is recommended to refer to the report after the sub-database, and to introduce the targeted solutions for the impact on the report development after the sub-database.

This is the end of the introduction to "how to dynamically select data sources for big data reports". More related content can be searched for previous articles, hoping to help you answer questions and questions, please support the website!

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.