Essbase-SQL/IF Users Cannot Access Essbase Load Rules In Essbase Administration Services (EAS)
Last updated on AUGUST 01, 2017
Applies to:Hyperion Essbase - Version 188.8.131.52.005 and later
Information in this document applies to any platform.
When trying to open a load rule and open the data source, it errors with
Error 1021106 Failed to Execute SQL Statement
The user has access to the tables the load rule is trying at connect to and can access those tables using sqldeveloper. This issue occurs only with certain users, other users with same access level to Essbase and database tables can access the load rule with no issues.
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