) Why is there a restriction of 16 Dim tables in an Info
Cube and 16 key fields in an ODS.
- 3 Answers
- 13753 Views
- TCS, I also Faced
- E-Mail Answers
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
What is dbdatasource ?
Hi Friends, 1) What precautions i should take as a BI Consultant when it is to UPGRADE the version of ECC (Eg: from R/3 to ECC 6.0)? 2) Will this upgradation affect BI system anyway?
Where does di server executes i.e. Client or server ?
What is di server in sap business one ?
What is dtw in sap business one?
What are the different components of sap business one client software ?
What are the benefits of sap business one?
How is sap business one implemented ?
How types of reports we can create in BOBJ
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.
What are the functions of data interface api (di api)?
What is the value returned when any method of an di api object executes successfully ?
For performing heavy duty operations what is suitable di api or di server ?
Explain different parts of di api?
What are the different types of transactions supported by di api ?
