(OBI12cPF) Oracle BI Publisher 12c R1: Fundamentals

Описание курса

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.

Learn To:

• Create data models by using the Data Model Editor.
• Create BI Publisher reports based on data models.
• Create report layouts by using the Layout Editor (online).
• Create reports based on OBI EE data sources.
• Publish the reports on OBI EE Dashboards.
• Schedule reports and burst these reports.
• Creating Reports
  
  Furthermore, you'll learn how to create layouts for reports, then publish the highly formatted reports to a wide range of destinations (printers, faxes, email, and document repositories via FTP or WebDav). Publisher's report formats can also be designed by using familiar Microsoft Office tools like Microsoft Word and Excel.
  
  Scheduling and Bursting Reports
  Oracle BI Publisher 12c provides best of breed capabilities for scheduling and bursting reports. By investing in this course, you'll learn how to schedule and manage scheduled jobs, along with bursting reports to other destinations.
   

Цель курса:

• 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

   

Аудитория курса:

• End Users
• Application Developers
• Business Analysts
• Technical Consultant
• Functional Implementer
• Reports Developer
• Business Intelligence Developer
• Delivery

Программа курса

Introduction to Oracle BI Publisher 12c
Course Agenda. 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. 

BI Publisher Technology and Architecture
Multitier Architecture. 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 Objects. 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. 

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. 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
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 CSV Data source. 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. 

Performing Translations
Exporting and Importing the XLIFF for a Catalog Folder. Managing XLIFF Translations on BI Publisher Server. Describing the Overall Translation Process. Translating by Using the XLIFF Option. Translating by Using the Localized Template Option. Describing Catalog Translation. Describing Translation Types.