--- description: What is Schema ? In database management system (DBMS), the schema represents relational database. It defines the tables, the fields in each table and the relationship between fields and tables. In ot title: Star Schema & Extended Star Schema in SAP BI/BW image: https://www.guru99.com/images/star-schema-and-extended-star-schema-in-sap-bi-bw.png --- [Skip to content](#main) **โšก Smart Summary** Star schema and extended star schema in SAP BW organize data into fact and dimension tables, where the extended model links dimensions to master data through SID tables, enabling far greater analysis depth and master data reuse. - โญ **Classical Star Schema:** A central fact table surrounded by dimension tables that hold master data inside the cube. - ๐Ÿ”— **Extended Star Schema:** SID tables link dimensions to master data stored outside the cube for reuse. - ๐Ÿ“ **Analysis Depth:** The extended model allows 16 dimensions times 248 SID tables for richer analysis. - ๐Ÿ”‘ **SID Tables:** Surrogate IDs connect dimension tables to attribute, text, and master data tables. - ๐Ÿ“Š **Fact Table:** A fact table holds key figures and supports up to 233 measurable key figures. - ๐Ÿค– **AI Assistance:** AI and SAP HANA optimize these models for fast, large-scale analytical queries. Read More ![Star Schema and Extended Star Schema in SAP BI/BW](https://www.guru99.com/images/star-schema-and-extended-star-schema-in-sap-bi-bw.png) ## What is a Schema? In a database management system (DBMS), a schema represents the relational database. It defines the tables, the fields in each table, and the relationships between fields and tables. In other words, a schema is a collection of database objects, including tables, views, indexes, and synonyms. Schemas are generally stored in a data dictionary. ## What is a Classical Star Schema? A classical star schema is a multidimensional data model. It is based on a central **fact table** surrounded by several dimension tables in the shape of a star (hence the name). An InfoCube consists of several [InfoObjects](https://www.guru99.com/all-about-infoobject-infoarea-infoobject-catalog.html) (characteristics and key figures) and is structured according to the star schema. There is a large fact table with key figures for the InfoCube, surrounded by many dimension tables that form the star. A fact table can have a maximum of 16 dimensions. The benefits of the star schema are easy slicing of data, easy understanding, and improved performance. [![Star Schema in SAP BI/BW]()](https://www.guru99.com/images/sap/SAP_BI/sap_bi_18_1.jpg) ## What is an Extended Star Schema? In the extended star schema, the โ€œfact tableโ€ and the โ€œmaster data tableโ€ are connected through an SID (Surrogate ID) table. The fact table and dimension table sit inside the cube, while master data sits outside it. It has an analyzing capacity of 16 ร— 248 (SID tables). The fact table is small and the dimension table is large, contrary to the classical star schema. Under the extended star schema, the dimension table does not contain master data. [![Extended Star Schema in SAP BI/BW]()](https://www.guru99.com/images/sap/SAP_BI/sap_bi_18_2.jpg) The different components of an extended star schema are: 1. The attribute table holds the attributes of master data. 2. The SID table creates a unique SID (Surrogate ID) for every master data record. 3. The dimension table creates a DimID for every unique combination of SIDs (a maximum of 248 SID characteristics can be accommodated in a dimension table). 4. The text table holds descriptions of master data. 5. The fact table contains a unique combination of DimIDs and key figures (a maximum of 233 key figures can be accommodated in a fact table). [![Extended Star Schema in SAP BI/BW]()](https://www.guru99.com/images/sap/SAP_BI/sap_bi_18_3.jpg) Below is an example of how a fact table of an InfoCube looks. [![Extended Star Schema in SAP BI/BW]()](https://www.guru99.com/images/sap/SAP_BI/sap_bi_18_4.jpg) Below are the dimension and SID tables. [![Extended Star Schema in SAP BI/BW]()](https://www.guru99.com/images/sap/SAP_BI/sap_bi_18_5.jpg) Below are the InfoObject master data and text tables. [![Extended Star Schema in SAP BI/BW]()](https://www.guru99.com/images/sap/SAP_BI/sap_bi_18_6.jpg) **Don't Miss:** - [How to Create an InfoObject with Characteristics in SAP BI/BW](https://www.guru99.com/how-to-create-an-infoobject-with-characteristics.html) - [How to Load Master Data From ECC in SAP BI/BW](https://www.guru99.com/how-to-load-master-data-from-ecc.html) - [RSA5 Tcode in SAP BW: Load ECC Transaction Data](https://www.guru99.com/how-to-load-transaction-data-from-ecc.html) - [Top 40 SAP BW Interview Questions and Answers in 2026](https://www.guru99.com/sap-bw-bi-interview-questions.html) ## InfoCube: Sample Extended Star Schema The following is an example of an InfoCube showing the extended star schema. **Steps explaining the extended star schema of an InfoCube:** 1. The fact table of the InfoCube has a value of 3. 2. The value of the fact table (โ€œ3โ€) is mapped in the dimension table. 3. The Dimension ID โ€œ3โ€ has an SID mapped in the SID table. 4. The SID value is mapped with the text and master data tables. [![InfoCube Sample Extended Star Schema]()](https://www.guru99.com/images/sap/SAP_BI/sap_bi_18_7.jpg) ## FAQs ๐Ÿ”‘ What is an SID table in SAP BW? An SID (Surrogate ID) table assigns a short, unique integer key to each master data value. In the extended star schema, SID tables link dimension tables to master data, text, and attribute tables, improving join performance and reuse. ๐Ÿ—ƒ๏ธ Where is master data stored in the extended star schema? Master data is stored outside the InfoCube in separate attribute, text, and SID tables, not inside the dimension tables. This separation lets the same master data be reused across many InfoCubes instead of being duplicated. ๐Ÿ†š What is the difference between a fact table and a dimension table? A fact table stores the measurable key figures and the DimIDs that link to dimensions. A dimension table groups related characteristics and connects, via SID tables, to the master data that describes them. Fact tables are large; dimension tables are smaller. ๐Ÿค– Can AI optimize SAP BW data models and queries? Yes. SAP HANA and machine learning analyze query patterns to recommend aggregates, partitioning, and model changes. In SAP Datasphere and Analytics Cloud, AI further suggests models and surfaces insights from the underlying schema. ๐Ÿง  How does machine learning use star schema data for analytics? Machine learning reads the clean, structured fact and dimension data to train forecasting and anomaly-detection models. The star schemaโ€™s consistent keys and master data make it a reliable foundation for AI-driven analytics and planning. #### Summarize this post with: ChatGPTPerplexityGrokGoogle 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) ร— Search for: ```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/star-schema-and-extended-star-schema-in-sap-bi-bw.png","url":"https://www.guru99.com/images/star-schema-and-extended-star-schema-in-sap-bi-bw.png","width":"700","height":"250","caption":"Star Schema & Extended Star Schema in SAP BI/BW","inLanguage":"en-US"},{"@type":"BreadcrumbList","@id":"https://www.guru99.com/all-about-classical-extended-star-schema.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/all-about-classical-extended-star-schema.html","name":"Star Schema & Extended Star Schema in SAP BI/BW"}}]},{"@type":"WebPage","@id":"https://www.guru99.com/all-about-classical-extended-star-schema.html#webpage","url":"https://www.guru99.com/all-about-classical-extended-star-schema.html","name":"Star Schema & Extended Star Schema in SAP BI/BW","dateModified":"2026-10-09T16:26:02+05:30","isPartOf":{"@id":"https://www.guru99.com/#website"},"primaryImageOfPage":{"@id":"https://www.guru99.com/images/star-schema-and-extended-star-schema-in-sap-bi-bw.png"},"inLanguage":"en-US","breadcrumb":{"@id":"https://www.guru99.com/all-about-classical-extended-star-schema.html#breadcrumb"}},{"@type":"Person","@id":"https://www.guru99.com/author/editorial","name":"Editorial Team","url":"https://www.guru99.com/author/editorial","image":{"@type":"ImageObject","@id":"https://www.guru99.com/images/favicon-new-logo.png","url":"https://www.guru99.com/images/favicon-new-logo.png","caption":"Editorial Team","inLanguage":"en-US"},"sameAs":["https://www.guru99.com/editorial-team"],"worksFor":{"@id":"https://www.guru99.com/#organization"}},{"articleSection":"SAP - BI","headline":"Star Schema & Extended Star Schema in SAP BI/BW","description":"What is Schema ? In database management system (DBMS), the schema represents relational database. It defines the tables, the fields in each table and the relationship between fields and tables. In ot","keywords":"sap-bi","speakable":{"@type":"SpeakableSpecification","cssSelector":[".entry-title",".summary"]},"@type":"Article","author":{"@id":"https://www.guru99.com/author/editorial","name":"Editorial Team"},"dateModified":"2026-10-09T16:26:02+05:30","image":{"@id":"https://www.guru99.com/images/star-schema-and-extended-star-schema-in-sap-bi-bw.png"},"copyrightYear":"2026","name":"Star Schema & Extended Star Schema in SAP BI/BW","subjectOf":[{"@type":"FAQPage","mainEntity":[{"@type":"Question","name":"What is an SID table in SAP BW?","acceptedAnswer":{"@type":"Answer","text":"An SID (Surrogate ID) table assigns a short, unique integer key to each master data value. In the extended star schema, SID tables link dimension tables to master data, text, and attribute tables, improving join performance and reuse."}},{"@type":"Question","name":"Where is master data stored in the extended star schema?","acceptedAnswer":{"@type":"Answer","text":"Master data is stored outside the InfoCube in separate attribute, text, and SID tables, not inside the dimension tables. This separation lets the same master data be reused across many InfoCubes instead of being duplicated."}},{"@type":"Question","name":"What is the difference between a fact table and a dimension table?","acceptedAnswer":{"@type":"Answer","text":"A fact table stores the measurable key figures and the DimIDs that link to dimensions. A dimension table groups related characteristics and connects, via SID tables, to the master data that describes them. Fact tables are large; dimension tables are smaller."}},{"@type":"Question","name":"Can AI optimize SAP BW data models and queries?","acceptedAnswer":{"@type":"Answer","text":"Yes. SAP HANA and machine learning analyze query patterns to recommend aggregates, partitioning, and model changes. In SAP Datasphere and Analytics Cloud, AI further suggests models and surfaces insights from the underlying schema."}},{"@type":"Question","name":"How does machine learning use star schema data for analytics?","acceptedAnswer":{"@type":"Answer","text":"Machine learning reads the clean, structured fact and dimension data to train forecasting and anomaly-detection models. The star schema's consistent keys and master data make it a reliable foundation for AI-driven analytics and planning."}}]}],"@id":"https://www.guru99.com/all-about-classical-extended-star-schema.html#schema-1123389","isPartOf":{"@id":"https://www.guru99.com/all-about-classical-extended-star-schema.html#webpage"},"publisher":{"@id":"https://www.guru99.com/#organization"},"inLanguage":"en-US","mainEntityOfPage":{"@id":"https://www.guru99.com/all-about-classical-extended-star-schema.html#webpage"}}]} ```