) Why is there a restriction of 16 Dim tables in an Info
Cube and 16 key fields in an ODS.
Answers were Sorted based on User's Feedback
Answer / sudhir
The oracle Data base allows up to 16 primary keys.That is the reason SAP Allow 16 Dimensions in Cube&16 Key fields in DSO.
Is This Answer Correct ? | 15 Yes | 0 No |
Answer / samar
good question dear according to cord rule there is max no of
dimensions are 16 only more then not possible .ods is a flat
table.db architectured by mr card.
Is This Answer Correct ? | 7 Yes | 1 No |
Answer / hemant patidar
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.
Is This Answer Correct ? | 5 Yes | 0 No |
What is difference between ap or a/p and ar or a/r?
what is the difference between DBCONNECT AND UDCONNECT IN SAP BI SYSTEM
How does cell editor works in BEx.
what is report to report interface and why we use it sap bi
Can we format BEx reports/graphs using HTML and CSS
can we have separate cubes for Delivery & Billing Data Sources.
What are the limitations of di server?
Hi Experts, What are the common Transport errors in SAP BW?
Why we have only 16 Dimension tables in a cube.Is there any reson.Is it a limitation?
4 Answers Enteg Technologies, IBM, Infosys, TCS, Wipro,
what is concept behind incoming payment and outgoing payment?
How many types of Routines in SAP BI(7.0)?
29 Answers IBM, TCS,
1. We have standard info objects given in sap why you created zinfo objects can u tell me the business scenario