Article Categories
» Arts & Entertainment
» Automotive
» Business
» Careers & Jobs
» Education & Reference
» Finance
» Food & Drink
» Health & Fitness
» Home & Family
» Internet & Online Businesses
» Miscellaneous
» Self Improvement
» Shopping
» Society & News
» Sports & Recreation
» Technology
» Travel & Leisure
» Writing & Speaking

  Listed Article

  Category: Articles » Technology » Article

SAP Data Warehousing Solution

By Ron victor

SAP BW is a continuous data warehousing solution that uses former SAP technologies. This SAP BW is built on the Basis of 3-tier architecture and coded in the ABAP (Advanced Business Application Programming) language. This 3-tier architecture and code language uses ALE (Application Link Enabling) and BAPI (Business Application Programming Interface) to link BW with SAP systems and non-SAP systems.

BW Architecture

The BW has three layers in it. The top layer is the reporting layer. This top layer may be BW Business Explorer (BEx) or a third-party reporting device. This BEx consists of two components: one is BEx Analyzer and other is BEx Browser.

BW Server is a middle layer that carries out three tasks: it administrates the BW system, stores data and retrieves the data. In The bottom layer it consists of source systems, which may be R/3 systems, BW systems, flat files, and other systems. In the source systems a SAP component called Plug-In must be installed. It contains extractors. An extractor is a set of ABAP programs, database tables, and other objects that BW uses, which helps to extract data from the SAP systems. This BW Server contain Administrator Workbench, Metadata Repository and Metadata Manager, Staging Engine, PSA, ODS and User Roles.

This Administrator Workbench checks metadata and all BW objects. It has two components: one is BW Scheduler and other is BW Monitor. This component helps to load data and to monitor the data.

This Metadata Repository contains information relating to data warehouse. Metadata Repository contains two types one is business-related and other is technical. Metadata Manager is used to maintain Metadata Repository.

PSA (Persistent Staging Area) is also a BW server. This PSA stores data in the original format while being imported from the source system. It ensures quality check of data before they are loaded in their destinations, such as ODS Objects or Info Cubes.

This ODS (Operational Data Store) Objects helps to build a multilayer structure for operational data reporting. It is used for detail reporting.

Info Cubes is an actual table and they are the associated dimension tables in a star schema.

The OLAP Processor is the analytical processing engine. It analyzes and retrieves data as per users' requests.

Documents are stored in BDS (Business Document Services). The documents can appear in different formats like Microsoft Word, Excel, PowerPoint, PDF, and HTML.

BW Business Content

The BW's most powerful selling is Business Content. It contains standard reports and other associated objects. For standard reports, BW use a function called Generic Data Extraction. This function is used to extract R/3 data.

Nowadays, BW is rapidly evolving. It helps to plan BW projects and their scopes.

This sap e-business consists of three components: they are my SAP Technology, my SAP Services and my SAP Hosted Solutions.

MySAP Technology provides an infrastructure for Web Application Server and for process-centric collaboration. This infrastructure contains a component called mySAP Business Intelligence.

Another type of services called mySAP Services are the best services which support SAP offers to the customers. They offer for business analysis, technology implementation, and training to system support.

This mySAP Hosted Solutions are the outsourcing services of SAP. With the help of this solution, customers need not want to maintain physical machines and networks.
About the Author
Ron Victor is a SEO copywriter for . He written many articles in various topics in SAP Articles and Contact him at

Article Source:
If you wish to add the above article to your website or newsletters then please include the "Article Source:" as shown above and make it hyperlinked.

  Some other articles by Ron victor
How to Choose the Perfect Granite
Granite said to be the pleasant igneous rock which is formed in the earth for millions of the years from heat and fusion. It comprises of quartz, feldspar and ...

Buy House with Resale Value
When the home property purchased by you should have a good resale value. The house property purchased should have resale value, probably to pay off your debt. There are many factors ...

Stop Foreclosure - We buy houses
The term foreclosure refers to the circumstances, which arise due to the nonpayment of loan to the lender. When the borrower failed to ...

Common Mistakes Done By The Buyers During Purchase
Purchasing a house property needs more experience in the house property business as well as some knowledge in that. The buyer deals with different kinds of experience ...

Sell Your Home By Yourself
Properties can be sold by the house owners individually. Selling the properties individually is not a difficult task. It depends upon the seller's interest, attitude ...

Real Estate Investing Strategies
Investing in real estate market carries risk. The reason for this risk statement is that, it carries fluctuation. Investing in the real estate market without having ...

  Recent Articles
3 Mobile Phone Network and Role of Online Reviews on It
by Gregory Gibson

Gadgets for mobile phone owners
by Bill. Jones.

Reasons why gadgets are worth it
by Bill. Jones.

Why an iPod Battery Dies
by Anthony Magnabosco

LAN: Local Area Network
by Hemant Gupta

The Dilemma of Nanotechnology - Science vs. Ethics
by Tatiana Velitchkov

Computer classifieds
by Mohammed Aijaz

7 Reasons Why You Need A Shake Flashlight
by Jesse Whitehead

Buying Cell Phone Accessories Online? 5 Tips to Shop Smart
by John Hooley

How to Unlock a Cell Phone- the Easy Way
by Samantha Hasson

Tips For Data Recovery
by Khal Nuwar

Misunderstandings about motion capture
by Antony Rodrigues

Can't connect to database