SAP B1 Question:
Download Job Interview Questions and Answers PDF
Why is there a restriction of 16 Dim tables in an Info Cube and 16 key fields in an ODS?
Answer:
In all of the database systems there is maximum number of
fields allowed to create a primary key (composite key) is 16.
An in the case of cube, to fetch a single record a
combination of all dimension is used, so this is the reason
behind having maximum no. of dimension in cube is 16 only.
fields allowed to create a primary key (composite key) is 16.
An in the case of cube, to fetch a single record a
combination of all dimension is used, so this is the reason
behind having maximum no. of dimension in cube is 16 only.
Download SAP B1 Interview Questions And Answers
PDF
| Previous Question | Next Question |
| Can we format BEx reports/graphs using HTML and CSS | Why we have only 16 Dimension tables in a cube. Is there any reason. Is it a limitation? |