Planner Unable to Load to Planning Application With FDM

Planner Unable to Load to Planning Application With FDM
		Modified 19-APR-2010     Type PROBLEM

---

Applies to:

Hyperion Financial Data Quality Management - Version: 9.3.1.2.00 to 9.3.1.2.00 - Release: 9.3 to 9.3
Information in this document applies to any platform.

Symptoms

Setup a user in Shared Services that is assigned the role "Planner" and "Essbase Write Access".  The user is also an FDM user.  When the user attempts to load to the planning database the load fails.  The error log returns:

** Begin Essbase Adapter Runtime Error Log Entry [2009-09-01-11:07:52] **
-------------------------------------------------------------
? ERROR:
??? Code.............. 10407
??? Description....... Essbase API Procedure: [EsbPutObject] Threw code: 1051041 - 1051041 - [Tue Sep 01 11:07:52 2009]USNYMEHYP07/Corppln/Finstmt/dntest.user/Error(1051041)
Insufficient privilege for this operation
??? Procedure......... clsHPDataManipulation.fCopyToServer
??? Component......... upsES9XG4A
??? Version........... 100
??? Thread............ 396

Cause

The issue is that the user that is performing the load to the Essbase database does not have 'Calc" privileges within the Planning Application in Essbase, resulting in the error message: 
"Insufficient privilege for this operation" 


In order to perform the load from FDM to Essbase, the user performing the load must have the "Calc" privilege at a minimum, which is the "Planner" role in the Planning Application. After applying the Planner Role to the user, security must be refreshed to allow the calc privilege within the Essbase application to perform the load. 


The second issue is that the ES9x-G4A adapter was being used. To resolve this error, an upgrade to the ES9x-G4B adapter needs to be applied. 

Unpublished Bug 6574927 outlines that the user must have calc privileges at a minimum within Essbase to be able to perform a load successfully. The ability to perform this process with a String Load was added to the ES9x-G4-B adapter. Currently the A adapter does not contain this functionality. The cause of the issue is related to the user’s security within Essbase as well as the version of the Essbase adapter being used within FDM. If the user has the "Calc" right within Essbase, they will be able to perform the load successfully. 

Solution

a) Login to the FDM application as a power user
b) Right-Click on the ES9x-G4-B adapter and choose "Configure"
c) Click on the "Hyperion Essbase Integration Setup" tab
d) Click on the "Load/Check" button
e) Check the "Enable String Load" box and click "Apply" and click "ok"
f) Choose Metadata/Locations on the web client and click on the location performing the load
g) Click on the "Options" tab and in Integration Option 2 enter the rule name to be used for the load and save the change
h) Perform the export/load to the Planning database and the load completes successfully if the load file contains a valid record that the user has access to.  Currently the .err file generated if the user does not have access to all records is created in the outbox directory.  A bug has been entered against the ES9x-G4-B adapter to display the .err file to the end user.  Unpublished bug number 9037697.