In this Business Intelligence course, you will learn how to get started with Oracle BI Publisher 184.108.40.206.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.
This lesson covers how to get started with Oracle BI Publisher 220.127.116.11.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.
This lesson shows you the required software and system requirements in order to successful download and install the software.
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
In this lesson you will be shown step by step how to install the Oracle Database 12c software required for this course.
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.
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.
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.
This part shows you how to start the software after an initial installation and going forward whenever you intend to use the software.
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)
This lesson demonstrates how to get started with Oracle BI Publisher 18.104.22.168.0 and later versions
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.
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.
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.
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.
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 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.
In this lesson you will learn how to add parameters to the data model.
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.
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.]
In this lesson you will edit parameters and view them in the Report Viewer.
This part will show you how to use the Viewer menu in order to view the report in Interactive view within a browser window.
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.
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.
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.
This lesson will show you how to insert a Gauge Chart and/or a Pivot Table to your report.
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.
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.
This lesson demonstrates to you how to build and upload your RTF templates in a disconnected mode which is sometimes called Offline mode.
This lesson is a continuation of lesson 28 "Building an RTF Template in Offline Mode- Part I"
This lesson is a continuation of lesson 29 "Building an RTF Template in Offline Mode- Part II"
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.
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.
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.
This is a very short lesson and demonstrates how to use the Validate Template utilities available in Template Builder.
This is a very short lesson and demonstrates how to use Field Browser utilities available in Template Builder.
This is a very short lesson and demonstrates how to use Check Accessbility utilities available in Template Builder.
This lesson shows you step by step how to administer BI publisher by demonstrating how to create data sources and then how to create roles using the Oracle Administration Console.
Habergeons Technologies specializes in oracle software and provides business intelligence solutions and application development mainly using Oracle products.
The instructor of this course is Ian: He is a Certified Oracle Business Intelligence Implementation specialist and has worked with Oracle software including Oracle Databases, ODI and OBIEE for over 9 years on versions 9i, 10g, 11g and 12c.
We look forward to assisting you attain your learning goals.