My Oracle Support Banner

Smart View VBA HypGetSheetOption and HypSetSheetOption Are Not Working For Member Name Display Options (Doc ID 2145834.1)

Last updated on FEBRUARY 11, 2019

Applies to:

Hyperion Essbase - Version and later
Information in this document applies to any platform.


Using VBA Excel modules that pull data from Essbase via Smart View. Various sheet and global options are being set by the code, HypGetSheetOption and HypSetSheetOption, but they are not consistently being applied at run time. Other users try to run these models on other computers and get incorrect results because it is defaulting to the user's option settings rather than the ones specified in the code.


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.