How do I use SQL Server 2005 to complete a large business quick report?

Sandvik Tooling, a Swedish tool maker with more than 15,000 employees in nearly 70 countries, needs a centralized reporting solution to help its managers monitor the operations of their businesses. By using the Microsoft®sql server™2005 beta version, The company creates a data warehouse for reporting and analysis. The Microsoft SQL Server 2005 profiling service is used to create cube cubes for analysis. At the same time, Microsoft SQL Server 2005 Reporting Services make it easier for managers to create and manage their own reports, and reports that previously took three weeks to build can now be created every day. The SQL SERVER 2005 Notification Service allows managers to set their own triggers for receiving information updates, which can be automatically sent to different devices, including personal data Assistants (PDAs) and mobile phones-which are very helpful to those who travel.

First, the situation

Sandvik Tooling, which has nearly 2.9 billion dollars in revenue in 2004, is the largest company in the Sandvik group, and the Sandvik Group, in 1862 in Sweden as a producer of high-quality Steel, is now a multinational with $8 billion trillion in assets. The company developed a professional production of stainless steel technology, Sandvik Tooling also because of its tools and processing systems in the world enjoy a good reputation.

Over the past 10 years, Sandvik tooling has expanded four times times in size. The company has more than 15,000 employees in nearly 70 countries. Rapid growth has shown that Sandvik tooling remains well-managed---because even the same growth makes it increasingly difficult to keep a clear vision of business activity.

The time it takes to collect basic data, such as factory orders, sales and distribution activities, is also longer than the manager expects, because information is stored separately in different places, including VAX Mainframe, IBM as/400 system, Oracle database running on UNIX, and a separate microsoft®sql server™2000 database. SQL Server 2000 is part of the Microsoft Windows Server system™ Integration Server software. In recent years, companies have created data warehouses, but since these are independent of each other, the company faces the challenge of gathering this information together for analysis and reporting