My Oracle Support Banner

Smartview v11. Refresh Overwriting Excel Formulas Used for Member Names (Doc ID 2402643.1)

Last updated on MAY 24, 2018

Applies to:

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


If a Smart View template uses Excel formulas to define member names, when the sheet is refreshed, these member names are overwritten.   For example, in the sheet, cell B2 contains the member name.  Cells C2-F2 contain an Excel formula that pulls the member name from cell B2 (=B2).  When the refresh is run, the member names with the Excel formula are over-written.  




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.