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
calculate sparsity in the cube
-
lotsaram
- MVP
- Posts: 3652
- Joined: Fri Mar 13, 2009 11:14 am
- OLAP Product: TableManager1
- Version: PA 2.0.x
- Excel Version: Office 365
- Location: Switzerland
Re: calculate sparsity in the cube
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.
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.
Please place all requests for help in a public thread. I will not answer PMs requesting assistance.
-
Moh
- Posts: 43
- Joined: Fri Aug 01, 2014 5:17 pm
- OLAP Product: Cognos
- Version: 10.1.1
- Excel Version: 2010
Re: calculate sparsity in the cube
thank you.I was confused about the calculation mentioned in the IBM document
-
ByronB
- Posts: 17
- Joined: Tue Mar 01, 2016 5:55 am
- OLAP Product: TM1 + BI
- Version: TM1 10.2
- Excel Version: Excel 2010
Re: calculate sparsity in the cube
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,
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,