2 Replies Latest reply: Jun 27, 2014 4:25 PM by RahulSharma RSS

    restructure

    903558

      hi

      can any one tell me my cube is  correct way  do i need to change ?

      first 4 dimension are dence rest are sparce

       

      Declared Dimension Sizes = [21 480 26 3 8 11 27 34 60 97 176 184 305 346 1 6 ].

       

      Actual Dimension Sizes = [21 478 25 2 7 10 20 25 47 87 167 183 304 331 0 5 ].

       

      The number of Dynamic Calc Non-Store Members = [8 88 3 0 0 0 7 0 12 8 1 1 1 1 ].

       

      The number of Dynamic Calc Store Members = [0 0 0 0 0 0 0 0  0 0 0 0 0 0 ].

       

      The logical block size is [501900].

       

      Maximum Declared Blocks is [1606773894115737600] with data block size of [786240].

       

      Maximum Actual Possible Blocks is [828976954881600000] with  data block size of [223080].

       

      Essbase needs to retrieve [279532500] Essbase Kernel blocks  in order to calculate the top dynamically-calculated block..

       

      OK/INFO - 1012736 - The Dyn.Calc.Cache for database [Drxxxxxx] can hold a maxim um of [5] blocks..

        • 1. Re: restructure
          JB1

          Hi

           

          You are going struggle to get an answer to 'is my cube correct' ... as there isn't really a 'correct' way for a cube to be designed or structured.  And without a lot more detail its pretty much impossible to comment.

           

          I guess knowing what the business wants in terms of functionality and performance then seeing if your cube matches these criteria, is the only way you can really determine if your cube is 'correct', or at least fit for purpose.

           

          If I were to comment based on what you have stated, 16 dimensions seems like a lot, and your block size may be on the large side (if running 32 bit Essbase)...but again, both of these are pretty subjective opinions.

           

          JB

          • 2. Re: restructure
            RahulSharma

            I do agree with JB1 that for anyone to comment the information you have provided is less. Clarify the actual problem you are facing you might get an answer.

            1. Why do you have first 4 as dense? You can easily do with first 2 as dense and have a decent blocksize which would not give you issues.
            2. Is this the only application on your server?