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 MAY 08, 2018

Applies to:

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

Symptoms

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.

Cause

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

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


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