info cube


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