OBIEE 10g Build Repository

Certificate Program Provided by Creative Probers Software & Services (I) Pvt Ltd BENEFITS OF TRAINING- a Learn from Industry Leaders - who have been helping Companies overcome their Business challenges a Maximize your learning - as you will be taught by subject matter experts who have both consulting as well as Corporate Training experience, having trained fortune 500 companies. a Practical real world best practices discussed in classes, to bridge the knowledge gap a Course Material, Course Environment and Certifications are from Oracle Corporation, which is of real value Brief outlines of the course: Building the Physical, BMM and Presentation Layers of a Repository, Creating Dimension Hierarchies and Level-Based Measures, Using Aggregates, Modeling Many-to-Many Relationships, Setting an Implicit Fact Column, Integrating Third-Party Reporting Tools, Creating Repositories from Multidimensional Data Sources, Security, Cache Management, Enabling Usage Tracking, Multi-User Development, Oracle BI Repository Design Principles

---

OBIEE 10g Build Repository Seminar Schedule

OBIEE 10g Build Repository Course Objectives:

Build the Physical, Business Model and Mapping, and Presentation layers of a repository.
Set up query logging for testing and debugging.
Use Oracle BI Answers to run queries to test and validate a repository.
Add multiple sources to business model objects.
Build simple and calculated measures for a fact table.
Create dimension hierarchies and level-based measures.
Model aggregate tables to speed up processing.
Model partitions and fragments to improve application performance and usability.
Use variables to streamline administrative tasks and dynamically modify metadata content.
Use time series functions to support historical time comparison analyses.
Use bridge tables to resolve many-to-many relationships between dimension and fact tables.
Use helper tables to maintain team-based hierarchical relationships in a dimension table.
Configure Oracle BI to support multilingual environments.
Use implicit fact columns to select fact tables for dimension-only queries.
Create a repository using a multidimensional data source.
Set up security to authenticate users and assign appropriate permissions and privileges.
Apply cache management techniques to maintain and enhance query performance.
Enable usage tracking to track queries and database usage, and improve query performance.
Set up and use a multi-user development environment.
Use Administration Tool utilities and wizards to perform administrative tasks
Identify best practices for optimizing end-user query performance when implementing Oracle BI Enterprise Edition.

Brief outlines of the course:

Building the Physical, BMM and Presentation Layers of a Repository, Creating Dimension Hierarchies and Level-Based Measures, Using Aggregates, Modeling Many-to-Many Relationships, Setting an Implicit Fact Column, Integrating Third-Party Reporting Tools, Creating Repositories from Multidimensional Data Sources, Security, Cache Management, Enabling Usage Tracking, Multi-User Development, Oracle BI Repository Design Principles

About The Training Provider: Creative Probers Software & Services (I) Pvt Ltd

More Siebel Analytics / OBIEE Training from Creative Probers Software & Services (I) Pvt Ltd

• OBIEE 10g Create Reports and Dashboards
• OBIEE 10g Develop Data Warehouse
• Siebel Analytics OBIEE Create Reports and Dashboards Training