+91 7719882295
+1 315-636-0645
OBIEE 11gā
Data warehouse Concepts
- Data warehouse
- Data mart
- Difference between OLTP and OLAP
- Data warehouse
Dimensional Modeling Overview
- Introduction to Dimensional Modeling
- Dimensional table
- Fact table
- Aggregate table
- Star schema
- Snowflake schema
- Star schema Vs. Snowflake schema
- Fact Vs. Dimension table
- Fact Vs. Aggregate Table
- Types of Facts
- Types of Fact tables
- Types of Dimensions
- Level of Granularity
- Grain of fact
- Slowly Changing Dimensions( SCD )
- Normalization
- DE normalization
OBIEE Overview
- Introduction to Siebel Analytics
- Introduction to OBIEE 10 G
- What is Obiee?
- Advantages of Obiee
- End to End Life Cycle of Obiee
- Types of Reports
- Types of Applications
- Components OF Obiee
- Client Components Of Obiee
- Obiee Architecture
- Difference between Obiee 10g and Siebel Analytics
- Difference between Obiee 10g
Repository Basics
- What is Meta data?
- Creating a Repository using BI Administration Tool
- Physical, Business Model and Mapping, and presentation layers
- Properties of repository objects
- Online Mode and Offline Mode
Building the Physical Layer of a Repository
- Physical Layer from Relational Data Sources
- Database Objects
- Setting Up and Properties of Connection Pools
- Physical Tables
- Alias Tables
- Physical Layer Folders
- Physical Joins
- Defining Physical Foreign Keys and Joins
- Using Database
- Viewing Data in Physical Tables or Columns
- Creating and Editing a Column in a Physical Table
- Fragmented Data
- Primary Key and Foreign Key Relationships
- Complex Joins
- Opaque Views
Business Model and Mapping Layer
- Business Model Objects
- Duplicate Business Model and Presentation Catalog
- Creating and Administering Logical Tables
- Creating and Administering Logical Columns
- Creating and Administering Logical Table Sources (Mappings)
- Dimensions and Hierarchical Levels
- Process of Creating and Administering Dimensions
- Unbalanced (Ragged) and Skip-Level Hierarchies
- Parent-Child Hierarchies
- Subject Areas for Logical Stars and Snowflakes
- Display Folders
- Logical Joins
- Level Based Measures
- Aggregation Navigation
- Time Series Function
Presentation Layer
- About the Presentation Layer
- Creating and Customizing the Presentation Layer
- Working with Subject Areas
- Working with Presentation Tables and Columns
- Working with Presentation Hierarchies and Levels
- Setting Permissions for Presentation Layer Objects
- Creating Aliases (Synonyms) for Presentation Layer Objects
- Controlling Presentation Object Visibility
Utilities and Wizards
Advantages of Caching Cache Manager
- Using the Cache Manager
- Monitoring and Managing the Cache
- Purging and Maintaining Cache
Config Files
- Nqs Config
- Nqs Server
- Nqs Query
- Instance Config
Variables
- Variable
- Repository Variables
- Static and Dynamic
- Session Variables
- System and Non System Variables
- Initialization Blocks
- Row Wise Initialization
Security
- Data level Security
- Object Level Security
- Authentication
- Authorization
- Users and Groups
Types Of Authentication
- LDAP Authentication
- External Table Authentication
- Database Authentication
- Oracle BI Delivers and Database Authentication
- Oracle BI Server User Authentication
Analysis
- Types of Views
- Column Properties
- Filters
Dashboards
- Dashboard Page
- Dashboard Objects
- Actions and Conditions
- Kpi and Scorecard
Prompts
- Inline and Dashboard Prompts
- Column Prompt
- Image Prompt"
- Currency Prompt"
- Variable Prompt
Administering Oracle Business Intelligence Presentation Catalog
- Maintaining the OracleBI Presentation Catalog
- Maintaining security
- Understanding security inheritance
Using Oracle Business Intelligence Delivers
- Building alerts
- Building Agents
- Introduction to OracleBI Scheduler