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

I have 2 Data Sources sales and Billing.I have 2 Cubes called 1.sales cube and 2.Billing Cube with its own Data,Now i want to add Sales Data to Billing Cube.How Can it Possible,Can you any one Explain?

2 Answers Bosch,

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

1 Answers Atos Origin, L&T,

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,

How to fill data in recordset ?

0 Answers

What is dtw in sap business one?

0 Answers

Is it possible to alter the standard behaviour of sap business one using sdk ?

0 Answers

What is di api in sap business one?

0 Answers

How does cell editor works in BEx.

1 Answers TCS,

what are the table created when you created a infoobject