In this article we will discuss on what roles are required for BI reports in Oracle Fusion, Oracle Fusion provides two major reporting capabilities for creating system reports. BIP and OTBI Reports are the two reporting tools. We can design and build new reports in the Oracle Fusion application using these two report tools.
OTBI is a very user-friendly tool that requires little technical knowledge, whereas BIP is a pure technical tool in Oracle Cloud that helps in the creation of more complicated reports and report layouts. To design reports in Oracle Fusion, we must have the appropriate application access. To create the OTBI and BIP reports, we’ll require desired roles on the Oracle cloud.
Oracle Fusion has added a reports and analytics icon to the cloud application’s reports tool. We may build both OTBI and BIP reports under reports and analytics.
Oracle Fusion Has Three Major Roles for Reports and Analytics
We must have the proper roles associated with the user account in order to access the reports and analytics. Below is a list of significant BIP report responsibilities that assist in the design and creation of BIP reports.
- BI Administrator Role
- BI Platform Author Role
- BI Consumer Role
(1) BI Administrator Role
In Oracle Cloud, BI reports play a critical role. When compared to other BI roles, this role has all of the privileges for BI reports. This job allows users to create, develop, update, run, and delete reports in Oracle Cloud. The BI Administrator role in Oracle Fusion has full access to all BI reports, reports, and analytics.
(2) BI Platform Author Role
This role is quite similar to the BI Administrator Role. This job also has full access to Oracle Cloud reports, including the ability to create, design, update, run, and delete them.
(3) BI Consumer Role
In Oracle Cloud, this role has the fewest privileges in the BI role matrix. Users with this type of role can only execute BI reports in Oracle Fusion’s reporting and analytics. This role is only for running reports. Users with this role are unable to create new reports or make any changes to the BIP report.
Reports and Analytics Security Levels
The following three levels of security can be found in reports and analytics:
- User-level security.
- Object-level security.
- Data-level security.
(1) Security at the user level (authentication of users)
The verification and confirmation of a user’s identity based on the credentials provided, such as username and password, is known as user-level security. User-level security is enabled by default in the LDAP server and policy store.
(2) Object-level security
The visibility of business logical objects is controlled at the object level, based on a user’s role. Object-level security can be configured for Oracle BI Repository items like business models and subject areas, as well as Web objects like dashboards and dashboard pages defined in the Presentation Catalog.
(3) Data-level security
Based on the user’s association with data in the transactional system, data-level security controls the visibility of data (information produced in subject areas, dashboards, analytics, and so on).