Duration
3 Days
18 CPD hours
This course is intended for
Analyst
Developer
End User
Implementer
Overview
Schedule and Burst Reports
Perform Translations
Create Reports Integrated With Oracle BI EE
Administer BI Publisher Server
Describe BI Publisher Technology and Architecture
Create reports from OBI EE data sources
Create and Modify Data Models
Create RTF Templates by Using Template Builder
Explore and Use the Form Field Method for Creating RTF Templates
Create Layouts by Using the Layout Editor
This Oracle BI Publisher 12c training will help you build a foundation of understanding how to best leverage this solution. Through Classroom Training or Live Virtual Class Training, you'll learn the ins and outs of how to use this solution.
BI Publisher Technology and Architecture
Functional Components
Layout Templates
Multitier Architecture
Enterprise Server Architecture and Performance and Scalability
Document Generation Process and Output Formats
Supported Data Sources
Bursting Overview
Internationalization and Language Support
Getting Started with BI Publisher
Logging In, the Home Page, and Global Header, and Setting Account Preferences
Viewing Reports
Managing Repository Objects
Managing Favorites
Using Create Report wizard to Create Reports
Selecting Data: Data Model, Spreadsheet, and BI Subject Area
Configuring Report Properties
Using the Data Model Editor
Exploring the Schemas Used in the Course
Exploring the Data Model Editor UI and the Supported Data Sources
Creating a Private Data Source
Creating a Simple Data Model based on a SQL Query Data Set
Using Query Builder to Build a Query
Viewing Data and Saving Sample Data Sets
Adding Parameters and LOVs to the Query
Configuring Parameter Settings and Viewing Reports with Parameters
Working with Layout Editor
Opening the Layout Editor and Navigating the Layout Editor UI
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
Inserting and Editing Charts, and Converting Charts to a Pivot Tables
Adding Repeating Sections, Text Items, and Images
Working with Lists, Gauges and Pivot Tables
Creating Boilerplates
Using Template Builder to Create RTF Templates
Using the BI Publisher Menu Bar
Creating an RTF Template from a Sample, Changing Field Properties, and Previewing Table Data
Adding a Chart to an RTF Template
Designing an RTF Template for a BI Publisher Report
Creating a BI Publisher Report by Using Template Builder in Online Mode
Exploring the Basic and Form Field Methods
Exploring Advanced RTF Template Techniques Including Conditional Formats, Watermarks, Page-Level Calculations, Running Totals, Grouping, and Sorting
BI Publisher Server: Administration and Security
Describing the Administration Page
Creating the JDBC Connections
Setting, Viewing, and Updating Data Sources
Describing the Security Model for BI Publisher and Oracle Fusion Middleware
Describing Groups, Users, Roles, and Permissions
Describing Delivery Options Including Print, Fax, Email, WebDav, HTTP Server, FTP, and CUPS
Describing and Configuring BI Publisher Scheduler
Integrating with Oracle BI Presentation Services and Oracle Endeca Server
Scheduling and Bursting Reports
Scheduling and Describing a Report Job and Related Options
Managing and Viewing a Report Job
Viewing Report Job History
Scheduling a Report with Trigger
Describing Bursting
Adding a Bursting Definition to a Data Model
Scheduling a Bursting Job
Integrating BI Publisher with Oracle BI Enterprise Edition
Configuring Presentation Services Integration
Navigating Oracle BI EE
Creating a Report based on OBI EE Subject Area
Creating a Data Model and Report based on a BI Server SQL Query
Creating a Data Model and Report based on an Oracle BI Analysis
Adding a BI Publisher Report to an Oracle BI EE Dashboard
Creating Data Models and BI Publisher Reports Based on Other Data Sources
Configuring Presentation Services Integration
Describing the Web Services Data Source
Describing the HTTP (XML/RSS Feed) Data Source
Explaining Proxy Setting for Web Services and HTTP Data Sources
Creating a BI Publisher Report based on an External Web Service
Creating a BI Publisher Report based on an HTTP Data Set
Creating a BI Publisher Report Based on XML File
Creating a BI Publisher Report Based on CSV Data source
Performing Translations
Describing Translation Types
Translating by Using the Localized Template Option
Translating by Using the XLIFF Option
Managing XLIFF Translations on BI Publisher Server
Describing the Overall Translation Process
Describing Catalog Translation
Exporting and Importing the XLIFF for a Catalog Folder
Additional course details:
Nexus Humans Oracle BI Publisher 12c R1: Fundamentals training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward.
This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts.
Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success.
While we feel this is the best course for the Oracle BI Publisher 12c R1: Fundamentals course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you.
Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.