Forum Stats

  • 3,770,332 Users
  • 2,253,095 Discussions
  • 7,875,405 Comments

Discussions

User add automate

Hyp_Learn
Hyp_Learn Member Posts: 327 Blue Ribbon
edited Jun 30, 2020 12:45AM in EPM System Infrastructure

Hi, I have EPM 11.1.2.3. Is there is any way to automate user addition and user removal to groups instead of manually adding users to groups and removing from Shared service. Please let me know if there are any suggestions?

I appreciate your time to look into this.

Best Answer

  • Vasantha Kumar
    Vasantha Kumar Member Posts: 49 Bronze Badge
    edited Jun 29, 2020 11:36PM Accepted Answer

    Hi,

    In one way you can do this via LCM approach. Export the groups from HSS via LCM. You should have the Groups.csv file. In that file 1st section will have the Groups details, you can delete all those. Next section will have Group->Users details. There you have to update the new users you have to add to the respective groups (you can remove all the existing content and just add the group and users which are needed to be added). Save the Groups.csv file at the same location and go to shared service and import the groups. For removal, it is the same process, just make sure in the migration options -> shared services import is set to delete.

    You can also automate this via LCM utility to run from the command line.

    Regards,

    Vasanth

Answers

  • Srini+K
    Srini+K Member Posts: 253 Blue Ribbon
    edited Jun 29, 2020 2:46PM

    The following works are all versions..

    create some essbase cube sample or something.   create user group you want to create.. assign rw access to this unseful cube.

    assign appropriate roles needed...

    after that. one time process..

    use maxl to create user.. (or programatically).  ... this allows you to script batch creation of whole bunch of users..

  • Hyp_Learn
    Hyp_Learn Member Posts: 327 Blue Ribbon
    edited Jun 29, 2020 7:53PM

    Hi Srini,

    Can we use your mentioned process for Planning applications?

    Hyp_Learn
  • Vasantha Kumar
    Vasantha Kumar Member Posts: 49 Bronze Badge
    edited Jun 29, 2020 11:36PM Accepted Answer

    Hi,

    In one way you can do this via LCM approach. Export the groups from HSS via LCM. You should have the Groups.csv file. In that file 1st section will have the Groups details, you can delete all those. Next section will have Group->Users details. There you have to update the new users you have to add to the respective groups (you can remove all the existing content and just add the group and users which are needed to be added). Save the Groups.csv file at the same location and go to shared service and import the groups. For removal, it is the same process, just make sure in the migration options -> shared services import is set to delete.

    You can also automate this via LCM utility to run from the command line.

    Regards,

    Vasanth

  • Srini+K
    Srini+K Member Posts: 253 Blue Ribbon
    edited Jun 29, 2020 11:59PM

    it works with Planning as well.   you will just need to deploy the planning application with security, sharedmembers etc options.

    Thanks

    Hyp_Learn