ERP BO Training

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
• 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

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 (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

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

SAP BOBI 4.0 Universe Design Tool

• Connections
• Connection Types
• Universe parameters
• Parameters
• Kinds of Joins
• Loops
• Context
• Aliases
• Class
• Sub Class
• Objects
• ConditionObjects
• 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 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