SAP BIBO Course

Introduction to SAP

  • Introduction to Business Objects
  • New features in SAP BO BI 4.0.
  • Data Warehousing Architecture.
  • Business Objects Architecture.

SAP BO Data Modelling

  • SAP BO ER Modelling
  • SAP BO Dimensional Modelling
  • Dimensional Tables.
  • Fact Tables.
  • Different types of Dimension Tables
  • Conformed Dimension Tables
  • Junk Dimension Tables
  • Degenerative Dimension Table

Schema

  • Star Schema
  • Snowflake Schema
  • Galaxy Schema
  • Slowly Changing Dimensional Tables.
  • Fact Table.
  • Factless Fact Table.

SAP BO Different Types of Facts or Measures

  • Bridge tables.
  • Lookup Tables.
  • Top-Down Approach
  • SAP BO Bottom-Up Approach

ODS

  • SAP BO Data Mart
  • Dependent Datamart.
  • SAP BO Independent Data Mart
  • Staging Area
  • Granularity
  • Normalization
  • Denormalization
  • OLTP
  • OLAP
  • Types of OLAPs

Oracle 10g (SQL)

  • SAP BO Introduction to Oracle Database
  • Data Types
  • SQL Statements
  • DDL – Data Definition Language
  • DML – Data Manipulation Language
  • DQL – Data Query language
  • DCL – Data Controlling language
  • TCS – Transaction Controlling Language

Built-in functions

  • SAP BO Character Functions
  • Numeric Functions
  • Data Functions
  • Conversion Functions
  • Aggregate Functions

Joins

  • SAP BO Inner Join
  • Left Outer Join
  • Right Outer Join
  • Full Outer Join
  • Cartesian Join
  • Self Join
  • Natural Join

Set Operators

  • Union
  • Union All
  • Intersect
  • Minus
  • Sub Queries

SAP BOBI 4.0 – Information Design Tool

  • SAP BO Creation of Project
  • Relational Connection
  • OLAP Connection
  • Data Foundation Layer
  • Business Layer
  • Edit Connection
  • Shortcut Connection
  • Secured Connection
  • Publishing Connection
  • Publishing the Business layer
  • Converting Repository Universe from Unv into Unx
  • Publishing the Universe to Repository
  • Publishing the Universe to Local
  • Retrieving the Universe from Repository
  • Multi-Source Universe

Data Foundation

  • Insert tables in Data Foundation
  • Define Joins in Data Foundation
  • Cordiality setting in Data Foundation

Arrange Tables

  • View Table values in Data Foundation
  • Filter Table values in Data Foundation (won't Impact in Reports O/P)
  • Edit Table values (Removing Columns, Changing Data types & Keys)
  • Calculated Column in Tables
  • Sort and re-ordering the columns in Data Foundation
  • Refresh Structure
  • Derived tables
  • Create Views
  • Detect Join / Cordiality / Alias / Keys / Row Counts
  • Resolving Loops
  • Alias
  • Context
  • Business Layer

Folders (Class)

  • Sub Folder (Sub Class)
  • Objects
  • Dimension
  • Measure
  • Attribute

Filter

  • Native Filter
  • Business Filter
  • Hide Folders , Objects & filters
  • Show Script
  • Show Values
  • View Tables and Object Dependency
  • Custom Navigation Path

Queries

  • Parameters and List of values
  • Check Integrity
  • Data Security
  • Business Security

SAP BOBI 4.0 BI Launchpad & Web I Rich client

  • BI launch pad: What’s new in 4.0
  • Introducing Web Intelligence
  • Creating BI workspace
  • Folders
  • SAP Steam
  • Scheduling a Document
  • Working with Thin Clients

Creating Web Intelligence Documents with Queries

  • Report Design in the Java Report Panel
  • Enhancing the Presentation of Reports
  • Formatting Reports
  • Creating Formulas and Variables
  • Drilling
  • Filtering data
  • Alerts

Input Control

  • Scheduling
  • Sharing Web Intelligence Documents
  • Filter
  • Formula
  • Functions
  • Variable
  • Merge dimensions
  • Alert
  • Rank
  • Sort
  • Break
  • Section
  • Hyperlink
  • Page view
  • View Structure
  • Refresh
  • Purge
  • Drill Filter Toolbar
  • Drill
  • Snapshot

SAP BO Download to PDF, Excel & CSV

  • Export to CSV

Scope of Analysis

  • Database Rank
  • Sub Query
  • Combined Query
  • Custom SQL
  • Changing report source
  • Hyperlink

SAP BOBI 4.0 Universe Design Tool

  • Connections
  • Connection Types
  • Universe parameters
  • Parameters
  • Kinds of Joins
  • Loops
  • Context
  • Aliases
  • Class
  • Sub Class
  • Objects
  • condition objects
  • Functions
  • @Functions
  • @Prompts
  • @Select
  • @Where
  • @Variable

SAP BO Cascading Prompts

  • Hierarchy
  • LOV’s
  • Cascading LOV’s
  • Editing the LOV’s
  • Derived tables
  • Check Integrity
  • Implementing Security
  • Universe options
  • Universe Locking
  • Linking Universe
  • Security Implementation

SAP BOBI 4.0 Dashboards

  • What’s new in SAP Business Objects Dashboards 4.0
  • Connection to BO universe by using QAAWS Connection
  • Using Live Office Data
  • Connecting to Query Builder
  • Canvas
  • Components
  • Component Properties
  • Dynamic Visibility
  • Drill option
  • Developing Chart Dashboards
  • Developing Maps Dashboards
  • Using Containers
  • Uploading Images
  • Calling Hyperlinks in Dashboards
  • Getting around in Xcelsius
  • Working with your Excel workbook
  • Visualizing data with charts
  • Applying formatting options
  • Using themes and templates to apply formatting
  • Using selectors
  • V lookup in Excel
  • Adding dynamic visibility
  • Troubleshooting interactivity

Working with Business Requirements

  • Administration
  • Setting up groups and users
  • Taking Metadata backup
  • Moving the code between environments
  • Handling Services
  • License Up gradation
  • Organizing and changing Folders & Categories
  • Time Out sessions
  • Instance Management
  • Managing Servers
  • Connections
  • Migrating from Lower version to Existing version

Controlling Universes

  • Scheduling through CMC
  • Publication
  • User Security
  • Modify Settings for Applications
  • Access Levels
  • Security