Deleting Hyperion Planning User security from the Database

We migrated the Hyperion Planning application from the Production to the Development environment and when we tried to "Refresh Security", it threw error that 4 users were not found.

Since 1 of the user was a native user, we tried creating it but this did not help.

This usually happens if the users are deleted from the MSAD when the user leaves the organization but it still exists in Planning tables. 

Since the Shared Service Security and the Essbase/Planning security were out of sync. We ran the available utilities to fix the issue. 

1360954.1 Where you run the UpdateUsers and ProvisionUsers utilites

This did not help , it threw error that

Unable to delete the users A,B,C,D.

We tried a couple of things like manually copying the SID from CSS_USERS to HSP_USERS but that did not fix it either.This is an interesting article - Failed to Sync User Provisioning

Finally, we restored to deleting the users from the Planning Application Tables.

Mind you, please do not attempt this unless you have expertise in messing with the Database.

We started off firstly by BACKING up the entire schema of our application using below commands

expdp schemas=PLANAPP dumpfile=PLANAPP-18Mar2016.dmp logfile=PLANAPP-18Mar16.log 

Then we started deleting the listed user by doing this :

This query should give the OBJECT

SELECT OBJECT_ID,OBJECT_NAME FROM PLANAPP.HSP_OBJECT WHERE OBJECT_NAME LIKE 'LIST OF USERS';

Once you have the list of users you want to delete and their object ids. You will have to delete from the following tables. ( I will update this list in case I have missed something)

HSP_JOB

HSP_JOB_STATUS

HSP-HISTORICAL_JOB_STATUS

HSP_CALCULATION_MANAGER

HSP_ACCESS_CONTROL

HSP_USERSINGROUP

HSP_USER_VARIABLE

HSP_USER_VARIABLE_VALUE

HSP_MRU_MEMBERS

HSP_USER_PREFS

HSP_USERS

HSP_OBJECT

HSP_OUTOF_USRID

These are the list of tables that get impacted. The easiest way to do this is start deleting from HSP_USERS it will lead to all the entries that need to deleted before you could delete it from HSP_USERS.

Once you have deleted the users. Restart Planning and you should be good to go. 

Related Errors:
Failed to Sync with User Provisioning. Check Planning logs for details

Read More

Job Openings for Hyperion Planning

We have openings in HP&A practice in ADI India.

We are looking out for the following profiles –

Consultant – (1 position)

 2 to 4 years of experience in Consulting and Implementation of Hyperion Planning and Essbase solutions

 Multi Skill sets exposure (Preferably) – Hyperion Planning, Hyperion Essbase, ODI, FDMEE, Reports etc

 Exposure to at least 2 full project implementation cycles

Senior Consultant/Lead Consultant – (1 position)

 4 to 7 years of experience in Consulting and Implementation of Hyperion Planning and Essbase solutions

 Multi Skill sets exposure (Preferably) – Hyperion Planning, Hyperion Essbase, ODI, FDMEE, Reports etc

 Experience in Leading projects, Client Interactions and Project Team Management

 Exposure to at least 4 full project implementation cycles

 Experience in handling and mentoring teams

Both the above positions are offshore positions. Resource should be open to travel based on project needs.

If interested please email on [anjumara.dba][@][gmail.com]

Read More

An Overview of EPM Infrastructure for All Consultants with Basic Troubleshooting

This presentation was done during one of the sessions I took for a group of Hyperion Developers with various expertise like HFM, Planning and HPCM. This presentation is a guide to basics of Hyperion and how it functions.

Read More