obiee-training-8712125858

About AimAxis:

AimAxis is a leading e-learning platform providing live instructor-led interactive online training. We cater to professionals and students across the globe in categories like Data Science, Artificial Intelligence (AI), R Language, Python, SEO, Digital Marketing, Photoshop, Google Cloud Platform (GCP), Amazon Web Services (AWS), DevOps, SAP-BO-XIR 4.1/R4.2, Data Warehousing, IBM Cognos BI, Informatica Power Center 9.6.1/10.1, OBIEE, MSBI, Power BI, Tableau, Big Data, Hadoop, Business Analytics, Mobile Technologies, System Engineering, Project Management, and Programming. We have an easy and affordable learning solution that is accessible to all of the learners. With our students spread across countries like the US, India, UK, Canada, Singapore, Australia, Middle East, Brazil, and many others, we have built a community of overall learners across the globe.

OBIEE Training

 

  • Introduction to OLAP systems
  • Difference between OLTP systems and OLAP systems
  • Introduction to RDBMS
  • Introduction to Data warehousing 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:
  1. Creation of the ODBC Data Source Name (System DSN) for Different Databases
  2. ODBC connectivity between Database and Oracle BI Administrator
  3. Development of RPD (Repository Directory) files at OBI
  • Repository file (RPD) creation:

                  Physical layer:

Design physical diagram using various physical objects:

  1. Tables
  2. Views
  3. Synonyms
  4. Stored procedures

Import tables from different RDBMS and files systems

  1. RDBMS:
    1. Oracles
    2. SQL server
  • MS-Access, etc
  1. Non-RDBMS (file systems):
    1. Flat files
    2. XML files
  • 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 Connection pool
  • 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
  • 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),
  • Multidimensional 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
    • Apply the filters

Presentation layer:

  • Arrange the Business Models as subject areas
  • Derive New presentation tables
  • Rename the Meta Data for business user understanding
    • Working with Repository and Session Variables.
    • Provide security at Subject Area, Presentation table and Column lavel.

Repository variables:

Static and Dynamic

Session Variables:

System and non-system

  • Working with OBI ODBC
  • 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)

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.
  1. Query Optimization
  2. 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
    • 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:
  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

CONTACT AIM AXIS

All Courses

Preview Sample Certificate

aimaxis-certificate-your-course-name
Contact Us

We're not around right now. But you can send us an email and we'll get back to you, asap.

Not readable? Change text. captcha txt

Start typing and press Enter to search