Oracle Business Intelligence Publisher 11g (Oracle BIP 11g)

Name: Oracle Business Intelligence Publisher 11g (Oracle BIP 11g)
Rating: 3.8 (166 reviews)

Working with Oracle BI Publisher 11g from simple install to building complex reports

Created byIan Mwila

Last updated 12/2017

English

What you'll learn

•Install Oracle database software, Oracle Business Intelligence Publisher Enterprise Edition
•Launch and Log in to the BI Publisher
•Set Preferences
•Define Data Sources
•Create a Data Model
•Create a Report using Report Editor
•Use Layout Editor
•Schedule Reports (Create Report Jobs)

Course content

5 sections • 37 lectures • 3h 1m total length

Oracle Business Intelligence Publisher 11g3:30
This lesson covers how to get started with Oracle BI Publisher 11.1.1.6.0 and later versions to create simple reports and complex reports. You will learn how to create a data model, and a report layout using the online Layout Editor. In addition, you will learn how to schedule reports.
System and Software Requirements1:18
This lesson shows you the required software and system requirements in order to successful download and install the software.
Download Required Software4:14
This lesson shows you all the required software you will need to download from Oracle.com and also which version of the software to download
Installation of Oracle Database 12c5:02
In this lesson you will be shown step by step how to install the Oracle Database 12c software required for this course.
Installation of ODBC - Instant Client8:17
This lesson walks you through the process of installing Open Database Connectivity (ODBC) - instant client software in order to connect to the Oracle database using different applications.
Install Repository Creation Utility - RCU4:32
This lesson shows you how to install the Repository Creation Utility(RCU) step by step required for creating repository tables in the Oracle database used in this course.
Installation of Oracle BI Publisher 11g6:38
This lesson will show you step by step how to install the Oracle Business Intelligence Publisher 11g software which you will be using through out this course. At the conclusion of the installation steps process you will a working software required for all succeeding lessons.
Starting BI Publisher on Windows6:10
This part shows you how to start the software after an initial installation and going forward whenever you intend to use the software.
Stopping BI Publisher on Windows3:12
This part shows you the right way to STOP the software.(following start and stop instructions shown in these lessons is important in order to avoid corrupting configuration files)
Getting Started with Oracle BI Publisher4:16
This lesson demonstrates how to get started with Oracle BI Publisher 11.1.1.6.0 and later versions
Oracle BI Publisher User Interface5:17
This topic will cover logging in to the BI Publisher and navigating through the Home page, using the catalog objects, managing the favorites, and viewing the user account settings.

Creating a New Folder1:49
You will learn how to create a new folder in the catalog. You will use this folder to store/save all the objects that you create in this lesson.
Uploading a Resource to the Catalog2:15
This lesson will show you how to upload a predefined object or a resource to the catalog.
This topic will show how to upload a predefined data model to the catalog. A downloadable file had been provided; you will first need to unzip the file before you can upload it to BI Publisher.
Setting My Account Preferences5:31
In this lesson you will be shown how to set your account preferences for using the My Account option for your login for your user credentials.
Configuring the Data Sources5:08
In this lesson, you will learn how to configure a JDBC connection to Oracle Database sample schema. (OE Schema). [Through JDBC connections Oracle BI Publisher supports various types of Data Sources such as Oracle Database]
Creating a Data Model - Part I9:02
Creating a new data model or selecting an existing/predefined data model is the first step in creating a BI Publisher report. In this lesson you will learn how to create a Data Model based on SQL query using the JDBC connection that you defined in lecture 15.
Creating a Data Model - Part II9:42
In this lesson you will learn how to add parameters to the data model.

Creating a New Report3:31
In this lesson you will create a New Report with the existing Data Model Salary Report Parameters, and choose to create the report by using the Report Editor Option.
Creating a Report Using Report Editor - Part I4:11
In this lesson you will be creating a new layout using the Layout Editor, and use it to view the reports.[Creating a New Report involves selecting the source of the data for the report, selecting the data columns to be displayed in the report, and then adding a meaningful layout for this data, defining the properties for the report parameters, and scheduling the report.]
Creating a Report Using Report Editor - Part II8:16
In this lesson you will edit parameters and view them in the Report Viewer.
Viewing a Report in Interactive View4:32
This part will show you how to use the Viewer menu in order to view the report in Interactive view within a browser window.
Creating a Report Job6:14
This lesson will demonstrate to you the different ways in which you can create a Report Job and how you can schedule a Report Job.
Managing Report Jobs5:38
This lesson will show you how to view and manage the scheduled jobs and job history.
You will also be able to edit a scheduled job and run it or resubmit and run again.
Connecting to an Email Server2:07
In order to deliver reports to multiple users, it may be necessary to connect to an email server. This lesson will show you how to use BI Publisher to connect to an email server in order to send scheduled jobs to your colleagues.
Inserting a Gauge Chart or a Pivot Table5:44
This lesson will show you how to insert a Gauge Chart and/or a Pivot Table to your report.

