This Essbase discussion board is provided as a free service and dedicated to all the Essbase professionals out there!
 Return to Index  

Just some thoughts...

July 24 2012 at 4:42 PM
No score for this post
Kelly 
from IP address 198.147.192.8


Response to Report Server Performance: What is max memory allowed on HFR server?

Although I don't have experience with v11/x64, I have always used 1280 min/max for all of our Hyperion (9.3.3) JVM heaps.

You may also want to consider the Essbase angle, take a look at two functions in MDX called NONEMPTYMEMBER and NONEMPTYTUPLE (just Google for more info, they are also in the Essbase documentation). In a complex ASO cube retrieval, sometimes using these can significantly cut the retrieval time. These act as a filter for certain dimensions, if they are empty, it won't execute the calculation and move to the next.

 
Scoring disabled. You must be logged in to score posts.Respond to this message   
Responses

  1. Re: Just some thoughts... - AlexS on Jul 24, 4:53 PM
    1. Any Advice - Rush on Nov 1, 5:30 AM
     

RSS feed for this forum - http://www.network54.com/Forum/58296?xml=rss. Please email hypess (at) gmail.com, if you have any questions/feedback/issues.