What is the use of star schema in SAP BW?
In Star Schema, each dimension is joined to one single fact table. Each dimension is represented by only one dimension and it is not further normalized. A dimension Table contains a set of attributes that are used to analyze the data.
What is extended star schema in SAP BW?
What is Extended Star Schema? In extended star schema, “fact table” and “master data table” is connected through SID (Surrogate ID) table. In extended star schema , fact table and dimension table will be inside the cube. It has analyzing capacity of 16*248 (SID Table).
How many dimensions can a star schema have?
four dimensions
A star schema for AllElectronics sales is shown in Figure 4.6. Sales are considered along four dimensions: time, item, branch, and location.
What is snowflake and star schema?
Comparing Snowflake vs Star schema, a Snowflake Schema is an extension of a Star Schema, and it adds additional dimensions. It is called snowflake because its diagram resembles a Snowflake. In a star schema, only single join defines the relationship between the fact table and any dimension tables.
What kind of schema does BW use?
Few thoughts .. BW uses extended star schema.The Fact table consists of key figures and DIM ID’s (Dimension ID’s). The DIM ID’s will reference the dimensions that are involved with a particular Fact Table. The dimensions in turn will have SID’s (Surrogate ID’S) which in turn will reference the master data.
What is the difference between star schema and extended star schema?
In extended star schema , fact table and dimension table will be inside the cube. It has analyzing capacity of 16*248 (SID Table). Fact table is small and dimension table is huge contrary to Star Schema model. Under the extended star schema model, the dimension table do not contain master data
What is an example of an extended star schema in infocube?
The below is an example of Infocube showing the Extended Star Schema. The Fact table of the InfoCube has a value 3. The value of the fact table (i.e “3”) is mapped in the Dimension table. The Dimension ID “3” has an SID mapped in the SID table. The SID value is mapped with the Text and Master data table.
What is a star schema in Hana?
To conclude, the star schema shows you how the backbone of your data models must look like. This will be much more clearer and fun when we actually start building data models in HANA and BW on HANA.