Migrating analysis systems for a pharmaceutical manufacturer's production costs and sales data

The OLAP databases are migrated from the existing OLAP database technology in Microsoft SQL Server 2000 (Analysis Services) to the SQL Server 2005 (Analysis Services). The design of the OLAP databases is to be aligned with the management reporting specifications (analysis database currently available in SQL Server 2005).The processes for loading the fact and dimension data are implemented using Integration Services. The data processes to be implemented are integrated into a centralized sequence control system that has already been established. The Business Intelligence Development Studio, based on Visual Studio 2005, is used as the development environment for the data processes and the OLAP databases. The OLAP databases are made available to users by means of Analysis Services. At the front end, users can select either "MIS Plain" (from MIS AG) or "Deltamaster" (from Bissantz). This is made available to users via an application server (Citrix).