Outline optimization Urgent
hi,
Yesterday i was told about modified Hour glass method as follows:
- Time (if it's dense)
- Accounts (if it's dense)
- Densest dense dimension to Least densest dense dimension
- Sparse dimension with the smallest ratio of ancestors to level 0 members
- Sparse dimension with the largest ratio of ancestors to level 0 members
- Largest sparse dimension (if you're using the calculator cache)
- Non-aggregating sparse dimensions
I didnt get much success in optmization though or may be was not able to arrange the dimension properly as had few confusion about it. The specifications of dimension i have in outline is as follows:
Dimension No OF Ancestors No of stored member Ratio: No Of Ancestores to level0 members Type of dimension
BU 2 19 0.11 Sparse
MT 9 36 0.25 Sparse
IC 20 47 0.43 Sparse
Branch 37 122 0.30 Sparse
Project 10 181 0.06 Sparse
Product 52 145 0.36 Sparse
Entity 32 517 0.06 Sparse
Year 3 Sparse
Scenario 7 Sparse
Version 3 Sparse
Account 424 Dense
Period 13 Dense
It would be great if anybody can let me know what would be the best way to order these dimensions in outline according to modified hour glass technique .
Thanks In advance :)