Szkolenia Oracle

Cel szkolenia

This Oracle BI 11g R1: Build Repositories training is based on OBI EE release Expert Oracle University instructors will teach you step-by-step procedures for building and verifying the three layers of an Oracle BI repository; you'll begin by using the Oracle BI Administration Tool to construct a simple repository to address a fictitious company's business requirements.

Learn To:

  • Build and execute analyses to test and verify a dimensional business model.
  • Use the Oracle BI Adminstration Tool to administer Oracle BI Server.
  • Use the Oracle BI Administration Tool to build, manage and maintain an Oracle BI repository.
  • Build a dimensional business model to address business intelligence requirements.
  • Validate your work by creating and running analyses, and verifying query results using the query log.

Plan szkolenia Rozwiń listę

  1. 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
    • Installing the BI Client software
    • Overview of Exalytics Machine
  2. 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
    • Printing the physical layer diagram
  3. 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
    • Printing the business model and mapping layer diagram
  4. Building the Presentation Layer of a Repository
    • Exploring presentation layer objects
    • Creating presentation layer objects
    • Modifying presentation layer objects
    • Examining presentation layer object properties
    • Nesting presentation tables
    • Controlling presentation layer object visibility
  5. Testing and Validating a Repository
    • Checking repository consistency
    • Turning on logging
    • Uploading the repository through Enterprise Manager
    • Executing analyses to test the repository
    • Inspecting the query log
  6. Managing Logical Table Sources
    • Adding multiple logical table sources to a logical table
    • Specifying logical content
  7. Adding Calculations to a Fact
    • Creating new calculation measures based on logical columns
    • Creating new calculation measures based on physical columns
    • Creating new calculation measures using the Calculation Wizard
    • Creating measures using functions
  8. 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
    • Creating ragged and skipped-level hierarchies
  9. Enabling Usage Tracking
    • Creating the usage tracking tables
    • 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
  10. Using Model Checker and Aggregates
    • Using Model Check Manager
    • Modeling aggregate tables to improve query performance
    • Using the Aggregate Persistence Wizard
    • Testing aggregate navigation
    • Setting the number of elements in a hierarchy
  11. Using Partitions and Fragments
    • Exploring partition types
    • Modeling partitions in an Oracle BI repository
  12. Using Repository Variables
    • Creating session variables
    • Creating repository variables
    • Creating initialization blocks
    • Using the Variable Manager
    • Using dynamic repository variables as filters
  13. Modeling Time Series Data
    • Using time comparisons in business analysis
    • Using Oracle BI time series functions to model time series data
  14. Modeling Many-to-Many Relationships
    • Using bridge tables to resolve many-to-many relationships between dimension tables and fact tables
  15. Setting an Implicit Fact Column
    • Ensuring the correct results for dimension-only queries
    • Selecting a predetermined fact table source
    • Specifying a default join path between dimension tables
  16. Importing Metadata from Multidimensional Data Sources
    • Importing a multidimensional data source into a repository
    • Incorporating horizintal federation into a business model
    • Incorporating vertical federation into a business model
    • Adding Essbase measures to a relational model
    • Displaying data from multidimensional sources in Oracle BI analyses and dashboards
  17. 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
  18. Cache Management
    • Restricting tables as non-cacheable
    • Using Cache Manager
    • Inspecting cache reports
    • Purging cache entries
    • Modifying cache parameters and options
    • Seeding the cache
  19. Exploring the Summary Advisor Tool
    • Setting up Summary Advisor
    • Running the Summary Advisor wizard to create the aggregate script
    • Running the aggregate script to create the aggregates
  20. Using Administration Tool Utilities
    • Using the various Administration Tool utilities
    • Using BI Server XML API to create XML representation of repository metadata
  21. Multiuser Development
    • Setting up a multiuser development environment
    • Developing a repository using multiple developers
    • Tracking development project history
  22. Performing a Patch Merge
    • Comparing repositories
    • Equalizing objects
    • Creating a patch
    • Applying a patch
    • Making merge decisions
Pobierz konspekt szkolenia w formacie PDF

Dodatkowe informacje

  • Knowledge on Dimensional modeling
  • Knowledge on Basic SQL
  • Knowledge on Data warehouse design
Poziom trudności
Czas trwania 5 dni
Zobacz więcej szkoleń Oracle

Prosimy o wypełnienie poniższego formularza, jeśli chcą Państwo uzyskać więcej informacji o powyższym szkoleniu.

Cena szkolenia

  • Forma szkolenia: stacjonarne


Czytaj więcej o ctab

Czas trwania

5 dni

Dostępne terminy

Brak ustalonych terminów dla tego szkolenia.

Zaproponuj własny termin