Page 1 of 1
calculate sparsity in the cube
Posted: Fri Mar 04, 2016 12:18 pm
by Moh
Good morning Gentleman,I am looking for solution to calculate sparsity and density of the cube.I have gone through IBM link and unable to understand it.Do you know any other simple solutions.
http://ibm.co/1TQyy3W
Re: calculate sparsity in the cube
Posted: Fri Mar 04, 2016 12:29 pm
by lotsaram
Density = Number of populated leaf cells / Number of possible leaf cells
Sparsity = 1 - Density
What is not to understand?
Obviously there's much more to optimal ordering of dimensions than that. But in essence calculating density for a particular dimension or for the cube as a whole is just the simple calculation above.
Re: calculate sparsity in the cube
Posted: Fri Mar 04, 2016 1:20 pm
by Moh
thank you.I was confused about the calculation mentioned in the IBM document
Re: calculate sparsity in the cube
Posted: Tue Mar 08, 2016 5:06 am
by ByronB
Hi Moh
I would recommend you to have a look at this post :
http://cubewise.com/blog/optimising-dim ... order-cube
It details how to calculate the density of a dimension in a cube
Cheers,