Ad-hoc Retrieval on Smart Slice Returns Error "Invalid free form; need at least one row and one column dimension.
Last updated on SEPTEMBER 27, 2016
Applies to:Hyperion Essbase - Version 188.8.131.52.00 to 184.108.40.206.000 [Release 11.1]
Information in this document applies to any platform.
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
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.
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