Doing A Multi Grid Essbase Retrieval With Smart View Removes Formulas And Range (Doc ID 2205557.1)

Last updated on MARCH 08, 2017

Applies to:

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

Symptoms

Performaing a multi grid Essbase retrieval with Smart View with formulas and Range and they are removed. 

Changes

In the before worksheet I highlight cells A3 - G9. Please note that cells G4 and G5 have formulas.

Select this range and then I get the message "You have a range selected. Would you like to change this sheet to support multiple grids?".

Select yes. It then creates a range name but it only goes as far as column F and the formulas in G4 and G5 get wiped out.

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