Essbase Add-In For Excel Not Staying Registered

Applies to:

Hyperion Essbase – Version: 9.3.3.0.00 and later [Release: 9.3 and later ]
Information in this document applies to any platform.

Symptoms

Customer has installed the Essbase Add-In for Excel, but with a user that does not have local admin permissions to that PC, and now they sporadically see the Add-in not “stick”/they have to occasionally re-register it.

Changes

User used to install Essbase Add-in for Excel did not have Admin permissions to that PC.

Cause

Incorrectly installing the Essbase Add-In for Excel without local Admin permissions does not allow the Add-in files to be properly registered/used/saved, therefore causing the sporadic problems such as the Add-In’s de-registration/disappearance.

Solution

If customer cannot allow their users to keep the local Admin permissions to the PC where they want to use the Essbase Add-in, then in the older pre-v11 versions of the Add-In there are two workarounds for the issue.

Note that you will still need to *install* the Add-in with a user that has Local admin permissions.

Ensure your MS Excel is closed before you do these suggestions:

Suggestion One:

1. Temporarily give your user’s UserID the full admin privileges for that machine
2. Install the Excel Add-In with that UserID (and not with the actual administrator)
3. Then Remove admin privileges from that UserID
4. Finally, run the excel add-in using that user’s UserID without admin privileges
5A. Restart Excel and try again
5B. (As you found, you may have to untick “Require Application Addins to be signed by Trusted Publisher”).

And normally that should fix the issue. However, if it doesn’t:

Suggestion Two:

1. Temporarily give your user’s UserID the full admin privileges for that machine
2. Install the Excel Add-In with that UserID
3. Then remove admin privileges from that UserID
4. Then open up the Hyperion locale directory to read/write for everyone (usually C:\Hyperion\AnalyticServices\locale):
Right-click on the Locale directory, then click on Properties, go to the Security tab, and confirm that Everyone has full control.
Then click on the “Advanced button”, and in the new window, make sure the two boxes are checked:

Allow inheritable permissions from the parent to…
Replace permission entries on all child objects…

Then click OK and OK again until you are back to the desktop.
5. Close and open Excel, and try again.

Advertisements
This entry was posted in Oracle EPM and tagged , , . Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s