Bulk user addition in Shared Services 18

I’ve once talked about adding bulk native users in Hyperion Shared Services using CSSExportImport Utility.
This is an attempt to re-visit the same keeping in mind that CSSExportImport is no longer available from 11.1.2 onwards.
I believe all of you are aware that Shared Services is no longer using OpenLdap and is replaced with relational databases for more stability. You can check this entry for some information on the internal handling.
The challenge in adding multiple users at time (not from front end, where you’ll add users one by one) is to generate the Encrypted password and the internal ID, as both are system generated.
I was looking around to find a way out where I had to add 300 users to the system for Performance testing.
I tried to find a match for an internal id and then achieved the task by incrementing the internal ids and copying the encrypted password for all the users(as password were same for them). (do not try this, as it is not a recommended way).
Then later I came across a Maxl statement which creates a user in Essbase and HSS 🙂
You can specify the password for a user, you can even add the native user to a group using the below given Maxl.
create user ‘test1’ identified by ‘password’ member of group ‘All Planners’;
Only issue in doing so is the user will get a default Essbase server access.
However you can remove the provisioning using LCM.
Perform LCM for Shared Services and select Essbase Cluster from the Assigned Roles section.
You can export this to a file system (This file will be exported to a folder under <Shared Services installation drive>:OracleMiddlewareuser_projectsepmsystem1import_export<user who performed LCM>)
and edit the EssbaseCluster-1.csv file to remove all entries except the newly added user information.
Perform an LCM from File system to Shared Services and select Import Operation as DELETE)
This will remove the existing provisioning (Server Access) from all newly added users.
Updated on 11-11-2011

Thank you very much for pointing this out Henry Vilminko. You can generate the users by editing csv file (use export for edit option) and follow the below given steps.

If you want to create new native users you can just leave the internal_id field empty and HSS will generate a new id automatically. The password can be given in plain text – Shared Services will encrypt it before storing the user in the database. The file shown below will create three new test users in Native Directory when imported through LCM.

Henri Vilminko

testuser1,Native Directory,testuser1,Test1,User1,Test User Number1,,,testpassword1,true
testuser2,Native Directory,testuser2,Test2,User2,Test User Number2,,,testpassword2,true
testuser3,Native Directory,testuser3,Test3,User3,Test User Number3,,,testpassword3,true

About Celvin Kattookaran

I’m an EPM Consultant, my primary focus is on Hyperion Planning and Essbase. Some of you from Hyperion Support team might recognize me or have seen my support articles, I was with the WebAnalysis Support Team. I'm an Independent Consultant with “Intekgrate Corporation” based out of Aurora office. I’m from God’s Own Country (Kerala, India), lived in all southern states of India, Istanbul and Johannesburg (and of course United States). I’m core gamer :) and an avid reader. I was awarded Oracle ACE Director for my contributions towards EPM community.

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.

18 thoughts on “Bulk user addition in Shared Services