Why we have only 16 Dimension tables in a cube.Is there any
reson.Is it a limitation?
Answers were Sorted based on User's Feedback
Answer / rakesh nagpure
Database Table can have maximum of 16 keyfields only.So we
can not create more than 16 dimensions. three is sap
provided and we create only 13 dimensions.
Is This Answer Correct ? | 32 Yes | 1 No |
because Cube is nathing but Fact Table and in sap for each
table we will have 16 Composite key or Primary Key so
Demension is nathing but primary key for Cube or fact Table
Is This Answer Correct ? | 11 Yes | 4 No |
Answer / ravi kiran
Thus is called Codd rule.The basic database concept genrally we are using is restricted to 16 key fields.with in this 16 unlimited combinations possible.Oracle supports Codd rule as well as SAP also...
Is This Answer Correct ? | 5 Yes | 0 No |
Answer / bharathr94
SAP BI InfoCube Can have maximum 16 Dimension, Why because
na Cube shape will have only 16 Dimensions and also Normal
data base table will have only 16 keyfields. When we create
InfoCube system is going to create tables like F-table and
E-table So,we should follow that database concepts Because
of that InfoCube will Have only 16 Dimensions..
Is This Answer Correct ? | 3 Yes | 2 No |
How many types of Routines in SAP BI(7.0)?
29 Answers IBM, TCS,
you run info package in process chain level you got error how to delete that one
What are the different types of transactions supported by di api ?
if someone interviewer ask me briefly explain your sales flow in your project ?-rajesh
What is dtw in sap business one?
how to write a customise code in reporting replacement path
my name is sandeep i want to join SAP Bi/BO hyd. can anyone suggest best institue or tranier with material also .sucess rate of them should be very good.. bcoz its very hard select insistiue in ameerpet...one and other all are same many people are misguided.. failling in interviews...if any one know please help answer this question so this will help others also
Name of the tool used for unit testing
What are the complex reports you developed in Business Objects.Please tell me 3 reports you developed and the complexity you faced and the solution
) Why is there a restriction of 16 Dim tables in an Info Cube and 16 key fields in an ODS.
Which tool is provided by sap for keeping the track of events ?
How we know, whether we have to use DSO or Infocube for particular data source?