
Learn to build pixel-perfect reports and brochures with bi Publisher, from architecture and data modeling to blending two data sources, charts, Word templates, dashboards, and Oracle Analytics Server administration.
Explore BI Publisher in Oracle analytics, log in to data visualization and OBIEE, browse the publisher home page, create reports and data models, manage administration and preferences, and sign out.
Install and configure Oracle Analytics Server 6.4 by setting up a supported JDK, configuring Java Home, installing Fusion Middleware WebLogic, creating the RCU repository, and configuring the domain.
Set the java_home environment variable on Windows by specifying the jdk path in system environment variables, then verify the installation with a command line check for the Java version.
Set up the Java environment and install Oracle Fusion Middleware infrastructure using the Oracle Universal Installer, including prerequisite checks, install location, and verifying the middleware home and inventory.
Install the OAS binaries into the existing WebLogic Middleware home with the Oracle Analytics installer, verify the Java version, and install required Visual C++ runtimes; repository creation is next.
Open the RCU (repository creation utility) from Oracle home, run the rcu.bat, configure the default database connection and prefixes, and complete the prerequisites to create the required schemas for WebLogic.
Configure Oracle BI publisher into a WebLogic domain by running the configuration assistant, selecting analytics and DV publisher, and setting domain, credentials, and schema.
Install and configure the Oracle client tool, create an ODBC data source, and open the Oracle administration tool to access the RPD online and offline.
Create data sources in Oracle BI Publisher using jdbc and file connections in administration; configure name, driver, and connection details, then test and add file sources with csv or xls.
Create a data model from a SQL query, define the data source, and parameters with on-change refresh. Save as sample data for XML export to report builder.
Enable interactivity in BI Publisher reports by adding from date and to date parameters and department and job id LOVs with bind variables for filtering.
Learn how to refresh other parameters on change in BI Publisher. Filter job lists by the selected department to show only related jobs.
Build a data model and data sets in Oracle BI Publisher using the query builder to create self-join between employees and managers, apply a right outer join, and define parameters.
Create a data model with aggregation functions in Oracle BI Publisher by joining employees, departments, and jobs, selecting salary, department name, and job title, and applying sum with group by.
Create a data model by using a flat file such as Excel and blend your data with an Oracle database to produce a unified dataset.
Create dataset models in BI publisher using Excel files with one or more tables, define names for multiple tables, map headers to columns, and configure parameters and relationships.
Create a dataset from an XML file in Oracle BI Publisher by uploading a UTF-8 XML from a shared directory or local folder, noting no metadata available and no grouping.
Regarding the creation of Subject Areas featured in this video, please consult Section 8, 'Creating Oracle BI Repository (RPD),' in Chapters 54-66 for a detailed explanation on how to create a subject area
Create a dataset using dv data and self-service data sets from an excel sales file, select columns, add a parameter, and build a data model for reports.
Create a report in Oracle Business Intelligence Publisher using guide me or report editor, build a chart and pivot table from a data model, and export to pdf or PowerPoint.
Create a new Oracle BI Publisher report with the report editor from an existing data model, add a header and charts, pivot table, and a repeating section for department employees.
Create interactive BI Publisher reports that filter across charts and tables via dashboards. Configure parameters, layouts, and export options including HTML, PDF, RDF, Excel, and PowerPoint.
Configure interactivity and events in Oracle Business Intelligence Publisher to control how chart selections filter other reports, and tune properties for charts, pivot tables, and repeating regions.
Add and customize a reward list in Oracle BI Publisher with drag-and-drop and vertical or horizontal layouts, styling; create a data model and report, then format and center the list.
Create a master-detail report in Oracle BI Publisher by building a data model with a master table and related detail records, applying joins, and configuring parameters and lists of values.
Learn to use predefined and custom formulas in BI Publisher Report Builder to compute new salaries, totals, averages, and rankings from joined Oracle HR data and CSV salary files.
Learn to build highly formatted Oracle BI Publisher reports using Microsoft Word integration, create templates from data models, add tables and charts, and upload templates to the Publisher server.
Learn to build an RTF template in Oracle BI Publisher online mode by designing a certificate with header, logo, dynamic fields, and repeating groups for multiple employees.
Set up an offline BI Publisher workflow by exporting XML data, designing an RTF template in Word, grouping data by department, and applying sum aggregation to show department totals.
Create a style template in BI Publisher using Microsoft Word to apply header and footer across reports, uploading a single RDF template per locale and applying it to publisher reports.
Configure delivery options in Oracle BI Publisher, including email, printer, and fax, under the delivery tab. Enter email server details, test the connection, and save the configuration.
Retrieve images stored as blob data and render them in BI Publisher using XML templates and form fields, building a blob data model to load and size images.
Learn to split an RDF template with conditional page breaks using split by page break, creating per-department pages, with PDF, RDF, and PPT outputs and mod-based controls.
Learn to create alternating row backgrounds in BI Publisher for report builder and RDF templates using conditional formatting, hex color codes, and the alternate row color property.
Learn to create BI Publisher datasets by calling a PL/SQL procedure that returns a ref cursor, using Zdo_cursor as the data model's first out parameter to filter by region.
Create non-standard SQL data sets in Oracle BI Publisher using package functions and ref cursors, test the package, and manage metadata limitations in the data model.
Create a data model by importing an Oracle database table and a flat file, join them on department ID, and build a report showing salary, salary increase, and new salary.
Learn to use Oracle database functions directly in Oracle BI Publisher SQL queries to compute manager names via concatenation and self-join, and create data models and reports.
Use event triggers in BI Publisher to run a PL/SQL function before or after a dataset refresh. Capture login, language, and locale in an audit table via a boolean function.
Learn to implement event triggers in BI Publisher to audit and monitor user parameters, create data models with parameterized queries, and log activities to an audit table.
Shows how Oracle BI Publisher bursts data by department, generating customized invoices, pay slips, and reports from a single query, using templates, output formats, and delivery channels.
Create subgroups within a data model to organize data efficiently in Oracle BI Publisher. Build a report with department details and its employees using repeating groups and page breaks.
Learn to model group level aggregate elements in a data model editor, using department as a parent and employees as children to compute sum, average, max and min salaries.
Apply group filters to the data model to retrieve a subset of records by conditional operators. In the example, filter employees by manager id 100 and view the filter indicator.
Learn to use global level functions in Oracle BI Publisher data model to apply a 5% salary increase via expressions, showing old and new salaries across the report.
Access Oracle BI Publisher reports via URL from external applications. Pass necessary parameters, choose layouts and output formats such as PDF, Word, or HTML using XPT, ZDO, and X mode.
Discover printing barcodes in BI Publisher using RTF templates by building a data model and applying the three of nine barcode font after installation.
Learn to print barcodes in BI Publisher using Report Builder by building a data model, installing the three of nine barcode font, and applying it to reports.
Learn to schedule and monitor report jobs in Oracle BI Publisher, configure output formats (PDF, HTML, Excel), destinations (email, fax, printer), and recurring schedules with notifications and diagnostics.
Learn how to translate and localize Oracle BI Publisher reports and data models by exporting and importing zf files, translating layouts, column headers, and parameters for multiple languages.
Create OBIEE dashboards and embed BI Publisher reports, arranging reports across pages, columns, and sections with drag-and-drop, then customize properties and add a home page with navigation links.
Create an Oracle BI Repository RPDor Create a Semantic Modelby Using Oracle BI Administration Tool
How to open an Oracle BI Repository RPD online
How to save RPD file
How to open Repository RPD file in offline mode
Creating New Database and Connection Pool
Import Metadata
Data Source Name
How to check the Physical Diagram
Data Source Name configuration
Create A New Business Model and Mapping
Add tables to the Business Model and Mapping
Fact and Dimension Tables
Remove all Tables from BMM Layer
Merge detailed dimensions into a single dimension
How to create Measures
Rename Measures, Dimensions, and logical names
Presentation Layer – Create a new Subject Area
Enable the BMM Model
Check Global Consistency
Learn how to upload an rpd file to Oracle BI publisher, perform a global consistency check, use command-line or web interface methods, and reload metadata to access subject areas.
Create BI Publisher reports by selecting a subject area and a layout. Drag measures like number of orders and status, preview, customize, and save to BI Publisher catalogs.
How to create Level based Hierarchy
Create a time dimension in Oracle BI Publisher by building a date table, forming a chronological, level-based hierarchy from year to day, and linking it to orders for flexible dashboards.
Fix month name sorting by using the month number as the sort key. Create a logical level key and apply global consistency so the month order displays correctly.
Explore ragged versus skipped level hierarchies in level-based and level-space structures, learn definitions of unbalanced branches and non-uniform level gaps, and know when to apply each in BI publisher.
Learn to create Oracle Analytics reports from a subject area by selecting columns, choosing chart types, and saving reports, using steps like new view, graph, pie chart, and tables.
Learn to edit Oracle Analytics report details, including criteria, sort, edit formula, column properties, and conditional formatting. Explore filters, prompts, interactions, and saving dashboard-linked filters for reusable reports.
Learn to print and export Oracle analytics reports in pdf, html, excel (formatted or data), csv, or xml, and build compound layouts with tables, charts, and dashboard prompts.
Explore how to customize Oracle Analytics charts using view properties, style, and conditional formatting, including legend, data markers, and axis labels.
Create and modify Oracle Analytics reports from the orders subject area, building pivot tables and charts for orders by employee, date, status, and customer, with formatting and interactive view switching.
Create Oracle analytics reports from the orders items subject area by building tables and charts, applying top ten by amount, and formatting totals, percentages, and view options.
Learn to create Oracle analytics reports from inventories subject area, replace nulls with zero, format data, and use pivot tables and region hierarchies for dashboards.
Learn to create and configure Oracle analytics dashboards, including pages and sub pages, objects, prompts, navigation, styling, HTML, JavaScript, and CSS contents, and print export options for a landing page.
Create and configure Oracle Analytics dashboards for orders and order items, incorporating inventory-based security segregation, page-level settings, and dynamic prompts for interactive reporting.
1. Create dashboard for each folder
2. Add Dashboard Page / Add subpage
3. Dashboard Objects
4. Change Dashboard Style
5. Dashboard Properties
6. Dashboard Report Links
7. Hide Page
8. Print & Export Options
9. Page Report Link
How to Create Dashboard Prompts and Filters
How to add Landing Page and Portal Path
Manage BI Publisher objects—folders, data models, and reports—by editing, deleting, copying, renaming, and exporting to excel; archive and migrate between development and production via analytics, preserving permissions.
If you are looking for a simple Business Intelligence tool to present your data then come to the right place
In this course you will learn how to create pixel prefect report, certificates and brochures
We will start diving from scratch to the advanced topics
The journey will begin with Introduction to BI Publisher,
Architecture,
Login to Oracle Analytics server ,
Build your data model,
Blending your data from two different data sources
Use group functions
Create reports with different chart types
Build your template by using Microsoft word
Create style template
Schedule report jobs
Localization
Create OBIEE Dashboards
Administrating BI Publisher by Stop and start Oracle analytics server
Login to Console and create Users
Login to EM and assign roles to the users
So are you ready
Then sign up today to access presentation, queries and resources and sample questions for Oracle Cloud Platform Enterprise Analytics 2023
And full support
Training Agenda:
• Introduction to BI publisher
• Login to Oracle Analytics Server including DV, OBIEE and BI Publisher
• Define Data source
• Create data models by using SQL Query and Query Builder
• Create BI Publisher reports using report builder
• Building an RTF Template in online and offline mode
• Create a Style Template
• Configure Delivery Options
• Schedule Reports Jobs
• Translate or BI Publisher Localization
• Creating OBIEE Dashboards and adding BI Publisher reports to Dashboard Pages
• Managing BI Publisher Objects
• Administrating BI Publisher