In Smart view's Ad-Hoc Analysis Members with Numeric Characters needs to Change Format to Text (Doc ID 2072422.1)

Last updated on NOVEMBER 11, 2015

Applies to:

Hyperion Financial Management - Version 11.1.2.2.306 and later
Information in this document applies to any platform.

Symptoms

In Smart view's Ad-Hoc Analysis for a Hyperion Financial Management(HFM) application, when dimension member's names that are numbers are typed in to Excel, Excel treats this as number.

Refresh the sheet, the following error comes, and refreshing does not work.

"Invalid grid. Either rows or columns have zero members. Please check suppression options and try your action again"

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