Oracle Business Intelligence Publisher (OAS BIP)

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.

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.

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 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.

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.

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 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.

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.

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.

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 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.

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.

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.

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 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.

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.

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.

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.

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.