) Why is there a restriction of 16 Dim tables in an Info Cube and 16 key field

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

Question Posted / srinivas_buddy

3 Answers
15161 Views
TCS, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

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

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

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

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

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

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

Post New Answer

More SAP Business One Interview Questions

Hi. My name is Maya. I am new in SAP B1. I have a task to reset SAP B1 system and upload Opening Balance (OPBAL) in my company. Could anyone teach/show me 'how to' how do it, please? Ty

2 Answers TIS,

Difference between UNION and UNIONALL

1 Answers Axtria, ITC Indian Tobacco Company, TCS,

What is used in sdk for developing a form ?

0 Answers

can we have separate cubes for Delivery & Billing Data Sources.

2 Answers

Hi, I am currently working in midsized company in SAP Business One after getting two years experience can i move to MNC company with SAP B1 or can i change technology to SAP ABAP na Please suggest me......

1 Answers

1. We have standard info objects given in sap why you created zinfo objects can u tell me the business scenario

2 Answers TCS,

Can we load the datatable directly using sql query ?

0 Answers

What is the value returned when any method of an di api object executes successfully ?

0 Answers

Can we format BEx reports/graphs using HTML and CSS

1 Answers

you run info package in process chain level you got error how to delete that one

1 Answers IBM,

What are the different parts of di api ?

0 Answers

What is the function of ui api i.e. User interface api ?

0 Answers

For more SAP Business One Interview Questions Click Here