Oracle Business Intelligence Publisher (OAS BIP)
- Descrição
- Currículo
- FAQ
- Revisões
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
-
3
Installation of a supported Java Development -
4
Set JAVA_HOME Environment Parameter
-
5
Installation of Fusion Middleware Infrastructure
-
6
Installation of the OAS binaries
-
7
RCU (Repository Creation Utility)
-
8
Configuration of OAS into Weblogic Domain
-
9
Installing Oracle BI Administration Tool and open RPD on online and offline mode
-
10
Create Data Sources
-
11
Create Data model by SQL Query – Writing SQL Query
-
12
Parameters List of Values LOV
-
13
Refresh other parameters on change
-
14
Create Data model by SQL Query - Query Builder
-
15
Create Data model with Aggregation function
-
16
Create Data model by using flat file and Blend your data
-
17
Create a Dataset Using Excel File
-
18
Create a Dataset Using XML File
-
19
Create a Dataset Using an Analysis
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
-
20
Create a Dataset Using DV Dataset
-
28
Building an RTF Template By using Microsoft Office
-
29
Building an RTF Template - Online mode
-
30
Building an RTF Template - Offline mode
-
31
Create style template
-
32
Configuring Delivery Options
-
33
Using BI Publisher to Show Images from BLOB Data
-
34
Create Excel Template for BI Publisher
-
35
Splitting an RTF Template - Inserting Conditionally Page Breaks
-
36
Creating Alternating Row Backgrounds in BI Publisher
-
37
Create Data model by using Call procedure
-
38
Create Data model by using NON-standard SQL
-
39
Create Data model by using file and Blend your data
-
40
Use Oracle DB function in Oracle BI Publisher
-
41
Event Triggers in BI Publisher- System Variables
-
42
Event Triggers in BI Publisher - User parameters
-
43
Bursting in BI Publisher
-
44
Data model - Create Subgroups
-
45
Data model - Create Group-Level Aggregate Elements
-
46
Data model - Group Filters
-
47
Data model - Global-Level Functions
-
48
Accessing Reports via a URL
-
49
Printing Barcodes in BI Publisher Using RTF Templates
-
50
Printing Barcodes in BI Publisher Using Report Builder
-
54
Create an Oracle BI Repository RPD
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
-
55
Creating New Database and Connection Pool
Creating New Database and Connection Pool
Import Metadata
Data Source Name
How to check the Physical Diagram
-
56
Data Source Name configuration
Data Source Name configuration
-
57
Create A New Business Model and Mapping
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
-
58
Merge detailed dimensions into a single dimension
Merge detailed dimensions into a single dimension
-
59
How to create Measures
How to create Measures
Rename Measures, Dimensions, and logical names
-
60
Presentation Layer – Create a new Subject Area
Presentation Layer – Create a new Subject Area
Enable the BMM Model
Check Global Consistency
-
61
How to upload RPD
-
62
How to Create BI Publisher reports using Subject Area
-
63
Dimension Hierarchies
How to create Level based Hierarchy
-
64
How to create Time Dimension
-
65
Logical Column – Sort Order
-
66
Skipped & Ragged Hierarchies
-
67
How to create Oracle Analytics reports using subject area
-
68
Edit Oracle Analytics Report Details - Part 1
-
69
Edit Oracle Analytics Report Details - Part 2
-
70
Edit Oracle Analytics Report Details - Part 3
-
71
Creating Oracle Analytics reports based on Orders Subject Area
-
72
Creating Oracle Analytics reports based on Orders_Items Subject Area
-
73
Creating Oracle Analytics reports based on Inventories Subject Area
-
74
Oracle Analytics Dashboard - Part 1
-
75
Oracle Analytics Dashboard - Part 2
-
76
Oracle Analytics Dashboard - Part 3
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
-
77
Oracle Analytics Dashboard - Part 4 - Creating Dashboard Prompts and Filters
How to Create Dashboard Prompts and Filters
-
78
Oracle Analytics Dashboard - Part 5 - Landing Page and Portal Path
How to add Landing Page and Portal Path
-
79
Managing BI Publisher Objects
