Course Duration in Hours
90
90
SAP BO TRAINING COURSE CONTENTS
Introduction to SAP.
Introduction to Business Objects
New features in SAP BO BI 4.0.
Data Warehousing Architecture.
Business Objects Architecture.
sap bo Data Modeling
sap bo ER Modeling
sap bo Dimensional Modeling.
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 7.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 7.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 Anlaysis
Database Rank
Sub Query
Combined Query
Custom SQL
Changing report source
Hyperlink
SAP BOBI 7.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
LOVs
Cascading LOVs
Editing the LOVs
Derived tables
Check Integrity
Implementing Security
Universe options
Universe Locking
Linking Universe
Security Implementation
SAP BOBI 7.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 form Lower version to Existing version
Controlling Universes
Scheduling through CMC
Publication
User Security
Modify Settings for Applications
Access Levels
graduation
Unified Enterprise Solutions, Pune, Chinchwad East (Pune),Pune,IN