) 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
14892 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

Explain core modules of sap business one?

0 Answers

How to fill data in recordset ?

0 Answers

What is the function of observerdll.dll ?

0 Answers

What are the different components of sap business one client software ?

0 Answers

Hi,Could you plz explain me Diff between transfer rule&update rules

2 Answers

your process chain link with ABAP Program,suppose your ABAP Code need some changes how you do this(your process chain is in running stage)

1 Answers Accenture,

why u r creating custom cube. wht is scenario to creating the custom cube.

4 Answers

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 are the table created when you created a infoobject

4 Answers Accenture, IBM,

what is report to report interface and why we use it sap bi

1 Answers Atos Origin, L&T,

How do wé delete '0' values in the crm planning infocube 0crm_c01

1 Answers ITC Infotech,

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,

For more SAP Business One Interview Questions Click Here