6 Replies Latest reply: Jun 25, 2014 8:02 AM by Robert Angel RSS



      i have dimension 3 dense and 12 sparse block size is 80kb but my block density is 0% any suggestions i can higher my density?

        • 1. Re: block

          The 'density' of a block is the ratio of cells that actually have data, to the number of cells in the block. If you have a block with 100 stored cells, and 10 of them have data, your block density is 10%.



          so i hope you have data loaded in essbase and then see the block density.






          • 2. Re: block
            Robert Angel

            Dense dimensions typically have a high degree of data population, so dimensions such as; - period, year, scenario, version are ideal candidates for being dense dimensions.


            Sparse dimensions are typically dimensions where there are a larger number of members, where a large number of combinations of sparse data may not have values populated.


            So sparse dimensions act as indexes to take the end user to specific blocks of data, blocks of data being populated densley (most permutations have values).


            Precise tuning of the balance is a case of looking at what are obvious candidates for being dense and sparse, and then thinking of the practical considerations of block size and thinking how this will change over time and finding best fit.



            Hope this helps,



            • 3. Re: block
              customer2 regionsparce167
              customer anotehr typesparce200
              ares of businesssparce324


              here is my outline i tried with hour glass model but yet its very bad in performance any suggestion

              • 4. Re: block
                Robert Angel

                My suggestion would be consider making your non-dynamic with a smaller number of members sparse dimensions dense; - so consider currency, scenario, period (there may be others - I don't know your business!); and do the maths on block size and total density, taking into account how this may change over the likely useful life of your application.






                • 5. Re: block

                  so let me you ask 1 , if i have dimension where all the member are loaded and calc with data so shall i consider it has dence ? because i always confuse my self with dense and sparse configuration like entity ?

                  • 6. Re: block
                    Robert Angel




                    imagine you have a country dimension and a business unit dimension.


                    As all business units are NOT in all countries then this already argues for sparsity.


                    With accounts (expense types) these are typically used with a high degree of regularity across your entire organisation (dense).


                    Entities will only be used in limited subsets of the entire cube (typically it will be in one geographic location), so the argument typically here is for sparse.


                    But, these are generalist comments, you need to know how the segments are used in your business circumstances.