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

    HsGetValue - is it fast?

      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?
        • 1. Re: HsGetValue - is it fast?
          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?
            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?
              thanks all for the advice