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

    block

    903558

      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
          KKT

          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.

           

           

           

          Thanks,

          ~KKT~

          • 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,

             

            Robert.

            • 3. Re: block
              903558
              accontdense500
              loaddense30
              dense10
              scnariosparce5
              yearsparce5
              periodsparce12
              customersparce20
              entittysparce47
              currecnysparce25
              entuity1sparce87
              customer2 regionsparce167
              customer anotehr typesparce200
              ares of businesssparce324
              productsparce500

               

              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.

                 

                 

                Regards,

                 

                Robert.

                • 5. Re: block
                  903558

                  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

                    Hi,

                     

                     

                    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.

                     

                     

                    regards,

                     

                    Robert.