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

HypSetOption is not working?

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

Summary

HypSetOption is not working?

Content

Hi All,

I am doing a testing on using VBA and API to set the option by using HypSetOption function, but it seems like this function is not reacting accordingly in Smart View.

I wanted to set the adjust column width to "False", which is to uncheck the "Adjust Column width" in the Options window.

Below are my codes. At first, I am setting the option by using HypSetOption to "False", the result returned as 0.

Next, I try to use HypGetOption to get the value for the setting, and it returns "False".

However, after I run my code, I checked the checkbox in the Options and found that it's still being checked at the "Adjust Column width" checkbox.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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