Obiee
Register for Free Demo
Repository Basics
- Oracle BI architecture components
- Repository structure, features, and functions
- Using the Oracle BI 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
Modeling 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
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
- Seeding the cache
- Modifying cache parameters and options
Multi-user Development
- Setting up a multi-user development environment
- Developing a repository using multiple developers
- Tracking development project history
Using Administration Tool Utilities
- Using Administration Tool wizards and utilities to manage, maintain, and enhance repositories
OBI Answers
1: Working with Oracle Business Intelligence Answers
- Introduction to Oracle BI Answers
- Working with requests in Oracle BI Answers
- Using advanced formatting
2: Filtering Requests in Oracle Business Intelligence Answers
- Introduction to filters in Answers
- Adding filter prompts to requests
- Using saved requests as filters
3: Oracle Business Intelligence Answers: Advanced Features
- Combining request criteria using set operations
- Executing direct database requests
- Editing logical SQL generated by a request
4: Building Views and Charts in Requests
- Introduction to Answers views and charts
- Creating and editing charts
- Performing common view tasks
5: Showing Results with Gauge Views
- Introduction to the Gauge view
- Working with Gauge views
6: Showing Results with Pivot Tables
- Introduction to pivot tables
- Formatting pivot tables
- Setting aggregation rules and building formulas
OBI Interactive Dashboards
1: Creating Oracle Business Intelligence Interactive Dashboards
- Introduction to Interactive Dashboards and pages
- Dashboard Editor UI elements
- Composing dashboard elements
2: Configuring Oracle Business Intelligence Interactive Dashboards
- Types of dashboard content
- Embedding content in Interactive Dashboards
- Using bookmark links to distribute and save Interactive Dashboards
3: Customizing the Oracle Business Intelligence User Interface
- Modifying cascading style sheets
- Modifying XML message files
- Making configuration changes using the instanceconfig file
4: Configuring Guided Navigation Links
- Building guided navigation with static links
- Building guided navigation with conditional links and sections
5: Administering the Oracle Business Intelligence Presentation Catalog
- Maintaining the Oracle BI Presentation Catalog
- Maintaining security
- Understanding security inheritance
OBI Delivers
1: Using Oracle Business Intelligence Delivers
- Introduction to Oracle BI Delivers
- Configuring delivery devices
- Adding delivery profiles
- Building alerts
- Introduction to Oracle BI Scheduler
OBI for MS Office
1: Using Oracle BI for Microsoft Office
- Introduction to Oracle BI for Microsoft Office
- Working with Oracle BI content in Microsoft Office applications