When trying to upgrade your SAP BusinessObjects (BO) Business Intelligence (BI) Platform from XI3.1 to 4.0 or greater and migrate your Windows AD Users and Groups, you will notice that they were migrated with Copy (1) in their name. For more details follow this SAP Note: 1737240.
The resolution provided by SAP in this case is to manually rename the Users and Groups.
This is fine if you have up to 50 objects to rename; but in general this is not the case, so you will want an automated solution (unless you want to waste some good hours).
Now the question is: How you can create an automated solution? There is a simple answer: by taking advantage of the Platform SDK.
So, what exactly does this mean? By using the Platform SDK?
First of all, if you don't have any knowledge about Platform SDK, I recommend you to first read this document: Introduction to SAP BI SDK. It won't make you an SDK expert overnight but at least you will have a brief knowledge on what it can be used.
Now going back to the issue, we will need to make an mass updates on the repository. To make this a bit easier, you can already find the script here: massChange.jsp
There are few small changes which are needed to be done before running the script:
//administrator user
String username = "Administrator";
//administrator password
String password = "Password";
//CMS name where you want to make the change
String cmsname = "CMSNAME:6400";
It's recommended to check what you want to update before running the script. You can easily do that by accessing SAP BOBI query builder (http://[ServerIP]:[Port]/AdminTools/querybuilder/ie.jsp) and running the following query:
Select * FROM CI_SYSTEMOBJECTS
WHERE SI_Kind='User'
AND SI_NAME!= 'Administrator'
AND SI_NAME !='Guest'
AND SI_NAME like '%- Copy%'
ORDER BY SI_ID ASC
After checking the result of the query, you can run the script and then you can re-run the query which should return an empty page.
I also recommend to do the following tests after the change is done:
- Login to CMC
- Go to 1 Group which was renamed and check the properties and also the users inside the Group
- Go to 1 User which was renamed and check the properties
- Login to BI and/or CMC with 1 User which was renamed
If you follow exactly the above steps, you should now be able to update hundred of objects in just few seconds!