Enterprise Resource Planning
  Home ERP Benefits Features Selection Implementation SAP Oracle Microsoft Dynamics Books
ERP Guide
Business One vs GP
Causes of Failures
Choose Best Software
Choosing the Software
Companies and Providers
Consultants Role
Cost of Software
Dynamics Selection
Errors in Implementation
For Large Corporation
For Real Estate
For Small Business
For Health Care Industry
How to Choose ERP
How to Sell Software
Implementation Challenge
Implementation Cost
Implementation Methods
Implementation Troubles
Importance in Small Business
Increase Productivity
Market in India
Purpose of Software
Open Source Technologies
Selection of Software
Success Factors
System Implementation
Training for Jobs
Troubles and Solutions
Why Implement ERP
Wireless Technology
SAP Section
ABAP Developer
ABAP Performance Tuning
ABAP Programming
ABAP Programming Language
Advanced Planner Optimizer
Basic Modules
Business Intelligence
Business One
Business Warehouse
BW Module
CO Module
Data Warehousing
Different Components
FI Module
HR Module
MM Module
Module Introduction
Online Training Program
Performance Tuning
SD Module
Strategic Management
Web Application Server
What Is SAP

SAP Data Warehousing Solution

SocialTwist Tell-a-Friend

SAP data warehousing solution is the basis of SAP BW which converts the scattered and disjointed data into valuable information. The customization of data warehousing solution and its integration with all the SAP solutions gives the power to company management to analyze the data according to their needs and make decisions for better business and in line with the market trends and demands.

SAP data warehousing solutions performs tasks to the data irrespective of the source which means it can accept data from either a SAP or a non SAP source. These tasks are integration that is loading the data from the source, transformation, consolidation, cleanup, storage and staging for analysis and interpretation. SAP data warehousing solutions reside in SAP BI suite and once data is ready for analysis and interpretation the analytical and reporting tools of SAP BI suite are used to present it in desired format to give timely, quick and multi dimensional insight.

Data acquisition is one of the processes in SAP data warehousing in BI. Data can be retrieved form SAP or non-SAP sources these sources can be relational databases or user defined sources like Dbase, Excel etc. flat files, API or legacy applications like oracle financial etc. The data loading is done on the request and is monitored through a proper process specifically designed for every type of source.

Data transformation is the next step in SAP data warehousing solution as the data collected from different sources needs to be normalized and transformed into the format acceptable to the target BI object for processing. Data transformation is data synchronization which is done by BI objects DataStore, InfoSource, DataStore Object, InfoCube, InfoObjects and InfoSet serving as source objects whereas BI objects InfoSource, InfoObject, DataStore Object and InfoCube serving as target object.

Apart from data staging and data processing SAP data warehousing solution also provides the capability of data distribution to BI applications or data can be distributed to be loaded to other applications. Open hub destination and data mart interface are used for distributing the data to SAP or non-SAP applications.

Data Warehousing Workbench is the central point of most of the processes used for data warehouse management. This workbench performs many functions like monitoring the loading of data and administration of infoproviders, archiving and classification of data according to its history, authorization to access the data for data security and consistency, and creation of documents with related information about content of BI objects which can also be used during reporting. Data warehousing workbench of SAP data warehousing solution also provides change and transport organizer which allows the users to collect the newly developed or incorporated BI objects and transport them to required target system.

Real time data acquisition of SAP data warehousing solutions allows the user to transfer the data to BI reporting tools in real time. It transfers the data at short intervals to keep data up to date and reporting more relevant. The data is transferred to delta queue or PSA table which is then transferred to operational DataStore layer at frequent short intervals.

 Read Related Articles

ERP SoftwareSAP FI (Financial) Module
ERP SystemHuman Resource Management Module
Enterprise SystemMaterial Management Module
Enterprise SoftwareSAP Modules Introduction

  SocialTwist Tell-a-Friend
Review Section
Business One  
Dynamics AX  
Dynamics CRM  
Sage MAS 90