A Specific User Cannot Access Essbase Even After Deleting and Recreating the User (Doc ID 1365000.1)

Last updated on JULY 28, 2016

Applies to:

Hyperion Planning - Version 11.1.2.0.00 to 11.1.2.1.000 [Release 11.1]
Information in this document applies to any platform.
march 2016

Symptoms

A specific user cannot access Essbase despite having the correct provisioning and permissions. Other users with the same security settings are unaffected.

Deleting and recreating the affected user does not resolve the problem.

The exact symptoms vary according to how Essbase is being accessed. For instance, the user may see an error when using Ad Hoc grids in Smart View.

Example

When a specific user "userX" logs into Smart View and tries to access the "App1" application they receive the following error in a popup window:

Cannot open cube view. Essbase Error(1054060): Essbase failed to select application App1, because userX@Native Directory is not completely provisioned by Planning.


After dismissing the error message, right-clicking on the application in the Smart View pane in Excel and choosing "Ad Hoc Analysis" throws the same error.

Provisioning a new user "userY" with the same roles and permissions works correctly. Only "userX" is affected.

Deprovisioning and/or deleting "userX" and reprovisioning/recreating them does not resolve the problem.

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