| SAP BW is a continuous data warehousing solution | | | | being imported from the source system. It ensures |
| that uses former SAP technologies. This SAP BW is | | | | quality check of data before they are loaded in their |
| built on the Basis of 3-tier architecture and coded in | | | | destinations, such as ODS Objects or Info Cubes. |
| the ABAP (Advanced Business Application | | | | This ODS (Operational Data Store) Objects helps to |
| Programming) language. This 3-tier architecture and | | | | build a multilayer structure for operational data |
| code language uses ALE (Application Link Enabling) | | | | reporting. It is used for detail reporting. |
| and BAPI (Business Application Programming | | | | Info Cubes is an actual table and they are the |
| Interface) to link BW with SAP systems and | | | | associated dimension tables in a star schema. |
| non-SAP systems. | | | | The OLAP Processor is the analytical processing |
| BW Architecture | | | | engine. It analyzes and retrieves data as per users' |
| The BW has three layers in it. The top layer is the | | | | requests. |
| reporting layer. This top layer may be BW Business | | | | Documents are stored in BDS (Business Document |
| Explorer (BEx) or a third-party reporting device. This | | | | Services). The documents can appear in different |
| BEx consists of two components: one is BEx | | | | formats like Microsoft Word, Excel, PowerPoint, PDF, |
| Analyzer and other is BEx Browser. | | | | and HTML. |
| BW Server is a middle layer that carries out three | | | | BW Business Content |
| tasks: it administrates the BW system, stores data | | | | The BW's most powerful selling is Business Content. |
| and retrieves the data. In The bottom layer it | | | | It contains standard reports and other associated |
| consists of source systems, which may be R/3 | | | | objects. For standard reports, BW use a function |
| systems, BW systems, flat files, and other systems. | | | | called Generic Data Extraction. This function is used |
| In the source systems a SAP component called | | | | to extract R/3 data. |
| Plug-In must be installed. It contains extractors. An | | | | Nowadays, BW is rapidly evolving. It helps to plan BW |
| extractor is a set of ABAP programs, database | | | | projects and their scopes. |
| tables, and other objects that BW uses, which helps | | | | This sap e-business consists of three components: |
| to extract data from the SAP systems. This BW | | | | they are my SAP Technology, my SAP Services and |
| Server contain Administrator Workbench, Metadata | | | | my SAP Hosted Solutions. |
| Repository and Metadata Manager, Staging Engine, | | | | MySAP Technology provides an infrastructure for |
| PSA, ODS and User Roles. | | | | Web Application Server and for process-centric |
| This Administrator Workbench checks metadata and | | | | collaboration. This infrastructure contains a |
| all BW objects. It has two components: one is BW | | | | component called mySAP Business Intelligence. |
| Scheduler and other is BW Monitor. This component | | | | Another type of services called mySAP Services are |
| helps to load data and to monitor the data. | | | | the best services which support SAP offers to the |
| This Metadata Repository contains information | | | | customers. They offer for business analysis, |
| relating to data warehouse. Metadata Repository | | | | technology implementation, and training to system |
| contains two types one is business-related and other | | | | support. |
| is technical. Metadata Manager is used to maintain | | | | This mySAP Hosted Solutions are the outsourcing |
| Metadata Repository. | | | | services of SAP. With the help of this solution, |
| PSA (Persistent Staging Area) is also a BW server. | | | | customers need not want to maintain physical |
| This PSA stores data in the original format while | | | | machines and networks. |