Finding out errors in HsGetValue formulae
Content
Hello All,
Our client has recently moved from on-prem to PBCS. On-prem they used to use the Essbase connection to create ad-hoc grids and in some cases used HsGet functions to retrieve / post data.
The Essbase connection shows invalid HsGetValue retrieves as a message in the cell, whereas PBCS throws a popup error for the first invalid formula it encounters. In case of PBCS the user has to go through every error one by one which is a very time consuming task.
Is there a way to find out all invalid formulae on a sheet using a PBCS connection (just like Essbase)?