26. Installing Template Builder5:17
In this lesson you will learn how to download the Template Builder add-in, and install it. [Please note that if your MS Word is 2013 or greater do not download the template builder as demonstrated in this lesson, but rather follow instructions as provided in lesson 27]
This lesson lesson has all the required templates uploaded to the site for your download.
27. If Template Builder fails to Install3:23
This lesson troubleshoots installation issues you may experience if you are using Microsoft Word 2013 or later. You are shown how to download alternative Oracle BI Publisher Desktop tools which will work with later versions of MS Word in order for the Template Builder add-in to install correctly.
28. Building an RTF Template in Offline Mode - Part I9:13
This lesson demonstrates to you how to build and upload your RTF templates in a disconnected mode which is sometimes called Offline mode.
29. Building an RTF Template in Offline Mode - Part II4:34
This lesson is a continuation of lesson 28 "Building an RTF Template in Offline Mode- Part I"
30. Building an RTF Template in Offline Mode - Part III2:14
This lesson is a continuation of lesson 29 "Building an RTF Template in Offline Mode- Part II"
31. Building an RTF Template in Online Mode - Part I8:19
This lesson is a first part of two and it demonstrates how to design an RTF template while logged into BI Publisher. You can build and upload your template via a direct connection with the BI Publisher Server, called Online mode.
32. Building an RTF Template in Online Mode - Part II3:07
This lesson is a second part of two and is a continuation of lesson 3. It continues the demonstration of how to design an RTF template while logged into BI Publisher. You can build and upload your template via a direct connection with the BI Publisher Server, called Online mode.
33. Working with a Pivot Table in an Existing RTF Template5:06
This lessonc covers adding a pivot table to an existing RTF template. You will open an existing RTF template to preview a chart, and add a pivot table to the template.
34. Using Template Builder Utilities - Validate Template2:01
This is a very short lesson and demonstrates how to use the Validate Template utilities available in Template Builder.
35. Using Template Builder Utilities - Field Browser3:00
This is a very short lesson and demonstrates how to use Field Browser utilities available in Template Builder.
36. Using Template Builder Utilities - Check Accessibility1:25
This is a very short lesson and demonstrates how to use Check Accessbility utilities available in Template Builder.

Requirements

You should be able to use a PC at a beginner level
You should have basic relational database knowledge;
You should be able to follow step by step instructions for installing complex software and be able start and stop the software.

Description

In this Business Intelligence course, you will learn how to get started with Oracle BI Publisher 11.1.1.6.0 and later versions, such as how to install all the required software, create simple reports and more complex reports for distribution. You will also learn how to install Template Builder for MS Word and how to troubleshoot installation issues.

You will learn about creating a data model and creating and scheduling reports outside of Oracle Business Intelligence Enterprise Edition (OBIEE) when Oracle BI Publisher is delivered as a stand-alone application.

The course will also cover:

Installing required software

Creating a Data Model

Creating Reports and Scheduling Reports/jobs

Install Template Builder successfully

Create an RTF template in the Offline mode

Create an RTF template in the Online mode

The course teaches both the basics and implementation of core Oracle Business Intelligence practices you need to work successfully with this software.

Who this course is for:

This course is ideal for individuals who want to learn Oracle Business Intelligence Publisher 11g or higher
Oracle Business intelligence developer who want to go beyond the basics of OBIP

Oracle Business Intelligence Publisher 11g (Oracle BIP 11g)

What you'll learn

Explore related topics

Course content

Getting Started with Oracle BI Publisher Enterprise11 lectures • 52min

General Navigation and Preferences6 lectures • 33min

Creating Reports8 lectures • 40min

Complex formatting and Processing reports using RTF templates11 lectures • 48min

Administering Oracle BI Publisher1 lecture • 8min

Requirements

Description

Who this course is for: