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

Last updated on JUNE 06, 2016

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

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 hundreds of Community platforms