7Obiee Training
OBIEE 11g
Data warehouse Concepts
- Data warehouse
- Data mart
- Basics of Data Warehousing
- What is OLTP and OLAP?
- Difference between OLTP and OLAP
- 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
- 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
- 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
- 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 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
- 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
- Using the Cache Manager
- Monitoring and Managing the Cache
- Purging and Maintaining Cache
- Nqs Config
- Nqs Server
- Nqs Query
- Instance Config
- Variable
- Repository Variables
- Static and Dynamic
- Session Variables
- System and Non System Variables
- Initialization Blocks
- Row Wise Initialization
- Data level Security
- Object Level Security
- Authentication
- Authorization
- Users and Groups
- LDAP Authentication
- External Table Authentication
- Database Authentication
- Oracle BI Delivers and Database Authentication
- Oracle BI Server User Authentication
- Types of Views
- Column Properties
- Filters
- Dashboard Page
- Dashboard Objects
- Actions and Conditions
- Kpi and Scorecard
- Inline and Dashboard Prompts
- Column Prompt
- Image Prompt"
- Currency Prompt"
- Variable Prompt
- Maintaining the OracleBI Presentation Catalog
- Maintaining security
- Understanding security inheritance
- Building alerts
- Building Agents
- Introduction to OracleBI Scheduler