Introduction to Oracle BI Publisher 12c
Course Agenda00:00:00
Functions of Reporting Systems including Challenges
Salient Features of BI Publisher
BI Publisher as a Strategic Reporting Solution for All Applicationss
Overview of Oracle BI Foundation Suite
Introducing BI Publisher Paradigm
Overview of Oracle BI EE
Overview of Oracle Fusion Middleware
Draft Lesson
BI Publisher Technology and Architecture
Multitier Architecture00:00:00
Internationalization and Language Support
Supported Data Sources
Layout Templates
Document Generation Process and Output Formats
Bursting Overview
Functional Components
Enterprise Server Architecture and Performance and Scalability
Getting Started with BI Publisher
Managing Repository Objects00:00:00
Viewing Reports
Configuring Report Properties
Using Create Report wizard to Create Reports
Selecting Data: Data Model, Spreadsheet, and BI Subject Area
Logging In, the Home Page, and Global Header, and Setting Account Preferences
Managing Favorites
Draft Lesson
Using the Data Model Editor
Viewing Data and Saving Sample Data Sets
Configuring Parameter Settings and Viewing Reports with Parameters
Adding Parameters and LOVs to the Query
Creating a Simple Data Model based on a SQL Query Data Set
Exploring the Data Model Editor UI and the Supported Data Sources
Exploring the Schemas Used in the Course
Creating a Private Data Source
Using Query Builder to Build a Query
Working with Layout Editor
Creating Boilerplates
Working with Lists, Gauges and Pivot Tables
Creating a Layout by Using a Basic Template
Inserting a Layout Grid
Adding a Table, Formatting Columns, Defining Sorts and Groups, and Applying Conditional Formats
Adding Repeating Sections, Text Items, and Images
Opening the Layout Editor and Navigating the Layout Editor UI
Inserting and Editing Charts, and Converting Charts to a Pivot Tables
Using Template Builder to Create RTF Templates
Exploring the Basic and Form Field Methods
Creating an RTF Template from a Sample, Changing Field Properties, and Previewing Table Data
Designing an RTF Template for a BI Publisher Report
Adding a Chart to an RTF Template
Creating a BI Publisher Report by Using Template Builder in Online Mode
Draft Lesson
Using the BI Publisher Menu Bar
Exploring Advanced RTF Template Techniques Including Conditional Formats, Watermarks, Page-Level Calculations, Running Totals, Grouping, and Sorting
BI Publisher Server: Administration and Security
Describing Groups, Users, Roles, and Permissions
Integrating with Oracle BI Presentation Services and Oracle Endeca Server
Describing Delivery Options Including Print, Fax, Email, WebDav, HTTP Server, FTP, and CUPS
Describing the Security Model for BI Publisher and Oracle Fusion Middleware
Creating the JDBC Connections
Setting, Viewing, and Updating Data Sources
Describing and Configuring BI Publisher Scheduler
Describing the Administration Page
Scheduling and Bursting Reports
Adding a Bursting Definition to a Data Model
Managing and Viewing a Report Job
Scheduling a Bursting Job
Viewing Report Job History
Scheduling a Report with Trigger
Describing Bursting
Scheduling and Describing a Report Job and Related Options
Integrating BI Publisher with Oracle BI Enterprise Edition
Configuring Presentation Services Integration
Creating a Data Model and Report based on a BI Server SQL Query
Navigating Oracle BI EE
Adding a BI Publisher Report to an Oracle BI EE Dashboard
Creating a Data Model and Report based on an Oracle BI Analysis
Creating a Report based on OBI EE Subject Area
Creating Data Models and BI Publisher Reports Based on Other Data Sources
Creating a BI Publisher Report Based on CSV Data source
Explaining Proxy Setting for Web Services and HTTP Data Sources
Creating a BI Publisher Report based on an External Web Service
Describing the Web Services Data Source
Configuring Presentation Services Integration
Creating a BI Publisher Report based on an HTTP Data Set
Describing the HTTP (XML/RSS Feed) Data Source
Creating a BI Publisher Report Based on XML File