ABAP REPORTS: Data Ware house components

Data Provider Layer

The Data Provider layer is the primary gateway to the data sources (OLTP applications or other). Major tasks performed at this layer provide an environment in which to construct subject-oriented data analysis models.

Metadata (data about the data) is pulled in to a data warehouse environment from its data sources. Extraction, Transformation, and Transport services fetch data from data sources, qualify, perform value-added data manipulation, and push data out to data warehouse data objects. Key services performed at this layer are the following:

Data Transport
Data Transformation
Data Cleansing
Data Extraction
Subject Models

Service Provider Layer

The Service Provider layer is responsible for managing and distributing data objects across the Enterprise to support business intelligence activities in a controlled and secured fashion. At this layer, data is further transformed for specific data analysis tasks such as drill-down analysis and predefined reports integration with third-party subscribed data.

Moreover, data/text-mining data services transform data into knowledge by applying analytical techniques or combining structured and unstructured data, such as building a Web-centric environment by authoring Web pages to merge product sales data, charts, graphs, and product images. This layer is very complex within the data warehouse architecture. Key services performed at this layer are the following:

Analytical Applications Integration
Data Distribution
Data Profiling
Data Partitioning
Information Authoring
Data Consolidatio
Data Staging
Data Storage

The Information Consumer layer

It accesses information objects from a data warehouse. Information delivery services, provided by service providers, must be robust enough to handle large data volumes and multimedia objects. Keep in mind that not all end users have the same needs. Some users simply want to look at a list of numbers.

Some may want to have push-button models to see charts and graphs, and analysts may need access to large volumes of data to do extensive data analysis. Data access and delivery services must be robust enough to handle all such scenarios. Key services performed at this layer are the following:

Information Presentation
Search Engines
End-User Data Synchronization
Data Conversions
Information Access APIs
Information Consumer Profiling
Global Catalogs
Information Delivery

Data Warehouse Management Layer

The Data Warehouse Management layer provides services to manage all data objects in all layers. Additional services at this layer include component installation, monitoring, tuning, scheduling, networking, database operations, and component problem tracking/analysis that can be performed globally. Key services performed at this layer are the following: