⟩ Why is there a restriction of 16 Dim tables in an Info Cube and 16 key fields in an ODS?
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.