Select Page

Art of BI: Setting up OBIEE Impersonate – BITeamwork Updating Impersonate Credentials for BITeamwork OBIEE WS Service Account

Zach Randall | | July 4, 2015

BITeamwork makes use of the OBIEE API system and web service calls for part of the functionality it delivers to empower OBIEE users. A OBIEE service account for accessing the API must be created and then using the BITeamwork control panel those credentials are securely entered and encrypted to be leveraged by BITeamwork. That credential needs not have access to any data or reports, merely the impersonate user and SOAP access privileges. We often recommend customers use a default user for setting up this credential such as the administrator user created when OBIEE was originally installed. We typically set that user’s name as “weblogic” but we know other customers use “biadmin” or something equally as clever.

At any rate, that user or the application role it is assigned, such as the BIAdministrator role, must have the impersonateUser privilege assigned to it via Enterprise Manager’s privilege security management. This post walks you through how to achieve the desired result of adding the impersonate user privilege to an application role with which a user assigned as the web service service account will be associated. Please ping our support team if you need any assistance. If this is not configured for the Advanced Printing option now in OBIEE via BITeamwork you may receive the following error message:

1435984775_thumb.png

Screenshot 2015-07-02 17.07.54

Follow the steps below to ensure that you receive no error messages. These steps are also very general to setting up privileges for Application Roles in OBIEE 11g:

1. Open Enterprise Manager
2. Expand the Business Intelligence Folder
3. Right click on the Business Intelligence folder and select Security > Application Policies
4. Click on the row of the BIAdministrator role (or whatever other role your OBIEE WS Service Account, ex: weblogic, obiadmin, etc., is assigned) in order to select it

Screenshot 2015-07-02 18.08.51
5. Click on the pencil icon button to edit the privileges for this role

6. In the Permissions table (bottom of page) click the green plus “Add” icon button to open the Add Permission dialog window
7. Ensure that:

  • Permissions option is selected
  • Permission Class is oracle.security.jps.ResourcePermission

 Screenshot 2015-07-02 18.12.18

8. Enter oracle.bi.server.impersonateUser in the Resource Name field and then click the triangle play button to search for the resource.

Screenshot 2015-07-02 18.12.34
9. Click on the row in the Search Results table for the Resource Name entry. (Not selecting or clicking on the row before conducting the next step will result in failure of adding his new permission)

Screenshot 2015-07-02 18.12.49
10. Click the Continue button
11. Click the Select button to confirm the filled in form

Screenshot 2015-07-02 18.13.53

12. Click the OK button on the returned page
13. If working with BITeamwork, and testing the Advanced Printing option,Return to the OBIEE dashboard and run the Advanced Printing option in OBIEE using the Dashboard Options menu. This should now work for any user with access to the advanced printing option.

Oracle EPM Cloud Vs. On-Premises: What’s the Difference?

EPM applications help measure the business performance. This post will help you choose the best EPM solutions for your organization’s needs and objectives.

Bobby Ellis | April 10, 2018

Hyperion Myth #9: SOX Audit Requests Are Time-consuming

With serious financial penalties, SOX audits can be intimidating — but they don’t have to be. Find out how you can use Datavail’s software to automatically prove SOX compliance.

Jonathan Berry | March 13, 2018

12c Upgrade Bug with SQL Tuning Advisor

This blog post outlines steps to take on Oracle upgrade 11.2 to 12.1 if you’re having performance problems. Oracle offers a patch and work around to BUG 20540751.

Megan Elphingstone | March 22, 2017

Work with Us

Let’s have a conversation about what you need to succeed and how we can help get you there.

CONTACT US

Work for Us

Where do you want to take your career? Explore exciting opportunities to join our team.

EXPLORE JOBS