This topic explains systematic instructions to configure the BIP Interactive reports with BPEL.

1. Login to the BIP domain console, http/s:<hostname>:<port>/console.
2. To add the FCJCustomProvider, refer to steps from Configure Custom Authentication Provider topic.
3. Navigate to Security realms and click myrealm, and then click Users and Groups tab.
   The Settings for myrealm - Users and Groups screen displays.

   Figure 1-56 Settings for myrealm - Users and Groups

   
   

   
   Description of "Figure 1-56 Settings for myrealm - Users and Groups"

   
   

   Note:

   Check if the users from the schema, display in the Users tab, and the roles from the schema are displayed under the Groups tab.
4. Login to the Enterprise Manager (em) http/s:<hostname>:<port>/em.
   • Right click the domain (in which BI suite is installed) under the WebLogic domain.
   • Go to Security and then navigate to Application Roles.
   The Enterprise Manager screen displays.

   Figure 1-57 Enterprise Manager

   
   

   
   Description of "Figure 1-57 Enterprise Manager"

   
   
5. Navigate to the Application Roles screen, specify the following details:
   1. Select obi from the Application Stripe drop-down.
   2. Click the Search button.
   3. Click the Create button to add a role.
   The Application Roles screen displays.

   Figure 1-58 Application Roles

   
   

   
   Description of "Figure 1-58 Application Roles"

   
   
6. On the Create Application Role screen, specify the following details:
   1. Specify the Role Name (mandatory), Display Name (optional) and Description (optional).
   2. Click the Add button.
      The Add Principal pop-up displays.

      Figure 1-59 Add Principal

      
      

      
      Description of "Figure 1-59 Add Principal"

      
      
   3. Select Group from the Type drop-down.
   4. Select the checkbox under the Advanced Option section and again select Group from the Type drop-down.
      • Click the Search button, if the roles are listed then select the roles like ALLROLES-000, ADMINROLE-000 from the list.
      • Specify the Principal Name (mandatory), which is the role present in the FCUBS (ex: ALLROLES-000, ADMINROLE-000), Display Name (optional).
   5. Click the OK button in the Add Principal pop-up and then also in the Create Application Role screen.
      A confirmation screen displays with a message stating that a new role added successfully.
7. Again, right click the domain (which BI suite is installed) under the WebLogic domain and select Security and then select Application Policies.
   The Application Policies screen displays.

   Figure 1-60 Application Policies

   
   

   
   Description of "Figure 1-60 Application Policies "

   
   
8. On the Application Policies screen, specify the following details:
   1. Select obi from the Application Stripe drop-down and also select Application Role in the Principal Type field.
   2. Click the search button.
   3. Select BIConsumer from the list and click the Create button.
   The Application Policies screen displays.

   Figure 1-61 Application Policies

   
   

   
   Description of "Figure 1-61 Application Policies"

   
   
9. On the Create Application Grant screen, click the Add button.
   The Add Principal pop-up window displays.

   Figure 1-62 Add Principal

   
   

   
   Description of "Figure 1-62 Add Principal"

   
   
10. On the Add Principal pop-up window, perform the following actions:
    1. Select Application Role from the Type drop-down list and click the Search button.
    2. From the Searched Principals list, select ALLROLES that has been created earlier in the Application Role screen.
    3. Click the OK button in the Add Principal pop-up window and also on the Create Application Grant screen.
11. Click the Add button under Permissions section and add the two permissions one by one as mentioned below.
    • oracle.bi.publisher.runReportOnline
    • oracle.bi.publisher.accessReportOutput
    The Create Application Grant - Permissions screen displays.

    Figure 1-63 Create Application Grant

    
    

    
    Description of "Figure 1-63 Create Application Grant"

    
    

    The confirmation screen displays with a message stating that a security added successfully.

12. Login into the BI Publisher , http/s:<hostname>:<port>/xmlpserver.
13. Click Administration.
14. Click Roles and Permission under Security Center and check whether the added role (in em) is displayed or not, if not, restart the servers.
    The BIPublisher - Administration screen displays.

    Figure 1-64 BIPublisher - Administration

    
    

    
    Description of "Figure 1-64 BIPublisher - Administration"

    
    
15. Click Catalog, select the folder that has been created.
    The BIPublisher - Catalog screen displays.

    Figure 1-65 BIPublisher - Catalog

    
    

    
    Description of "Figure 1-65 BIPublisher - Catalog"

    
    
16. Click Permissions under the Tasks.
    The Permissions pop-up displays.

    Figure 1-66 Permission

    
    

    
    Description of "Figure 1-66 Permission"

    
    
17. Delete all the roles if any present.
18. Click the Add button.
19. Click the Search button in the Add Roles pop-up window.
20. Select the role that has been created and click the Move button and then click OK.
    The role will be added in the Permissions pop-up window.

    Figure 1-67 Permissions - Add Roles

    
    

    
    Description of "Figure 1-67 Permissions - Add Roles"

    
    
21. Select the options that should be granted to the particular role and check if permissions are only granted to items in the folder if necessary.
    Now the reports in the folder will be accessed accordingly based on roles.

    Note:

    Similarly, you can set the permissions at the report level also for a particular role.
22. Login in to BI Publisher http://server:port/xmlpserver.
23. Click Administration.
    The Administration screen displays.

    Figure 1-68 Administration

    
    

    
    Description of "Figure 1-68 Administration"

    
    
24. Under Data Sources, click JDBC Connection.
    The Administration - JDBC screen displays.

    Figure 1-69 Administration - JDBC

    
    

    
    Description of "Figure 1-69 Administration - JDBC"

    
    
25. Click Add Data Source to create the data source with name as FCSOA and use SOA schema details to create the same.
    The Add Data Source screen displays.

    Figure 1-70 Add Data Source

    
    

    
    Description of "Figure 1-70 Add Data Source"

    
    
26. Under Security, add FCUBS roles to Allowed Roles.
    The Add Data Source (Security) screen displays.

    Figure 1-71 Add Data Source (Security)

    
    

    
    Description of "Figure 1-71 Add Data Source (Security)"

    
    
27. Click Test Connection.
28. Once the connection is established successfully, click Apply.
29. Follow steps 25 to 28 to create the data source for FCUBS Schema and specify the name as FCBIPBPEL.