OBIEE 10g and 11g Course content
Part 1 : DWH Concepts
ü What is data.
ü What is Information.
ü Features of OLTP systems.
ü What is DWH.
ü Why to build Data warehouse.
ü Data Warehousing Architecture 1.
ü Data Warehousing Architecture 2.
ü Data Warehousing Architecture 3.
ü Data Warehousing Architecture 4.
ü Data Warehousing Architecture with
OBIEE.
ü Historical Developments in the areas of Data warehousing.
ü Dimensional Table.
ü Fact Table.
ü Why to have separate DWH.
ü Features of DWH.
ü Goals of DWH.
ü Data warehouse approaches.
ü Data mart.
ü Differences b/w OLTP and DWH.
ü Data warehouse Models.
ü Operational Data store.
ü ODS VS DW.
ü Schemas- Star schema , Snow flake
schema.
ü What is OLAP.
ü MOLAP, ROLAP, HOLAP.
ü Confirmed Dimension.
ü Slowly Changing Dimensions.
ü Rapidly Changing Dimensions.
ü Measures – Additive, Semi Additive, Non – Additive measures.
Part 2: OBIEE Architecture:
ü Oracle BI Enterprise Edition Concepts.
ü Exploring Oracle BI Enterprise Edition User Interfaces.
ü OBIEE 10 g Architecture.
ü OBIEE 11g Architecture.
ü Installation of Oracle10g& 11g, Obiee10g and OBIEE11g.
Part3 : Working with repository:
1. Building the Physical Layer of a Repository
Create a New Repository
Import
Metadata
Verify
Connection
Create
Aliases
Create Keys and
Joins
2. Building the Business Model and Mapping Layer of a Repository
Create a Business Model .
Examine Logical Joins .
Examine Logical
Columns .
Examine Logical
Table Sources .
Rename Logical Objects Manually .
Rename Objects
Using the Rename Wizard .
Delete
Unnecessary Logical Objects .
Create Simple
Measures.
3. Building the Presentation Layer of a Repository
Create a Subject
Area .
Create
Presentation Tables .
Create
Presentation Columns .
Rename
Presentation Columns.
Reorder
Presentation Columns .
4. Testing and Validating a Repository
Check Consistency.
Disable Caching.
Load the Repository.
Set Up Query Logging.
Create and Run an Analysis.
Check the Query Log.
5. Managing Logical Table Sources
Open the
Repository in Offline Mode.
Add a New Logical
Table Source.
Create
Presentation Layer Objects.
Load the
Repository.
Create and Run an
Analysis.
Check the Query
Log.
6. Creating Calculation Measures
Open
the Repository in Offline Mode.
Create a
Calculation Measure Derived from Existing Columns.
Create a
Calculation Measure Using a Function.
Load the
Repository .
7. Creating Logical Dimensions with Level-Based Hierarchies
Open the Repository in Offline Mode.
Create a Logical
Dimension for Product.
Create
Logical Levels.
Associate
Logical Columns with Logical Levels.
Set Logical
Level Keys.
Create
a Logical Dimension for Time.
Associate Time
Logical Columns with Logical Levels.
Create a Logical
Dimension for Customer.
Set Aggregation
Content for Logical Table Sources.
8. Creating Level-Based Measures
Open the
Repository in Offline Mode.
Create
Level-Based Measures
Create a Share
Measure
9. Creating Logical Dimensions with Parent-Child Hierarchies
Open
the Repository in Offline Mode.
Import Metadata
and Define Physical Layer Objects .
Create Logical
Table and Logical Columns .
Create a
Logical Join .
Create
a Parent-Child Logical Dimension .
Define
Parent-Child Settings .
Create
Presentation Layer Objects .
10. Creating Logical Dimensions with Ragged and Skipped-Level Hierarchies
Import
Metadata and Define Physical Layer Objects
Create
Logical Table and Logical Columns
Create a Ragged/Skipped Level Logical
Dimension
Create
Presentation Layer Objects
11. Using Aggregates
Import Metadata
Create New Logical Table Sources
Set Aggregate Content
12. Using Initialization Blocks and
Variables
Create an Initialization Block
Create Variables.
13. Creating Time Series Measures
Identify a Logical Dimension as a Time Dimension
Identify Level Keys as Chronological Keys
Create a Measure Using the AGO Function
Create
a Measure Using the TODATE Function
Create
a Measure Using the PERIODROLLING Function.
- Working on Online
mode.
- Using partitions and Fragments.
- How to work with
Multiple Fact tables.
- Setting implicit
Fact column.
- Security
a. Authentication and Authorization.
b. Creating users and Groups.
c. Object Level Security.
d. Data Level Security.
. 18. Multi – User Development
Environment
19. Cache Management.
20. Disconnected Analytics.
21. Alias, Circular Joins & Opaque views or selected tables.
22. Usage Tracking.
23. Upgrading Rpd using Upgrade
assistant.
24. Utilities
25. Look Up table
Part 3: Working with OBIEE
Answers(10g) and Analytics (11g)
Ø Introduction about Enterprise Manager(EM), Analytics and Console.
Ø Building Views and Charts in Requests.
Ø Different Views .
Ø Table View.
Ø Compound View.
Ø No result View.
Ø Narrative View.
Ø Pivot View .
Ø Bubble chart.
Ø column selector View.
Ø view selector.
Ø Filtering Requests in Oracle Business Intelligence Answers.
Ø Combined Filter.
Ø Sorting.
Ø Drill.
Ø Navigation
Ø Group Filter.
Ø Filter Based on other Request.
Ø Dynamic filter using variable.
Ø Direct Database Requests.
Ø Presentation Catalog permissions.
Ø Presentation Catalog Privileges.
Part 4: Dashboards
1. Creating Oracle business Intelligence Interactive Dashboards.
2. Section.
3. Link or image.
4. Embedded Content
5. Text.
6. Folder
7. Guided navigation link
8. Dash board Prompt and types
9. Presentation variable
10. Request variable.
Part 5: Delivers:
1. Introduction to Oracle BI Delivers.
2. Developing IBots.
3. Configuring Delivery Devices.
4. Adding Profiles.
5. Building Alerts.
Part6: Additional Topics.
1. Working with Oracle BI For Microsoft office
2. Working with Catalog manager.
3. Configuring Load Balancer in
OBIEE.
4. Managing Oracle Process Manager
(OPMN) Process in OBIEE 11g
ü Oracle bi Cluster Component.
ü Oracle bi Scheduler Component.
ü Oracle Bi Java host Component.
ü Oracle Bi Presentation servers.
ü Oracle Bi Servers component.
5. Explanation on MDS and BI platform Schemas.
6. Localization Meta data- Oracle BI.
7. Master Detail Linking View in OBIEE11g.
