Category: Oracle BI Report

Oracle Business intelligence roles apply to both Oracle Business Intelligence publisher and Oracle Fusion Transactional Business Intelligence (OTBI). They grant access to business intelligence functionality such as ability to run or authors reports. Role Name Description BI Consumer Role Runs Business Intelligence reports. BI Author Role Creates and edits reports. BI Administrator Role Performs administrative […]

In this section, we will see how to create BIP report with dependent parameters in fusion. Let us create sample BIP report with two parameters: Navigation—-> Tools—>Reports and Analytics Go to Browse Catalog—>New —–>Data Model. Create SQL Query to create Data Model. Go to Diagram—->SQL Query. Give Name, Data Source and Type of SQL as […]

In the last section, we have seen how to schedule BIP report with email delivery. While sending output to destination, we can send the output in Zip format. To send output in Zip format, we need to enable below checkbox while scheduling BIP report. Now let us submit this schedule BIP report. Here we can […]

BIP scheduling is used to run the BIP report at specified intervals. We can have different delivery options for BIP report scheduling like EMAIL, FTP, or UCM (CS), FAX, web folder, printer. In this section, we will see how to schedule BIP report with email delivery option. Let us create sample BIP report for AP […]

We can use information about current user in BIP report data model using system Variables. The user information is stored in system variables as shown below: System Variable Description xdo_user_name User ID of the user submitting the report xdo_user_roles Roles Assigned to user submitting the report. Example: XMLP_ADMIN_XMLP_SCHEDULER. xdo_user_report_oracle_lang Report language from user’s account preferences. […]