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 MAY 30, 2018
Applies to:Hyperion Essbase - Version 220.127.116.11.00 to 18.104.22.168.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.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document