This course provides step-by-step procedures for building and verifying the three layers of an Oracle BI repository. Students begin by using the Oracle BI Administration Tool to construct a simple repository to address a fictitious company's business requirements. Students import schemas, design and build logical business models, and expose business models to users in the Oracle BI user interface. In the process of constructing the repository, students learn how to build physical and logical joins, simple measures, and calculation measures. Students also learn how to validate their work by creating and running analyses, and verifying query results using the query log. Students then extend the initial repository and learn how to model more complex business requirements, such as logical dimension hierarchies, multiple logical table sources, aggregate tables, partitions, and time series data. Students also learn how to implement Oracle BI Server security, manage Oracle BI Server cache, set up a multiuser development environment, and use Administration Tool wizards and utilities to manage, maintain, and enhance repositories. Finally, students are exposed to more advanced topics, such as implicit fact columns, bridge tables, usage tracking, multilingual environments, write back, and patch merge.

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
  • A Live Virtual Class (LVC) is exclusively for registered students; unregistered inpiduals may not view an LVC at any
  • time. Registered students must view the class from the country listed in the registration form. Unauthorized recording,
  • copying, or transmission of LVC content may not be made.
  • Course Objectives :Build and run analyses to test and validate a repository
  • Build simple and calculated measures for a fact table
  • Create logical dimension hierarchies and level-based measures
  • Model aggregate tables to speed query processing
  • Model partitions and fragments to improve application performance and usability
  • Use variables to streamline administrative tasks and modify metadata content dynamically
  • Use time series functions to support historical time comparison analyses
  • Set up security to authenticate users and assign appropriate permissions and privileges
  • Apply cache management techniques to maintain and enhance query performance
  • Set up query logging for testing and debugging
  • Set up a multi-user development environment
  • Use Administration Tool wizards and utilities to manage, maintain, and enhance repositories
  • Enable usage tracking to track queries and database usage, and improve query performance
  • Perform a patch merge in a development-to-production scenario
  • Configure Oracle BI to support multilingual environments
  • Build the Physical, Business Model and Mapping, and Presentation layers of a repository

Course Topics:

  • 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

egabi Learn is a Professional Authorized Training Services and solutions provider covering a wide range of technical and management specializations. In addition, egabi Learn provides Rollout services covering end-to-end implementation to facilitate the entire rollout process as Theyll as outsTheircing services. egabi Learn offers various advanced learning solutions provided by experienced partners.

Since its establishment in 2007, egabi Learn has demonstrated remarkable growth, and is considered as one of the leading training services providers across MEA Region.

egabi Learn has acquired an impressive client base encompassing top multinational companies and key regional businesses from a wide range of business sectors covering government, telecommunication, banking and private sector companies.

See all Egabi Learn courses

Contact information not available.

Courses you can instantly connect with...
Making Powerful Presentations Career Development Organization Soft Skills Native Egyptians Training & Consulting Services Creativity and Innovation Kovay

Is this the right course for you?

Rate our content

Didn't find what you were looking for ?