Skip to Content

You can add users or user groups in bulk to the CMC using a CSV (comma-separated values) file. Useful and intuitive.

Version

SAP BusinessObjects BI 4.0 SP6

Build Number : 1036

Product Version : 14.0.6

Context

A list of users is available as a .CSV file. You want to import users in CMS in order to manage them.

Step-by-step guide

1. First of all, we need a flat file where users are listed. Be sure to respect this kind of format below to avoid misunderstanding during next step.

Action User Group User Full Name Password Mail Profile Name Profil Value

Add

MyGroup

MyUser1

MyFullName

Password1

My1@example.com

ProfileName ProfileValue

“Add” is an action and this key word is necessary. Other details complete user definition.

HT-Import users.png

Must Know : Entries of your CSV file must be separated by a comma (,).

2. On the Users and Groups tab, click Manage Import User Group User/Group/DBCredential .


The User/Group/DBCredential window is displayed.

HT-Import users 01.png

3. Click Browse, select a CSV file, and click Verify.

The file is processed. If the data is formatted correctly, the Import button becomes active.

HT-Import users 02.png

4. Click Import.

HT-Import users 03.png

The users or user groups are imported into the CMC.

HT-Import users 04.png

😉 It’s done !

Tips

The following conditions apply to the bulk addition process :

  • Any line in the CSV file that contains an error will be omitted from the import process.
  • User accounts are initially disabled after being imported.
  • You can use blank passwords when creating new users.

More informations

You can get more informations reading SAP BusinessObjects Business Intelligence Platform Administrator Guide :

http://help.sap.com/businessobject/product_guides/boexir4/en/xi4sp6_bip_admin_en.pdf

To report this post you need to login first.

34 Comments

