OBIEE 10g Reports and Dashboards - OBI200
This OBIEE training course shows you how to create ad-hoc queries and use them in interactive dashboards. You will build a dashboard using requests, then add other features, such as charts, prompts, gauges, navigation links, pivot tables, embedded content, and BI Publisher reports. You will also learn to maintain and configure interactive dashboards, as well as customizing the user interface with styles, XML message files, and cascading style sheets. Also taught in this course is using BI in conjunction with Microsoft Office with presentations and spreadsheets.
Overview of Oracle Business Intelligence Answers
- Introduction to Answers
- Requests and OBI Answers
- Answers advanced formatting
Filtering requests in OBI Answers
- Introduction to filters
- Request filter prompts
- Saved request filters
OBI Answers advanced topics
- Direct database requests
- Combining request criteria
- Editing generated SQL
Building views and charts
- Introduction to views and charts
- Creating and modifying charts
- Common view tasks
Gauge Views
- Introduction to Gauge Views
- Managing gauge views
Pivot tables
- Introduction to pivot tables
- Aggregation rules
- Building formulas
- Formatting pivot tables
Creating OBI interactive dashboards
- Introduction to interactive dashboards
- Dashboard user interface elements
- Creating dashboard elements
Configuring OBI interactive dashboards
- Dashboard content types
- Embedding content
- Bookmark links
Customizing the OBI user interface
- Cascading style sheets
- XML message files
- The instanceconfig file
- Navigation - static links
- Navigation - conditional links and sections
Administering OBI presentation catalog
- The Oracle BI presentation catalog
- Security
- Security inheritance
- Permission types
- The Manage Catalog screen
Using OBI Delivers
- Introduction to OBI Delivers
- Configuring delivery devices
- Delivery profiles
- Creating alerts
- The Oracle BI scheduler
- Job scripting
OBI briefing books
- Introduction to briefing books
- Creatingan OBI briefing book
- Adding content to a briefing book
- Editing a briefing book
- Downloading and viewing a briefing book
- Adding briefing books to a dashboard
- Using briefing books with OBI Delivers
Using OBI with Microsoft Office
- Introduction to OBI for Microsoft Office
- OBI content in Microsoft Office applications
Oracle BI Publisher
- Introduction to OBI Publisher
- Creating BI Publisher report from Answers request
- Creating BI Publisher report from BI Server
- Integrating Discoverer worksheet in BI Publisher report
Interactive dashboard best practices
- Dashboard design concepts
- Planning dashboards
- Dashboard design basics