Ordering of Dimensions
Posted: Sat May 19, 2018 7:52 am
Hi,
I am trying to derive the logical ordering of dimensions for a sample cube. For this I have calculated the N level count of each dimension using the SUBSIZ in excel and also the populated cells for dimension by creating a view and checking the no of rows populated with the zero suppression ON. Then calculated the density. Can anybody please tell if this approach is correct? For a complex models in Real time also and to deal with the Performance, do we need to do the same approach?
For E.g.
Division = 20/60 = 33.33% (No of populated cells/ No of N level cells)
channels = 20/80 = 25
Product = 40/210 = 19%
Version = 20/20 = 100
Month = 50/120 = 41%
So Ordering of the dimension taken is as
1.Product
2.Channels
3.Divisions
4.Month
5.Version
6.Measure
Thanks in advance...
I am trying to derive the logical ordering of dimensions for a sample cube. For this I have calculated the N level count of each dimension using the SUBSIZ in excel and also the populated cells for dimension by creating a view and checking the no of rows populated with the zero suppression ON. Then calculated the density. Can anybody please tell if this approach is correct? For a complex models in Real time also and to deal with the Performance, do we need to do the same approach?
For E.g.
Division = 20/60 = 33.33% (No of populated cells/ No of N level cells)
channels = 20/80 = 25
Product = 40/210 = 19%
Version = 20/20 = 100
Month = 50/120 = 41%
So Ordering of the dimension taken is as
1.Product
2.Channels
3.Divisions
4.Month
5.Version
6.Measure
Thanks in advance...