You must be Logged on to comment or reply to a post.

  1. Boman Hwang

    Thank you for that, nicely done and could be quite handy! Incredible that I have overlooked that option before, since it seems to have been in BI 4.0 at least since SP4 (at which I am looking at right now).

    Do you also happen to know the proper format for importing Database Credentials in bulk as well? I think that one would look somewhat similar, but I am not sure and could not find any information about that in the Admin Guide.

    (0) 
    1. WILLIAM MARCY Post author

      Thanks for your comment.

      I’m looking for further test to define proper format for importing Database Credentials in bulk. I’ll post a new version of my document once the answer found.

      Stay tuned.

      (0) 
  2. Merlijn Ekkel

    Hi William,

    Nice overview (easier to read compared to the manual)..

    Some suggestions:

    You can update users via this script as well (like changing passwords and email). IN this case you can use the ADD statement just like creating the user as the CMS will pick this up as an update as the username has to be unique.

    Bulk removing should be available by using the command “REMOVE” followed by the user..

    so in example:

    Col A          Col B

    Remove       bobama

    Add an existing user to an addtional group should be available via the add statement..

    Although I have never tested this in BI4.0 this all worked in XIR2, so will be surprised if it does not work anymore

    (0) 
    1. WILLIAM MARCY Post author

      Thanks Merlijn for these details.Very useful.

      Don’t hesitate to add more tips, I’ll test “REMOVE” command to go further… This kind of features already exists for a while but well-hidden so, I do it out of the box !

      Regards,

      (0) 
    2. Erin Shaw

      Hi Merlijn,

      Thank you for your extra info. I just wanted to make sure I am following you correctly, so if I had one person in multiple groups would this be the info I use in the CSV file for example John Smith or will one overwrite the other or will I have 2 John Smiths?

      John Smith example.PNG

      Also I think I understand the profile name, but if anyone can give me an example of profile values that would be a huge help.

      Thank you for any help you can provide!

      Erin

      (0) 
    1. Dinesh Kumar Agarwal

      Hi William,

      Thanks a lot for sharing this information

      .

      We are using SAP as authentication system for BI4.0

      Is there a way we can bulk upload SAP Backend roles (BW roles) in Business Objects?

      Thanks in advance 🙂

      Cheers !!

      Dinesh

      (0) 
      1. WILLIAM MARCY Post author

        Hi Dinesh,

        Yes you can. In SAp Authentication options, you can import automatically SAP BW Roles and set up a security matrix to manage new users in SAP BW with automatic security profiles in SAP BI 4.0.

        You can plan updates from SAP BW in these options, so BI Platform does it for you.

        Each SAP BW role is created as a user group in CMC, so users are imported without any manual action.

        Hope it will help.

        Regards,

        (0) 
        1. Dinesh Kumar Agarwal

          Thanks William for the response.

          One more question 🙂

          We need to create a lot of user groups for providing access to folder , universes, connections etc.

          Is there a way we can mass upload user groups in BI4.0 system from some file(excel etc.). What we need is group name and description.

          Best Regards,

          Dinesh

          (0) 
          1. Yozgart Alvarez

            Hi Dinesh,

            When you add a user, if the group does not exist, it will be created during the import. When you delete the user with “Remove”, this group is not deleted, even if the eliminated user is the last one in the group.

            (0) 
          2. Erin Shaw

            Hi Dinesh,

            I added groups using the same steps as above the only difference was my CSV file had only two columns. Column A said “add” like the above sample and the B was my list of groups. I did this step first and then when I added my users, they went into these groups. See pic attached. I hope that is what you were asking and this help!Add Group In Bulk.PNG

            (0) 
            1. Dinesh Kumar Agarwal

              Hi Erin,

              Thanks a lot for sharing. It works perfect.

              However, is there a way we can include the group description as well? Using above script we can import groups but description is blank.

              Thanks again

              🙂

              Dinesh

              (0) 
              1. Erin Shaw

                I have not tried it, but can you add a description column to the file like the user group column? Let me know if you try it and if it works and if I get to that point I’ll let you know as well.

                (0) 
  3. Yozgart Alvarez

    My only concern is that once you have created all the users, you need to enable all the users one by one, and it should also include a field for Description.

    (0) 
  4. satheesh kumar vadivel

    Hi,

    This is really amazing feature. i tried this and unfortunatelly it is not working.

    In our environment we are using BO4.1 SP2, and Windows AD authentication. We recently migrated user groups and it is broken from original groups.

    So all users are existing in user list , now i want to add this users in to corresponding groups. some time one user might belongs to multiple group.

    When i tried this i am getting error, Any idea? am i missing something?

    Belive me we have 60K users and we are not able to imagine this do by manually…

    Thanks in advanceuser1.JPG

    (0) 
    1. Erin Shaw

      I am not sure why it did not add your groups but it looks like you may have used a name you have already used so it did not want to override the original. Can you put a screen shot of your file of your groups? That may help people see what happened.

      Example of group add below.

      Action     User Group

      Add          Accounting

      Add          Customer Service

      Then if I have a person who belongs to more than one group then the user add file would look like below.

      Action      User Group               User          Full Name

      Add          Accounting               Bjones          Bob Jones

      Add          Customer Service     Bjones          Bob Jones

      You just make 2 line items for that person and it will place them in both groups. I was worried it would over-write the first one, but in mine it did not. I would test it in yours with just a few to be sure though.

      Heads up though. I was just testing adding people in ours and was unaware at the time we only had a few licenses and when I added people it kicked some of our original users off. They still showed up in the groups and users, they were just not allowed to log in! Oops!

      Hope that helps!

      Erin

      (0) 
      1. satheesh kumar vadivel

        Hi Erin,

        Thanks for the reply. We have to add different set of users in to different groups.

        So we are trying one by one group. in the below case only few id’s through error.

        If i remove those id’s and import then works fine. i tried to research with those id’s but not able to find the differences.

        We have to add540K + users in to different groups.

        error users.JPG

        (0) 
        1. Erin Shaw

          Hi Satheesh,

          That is strange. I have no idea why those three would give you an error. Can you see if their are some sort of hidden characters or something may be in those cells or lines? Have you tried adding any one of those by hand to see if it would work that way, just to test that there is not something in your file in those lines that may be keeping these from going through?

          (0) 
        2. Erin Shaw

          Hi Satheesh,

          Did you ever figure out why you got the error above? When I loaded my users the first time we had to remove them and now when I have tried the above steps that worked before, I get an error similar to yours. It verified it fine and the Status says success, but if I look at the history and instance it gives me the error then.

          Thank you for any info you can provide.

          Erin

          Part of the error below.

          Parse Results
          Number of lines read: 29
          Number of blank lines skipped: 0

          Commit Results
          Number of users attempted to commit: 29
          Number of groups attempted to commit: 13

          Error in objects: RS Sales Manager Group
          Error: The property list(s) ‘SI_ADM_ADD_USERS_TO_USERGROUP, SI_ADM_ADD_USERS_TO_USERGROUP’ committed on the object named ‘RS Sales Manager Group’ with id number 89704 contained reference(s) to non-existant object(s) with id number(s) 90616, 90617.

          (0) 
  5. Skugan Venkatesan

    Hi,


    As Wen Mao asked before, seems this only works for if we have a concurrent user licensing. What if I want to add bulk users if I have named users license. Because I have named user license and I tried the bulk loading but users were NOT added in to the CMC.


    Thanks,

    Skugan V

    (0) 
  6. Arjun Kadam

    Is there a way to bulk enable the users that are added. Since all the users that are added are disabled by default. It could save a lot of time 🙂

    (0) 
    1. Paul van Alst

      Hello Arjun,

      True, I had the same situation, all users were disabled by default.

      There is a possibility to mass change the users to enabled. The solution is to go to the usergroup, rightclick and choose ‘Account Manager’. You will be able to change three parameters:

      • Change User Passwords to New Value
      • Change Database Credentials
      • Enable/Disable User Aliases

      With the last one mentioned, you will be able to enable all users by authentication types which are provided for your system. For example you can enable ‘Enterprise’ by checkbox this type and checkbox again Enabled and click on Save.

      Off-course be careful because you will change all the users in the chosen group.

      Also be careful when you open this screen the first option ‘Change User Passwords to New Value’ is checkbox is default ‘Yes’, so you would change all the passwords as well.

      Kind regards,
      Paul

       

       

      (0) 

Leave a Reply