I have a need to rename an username in Business Intelligence (Analytics). Is it possible?
I succeeded in going offline. You have to be on the server (I used MobaXTerm so I was failed).
Refer :
How To Execute Bulk Rename Accounts Using runcat.sh/runcat.bat (renameAccounts) (Doc ID 2437991.1)
Hi @Staniša Avdalović , Welcome to the Oracle Analytics community! You can use the Catalog Manager (UI or command-line) to rename users.
Section 17.3, "About Catalog Manager"
./runcat.sh -cmd renameAccounts -help
As you may know, OBIEE 11g is very old, we recommend you make plans to update to Oracle Analytics Server(via OBIEE 12c) at your earliest convenience before it becomes an issue to migrate :-)
Migrate from Oracle Business Intelligence 11g
Thank you for your question!
Thanks for the answers. I will take a look.
I tried to change username and in the catalog manager username is change. At the other side in weblogic console username hasn't been changed! Beside it I couldn't sign in again.
Do you notice any errors in the sawlogs? Have you attempted to refresh the users' GUIDs?
After taking proper backup, You need to run the following command:
./runcat.sh -cmd renameAccounts -old ABC -new XYZ -online http://<ip>:9704/analytics/saw.dll -credentials boot.txt
Boot.txt is a credentials properties file that should be placed in a location accessible by OBI. Edit the file and include the following content:
login=username (Example: weblogic)
pwd=password
Here, username refers to the OBIEE Administration user, and password is the corresponding password. This should ideally work.
At the other side in weblogic console username hasn't been changed!
No command will rename the account in WebLogic if that's where you defined it. You have to do the renaming there, and I believe there isn't such a thing as renaming in WebLogic, and renaming is done by creating a new user with the right username and deleting the old one. Then the catalog manager rename does the job required in the catalog.
OBIEE 11g still was fully based on GUID, and those can go out of sync (mostly when migrating catalogs across environments). It's way too many years since last time I worked on a 11g to remember if the renameAccounts command in the catalog manager did handle the renaming preserving the GUID or a refresh was needed. I would guess you don't need it (maybe).
Your issue with the login is because you are now in a mixed state: WebLogic only knows of the old account, your catalog only knows of the new account.
That's correct.
I was thinking of making a new user and deleting the old one, but I don't know how to copy dashboards and reports from the old user to the new one.
In the Catalog Manager I can see renaming user. As you can see I cannot access users's folder!
How can I refresh the users' GUIDs?
Please refer (Take proper backups if following the steps):
OBIEE 11g: How to Refresh GUIDs on a single node OBIEE 11g ? (Doc ID 2181811.1)
OBIEE 11g: How To Refresh the GUIDs and Perform a Web Catalog Validation - Cluster/Scale-Out - the Reasons to do it, Preventing Inconsistencies and Process Detail (Doc ID 1493912.1)
Also, on your other query : By default Administrator does not get access to users content as users content is meant to be confidential. Please Refer :
OBIEE 12c: How To Update Object Ownership In The Catalog After A User's Name Has Been Modified (Doc ID 2759123.1)
OBIEE: Weblogic User Does Not Have Access To Other User Folders Using "Admin View" (Doc ID 2234422.1)
An Administrator User Cannot Modify Owned Items That Were Created By Another User In Oracle Analytics (Doc ID 2957146.1)
Where AI meets business outcomes Oracle AI World brings the Oracle community together to explore how AI and other technology innovations are driving real business outcomes across industries. Discover what’s new through: Mainstage keynotes to hear the latest directly from Oracle leadership Product demonstrations Customer…
I tried the following expression and it blows up when I select more that one value in the list see image
We are using Oracle Analytics Server 2026 with WebLogic Server 14.1.2. Our Account Statement report is accessed through '/xmlpserver'. We need to capture the following details in the OAS/Publisher log files whenever a user runs the report: Username Report name and path Report execution timestamp Account Number From Date To…
We need to download a report with the order number as the file name. In the main report, we have a data action (hyperlink) on each order number. When we click an order number, the linked report is downloaded with the corresponding order details. Currently, the file is downloaded using the report name. We need to download…
Hi all I work in UK healthcare across 30 hospitals nationwide, and we're currently reviewing our Oracle estate and roadmap. Part of that is deciding whether to make a case for investing further in Oracle Analytics Cloud for workforce reporting, or whether OTBI and our existing tools are enough for now. Our HR data sits in…
