Телефон: +7 (985) 509 57 68 Поделиться:

Oracle BI Publisher 12c R1: Fundamentals

Категория: Стандартные Цена: 39825 р.

Oracle BI Publisher 12c R1: Fundamentals

Дата
04.09.19 - 06.09.19
Записаться
Записаться на курс: Oracle BI Publisher 12c R1: Fundamentals

ФИО
Телефон *
Это поле обязательно для заполнения
Электронный адрес
Введён некорректный e-mail
Текст сообщения *
Это поле обязательно для заполнения
Необходимо ваше согласие на обработку персональных данных
Цена 39825
Дни 3
Город Санкт-Петербург
Описание курса

Аннотация:

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.

Аудитория

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

Цели курса:

  • 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

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

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