OBIEE 11g Training Details

L
Dfhhkhj’k’;’k’’
btrsaetyunbnmcfsfgjkjgjkOnlineDWHtrainings.com
Contact Name: Rao
Contact No: 919948713895
OBIEE 11g Training Details
 Introduction to OLAP systems

 Difference between OLTP systems and OLAP systems
 Introduction to RDBMS
 Introduction to Data wdzxvcbnm,./arehousing and Data Marts
 Introduction to Data Modeling;
 Need of reporting tools
 Introduction to OBIEE 11g
 Overview on
 Query merging
 Query customization
 Query optimization
 Report customization
 Report optimization
 Difference between OBIEE and other reporting tools

 Overview on OBIEE Server Architecture:
 Overview on OBIEE Administrator Architecture:
a) Creation of the ODBC Data Source Name (System DSN) for Different
Databases
1|Page
b) ODBC connectivity between Database and Oracle BI Administrator
c) Development of RPD (Repository Directory) files at OBI Administrator.
 Repository file (RPD) creation:
Physical layer:
Design physical diagram using various physical objects:
a. Tables
b. Views
c. Synonyms
d. Stored procedures
Import tables from different RDBMS and files systems
1. RDBMS:
i. Oracles
ii. SQL server
iii. MS-Access, etc
2. Non-RDBMS (file systems):
i. Flat files
ii. XML files
iii. Excel files
 Working with multi-dimensional data sources(cubes):
 SAP-BW
 Hyperion
 Micro-soft Analysis cubes
 Working with CRM Meta data tables
 Create new physical table in the Physical layer
 Add new physical columns in the Physical objects
 Create views in the Physical layer
 Define primary and foreign keys in the physical table
 Connection pool verification with ODBC data source name
 Working with Native drivers
 Working with type conversion and referential integrity in physical layer.
 Working with new foreign key and complex join in Physical diagram.
 Merge two data sources in single physical diagram
2|Page
 Connection pool verification with multiple data source connection
 Assign the permission to the users:
 BI Administrators
 BI Authors
 BI Consumers
Create new data source in the Physical layer
 Enter SQL script:
 Before connect to database
 Before query
 After query
 After connect to database
 Business model and mapping layer:
Design Business Model Diagram (logical table diagram) using logical fact tables and
logical dimensional tables.
 For standard requirements (detailed),
 Multi dimensional requirements (summarized) using arithmetic
operators, aggregate functions
 Case statement generation (IF statement, IF-ELSE statement,
SWITCH statement
 Working with various join types( Inner, Left outer, Right outer and
Full outer)
 Creation of global filters
 Develop the dimensions hierarchies (Multi dimensional analysis)
1. Level-based hierarchies
2. Parent-child hierarchies.
 Create logical dimensional tables
 Create logical fact tables
 Working with periodic snap-shot tables
 Working with transactional grain fact tables
 Working with fact-less fact tables
 Working with additive measures, semi-additive measures and non-
additive measures
3|Page
 Apply the filters
Presentation layer:
 Arrange the Business Models as subject areas
 Rename the Meta Data for business user understanding
 Working with Repository and Session Variables.
Repository variables:
Static and Dynamic
Session Variables:
System and non-system
 Working with OBI ODBC client.

 Overview on OBI server architecture.
 RPD file configuration at OBI Server Level
 Cache Management at server level
 Utilities
 Security creation of repository
Create users and user groups
 Row updations
 Internal Process at Server level (conversion of Business query in to SQL query)
 User alteration at Database level
 Working with multi-users development (MUDE)
 Merging of multiple repository files
 Working with performance tuning
 Working with consistency check manager
 Performance tuning
Project Development:
 OLAP Specifications
 Development of Business Requirement Specifications (BRS)
 Development of Reporting Requirement Specifications(RRS)
4|Page
Oracle BI Answers and Interactive Dashboards:
 Selection of the Subject Area

 Creation of the Excel Sheet for Reporting Requirement Specifications
using Business Requirement Specifications
 Develop the Request in the Criteria
 Generate the Reports using Results
 Develop the logical calculations using advanced tab (set sql format)
 Reports:
 Ad-hoc reports
 Standard reports
 Dashboard reports.
 Generate customized reports and override reports in different formats.
a. Query Optimization
b. Report Optimization
 2-dimensional
 Multi dimensional
 List reports
 Chart reports
 Line chart reports
 Bar chart reports
 Pie-chart reports
 Cross-Tab reports
Setup pages and sections in the cross-tab report
 Working with various variables
 Repository
 Session
 Presentation
 Prompts (advance filters)
 Cascading prompts
5|Page
 Dash board prompts
 Page prompts
 Testing the prompts with single Go button
 Working with KPI’s and KPI’s Watch List
 Working with score cards
 BI publisher, etc
 Combined the requests from the different subject areas using set operators like
Union, Intersect etc.
 case statement generation (IF statement, IF-ELSE statement, SWITCH statement
 Filters (Global and Local filters)
 Generation of Expression and Aggregated functions
 Download the reports in PPT and Excel sheet, etc formats
 Working with direct database connection
 Working with prompts in direct database request.
 Working with presentation catalogs.
 OBI server administrative activities:

 Creation of the folder for different requests
 Scheduling the reports
 Generation of the iBots (Agents)
 Dashboard Management, session management, privilege management, etc
 Tabs creation for multiple Dashboards
 Creation of the pages for different Dashboards
 Set permission to others users to work with direct database
 Interactive Dashboards:
 Create dash board and page prompts
 Create pages
 Create columns as sections in sequential and concurrent
 Arrange report in the columns and save the dashboard.
 Installation of Oracle 11g and Configuration Schemas at DBA level
 Installation of OBIEE 11g.
 Project Deployment:
6|Page
1. Development Environment
2. Test Environment
3. Production Environment
 Working with BI Publisher.
 Create a JDBC connection to access repository file and database.

 Create report request
 Create data model
 Working with query builder
 Create row set
 Create templates
 Working with list of values(LOVS)
 Working with parameters
 Working with Email bursting
 Working with Analyzer
 Working with Analyzer for Excel
 Working with Studio to generate list reports, chart and cross-tab reports.
 Working Enterprise Management (A middleware fusion control)
 Upload new repository file
 Manage the servers
 Apply roles and policies to the users and user groups
 Working with Weblogic Administrative Console
 Working with DAC to configure BI Apps with Informatica
7|Page

OBIEE 11g Training Details

Uploaded by

Copyright:

Available Formats

OBIEE 11g Training Details

Uploaded by

Document Information

Original Description:

Original Title

Copyright

Available Formats

Share this document

Share or Embed Document

Sharing Options

Did you find this document useful?

Is this content inappropriate?

Copyright:

Available Formats

OBIEE 11g Training Details

Uploaded by

Copyright:

Available Formats

L

OBIEE 11g Training Details

 Introduction to OLAP systems

 Difference between OBIEE and other reporting tools

 Working with OBI ODBC client.

 Selection of the Subject Area

 OBI server administrative activities:

 Working with BI Publisher.

 Create a JDBC connection to access repository file and database.

You might also like