1 Reply Latest reply on Apr 5, 2012 1:43 PM by Jasmine Pauline-Oracle

    Smartview HsGetValue Errors

    MikeTO
      Hi All,

      We are using Smartview HSGetValue formulas to pull data from Essbase ASO Cubes. We are on 11.1.1.3. On a typical spreadsheet, this works fine, however, on larger spreadsheets with lots of formulas, our Essbase HSGetValue formulas occasionally result in errors like 'Cannot query members by specs. null' or 'Out of Memory'. If we keep refreshing or log out, eventually it works but it's not very reliable.

      We have found that Smartview with HFM HSGetValue works much better.

      Has anyone else experienced this and do they have a fix?

      Thx,
      Mike
        • 1. Re: Smartview HsGetValue Errors
          Jasmine Pauline-Oracle
          Add the below registry values to the client machines:

          [HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Internet Settings]
          "KeepAliveTimeout"=dword:00300000
          "ServerInfoTimeout"=dword:00300000

          [HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Internet Settings]
          "ReceiveTimeout"=dword:00dbba00

          Please have a look at: Common Problems with HSGETVALUE and Smart View (Doc ID 1185449.1) in MOS.

          HTH-
          Jasmine.