1.2.8 BIP Interactive reports configuration

This topic explains the configuration of BIP Interactive Reports.

1. Login to the BIP domain console, http/s://<hostname>:<port>/<console>.
2. To add the FCJCustomProvider, refer the steps from /Custom Provider Configuration.
3. After adding, navigate to security realms, then myrealm, and then Users and Groups and check if the users from the schema are displayed in the Users tab, and Roles from the schema are displayed under the Groups Tab.
   The Users and Groups screen is displayed.

   Figure 1-56 Settings for myrealm - Users and Groups

   
   

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

   
   
4. Login to the Enterprise Manager (em) http/s:<hostname>:<port>/em.
   • Right click on the domain (in which BI suite is installed) under the WebLogic domain.
   • Go to security and then navigate to application roles.
5. Navigate to the Application Roles screen as mentioned in below screenshot.
   The Application Roles screen is displayed.

   Figure 1-57 Application Roles

   
   

   
   Description of "Figure 1-57 Application Roles"

   
   
6. After navigating to the Application Roles screen, specify the following details.
   • Select the Application Stripe as obi from the dropdown list.
   • Click on the Search button.
   • Click on Create button to add a role.
7. After clicking on Create button, specify the fields.
   The Create Application Role screen is displayed.

   Figure 1-58 Create Application Role

   
   

   
   Description of "Figure 1-58 Create Application Role"

   
   
8. On the Create Application Role screen, specify the following details.
   1. Enter the Role name (mandatory), Display name (optional) and, Description (optional).
   2. Click on the Add button.
   3. Select Type as Group from the dropdown list in the Add Principal pop-up window.
   4. In the Advanced Option check the checkbox and select the type as Group below
      • Click on the Search button, if the roles are listed then select the roles like ALLROLES-000, ADMINROLE-000 from the list.
      • Enter the Principal Name (mandatory), which is the role present in the FCUBS (ex: ALLROLES-000, ADMINROLE-000), Display Name (optional).
   5. Click on the OK button in the Add Principal pop-up window and also on the Create Application Role screen.

      Figure 1-59 Create Application Role

      
      

      
      Description of "Figure 1-59 Create Application Role"

      
      
9. After getting information message like A new role added successfully, then again:
   1. Right click on the domain (in which BI suite is installed) under the WebLogic domain.
   2. Go to Security and navigate to Application Policies.
      The Navigation - Security - Application Policies screen is displayed.

      Figure 1-60 Navigation - Security - Application Policies

      
      

      
      Description of "Figure 1-60 Navigation - Security - Application Policies"

      
      
10. After navigating to the Application Policies screen, specify the following details.
    1. Select the Application Stripe as obi from the drop-down and Principal Type as Application Role.
    2. Click on the search button.
    3. Select BIConsumer (it should be highlighted) from the list and click on the Create button.
    The Application Policies screen is displayed.

    Figure 1-61 Application Policies

    
    

    
    Description of "Figure 1-61 Application Policies"

    
    
11. After navigating to the Create Application Grant screen,
    1. Click on the Add button.
       The Add Principal pop-up window is displayed.

       Figure 1-62 Add Principal

       
       

       
       Description of "Figure 1-62 Add Principal"

       
       
    2. Select Type as Application Role from the dropdown list in the Add Principal pop-up window and click on the search (triangle icon instead of the word search TBD) button.
    3. From the Searched Principals list, select ALLROLES that has been created earlier in the Application Role screen.
    4. Click on the OK button in the Add Principal pop-up window and on the Create Application Grant screen.
       The Create Application Grant screen is displayed.

       Figure 1-63 Create Application Grant

       
       

       
       Description of "Figure 1-63 Create Application Grant"

       
       
    5. Click on the Add button under Permissions and add the two permissions one by one as mentioned below.
       • oracle.bi.publisher.runReportOnline
       • oracle.bi.publisher.accessReportOutput
12. After getting information message as A security added successfully, then:
    1. Login into the BIPublisher , http/s:<hostname>:<port>/xmlpserver.
    2. Click on the Administration.
    3. Click on the Roles and Permission under Security Center and check if the added role (in em) is displayed. If not, restart the servers.
       The BIPublisher - Administration screen is displayed.

       Figure 1-64 BIPublisher - Administration

       
       

       
       Description of "Figure 1-64 BIPublisher - Administration"

       
       
13. Click on the Catalog, select the folder that has been created, and click on Permissions under the Tasks.
    BIPublisher - Catalog screen is displayed.

    Figure 1-65 BIPublisher - Catalog

    
    

    
    Description of "Figure 1-65 BIPublisher - Catalog"

    
    
14. Click on the Add button.
    The Add Roles screen is displayed.

    Figure 1-66 Add Roles - Permission

    
    

    
    Description of "Figure 1-66 Add Roles - Permission"

    
    
15. Click on the Search button in Add Roles pop-up window.
16. Select the role that has been created and click on the Move button and click on OK.
17. Finally, the role will be added, and select the options that have to be provided for the particular role and check if the permissions are only to items within the folder if necessary.
    The Permissions with added role is displayed.

    Figure 1-67 Permissions - Added Role

    
    

    
    Description of "Figure 1-67 Permissions - Added Role"

    
    
18. Now the reports in the folder will be accessed accordingly based on the roles.

    Note:

    Similarly, we can set the permissions at the report level also for a particular role.
19. Login in to Bi Publisher http://server:port/xmlpserver.
20. Click on the Administration.
    The Administration screen is displayed.

    Figure 1-68 Administration

    
    

    
    Description of "Figure 1-68 Administration"

    
    

    Figure 1-69 Administration - JDBC Connection

    
    

    
    Description of "Figure 1-69 Administration - JDBC Connection"

    
    
21. Under Data Sources, click on JDBC Connection.
    The Administration - JDBC screen is displayed.

    Figure 1-70 Administration - JDBC

    
    

    
    Description of "Figure 1-70 Administration - JDBC"

    
    
22. Click on Add Data Source and create the data source with data source name as FCSOA and use soa schema details to create the same.
    The Administration - JDBC - Add Data Source screen is displayed.

    Figure 1-71 Administration - JDBC - Add Data Source

    
    

    
    Description of "Figure 1-71 Administration - JDBC - Add Data Source"

    
    
23. Add the FCIS roles to Allowed Roles under Security.
    Administration - JDBC - Add Data Source (Security) screen is displayed.

    Figure 1-72 Administration - JDBC - Add Data Source (Security)

    
    

    
    Description of "Figure 1-72 Administration - JDBC - Add Data Source (Security)"

    
    
24. Click on the Test Connection.
25. Once the connection is established successfully, click on Apply.
26. Follow steps 15 to 17 to create the data source for FCIS Schema and give the name FCBIPBPEL.