) 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
14868 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 frnds dc's suma could u tell me. 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 ? what is cell formatting? and advantages?

0 Answers HCL,

what is concept behind incoming payment and outgoing payment?

2 Answers Wipro,

What are the functions of data interface api (di 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,

what is cell formatting? and advantages?

0 Answers

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

2 Answers

If we are Extracting Data From SD Application component.ie Ex:- sales and billing 2lis_11_vahdr & 2lis_13_vdhdr Data Sources.Can I load From These 2 Data Sources to sales overview Cube 0sd_c03.Can you Explain the procedure.

0 Answers

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,

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

4 Answers

How does cell editor works in BEx.

1 Answers TCS,

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

1 Answers Atos Origin, L&T,

What are the limitations of di server?

0 Answers

For more SAP Business One Interview Questions Click Here