This discussion is archived
3 Replies Latest reply: May 10, 2012 11:00 AM by JohnGoodwin RSS

web form taking too long to generate

936200 Newbie
Currently Being Moderated
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 Journeyer
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Oracle ACE
    Currently Being Moderated
    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/

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points