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 220.127.116.11.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.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!