SAP BO

Reading Time: 4 minutes

SAP BO (Business Object)

    Module 1: Introduction to SAP

      Module 2: 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
      • De generative Dimension Table
      • Schema
      • Star Schema
      • Snowflake Schema
      • Galaxy Schema
      • Slowly Changing Dimensional Tables.
      • Fact Table.
      • Fact less 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 Data mart.
      • SAP BO Independent Data Mart
      • Staging Area
      • Granularity
      • Normalization
      • De normalization
      • OLTP
      • OLAP

      Module 3: 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

      Module 4: Built-in functions

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

      Module 5: Joins

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

      Module 6: Set Operators

      • Union
      • Union All
      • Intersect
      • Minus

      Sub Queries

        Module 7: 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 (Wont 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

        Module 8: 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 Tool bar
        • 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

        Module 9: 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

        Module 10: 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

        Module 11: Administration

        • Setting up groups and users
        • Taking Meta data 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