Why we have only 16 Dimension tables in a cube.Is there any
reson.Is it a limitation?
Answers were Sorted based on User's Feedback
Answer / rakesh nagpure
Database Table can have maximum of 16 keyfields only.So we
can not create more than 16 dimensions. three is sap
provided and we create only 13 dimensions.
Is This Answer Correct ? | 32 Yes | 1 No |
because Cube is nathing but Fact Table and in sap for each
table we will have 16 Composite key or Primary Key so
Demension is nathing but primary key for Cube or fact Table
Is This Answer Correct ? | 11 Yes | 4 No |
Answer / ravi kiran
Thus is called Codd rule.The basic database concept genrally we are using is restricted to 16 key fields.with in this 16 unlimited combinations possible.Oracle supports Codd rule as well as SAP also...
Is This Answer Correct ? | 5 Yes | 0 No |
Answer / bharathr94
SAP BI InfoCube Can have maximum 16 Dimension, Why because
na Cube shape will have only 16 Dimensions and also Normal
data base table will have only 16 keyfields. When we create
InfoCube system is going to create tables like F-table and
E-table So,we should follow that database concepts Because
of that InfoCube will Have only 16 Dimensions..
Is This Answer Correct ? | 3 Yes | 2 No |
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 three dimensions provided by SAP?
What are the benefits of sap business one?
Where does di server executes i.e. Client or server ?
why u r creating custom cube. wht is scenario to creating the custom cube.
process chain failure notifications
how to migrate the cube data from bw to bi? explain and give me the steps
Can anybody explain the what is "OLTP"(Online Transaction Processing) and "OLAP"(Online Abaytical Processing) in SAP BW/BI? and also plz explain What is the differences between those two? Thanks in advance, Phani
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?
Hi, I am currently working in midsized company in SAP Business One after getting two years experience can i move to MNC company with SAP B1 or can i change technology to SAP ABAP na Please suggest me......
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?
Is it possible to alter the standard behaviour of sap business one using sdk ?