Buy

Buy

List of Posts

Get this widget
To get notifications, Please like our Facebook Page >>>>>>

Use Search box to find a topic in this Blog!!!

Chapter 3: Extended Star Schema (SCN)




  • Fact table consists of DIM ID and key figures.
  • Every Info cube has two types of tables
  1. Fact table
  2. Dimension tables
  • Info cube consists of one fact table (E and F), surrounded by multiple dimension tables.
  • Maximum number of dimension tables in an info cube is 16 and the minimum number is 4.
  • There are 3 system generated tables
  1. Data Package dimension table (Technical dimension)
  2. Time dimension
  3. Unit dimension
  • Maximum number of key figures in an info cube are 233
  • Maximum number of characteristics in an info cube are 248

Advantages of Extended Star Schema:
  • Faster loading of data/ faster access to reports
  • Sharing of master data
  • Easy loading of time dependent objects

Classical Star Schema:

  • In classical star schema, the characteristic record is directly stored in DIM tables.
  • For every Dimension table, a DIM ID is generated and it is stored in the fact table.

Differences between Classical Star Schema and Extended Star Schema:
  • In Classic star schema, dimension and master data table are same. But in Extend star schema, dimension and master data table are different. (Master data resides outside the Info cube and dimension table, inside Info cube).
  • In Classic star schema we can analyze only 16 angles (perspectives) whereas in extended star schema we can analyze in 16*248 angles. Plus the performance is faster to that extent.

1 comment:

Note

This blog is solely for the purpose of getting educated in SAP. This blog does not encourage distribution of SAP hold copyright and any other publication and/or materials bearing SAP mark. If you find any copyright materials, please mail me so I can remove them. This blog is not in association with SAP.

ALL Posts

Get this widget