SAP - BI
What Is an Infocube in SAP BI/BW? How To Create One?
What is Infocube? Infocube is data storage area in which we maintain data which we are extracting from...
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 other words schema is a collection of database objects, including tables, views, indexes and synonyms. Schemas are generally stored in a data dictionary.
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 Info-Objects (Characteristics and Key figures) and is structured according to the star schema. This means that there is a large fact table with key figures for the InfoCube, as well as many dimension table surround it structure which appears like star.
The benefits of star schema are slicing down, easy understanding of data and performance increase.
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). 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
Following are the different components of an Extended Star Schema.
Below is an example of how a fact table of an Infocube looks like.
Below are the Dimension and SID tables.
Below shown are the Info object master data and text table.
The below is an example of Infocube showing the Extended Star Schema.
Steps explaining the Extended Star Schema of an Infocube:
What is Infocube? Infocube is data storage area in which we maintain data which we are extracting from...
Download PDF 1) What is SAP BW/BI? What is the purpose of SAP BW/BI? SAP BW/BI stands for Business...
Go to RSA1 -> Modeling ->Infoobjects Right click on the Infoarea -> Click on Create Infoobject...
What is an InfoObjects? Info-Objects take information from the source, then adjust and arrange the...
$20.20 $9.99 for today 4.6 (115 ratings) Key Highlights of SAP BI PDF 196+ pages eBook Designed for...
What is DSO? A DSO is a two dimensional storage unit which mainly stores consolidated and cleansed...