--- description: Before we learn more about SAP BI Architecture, lets learn about Conceptual Layers of Data Warehousing with BI Persistent Staging Area The data extracted from the Source Systems title: SAP BI Architecture Diagram: Overview Tutorial image: https://www.guru99.com/images/sap-bi-bw-architecture.png --- [Skip to content](#main) **⚡ Smart Summary** SAP BI architecture is organized into conceptual data warehousing layers, staging, data warehouse, operational data store, and data mart, across a three-tier database, application, and presentation structure that extracts, stores, and reports business data. * 📥 **Staging Layer (PSA):** The Persistent Staging Area receives raw, unchanged data from source systems. * 🏢 **Data Warehouse Layer:** Detailed history data is stored here for the long term without aggregation. * 🔁 **Operational Data Store:** The ODS holds frequently updated data and can recover lost warehouse data. * 📊 **Data Mart (InfoCube):** The Architected Data Mart stores aggregated data for analysis and reporting. * 🗄️ **Three Tiers:** Database, application (OLAP), and presentation servers form the BI architecture. * 🤖 **AI Assistance:** AI and SAP Datasphere modernize how BI layers are built and queried. [ Read More ](javascript:void%280%29;) ![SAP BI/BW Architecture](https://www.guru99.com/images/sap-bi-bw-architecture.png) Before we learn more about SAP BI architecture, let us learn about the conceptual layers of data warehousing with BI. ## Conceptual Layers of Data Warehousing with BI [![Conceptual Layers of Data Warehousing](https://www.guru99.com/images/sap/SAP_BI/sap_bi_2_1.jpg)](https://www.guru99.com/images/sap/SAP%5FBI/sap%5Fbi%5F2%5F1.jpg) **Persistent Staging Area:** The data extracted from the source systems first enters the Persistent Staging Area. The data at this layer is raw and unchanged; it is consolidated and cleansed only in the next layers. The staging area is a temporary table that holds the data and connects to the work area or fact tables. Without a staging area, the data load would go from the OLTP system to the [OLAP system](https://www.guru99.com/online-analytical-processing.html) directly, which hampers the performance of the [OLTP system](https://www.guru99.com/what-is-oltp.html). **Data Warehouse Layer (DWH Layer):** Data from the Persistent Staging Area is loaded into the data warehouse layer, which holds the corporate information repository. Data is stored here for a longer period, that is, the entire history data (for example, the last 5 years). There is no aggregation of reporting-relevant data; the granularity is at line-item (detailed) level. **Operational Data Store Layer:** Data is loaded into the Operational Data Store layer very frequently on a continuous basis from the source systems, so this layer contains all the changes made throughout the day. Data from the ODS can be loaded into the data warehouse layer at particular times (for example, end of day). It can also be used to recover data if the warehouse and data mart layers are lost. The ODS is not based on a star schema model; it is in flat file format. **Architected Data Mart Layer:** The Architected Data Mart layer, also known as the InfoCube, is designed to store summarized and aggregated data for long periods. Data from the data warehouse layer is loaded into it and used in analysis and reporting. It consists of a central fact table (key figures) surrounded by several dimension tables and supports BW queries. ## Key Components of a SAP BI System Business Intelligence is a core component of [SAP NetWeaver](https://www.guru99.com/what-is-netweaver.html). The figure below shows the key components of a BI system. [](https://www.guru99.com/images/sap/SAP%5FBI/sap%5Fbi%5F2%5F2.jpg) * **Data warehousing:** mainly to extract, transform, and load data from source systems. * **BI platform:** contains BI services that support complex analysis. It holds the Analytic Engine, which processes data requested through BEx navigations, and tools such as the Analysis Process Designer (APD) and Data Mining for merging, mining, and analyzing data. * **BI Suite:** tools that help create reports. It contains the Business Explorer (BEx), which provides flexible reporting and analysis tools. The following areas in the Business Explorer can be used for data analysis: 1. BEx Analyzer (Microsoft Excel-based analysis tool with pivot-table-like features). 2. BEx Web Analyzer (web-based analysis tool with pivot-table-like features). 3. BEx Web Application Designer (customer-defined and [SAP BI](https://www.guru99.com/introduction-sap-bi.html) Content provided). 4. BEx Report Designer (highly formatted web output). ### RELATED ARTICLES * [How To Create InfoObjects With Key Figures in SAP BI/BW ](https://www.guru99.com/how-to-create-infoobjects-with-key-figures.html "How To Create InfoObjects With Key Figures in SAP BI/BW") * [RSA5 Tcode in SAP BW: Load ECC Transaction Data ](https://www.guru99.com/how-to-load-transaction-data-from-ecc.html "RSA5 Tcode in SAP BW: Load ECC Transaction Data") * [Star Schema & Extended Star Schema in SAP BI/BW ](https://www.guru99.com/all-about-classical-extended-star-schema.html "Star Schema & Extended Star Schema in SAP BI/BW") * [Top 40 SAP BW Interview Questions and Answers in 2026 ](https://www.guru99.com/sap-bw-bi-interview-questions.html "Top 40 SAP BW Interview Questions and Answers in 2026") ## SAP BI/BW Architecture BI has a three-tier architecture: **Database Server:** where data is physically stored (ODS, PSA, InfoCube, and the metadata repository). **Application Server:** based on the OLAP processor. It is used to retrieve data stored in the database server. **Presentation Server:** manages reporting and data access. 1. Data is extracted from the source systems. 2. Data is staged at the Persistent Staging Area (PSA), which holds source-like data. 3. Data is cleansed, loaded, and stored in the DataStore Object. 4. Data is viewed at multiple dimensions in the InfoCube. 5. Data is made available by the OLAP processor to the Business Explorer to display per analysis requirements. 6. Data can be made available to SAP and non-SAP data marts by the Open Hub Service (InfoSpoke). [](https://www.guru99.com/images/sap/SAP%5FBI/sap%5Fbi%5F2%5F3.jpg) ## FAQs 📥 What is the PSA in SAP BW? The Persistent Staging Area (PSA) is the inbound staging layer where data from source systems first lands in its raw, unchanged form. It protects source system performance and provides a buffer from which a DTP loads data onward into InfoProviders. 🔓 What is the Open Hub Service (InfoSpoke) in SAP BW? The Open Hub Service distributes data out of SAP BW to SAP and non-SAP targets such as flat files, database tables, or other applications. The older InfoSpoke object and the newer Open Hub Destination control this controlled data export. 🧩 What is the role of the OLAP processor in SAP BI? The OLAP processor, or Analytic Engine, sits on the application server. It retrieves data from the database layer, applies query logic such as filters and calculations, and serves the results to the Business Explorer for reporting and analysis. 🤖 How does AI fit into modern SAP BI architecture? AI sits mainly in the analytics layer. SAP Analytics Cloud adds augmented analytics over BW data, while SAP Datasphere and HANA use machine learning for modeling and performance, extending the classic layered architecture with intelligent services. 🧠 Can AI automate data warehouse layer design? Increasingly, yes. Machine learning profiles source data to suggest staging, cleansing, and modeling steps, and the SAP Joule AI copilot can recommend objects. In SAP Datasphere, AI streamlines pipeline design across the warehouse layers. #### Summarize this post with: ChatGPT Perplexity Grok Google AI **Stay Updated on AI** **Get Weekly AI Skills, Trends, Actionable Advice.** ##### Sign up for the newsletter Subscribe for Free You have successfully subscribed. Please check your inbox. ![AI-Newsletter]() Chosen by over **350,000+** professionals [Scroll to top ](#wrapper)Scroll to top × Toggle Menu Close Search for: Search ```json {"@context":"https://schema.org","@graph":[{"@type":"Organization","@id":"https://www.guru99.com/#organization","name":"Guru99","sameAs":["https://www.facebook.com/Guru99Official","https://twitter.com/guru99com"],"logo":{"@type":"ImageObject","@id":"https://www.guru99.com/#logo","url":"https://www.guru99.com/images/guru99-logo-v1-150x59.png","contentUrl":"https://www.guru99.com/images/guru99-logo-v1-150x59.png","caption":"Guru99","inLanguage":"en-US"}},{"@type":"WebSite","@id":"https://www.guru99.com/#website","url":"https://www.guru99.com","name":"Guru99","publisher":{"@id":"https://www.guru99.com/#organization"},"inLanguage":"en-US"},{"@type":"ImageObject","@id":"https://www.guru99.com/images/sap-bi-bw-architecture.png","url":"https://www.guru99.com/images/sap-bi-bw-architecture.png","width":"700","height":"250","caption":"SAP BI/BW Architecture","inLanguage":"en-US"},{"@type":"BreadcrumbList","@id":"https://www.guru99.com/overview-of-sap-bi-architecture.html#breadcrumb","itemListElement":[{"@type":"ListItem","position":"1","item":{"@id":"https://www.guru99.com","name":"Home"}},{"@type":"ListItem","position":"2","item":{"@id":"https://www.guru99.com/sap-bi","name":"SAP - BI"}},{"@type":"ListItem","position":"3","item":{"@id":"https://www.guru99.com/overview-of-sap-bi-architecture.html","name":"SAP BI Architecture Diagram: Overview Tutorial"}}]},{"@type":"WebPage","@id":"https://www.guru99.com/overview-of-sap-bi-architecture.html#webpage","url":"https://www.guru99.com/overview-of-sap-bi-architecture.html","name":"SAP BI Architecture Diagram: Overview Tutorial","dateModified":"2026-06-27T12:24:37+05:30","isPartOf":{"@id":"https://www.guru99.com/#website"},"primaryImageOfPage":{"@id":"https://www.guru99.com/images/sap-bi-bw-architecture.png"},"inLanguage":"en-US","breadcrumb":{"@id":"https://www.guru99.com/overview-of-sap-bi-architecture.html#breadcrumb"}},{"@type":"Person","@id":"https://www.guru99.com/author/jessica","name":"Jessica Blake","description":"I'm Jessica Blake, an SAP Consultant, dedicated to helping businesses achieve their goals with expert SAP guidance.","url":"https://www.guru99.com/author/jessica","image":{"@type":"ImageObject","@id":"https://www.guru99.com/images/jessica-blake-author.png","url":"https://www.guru99.com/images/jessica-blake-author.png","caption":"Jessica Blake","inLanguage":"en-US"},"worksFor":{"@id":"https://www.guru99.com/#organization"}},{"articleSection":"SAP - BI","headline":"SAP BI Architecture Diagram: Overview Tutorial","description":"Before we learn more about SAP BI Architecture, lets learn about Conceptual Layers of Data Warehousing with BI Persistent Staging Area The data extracted from the Source Systems","keywords":"sap-bi","speakable":{"@type":"SpeakableSpecification","cssSelector":[".entry-title",".summary"]},"@type":"Article","author":{"@id":"https://www.guru99.com/author/jessica","name":"Jessica Blake"},"dateModified":"2026-06-27T12:24:37+05:30","image":{"@id":"https://www.guru99.com/images/sap-bi-bw-architecture.png"},"copyrightYear":"2026","name":"SAP BI Architecture Diagram: Overview Tutorial","subjectOf":[{"@type":"FAQPage","mainEntity":[{"@type":"Question","name":"What is the PSA in SAP BW?","acceptedAnswer":{"@type":"Answer","text":"The Persistent Staging Area (PSA) is the inbound staging layer where data from source systems first lands in its raw, unchanged form. It protects source system performance and provides a buffer from which a DTP loads data onward into InfoProviders."}},{"@type":"Question","name":"What is the Open Hub Service (InfoSpoke) in SAP BW?","acceptedAnswer":{"@type":"Answer","text":"The Open Hub Service distributes data out of SAP BW to SAP and non-SAP targets such as flat files, database tables, or other applications. The older InfoSpoke object and the newer Open Hub Destination control this controlled data export."}},{"@type":"Question","name":"What is the role of the OLAP processor in SAP BI?","acceptedAnswer":{"@type":"Answer","text":"The OLAP processor, or Analytic Engine, sits on the application server. It retrieves data from the database layer, applies query logic such as filters and calculations, and serves the results to the Business Explorer for reporting and analysis."}},{"@type":"Question","name":"How does AI fit into modern SAP BI architecture?","acceptedAnswer":{"@type":"Answer","text":"AI sits mainly in the analytics layer. SAP Analytics Cloud adds augmented analytics over BW data, while SAP Datasphere and HANA use machine learning for modeling and performance, extending the classic layered architecture with intelligent services."}},{"@type":"Question","name":"Can AI automate data warehouse layer design?","acceptedAnswer":{"@type":"Answer","text":"Increasingly, yes. Machine learning profiles source data to suggest staging, cleansing, and modeling steps, and the SAP Joule AI copilot can recommend objects. In SAP Datasphere, AI streamlines pipeline design across the warehouse layers."}}]}],"@id":"https://www.guru99.com/overview-of-sap-bi-architecture.html#schema-1123798","isPartOf":{"@id":"https://www.guru99.com/overview-of-sap-bi-architecture.html#webpage"},"publisher":{"@id":"https://www.guru99.com/#organization"},"inLanguage":"en-US","mainEntityOfPage":{"@id":"https://www.guru99.com/overview-of-sap-bi-architecture.html#webpage"}}]} ```