We are using Smartview HSGetValue formulas to pull data from Essbase ASO Cubes. We are on 126.96.36.199. 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?
Add the below registry values to the client machines:
Please have a look at: Common Problems with HSGETVALUE and Smart View (Doc ID 1185449.1) in MOS.