3 Replies Latest reply: May 10, 2012 1:00 PM by JohnGoodwin RSS

    web form taking too long to generate

    936200
      Hello I have a Data Form issue,

      My webform contains more than a 1000 CCenters in the page view.
      When selecting any of the CCenters the Data Form generates perfectly, all accept one of them!!
      Once a user selects that Center, it takes about 2.5 hours to generate.

      Where can i start trouble shooting this issue? What do you think can cause this?
        • 1. Re: web form taking too long to generate
          Rowdy
          Did you have supress missing block/data check-up on your form options?
          Can you try to pull the same data with excel add-in for this CC?
          What is the RAM on planning & webserver server hosts and OS information?
          What was the Essbase data cache setting ?
          Was there any security defined ont this user?
          Was there any other large sparse dimension in row/column ?
          • 2. Re: web form taking too long to generate
            936200
            Did you have supress missing block/data check-up on your form options? ------------->Yes
            Can you try to pull the same data with excel add-in for this CC? -------------> Yes
            What is the RAM on planning & webserver server hosts and OS information? ---------->dont have access to that info
            What was the Essbase data cache setting ? ------------> 30024KB
            Was there any security defined ont this user? --------------> I assign security..have all access..
            Was there any other large sparse dimension in row/column ----------> Yes...

            ....The webform is massive!! The number of employees and projects for this particular cost center exceed more than anyother. Is there anyway to fix tihs issue or its just that there is too much data???
            • 3. Re: web form taking too long to generate
              JohnGoodwin
              It is worth having a read of the following doc in Oracle Support - Hyperion Planning Data Form Design Considerations (Doc ID 779502.1)

              Cheers

              John
              http://john-goodwin.blogspot.com/