SAP B1 Question:
Download Questions PDF

Why is there a restriction of 16 Dim tables in an Info Cube and 16 key fields in an ODS?

SAP B1 Interview Question
SAP B1 Interview Question

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.

Download SAP B1 Interview Questions And Answers PDF

Previous QuestionNext Question
Can we format BEx reports/graphs using HTML and CSSWhy we have only 16 Dimension tables in a cube. Is there any reason. Is it a limitation?