We are using Smartview HSGetValue formulas to pull data from Essbase ASO Cubes. We are on 220.127.116.11. 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?