SAP - BI
SAP BEx: Characteristics & Key Figure Settings (RKF, CKF & Formulas)
In this tutorial you will learn about Characteristics Settings – Display Name Characteristics...
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:
In this tutorial you will learn about Characteristics Settings – Display Name Characteristics...
What is Write Optimized DSO? Write Optimized DSO is used when a Data storage object is required for...
Before we learn more about SAP BI Architecture, lets learn about Conceptual Layers of Data...
Step 1) Go to transaction code RSA1 to go to the Data Warehouse Workbench. Click the OK button....
What is Infocube? Infocube is data storage area in which we maintain data which we are extracting from...
What is DSO? A DSO is a two dimensional storage unit which mainly stores consolidated and cleansed...