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

How is sap business one implemented ?

0 Answers

how to write a customise code in reporting replacement path

1 Answers HCL,

i am raj i have attended lot of interviews but i could not get job. the interviwer asking me some real time scanrions please tell me any one . 1. expalin u have created any customize cube? 2. what is ur exp in bex and wad? 3. howmany reports u have created? give one scenario abour calculated key figure and formula? 4. tell me some recently what u have done tickets give me 2 tickets explain briefly? 5.what they (off shore team) have done ?

1 Answers Deloitte,

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,

What is difference between ap or a/p and ar or a/r?

0 Answers

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

3 Answers TCS,

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,

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

0 Answers

can any one explain end routine...like when it is used...and give an examole.......similarly for end routine..

0 Answers Wipro,

AFTER A PURCHASE ORDER HAS BEEN APPROVED, AND PRINTED, AND THERE IS NEED TO MAKE CHANGES ON THE P O, DO I CANCEL THE OLD P O OR DO I JUST EDIT AND SEND FOR APPROVAL?

4 Answers

What are the functions of data interface api (di api)?

0 Answers

Where does di server executes i.e. Client or server ?

0 Answers

For more SAP Business One Interview Questions Click Here