Recently, a web project is considering reporting tools. The report of the system is self-evident in the importance of system development.
On the one hand, for a general MIS or ERP, the report is the performance of the customer's most intuitive feeling of system functions, that is, the system can attract customers, especially the customer's leadership. The general system has a so-called "leader" or "decision support" module when designing, is preparation to the general manager or president when the system is selling system, I rarely see the high-level leadership when the system is really online. The system will be used directly because they are usually viewed, not directly using the system.
On the other hand, in a period of the project online, the customer proposes the most demand place is the report. Therefore, developing a variety of reports have become the daily work of maintenance personnel. Customers may suddenly, what kind of reports want to do, need to analyze the business data, which makes programmers trouble.
There are many ways to solve the problem:
1. The system designer will think of adding a "customer self-service query" or "report customization" feature to the system, actually it is a small report designer. This fees are fees, and the function is also a single one.
2. With a more powerful report tool, with a user designer. For example, Fast Report, Crystal Report, etc. The designer of these tools is very strong, and the user will design it yourselfself, but to let customers design complex reports with these tools, basically in developing user programming programmers.
3. Data warehouse technology is one of the solutions to these issues, which can be seen as the deepening of the report system.
Both major database vendors have their own data warehouse solutions. The concept of data warehouse is very large, but the general people are just enough to use it to do OLAP.
The theory of the data warehouse is also very complicated, and it is so deeply detailed for general applications. The data warehouse is also very simple. Microsoft's SQL Services came with Anylize Service. This is Microsoft's data warehouse product. It has a introduction tutorial, very simple, spend a few hours Step by Step Some basic bits of data The concept will understand.
