Oracle Fusion Technical BI OTBI BICC FRS SmartView
What you’ll learn
Business Intelligence (BI)
BI – Yeh Dil Maange More
All about BI Publisher RTF Templates
Schedule BI Reports
BI as Outbound Integration Tool
BI ESS Jobs & Report Security
Oracle Transactional Business Intelligence (OTBI)
Business Intelligence Cloud Connector (BICC)
Financial reporting Studio (FRS)
Smart View
UCM Web Service
Export BI Report Output from Fusion using OIC
Requirements
Basics of SQL
Microsoft Word & Excel
Description
What’s this course about?Learn Oracle Cloud Fusion ERP Technical – BI, OTBI, BICC, FRS, SmartView and dive deeper into it. Understand the Reporting tools and solutions of Oracle Fusion ERP Cloud. To be precise the reporting capabilities being provided by Oracle in Fusion Cloud SaaS.What do you expect end of this course?By the end of the course, you will be equipped with all the knowledge of Reporting tools and solutions of Oracle Fusion ERP Cloud e.g. BI Publisher, OTBI, BICC, FRS, Smart View ! And you will be ready for your next assignment! :-)A detailed list with the course content can be found below.Who’s teaching you in this course?My name is Raja Dutta and I have my partner Leena, We are both Fusion Cloud, PaaS and Fusion Middlware Consultant and we are passionate about helping more people to learn Fusion Cloud Technologies. After huge postive feedbacks we are here at Udemy with our second course of Oracle Fusion Technical – BI, OTBI, BICC, FRS, SmartView and we had lot of fun in preparing this course! Hope you too will have fun learning this course!It’s our goal to get you started with Oracle Fusion Technical – BI, OTBI, BICC, FRS, SmartView as soon as possible and ensure your success. I want everyone to get benefited out of this course and to us, helping others is the best way of learning. So Let’s Learn together!Is this course for you?This course is for you if ….. you want to upskill with Reports and Analytics in Oracle Fusion ERP Cloud.. you want to pursue your career with Oracle Fusion BI & Analytics.. you have idea on ERP and Package solutionsWhat’s inside the course?BI Publisher – BI Roles & Configuration – Develop First BI Report – BIP Report with Parameters – Export BIP Report Output – BI Report Migration – Master Details BI Report – BIP Bursting & Delivery Channel – Secure BI ReportBI – Yeh Dil Maange More – BI Report using Excel Template – Print Barcode in BI Report Output – Secure your PDF Report Output – Static Method – Secure your PDF Report Output – Dynamic Method – SubTemplates in Fusion BI – Explore different features of RTF Template – Fixed Position flat file using BI Report – Generate BI Report Output in Multi-Languages – Part1 – Generate BI Report Output in Multi-Languages – Part2 – Customize Standard BI ReportBI – All about RTF Templates – Auto Generate RTF TemplatesBI – Schedule BI Reports – FTP Delivery Channel Configuration – Schedule BI Report From Fusion & Burst Report Output to FTP Server – Prepare SOAP Payload to schedule BI Report using SOAP UI – Schedule BI Report through SOAP Web Service using PLSQLBI ESS Jobs – Getting Started with Enterprise Scheduler Services (ESS) Jobs – Creating first ESS Job on BI Report – Lookups in Fusion – Use in ESS Jobs Parameter – ValueSets in Fusion – Use in ESS Jobs Parameter – Secure your BI ESS JobBI Outbound Integration Tool – All about Report Service – Fetch Data from Fusion using BI & Java – Fetch Data from Fusion using BI & SOAOracle Transactional Business Intelligence (OTBI) – Getting Started with OTBI – OTBI Analysis – Tabular Representation – OTBI Analysis – Graphical Representation – Create Dashboard using OTBI – Create Drill Down Report using OTBI – Create BI Report using OTBI Analysis – All about OTBI Report Security – Create Infolet using OTBI AnalysisBI Cloud Connector (BICC) – BICC – What is this?? – Get Ready with BICC – Create your first BICC Extract(Full) – Run for Incremental Extracts – Secure your BICC ExtractFinancial Reporting Studio (FRS) – Getting started with FRS – Build Report using FRSSmart View – Getting started with Smart View – Build Report using Smart ViewExport BI Report Output to DB/FTP using OIC (Bonus) – Export BI Report Output to DB using OIC – Export BI Report Output to FTP using OIC
Overview
Section 1: Introduction
Lecture 1 Oracle Fusion Technical – BI,OTBI,BICC,FRS,SmartView & More – Course Preview
Lecture 2 Course Guide
Section 2: Business Intelligence (BI) Publisher
Lecture 3 BI Roles & Configuration
Lecture 4 Develop First BI Report
Lecture 5 BI Report with Parameters
Lecture 6 XSL Transformation vs. BIP Tags in BI Publisher
Lecture 7 Let’s see how to create the RTF Template
Lecture 8 Export BI Report Output
Lecture 9 BI Report Migration
Lecture 10 Master Details BI Report using Group Link
Lecture 11 Let’s create RTF Template for Master Details Report (Form-Table Layout)
Lecture 12 Master Details BI Report using Element Link
Lecture 13 Master Details BI Report using Subgroup
Lecture 14 BIP Bursting & Delivery Channel
Lecture 15 Secure BI Report
Section 3: BI Publisher – Yeh Dil Maange More
Lecture 16 BI Report using Excel Template
Lecture 17 Print Barcode in BI Report Output
Lecture 18 Secure your PDF Report Output (Static Approach)
Lecture 19 Secure your PDF Report Output (Dynamic Approach)
Lecture 20 SubTemplates in Fusion BI
Lecture 21 Fixed Position flat file using BI Report
Lecture 22 Generate BI Report Output in Multi-Languages – Part1
Lecture 23 Generate BI Report Output in Multi-Languages – Part2
Lecture 24 Understand the role of XPATH & XSL Transformation in BI Publisher
Lecture 25 Develop BI Report using XSL Template
Lecture 26 Customize Standard BI Report
Section 4: BI Publisher – Let’s Play with RTF Templates
Lecture 27 Auto Generate RTF Templates (Helpful for Functional Folks)
Section 5: BI Publisher – Schedule BI Publisher Reports
Lecture 28 Configure FTP Delivery Channel
Lecture 29 Schedule BI Publisher Report from Fusion and burst output to FTP
Lecture 30 Prepare SOAP Payload to schedule BI Publisher Report using SOAP UI
Lecture 31 Schedule BI Publisher Report in Fusion through SOAP Web Service using PLSQL
Section 6: BI ESS Jobs
Lecture 32 Getting Started with Enterprise Scheduler Services (ESS) Jobs
Lecture 33 Creating first ESS Job on BI Report
Lecture 34 Lookups in Fusion – Use in ESS Jobs Parameter
Lecture 35 ValueSets in Fusion – Use in ESS Jobs Parameter
Lecture 36 Secure your BI ESS Job
Section 7: BI as Outbound Integration Tool
Lecture 37 All about Report Service
Lecture 38 Fetch Data from Fusion using BI & Java
Lecture 39 Fetch Data from Fusion using BI & SOA
Section 8: Oracle Transactional Business Intelligence (OTBI)
Lecture 40 Getting Started with OTBI
Lecture 41 OTBI Analysis – Tabular Representation
Lecture 42 OTBI Analysis – Graphical Representation
Lecture 43 Create Dashboard using OTBI
Lecture 44 Create Drill Down Report using OTBI
Lecture 45 Create BI Report using OTBI Analysis
Lecture 46 All about OTBI Report Security
Lecture 47 Create Infolet using OTBI Analysis
Section 9: BI Cloud Connector (BICC)
Lecture 48 BICC – What is this?
Lecture 49 Get Ready with BICC
Lecture 50 Create your first BICC Extract(Full)
Lecture 51 Run for Incremental Extracts
Lecture 52 Secure your BICC Extract
Section 10: Financial Reporting Studio (FRS)
Lecture 53 Getting Started with FRS
Lecture 54 Configure FRS & Understand it’s Components
Lecture 55 Develop your First Report using FRS
Lecture 56 Do More with FRS – Part1
Lecture 57 Do More with FRS – Part2
Section 11: Smart View
Lecture 58 All about Smart View Reports!
Lecture 59 Build a Report using Smart View
Section 12: Reporting Tool Comparisons
Lecture 60 BI vs OTBI
Section 13: Appendix A – UCM Web Service
Lecture 61 UCM Introduction
Lecture 62 Import File into Fusion using UCM Service
Lecture 63 Export File from Fusion using UCM Service
Lecture 64 Closing Comments
Section 14: Appendix B – ACL Configuration to Invoke BI Report Service from PLSQL (Optional)
Lecture 65 Overview of Access Control List (ACL)
Lecture 66 Configure Access Control List (ACL)
Section 15: Bonus – Export Fusion BI Publisher Report Output to DB/ FTP using OIC (Optional)
Lecture 67 Export Fusion BI Publisher Report Output to Database using OIC
Lecture 68 Export Fusion BI Publisher Report Output to FTP Server using OIC
ERP Functional & Technical Consultants,Programmers,Database Developers,Fresh Graduates
Course Information:
Udemy | English | 9h 16m | 4.87 GB
Created by: Team sharpenskill.com
You Can See More Courses in the IT & Software >> Greetings from CourseDown.com