Error Connecting to Planning Application from Smartview After security changes

During my work for recent client I came across below issue multiple times so I thought of documenting the solution.

Issue Description : 

If you update a planning security for a user like adding additional role, removing a role, Adding or removing a group etc than user can face below issue while connecting to planning application through Smartview.

"Cannot open cube view. Essbase Error(1054060): Essbase failed to select application <Application Name> because <username@Directory> is not completely provisioned by Planning."

Issue Cause: Aforementioned issue caused because Essbase security is no longer in sync with Planning (Shared Services) after security changes in Shared Services for specific planning application have been made. (This is a product bug)

Issue Resolution:

To Resolve this issue you have to delete the user from Essbase and refresh the security from Planning to Essbase.

Please find detail steps below:

• Login to EAS console and open MAXL Script Editor

• Query user using below command

display user <username>;

• Delete user from Essbase using below command

drop user <username@provider> from security_file;

• Refresh security by logging into Planning application through Workspace

• Login to Smartview to confirm issue is resolved