Wednesday, 2 July 2014

Recreate the BI System Application Role

To recreate the BI system role, please review the following:

1. Recreate the BISytem Role - map this to BISystem User.

    Login to EM>Business Intelligence > coreapplicaiton > Right click > Application Roles>Select the    Application Stripe as obi>Click Create
    Role Name: BISystem   
    Display Name: BI System Role
    Members: BISystem User

2. Recreate BISystem Policies - add BISystem Role as member to this.
    Business Intelligence > coreapplication>Right Click > Application Policies>Select the Application Stripe as obi>Click Create
    Add the BISystem Role as the Grantee
    In the Permissions section, add the following:
        oracle.bi.scheduler.manageJobs - Grants permission to use Job Manager to manage scheduled Delivers jobs.
        oracle.bi.server.queryUserPopulation Internal use only.
        oracle.bi.server.impersonateUser - Used by internal components that need to act on behalf of end users.
        oracle.bi.server.manageRepositories - Grants permission to open, view, and edit repository files using the Administration Tool or the Oracle BI Metadata Web Service.
        EPM_Essbase_Administrator - Grants permissions for EPM Essbase Administrator.

3.When creating Application policies for BISystem Roles, if you don't find them from the search results, then leave the Resource Name empty and click continue and manually add the Permission Class, Resource Name and Permissions Actions.
Once you have added all the policies and have restarted your services, OBIEE should be back up and you should be able to log back in again

No comments:

Post a Comment

Power BI: Show Last Data Refresh on Dashboard

 To show last data refresh on Power BI report follow the below steps. 1. Open Report Query Editor Mode. 2. Clink on Get Data -> Blank...