Info cube:-
- It maintains Extended star schema concept
- Consists of Transaction data
- In infocube when we load data twice the another copic of data will be stored
- It also maintain Summary And Multi Dimensional data
- fact tables maintains prime key of Dimensions and measures
- link between to fact to dimensional tables with Dim id's
- link between dimensional table and master data table is with Sid's
Sid's and Did's are created automatically by system when data is loaded
the maximum no.of Dimension in a cube is = 16
3 pre-define by SAP
minimum no.of Dimension in a cube is =4
3+1 ( one user define )
255 fields arte contain in table
16 are Did's and 6 are SAP Admin other are 233 key figures