on 07-03-2012 7:40 PM
HI
U can get the same by using the tcode DB02 plz follow the below link
Regards,
RaviChandra
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
HI,
Generallly the Dimension to fact Table ratio should not ne more than 20% for better performance say like Data loading & Data Retrivel.
This infromation helps you to modify the Dimensions and see whether ratio is good or bad.
Accordingly you can set the properties of Dimension to either HIgh Cardinality & Line Item Dimensions.
This Improves the Performance of the cube.
For Doing this sort of performane tuning it is suggested to have good amount of records and see the ratio and then you will be able to judge what improements you can do.
Like if you are using less dimensions and one of the Diemension fact ratio is high , you may create another Dimension and move your objects to that new dimension. Even after doing so the ratio is high like 60 - 70 % you may mark the dimension as high Cardinal.
I have worked on some performance related actity on the cube and noticed the changes in our project. You may get back to me if you need more information.
Regards,
Ganesh Thota
Hi Kiran,
As Anand said, the ratio (% in the last column) indicates the number of rows in that table divided by number of rows in the fact table.
In your cube, the number of rows in fact table are 13. Hence the denominator remains 13 for all the calculations. This is the reason, for the fact table (last row) resulted 100%
Rows in that table = 13
Rows in fact table = 13
Dimension ratio = (Rows in that table / Rows in fact table)* 100 = (13/13)* 100 = 100%
As per SAP standard, the ratio of fact table rows to dimension table rows should not be more than 10%. Whenever this ratio crosses, the row will be highlighted in red color, thereby we should go redesigning that dimension. The highlighting of rows will be activated only if the cube has 30,000 rows
Please look into note 1461926 for better understanding on this report
Regards
Chandu
Hi Kiran,
As per dimension ratio, yes. But as the number of records are very less, it is not required to redesign. As I said, the ratios greater than 10% will be highlighted in RED and we have to redesign them. But this will happen only if cube has 30000 rows. Hence in your case, this can be ignored and is not required to redesign that dimension
Regards
Chandu
User | Count |
---|---|
84 | |
24 | |
11 | |
9 | |
7 | |
6 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.