2 Replies Latest reply: Jun 2, 2014 9:49 PM by Pisces-Oracle RSS

    Limiting number of rows in a Smartview query uning the PLANNING connection

    user548038


      Hello

      We have an Hyperion Employee solution containing 2 large dimensions (job and cost code) of over 4,000 members

      When creating a report in Smartview one has the option of an Essbase or Planning connection in version 11.1.2.3

       

      When creating a report at a high level and then zooming into lowest level using both large dimensions

       

      - the essbase connection protects itself with an error message - 'number of max rows exceeded'

      - the planning connection keeps going, maxes out the memory and crashes the system

       

      Any suggestions in how to prevent users from crashing the system using the Planning connection?

      Can one limit the number of rows the same as the Essbase connection?

       

      Please let me know

      Thanx

      Berndt

        • 1. Re: Limiting number of rows in a Smartview query uning the PLANNING connection
          KKT

          Hi,

           

          Below reply to your queries.

           

          Any suggestions in how to prevent users from crashing the system using the Planning connection?

          add these changes in Windows registry so that it will have netretry count increased that will stop from crashing.

          [HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Internet Settings]

          "ReceiveTimeout"=dword:00dbba00

          "KeepAliveTimeout"=dword:00180000

          "ServerInfoTimeout"=dword:00180000

           

           

          Can one limit the number of rows the same as the Essbase connection?

          By default its 50000 in essbase but again as planning data resides on essbase you cannot but yes you can change the default value from 50K to less as well in essbase cfg file.

          SSPROCROWLIMIT 50000

           

          Thanks,

          ~KKT~

          • 2. Re: Limiting number of rows in a Smartview query uning the PLANNING connection
            Pisces-Oracle

            update configuration file /scratch/essbase/biee/Oracle_BI1/products/Essbase/aps/bin/essbase.properties,

            increase the service.olap.dataQuery.grid.maxRows from 5,000 to any number you want

            increase service.olap.dataQuery.grid.maxColumns from 255 to XXX