Deploying Change Password Web Service in OBIEE 11g !!

Author: | Posted in Oracle Fusion DBA 7 Comments

Hi All,

We will see in today’s post regarding How to deploy a web service to change the password of the user by himself through OBIEE login, as this option by default is not available in OBIEE.


Through Jdeveloper have to generate a war file using some java code which acts as a webservice.

When a create java class, you have to remove the existing code and replace the new code which is given in below hyper link name and change the parameter webLogicHostname, webLogicPort, webLogicUsername, webLogicPassword according to your environment.

Link for the changepasswd code:

Create a new connection of your OBIEE weblogic server to deploy the created webservice:

Once the webservice deployed successfully , go to analytics sign with weblogic user to create new Dashboard, Action link.

 Create a new Dashboard,called User Settings.

 Under Location, select Browser…

 From the Shared Folders folder, select New Folder. Name it User Account.

Select the radio button for Add content later (Create empty dashboard). Click Ok.

 Click on the Catalog link, and navigate to the newly created folder, User Account.

 Select Permissions to set the appropriate permissions on the new folder, BI Administrator should have Full Control. BI Consumer should have Open.

  • Make sure that Apply permissions to sub-folders and Apply permissions to items within folder are both selected.

 Click Ok.

Invoke a web service from New option in the right side panel of analytics page.

Call the webservice which was deployed in OBIEE managed server through WSDL

Drill down until you can select passwordChange, and select it. Click Ok.

 This opens up a new dialog box, enter the following values for the prompts (no quotes):

  • passwordChange_arg0 = “Username:”
  • passwordChange_arg1 = “Old Password:”
  • passwordChange_arg2 = “New Password:”
  • passwordChange_arg3 = “Confirm Password:”

 For the Username argument, for Value select Session Variable, then type in USER and mark it as fixed and hidden.

  • This will force the password change to only work for the current logged in user.

 Click the Options button to personalize the messages (again, no quotes):

  • Set Dialog Title to “Change Password”
  • Set Action Help Text to “Please enter your existing password and new password below.”
  • Set Execute Button Text to “Change Password”
  • Leave all other options blank.

 Click on the Action Results tab and enter the parameters for the return messages (again, no quotes):

  • Set Dialog Text to “@{passwordChangeResponse}”
  • Create one XPath variable:
    • Name: passwordChangeResponse
    • XPath Expression: Body/passwordChangeResponse/return
  • Set Dialog Title to “Result”

 Click Ok. Click Save Action.

 Save the action as Change Password into the User Account Shared Folder you created above.

Navigate to your newly created Dashboard, User Settings. Edit the dashboard by placing a new section. In that section, add a text item. Place the following into the text item (making sure to check the Contains HTML Markup box):

<script type=”text/javascript”>

document.getElementById(“idPageOptions”).style.display = “none”;


Welcome to the change password page. This page will allow you to change your password for access to the Business Intelligence reporting application.<br><br>

You are currently logged in as <b>@{biServer.variables[‘NQ_SESSION.USER’]}</b>.<br><br>

Please click the link below to begin the password reset process.

Click Ok. Edit the Column Properties. Click on Custom CSS Style Options (HTML Only) and add the following to the Use Custom CSS Style:

position:absolute;height:120px; margin-top:40px;

 Click Ok.

 Drag an Action Link below your text item in that same section. Name the link Change Password, and navigate to the saved Action Link you saved to the Shared Folder. Don’t define any values, just click on the Ok button.

 Click Ok to close the Action Link Properties window.

On the main section properties, unselect Collapsible. Additionally, from the Section Properties, set the border position to None.

Click the icon to save the dashboard. Click the icon to view the results.

Now login with a user in analytics and try to change password:

It’s worked successfully.

Think found handy stuff.

Happy learing !!!


Reference :


  1. Posted by Nahid
    • Posted by hussaindba
  2. Posted by Baber
    • Posted by hussaindba
  3. Posted by Huynh Nhan
    • Posted by Stepehn
  4. Posted by Maksud

Add Your Comment