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

Problems with HsGetText function in Smart View

Received Response
edited Aug 2, 2018 2:36AM in Essbase 2 comments


Problems with HsGetText function in Smart View


We have upgraded to HFM (from  and Smart View (from

Since upgrading the HsGetText function in Smart View creates strange problems. In some lines it is woking, in some lines not. Sometimes Smart View also uses information from the sheet which is not even linked in the formula.

The error is "#Invalid member 'xxxx' for dimension 'xxxx'.

It looks like the error comes up if cells do not have a cell text. But that issues does not happen always.

In HFM it worked without problems. We have tested it with the old Smart View version - it works as long as we connect to HFM environment. As soon as is connected, we get the error.

Howdy, Stranger!

Log In

To view full details, sign in.


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