Advertisement

A modern data warehouse must meet the following requirements:

[source: Business Warehouse Course Handbook from mySAP.com]

Standardized structuring and display of all business information:

Decision makers urgently need reliable information from the production, purchasing, sales and distribution, finance, and human resources departments. They require an up-to-date and comprehensive picture of each individual business area and of the business as a whole. These results in high demands being put on the data collection process from the underlying data sources. An important aspect here is that the data is defined uniquely across the entire organization, in order to avoid errors arising through varied definitions in different sources.

Simple access to business information via a single point of entry:

Information must be combined homogeneously and consistently at a central point, from which it can be called up centrally. For this reason, modern data warehouses require a separate database. This database enables a stand-alone application environment to provide the required services.

Highly-developed reporting for analysis with self service for all areas:

In terms of presentation, efficient analysis and meaningful multimedia visualization techniques are essential. The system must be able to cope with the information needs of the most varied of user groups.

Quick and cost-efficient implementation:

When implementing the data warehouse, an influential cost factor is its integration into an OLTP system and the straight-forward loading of heterogeneous data. Alongside the Metadata Repository, Business Content also has an important role here.

High performance environment and Data modeling from heterogeneous Sources:

Data analyses can be carried out via a data warehouse, without integrating heterogeneous sources online using time-consuming read processes. This data can be loaded in separate batch jobs at performance-friendly times.

Relieving OLTP systems:

In the past, OLTP systems were strongly overloaded by having to store data and analysis it at the same time. A separate data warehouse server now allows you to carry out data analysis elsewhere.

Tags: * *

Filed under: Business Warehouse

Like this post? Subscribe to my RSS feed and get loads more!