Udemy Business

Teach on Udemy

Turn what you know into an opportunity and reach millions around the world.

Learn More

Your cart is empty.

Keep shopping

Oracle Business Intelligence Publisher (OAS BIP)

Name: Oracle Business Intelligence Publisher (OAS BIP)
Rating: 4.5 (699 reviews)

Oracle Analytics Server OAS - Oracle BI Publisher 2023 and Oracle Analytics

Created byMohammed Abdelkarim

Last updated 11/2025

English

English [Auto],Spanish [Auto],

What you'll learn

If you are looking for a simple Business Intelligence Tool to present your data
You will learn how to create Brochures, Certifications and Templates by using Pixel Perfect Reports and BI Analytics
You will learn how to create Reports by different types of charts
Manage the Weblogic server, groups and users
Overview about Oracle Analytics Server OAS and their products (DV, Analytics and xmlpserver)

Course content

13 sections • 85 lectures • 17h 35m total length

Training Agenda2:11
BI Publisher Overview5:20

Installation of a supported Java Development5:12
Set JAVA_HOME Environment Parameter1:33
Installation of Fusion Middleware Infrastructure7:43
Installation of the OAS binaries7:25
Install the OAS binaries into the existing WebLogic Middleware home with the Oracle Analytics installer, verify the Java version, and install required Visual C++ runtimes; repository creation is next.
RCU (Repository Creation Utility)8:35
Open the RCU (repository creation utility) from Oracle home, run the rcu.bat, configure the default database connection and prefixes, and complete the prerequisites to create the required schemas for WebLogic.
Configuration of OAS into Weblogic Domain15:28
Installing Oracle BI Administration Tool and open RPD on online and offline mode12:58
Install and configure the Oracle client tool, create an ODBC data source, and open the Oracle administration tool to access the RPD online and offline.

Create Data Sources3:37
Create Data model by SQL Query – Writing SQL Query5:47
Parameters List of Values LOV9:51
Refresh other parameters on change4:54
Create Data model by SQL Query - Query Builder8:45
Create Data model with Aggregation function4:45
Create Data model by using flat file and Blend your data3:46
Create a Dataset Using Excel File12:25
Create dataset models in BI publisher using Excel files with one or more tables, define names for multiple tables, map headers to columns, and configure parameters and relationships.
Create a Dataset Using XML File4:31
Create a Dataset Using an Analysis7:44
Regarding the creation of Subject Areas featured in this video, please consult Section 8, 'Creating Oracle BI Repository (RPD),' in Chapters 54-66 for a detailed explanation on how to create a subject area
Create a Dataset Using DV Dataset5:37

Create Report Using report builder6:52
Create a report in Oracle Business Intelligence Publisher using guide me or report editor, build a chart and pivot table from a data model, and export to pdf or PowerPoint.
Create Report using Report Editor11:31
BI Publisher is an Interactive report22:02
Component’s Properties16:10
Adding List9:11
Master-Detail Reports in BI Publisher37:02
Formulas in BI Publisher Report Builder15:43
Learn to use predefined and custom formulas in BI Publisher Report Builder to compute new salaries, totals, averages, and rankings from joined Oracle HR data and CSV salary files.

Building an RTF Template By using Microsoft Office25:53
Building an RTF Template - Online mode16:23
Building an RTF Template - Offline mode13:20
Create style template7:48
Configuring Delivery Options2:53
Using BI Publisher to Show Images from BLOB Data24:15
Create Excel Template for BI Publisher20:12
Splitting an RTF Template - Inserting Conditionally Page Breaks7:41
Creating Alternating Row Backgrounds in BI Publisher9:30
Learn to create alternating row backgrounds in BI Publisher for report builder and RDF templates using conditional formatting, hex color codes, and the alternate row color property.

Create Data model by using Call procedure13:17
Create Data model by using NON-standard SQL9:37
Create Data model by using file and Blend your data10:19
Use Oracle DB function in Oracle BI Publisher8:37
Event Triggers in BI Publisher- System Variables19:46
Event Triggers in BI Publisher - User parameters18:55
Bursting in BI Publisher25:25
Shows how Oracle BI Publisher bursts data by department, generating customized invoices, pay slips, and reports from a single query, using templates, output formats, and delivery channels.
Data model - Create Subgroups9:09
Create subgroups within a data model to organize data efficiently in Oracle BI Publisher. Build a report with department details and its employees using repeating groups and page breaks.
Data model - Create Group-Level Aggregate Elements10:45
Data model - Group Filters3:26
Data model - Global-Level Functions10:34
Accessing Reports via a URL24:31
Printing Barcodes in BI Publisher Using RTF Templates10:21
Printing Barcodes in BI Publisher Using Report Builder11:23

