Ad-hoc Retrieval on Smart Slice Returns Error "Invalid free form; need at least one row and one column dimension. (Doc ID 1338876.1)

Last updated on SEPTEMBER 27, 2016

Applies to:

Hyperion Essbase - Version 11.1.1.0.00 to 11.1.2.1.000 [Release 11.1]
Information in this document applies to any platform.

Symptoms


When using a Smart Slice connect to Application/Database and perform an ad-hoc retrieval.  Retype any of the members in the grid using different case, and then selecting
refresh will return error "Invalid free form; need at least one row and one
column dimension.

For example: If Measures is returned in the grid, retype with measures and the error will appear.  If
you retype with a capital M for Measures the refresh will be successful.

The outline in Essbase is not set to be case sensitive. If you perform a regular ad-hoc retrieval outside of the Smart Slice, measures or Measures is accepted for the refresh.

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