4 Replies Latest reply: Jun 11, 2014 8:26 PM by JohnTaylor RSS

    Essbase Error : 1270516

    JohnTaylor

      I came across this issue when deploying an ASO outline using Essbase Studio recently I couldn't find any documentation or help so I am posting my resolution in case anyone else comes across this.

       

      Failed to deploy Essbase cube.

      Caused by: Cannot end incremental build. Essbase Error(1270516): Maximum view count [4.5036e+015] exceeded

       

      The issue is that the Essbase Cube views exceeded the limit of 4503600000000000.  At first, I thought this message was related to the number of cells in the cube. But cell limits were not the issue.  It was views.  Views are determined by the number of levels in each dimension (multiply all levels for all dimension to get the cube total views).  Last month my cube had a total of 1.2413e+015, which is close to the limit, but still under.  I had one dimension switch from being dynamic with just 1 level (all dynamic dims have only 1 level) to being a multiple hierarchy stored dim with 7 levels.  This increased the view size to 8.6890e+015 and exceed the view limit.  I had to reset the dimesion settings back to dynamic in order to get the outline to deploy properly.  Hopefully this help someone understand the issue if they receive this error message.

       

      Here is the dimension levels that I was dealing with:

       

      Dim Old Levels New Levels
      Account                                           
        1
                                                 
        1
      BUDeptCode                                           
        4
                                                 
        4
      Calendar                                           
        5
                                                 
        5
      Currencies                                           
        3
                                                 
        3
      CustomerMajor                                           
        1
                                                 
        1
      CustomerMinor                                           
        3
                                                 
        3
      CustomerSRRChannel                                           
        2
                                                 
        2
      CustomerTerritory                                           
        3
                                                 
        3
      CustomerType                                           
        4
                                                 
        4
      CustomPub                                           
        3
                                                 
        3
      DeptFunction                                           
        4
                                                 
        4
      Entity                                           33
       
                                                 33
       
      FiscalYear                                           
        4
                                                 
        4
      Imprint                                           
        3
                                                 
        3
      ItemCode                                           
        3
                                                 
        3
      LedgerType                                           
        1
                                                 
        7
      MediaType                                           
        4
                                                 
        4
      MgtGroup                                           
        3
                                                 
        3
      Period                                           
        4
                                                 
        4
      PLMT                                           
        3
                                                 
        3
      ProductFamily                                           
        4
                                                 
        4
      ProductGroup                                           
        9
                                                 
        9
      RelativeTime                                           
        1
                                                 
        1
      Scenario                                           
        3
                                                 
        3
      SubjectMajor                                           
        3
                                                 
        3
      SubjectMinor                                           
        3
                                                 
        3
      SubLedger                                           
        4
                                                 
        4
      TechProd                                           
        4
                                                 
        4
      TitleCode                                           
        3
                                                 
        3
      TitleOwner                                           
        3
                                                 
        3
      Views (Product of Levels)  
        1,241,288,359,280,640
        
        8,689,018,514,964,480
      View Limit  
        4,503,600,000,000,000
        
        4,503,600,000,000,000
      Threshold OK EXCEEDED
        • 1. Re: Essbase Error : 1270516
          GlennS_3

          Interesting information. What I find even more interesting is a cube with 30 dimensions. Are these all real dimensions or are some attributes?

          • 2. Re: Essbase Error : 1270516
            JohnTaylor

            Glenn

             

            Thanks for the reply.  I am a big fan. I have your book on Essbase Studio and found it to be very valuable when learning to use the tool.

             

            This cube does actually have 30 standard dimensions.  It is a bad design that we inherited from a Third Party developer a few years back.  It is very slow to update and query.  It will be redevloped soon to provide a better solution.  The cube really only needs about 12 standard dimensions and all the rest could be attributes, or combined into shared hierachies, etc.

             

            The error message was odd because it is not listed in the standard Essbase Error Message Reference doc and I couldn't find anything about the maximum views limit on any forums or other documentation.

            • 3. Re: Essbase Error : 1270516
              TimG

              Not to take anything away from the value of your real-world example, John, but this is actually documented in the DBAG: Limits

               

              I've hit it myself.  Because it's the product of levels, you don't even have to have an incredible number of dimensions to do it - one eight-level dimension, for example, is just as 'bad' as three two-level dimensions.

               

              The Error Message Reference does seem to be the last to get updated (if at all)!

              • 4. Re: Essbase Error : 1270516
                JohnTaylor

                Great link.  That is what I needed to find the other day and I didn't look in the right place.