Bulk user addition in 11.1.2.1 Shared Services - Oracle

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.

Steps

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.

HTH

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.

Regards,
Henri Vilminko

#user
id,provider,login_name,first_name,last_name,description,email,internal_id,password,active
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

18 thoughts on “Bulk user addition in 11.1.2.1 Shared Services”

Share this:

Like this:

Related

Leave a ReplyCancel reply

18 thoughts on “Bulk user addition in 11.1.2.1 Shared Services”