|
Working with Oracle Business Intelligence Answers
- Introduction to OracleBI Answers
- Working with requests in OracleBI Answers
Filtering Requests in Oracle Business Intelligence Answers
- Introduction to filters in Answers
- Adding filter prompts to requests
- Using saved requests as filters
Views and Charts in Requests
- Introduction to Answers views and charts
- Creating a column selector view
Showing Results with Pivot tables
- Introduction to pivot tables
- Formatting pivot tables
- Setting aggregation rules and building formulas
Creating Interactive Dashboards
- Introduction to Dashboards and pages
- Dashboard Editor UI elements
- Composing Dashboard elements
Configuring Interactive Dashboards
- Types of Dashboard content
- Embedding content in Dashboards
Customizing the Oracle Business Intelligence User Interface
- Modifying cascading style sheets
- Modifying XML message files
Configuring Guided Navigation Links
- Building guided navigation with static links
- Building guided navigation with conditional links and sections
Administering Oracle Business Intelligence Presentation Catalog
- Maintaining the OracleBI Presentation Catalog
- Maintaining security
- Understanding security inheritance
Using Oracle Business Intelligence Delivers
- Building alerts
- Building iBots
- Introduction to OracleBI Scheduler
Interactive Dashboard Design Principles and Best Practices
- Understanding Dashboard design principles
- Course Topics: RPD Development
Repository Basics
- Oracle BI architecture components
- Repository structure, features, and functions
- Using the OracleBI Administration Tool
- Creating a repository
- Loading a repository into Oracle BI Server memory
Building the Physical Layer of a Repository
- Importing data sources
- Setting up connection pool properties
- Defining keys and joins
- Examining physical layer object properties
- Creating alias and select tables
Building the Business Model and Mapping Layer of a Repository
- Building a business model
Building logical tables, columns, and sources
- Defining logical joins
- Building measures
- Examining business model object properties
Building the Presentation Layer of a Repository
- Exploring Presentation layer objects
- Creating Presentation layer objects
- Modifying Presentation layer objects
- Examining Presentation layer object properties
Testing and Validating a Repository
- Checking repository consistency
- Turning on logging
- Defining a repository in the initialization file
- Testing a repository using Oracle BI Answers
- Inspecting the query log
Adding Multiple Logical Table Sources
- Adding multiple logical table sources to a logical table
- Specifying logical content
Adding Calculations to a Fact Table
- Creating new calculation measures based on existing logical columns
- Creating new calculation measures based on physical columns
- Creating new calculation measures using the Calculation Wizard
Creating Dimension Hierarchies and Level-Based Measures
- Creating dimension hierarchies
- Creating level-based measures
- Creating share measures
- Creating rank measures
Using Aggregates
- Purpose of aggregate tables in dimensional modeling
- Modeling aggregate tables to improve query performance
- Testing aggregate navigation
- Using the Aggregate Persistence Wizard
Using Partitions and Fragments
- Purpose for segmenting data into partitions and fragments
- Partition types
- Modeling partitions in an Oracle BI repository
Using Repository Variables
- Session variables
- Repository variables
- Initialization blocks
- Using the Variable Manager
- Using dynamic repository variables as filters
Modeling Time Series Data
- Using time comparisons in business analysis
- Using Oracle BI time series functions to model time series data
Security
- Creating users and groups
- Setting permissions for users and groups
- Authenticating using a external database
- Authenticating using database authentication
- Setting query limits and timing restrictions
- Setting filters to personalize information
Cache Management
- Restricting tables as non-cacheable
- Using Cache Manager
- Inspecting cache reports
Purging cache entries
- Modifying cache parameters and options
- Seeding the cache
Setting Up and Administering Usage Tracking
- Tracking and storing Oracle BI Server usage at the detailed query level
- Using usage tracking statistics to optimize query performance and aggregation
Strategies
- Analyzing usage results using Oracle BI Answers and other reporting tools
- Multi-user Development
- Setting up a multi-user development environment
- Developing a repository using multiple developers
- Tracking development project history
Administration Tool wizards and utilities to manage, maintain, and enhance repositories
- Employing techniques to optimize Oracle BI query performance
- Applying Oracle BI repository design principles
| 