You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Finding out errors in HsGetValue formulae

edited Sep 11, 2021 9:57PM in Planning 2 comments

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)?

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!