Smart View VBA HypGetSheetOption and HypSetSheetOption Are Not Working For Member Name Display Options
Last updated on JUNE 06, 2016
Applies to:Hyperion Essbase - Version 188.8.131.52.000 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.
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