Make Enquiry
  +44-740-880-6167 UK:    +44-740-880-6167       
+1-201-984-7795 USA:    +1-201-984-7795



Repository Basics
- Exploring Oracle BI architecture components
- Exploring a repository's 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 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
- Executing analyses to test a repository
- Inspecting the query log

Managing Logical Table Sources
- Adding multiple logical table sources to a logical table
- Specifying logical content

Adding Calculations to a Fact
- 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 measures using functions

Working with Logical Dimensions
- Creating logical dimension hierarchies
- Creating level-based measures
- Creating share measures
- Creating dimension-specific aggregation rules
- Creating presentation hierarchies
- Creating parent-child hierarchies
- Using calculated members

Using Aggregates
- Modeling aggregate tables to improve query performance
- Setting the number of elements in a hierarchy
- Testing aggregate navigation
- Using the Aggregate Persistence Wizard

Using Repository Variables
- Creating session variables
- Creating repository variables
- Creating 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

Setting an Implicit Fact Column
- Adding fact columns automatically to dimension-only queries
- Ensuring the expected results for dimension-only queries
- Selecting a predetermined fact table source
- Specifying a default join path between dimension tables

Security
- Exploring Oracle BI default security settings
- Creating users and groups
- Creating application roles
- Setting up object permissions
- Setting row-level security (data filters)
- Setting query limits and timing restrictions

Cache Management
- Restricting tables as non-cacheable
- Using Cache Manager
- Inspecting cache reports
- Purging cache entries
- Modifying cache parameters and options
- Seeding the cache

Enabling Usage Tracking
- Setting up the sample usage tracking repository
- 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

Multiuser Development
- Setting up a multiuser development environment
- Developing a repository using multiple developers
- Tracking development project history

Working with Oracle Business Intelligence Analyses
- Introduction to Oracle BI Analysis Editor
- Oracle BI column types
- Working with analyses in Oracle BI
- Using advanced formatting

Administering the Presentation Catalog
- Oracle BI and catalog security overview
- Managing security using roles
- Understanding security inheritance
- Setting object permissions
- Setting system privileges
- Archiving catalog items

Limiting and Grouping Data in Analyses
- Introduction to filters and selections
- Creating, editing, and grouping filters
- Adding prompts to analyses
- Dynamic filtering
- Using saved analyses as filters
- Creating groups
- Creating calculated items
- Creating selection steps

Oracle Business Intelligence Analyses: Advanced Features
- Setting analysis properties
- Combining analysis criteria by using set operations
- Executing direct database analyses
- Editing logical SQL generated by an analysis
- Creating a link to a saved analysis
- Creating an Excel Web Query file

Working with Views and Graphs in Analyses
- Introduction to views, graphs, and editors
- Working with views in Compound Layouts
- Creating and editing graphs
- Linking master-detail views
- Performing common view tasks

Showing Results With Pivot Tables
- Creating, arranging, and formatting a pivot table
- Using hierarchical columns
- Sorting in pivot tables
- Setting aggregation and using totals
- Showing an item's relative value
- Building calculations and displaying running sums

Creating Oracle Business Intelligence Dashboards
- Creating and editing dashboards
- Using the Dashboard Builder
- Exploring dashboard object properties and options
- Publishing dashboard pages
- Creating personal customizations and using other page options

Configuring Oracle Business Intelligence Dashboards
- Exploring types of dashboard content
- Embedding content in dashboards

Creating Dashboard Prompts and Variables
- Understanding variables
- Adding a named dashboard prompt to a dashboard
- Adding a hidden named dashboard prompt to a dashboard
- Creating additional prompt page and setting page preferences
- Adding variable prompts to a dashboard

Using Oracle Business Intelligence Delivers
- Configuring delivery devices and adding delivery profiles
- Adding an Alert Section to a dashboard
- Configuring an Agent
- Using Analysis and KPI conditions to deliver content with Agents
- Subscribing to an Agent
Posted in Obiee11g  
 

QUICK ENQUIRY

Name:
Email:
Phone:
Course:
Country:
Enquiry:
Captcha: captcha


Learner Registration

Learner Registration

Login

Publish a login form or anything you want to this position.

Register

Publish a registration form or anything you want to this position.