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

Answer Posted / 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       View All Answers


Please Help Members By Posting Answers For Below Questions

can any working guy help me...by explaining me about any twop reports which u have created.....on sales and purchase

1941


What is di api in sap business one?

772


Which are the dll’s used in sap business one sdk?

809


What is reconcile Adjustment Account in SAP Business One

2773


Which property of matrix gives the total number of rows in the matrix ?

783


What is company object in sap business one ?

754


What is the value returned by a method when it executes successfully?

800


Can sap business one be customized?

799


What is the function of observerdll.dll ?

981


What are the features of sap business one include?

742


What is difference between transfer rules and update rules?

1752


what is cell formatting? and advantages?

4423


What are the limitations of di server?

831


For performing heavy duty operations what is suitable di api or di server ?

809


What are the different types of datasources ?

782