.png)
In cube we have fact table and dimension table...
In star schema,
master table will be dimension table
transaction table will be fact table.
* fact table can hold only 16 characteristics.. out of which 3 is reserved for datapackage, time and unit..
In short, we can have only 13 dimensions possible in star schema..
* As master data is used inside the cube .. no reuse of master data..
* Material is stored as "M01" customer as " C01"...
so fact table must hold alpha numeric values.... which will degrade the performance of cube...
In extented star schema..
we have a intermediate table between master data table and dimension table..which is known as surrogate id table.
* We can have 248 x 13 dimensions... thus overcoming the limitation of dimensions in star schema...
* Master data is placed outside the cube.. so it can be reused...
* We don't have any alpha numeric characters inside the cube.. which will improve the performance of the cube.
The effort you have taken to explain concepts is awesome! Please keep up the good work which indeed makes SAP easy and interesting!
ReplyDeleteBeautifully explained....Keep up the good work...Thanks a lot
ReplyDeleteGreat work and the best online site i ever seen
ReplyDeleteExcellent work Aslam. Could you please post blog on common production issues like different types of load data & DTP failures. Also a blog on XCELSIUS Dashboard would be of great help.
ReplyDeletegreat commendable work by you ,as you are sharing knowledge..one thing i like to add is that many images in your blogs are now broken ,can you pls fix them?
ReplyDeleteWhy Cube has only 16 dimensions not more than that?
ReplyDeleteGreat Work
ReplyDeleteThank you Sir