3 Replies Latest reply: Feb 5, 2013 3:53 PM by user3055639 RSS

    HsGetValue - is it fast?

    user3055639
      Hi there
      I am trying smartview for the first time and have noticed they have given us the option of using HSGetValue (reminds me of the old Hyperion Enterprise Retrieve)
      Is this a fast option? does it degrade server performance? A few years back there was an option for Essbase (Esscell) except that it was horribly slow and degraded server performance when a number of people used it. How does HS GetValue stack up against EssCell?
      Thanks
        • 1. Re: HsGetValue - is it fast?
          TimG
          Compared to EssCell, Matt Milella says it's much faster, e.g.: http://essbaselabs.blogspot.com/2010/05/cell-functions-smart-view-1112-vs.html

          Of course, Matt would say it's better than the 'legacy' Add-In :) but seriously, he should know. You might also considering asking this type of question in the dedicated Smart View forum, since Matt and other Oracle people with direct involvement in the product do post there.
          • 2. Re: HsGetValue - is it fast?
            GlennS_3
            There have been improvements in HSGetvalue in the latest versions of Smart View to speed up HSGetvalue formulas, however, since it is still cell by cell (or grouped where possible) is it still slower than a grid retrieval . I've had multiple issues with it at various clients. If you have a large number of cells you are retrieving from Essbase or planning, is can be much slower. HFM seems to be faster, but I've not compared the two methods on it.
            • 3. Re: HsGetValue - is it fast?
              user3055639
              thanks all for the advice