Create an Oracle BI Repository RPD17:10
Create an Oracle BI Repository RPDor Create a Semantic Modelby Using Oracle BI Administration Tool
How to open an Oracle BI Repository RPD online
How to save RPD file
How to open Repository RPD file in offline mode
Creating New Database and Connection Pool11:44
Creating New Database and Connection Pool
Import Metadata
Data Source Name
How to check the Physical Diagram
Data Source Name configuration4:50
Data Source Name configuration
Create A New Business Model and Mapping12:07
Create A New Business Model and Mapping
Add tables to the Business Model and Mapping
Fact and Dimension Tables
Remove all Tables from BMM Layer
Merge detailed dimensions into a single dimension12:22
Merge detailed dimensions into a single dimension
How to create Measures12:04
How to create Measures
Rename Measures, Dimensions, and logical names
Presentation Layer – Create a new Subject Area6:20
Presentation Layer – Create a new Subject Area
Enable the BMM Model
Check Global Consistency
How to upload RPD12:07
Learn how to upload an rpd file to Oracle BI publisher, perform a global consistency check, use command-line or web interface methods, and reload metadata to access subject areas.
How to Create BI Publisher reports using Subject Area6:28
Create BI Publisher reports by selecting a subject area and a layout. Drag measures like number of orders and status, preview, customize, and save to BI Publisher catalogs.
Dimension Hierarchies21:15
How to create Level based Hierarchy
How to create Time Dimension21:00
Create a time dimension in Oracle BI Publisher by building a date table, forming a chronological, level-based hierarchy from year to day, and linking it to orders for flexible dashboards.
Logical Column – Sort Order7:45
Skipped & Ragged Hierarchies3:41
Explore ragged versus skipped level hierarchies in level-based and level-space structures, learn definitions of unbalanced branches and non-uniform level gaps, and know when to apply each in BI publisher.

How to create Oracle Analytics reports using subject area7:49
Learn to create Oracle Analytics reports from a subject area by selecting columns, choosing chart types, and saving reports, using steps like new view, graph, pie chart, and tables.
Edit Oracle Analytics Report Details - Part 126:11
Learn to edit Oracle Analytics report details, including criteria, sort, edit formula, column properties, and conditional formatting. Explore filters, prompts, interactions, and saving dashboard-linked filters for reusable reports.
Edit Oracle Analytics Report Details - Part 218:37
Edit Oracle Analytics Report Details - Part 315:29
Creating Oracle Analytics reports based on Orders Subject Area18:10
Creating Oracle Analytics reports based on Orders_Items Subject Area13:53
Creating Oracle Analytics reports based on Inventories Subject Area7:37

Oracle Analytics Dashboard - Part 128:07
Learn to create and configure Oracle analytics dashboards, including pages and sub pages, objects, prompts, navigation, styling, HTML, JavaScript, and CSS contents, and print export options for a landing page.
Oracle Analytics Dashboard - Part 211:01
Oracle Analytics Dashboard - Part 321:34
1. Create dashboard for each folder
2. Add Dashboard Page / Add subpage
3. Dashboard Objects
4. Change Dashboard Style
5. Dashboard Properties
6. Dashboard Report Links
7. Hide Page
8. Print & Export Options
9. Page Report Link
Oracle Analytics Dashboard - Part 4 - Creating Dashboard Prompts and Filters23:11
How to Create Dashboard Prompts and Filters
Oracle Analytics Dashboard - Part 5 - Landing Page and Portal Path3:43
How to add Landing Page and Portal Path
Managing BI Publisher Objects4:24

Requirements

Basic knowledge of Oracle SQL

Description

If you are looking for a simple Business Intelligence tool to present your data then come to the right place

In this course you will learn how to create pixel prefect report, certificates and brochures

We will start diving from scratch to the advanced topics

The journey will begin with Introduction to BI Publisher,

Architecture,

Build your data model,

Blending your data from two different data sources

Use group functions

Create reports with different chart types

Build your template by using Microsoft word

Create style template

Schedule report jobs

Localization

Create OBIEE Dashboards

Administrating BI Publisher by Stop and start Oracle analytics server

Login to Console and create Users

Login to EM and assign roles to the users

So are you ready

Then sign up today to access presentation, queries and resources and sample questions for Oracle Cloud Platform Enterprise Analytics 2023

And full support

Training Agenda:

• Introduction to BI publisher

• Login to Oracle Analytics Server including DV, OBIEE and BI Publisher

• Define Data source

• Create data models by using SQL Query and Query Builder

• Create BI Publisher reports using report builder

• Building an RTF Template in online and offline mode

• Create a Style Template

• Configure Delivery Options

• Schedule Reports Jobs

• Translate or BI Publisher Localization

• Creating OBIEE Dashboards and adding BI Publisher reports to Dashboard Pages

• Managing BI Publisher Objects

• Administrating BI Publisher

Who this course is for:

Anyone want to learn a simple Business Intelligence tool

Oracle Business Intelligence Publisher (OAS BIP)

What you'll learn

Explore related topics

Course content

Introduction2 lectures • 8min

Complete Steps to Install and Configure Oracle Analytics Server OAS 6.47 lectures • 59min

Build your data model11 lectures • 1hr 12min

Create BI Publisher Reports7 lectures • 1hr 59min

Building an RTF Template9 lectures • 2hr 8min

Advanced Topics in BI Publisher14 lectures • 3hr 6min

Schedule Report Jobs and Localization3 lectures • 41min

Creating Oracle BI Repository (RPD)13 lectures • 2hr 29min

Creating Oracle Analytics reports using Subject Area7 lectures • 1hr 48min

Dashboards Managing Objects6 lectures • 1hr 32min

Requirements

Description

Who this course is for: