Essbase-SQL/IF Users Cannot Access Essbase Load Rules In Essbase Administration Services (EAS)
(Doc ID 2289885.1)
Last updated on AUGUST 01, 2017
Applies to:Hyperion Essbase - Version 18.104.22.168.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.
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