Prerequisites
To apply for the SAP Business Objects Training, you need to either:
- Should have basic computer knowledge
- Proficiency in using operating systems like Windows.
- An aspirant should have basic skills in database concepts and SQL.
- Basic programming skills (depending upon the course).
- Aspirants should have good knowledge of SAP software and its various modules.
Module 1: 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
- Degenerate Dimension Table
- SchemaStar 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
- ODSSAP BO Data Mart
- Dependent Data Mart.
- SAP BO Independent Data Mart
- Staging Area
- Granularity
- Normalization
- De normalization
- OLTP
- OLAP
Module 2: 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 3: Built-in functions
- SAP BO Character Functions
- Numeric Functions
- Data Functions
- Conversion Functions
- Aggregate Functions
Module 4: Set Operators
- Union
- Union All
- Intersect
- Minus
Module 5: 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 to 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
- AliasContext
- 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 6: Joins
- SAP BO Inner Join
- Left Outer Join
- Right outer Join
- Full outer Join
- Cartesian Join
- Self JoinNatural Join
Module 7: SAP BOBI 4.0 Universe Design Tool
- Connections
- Connection Types
- Universe parameters
- ParametersKinds 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 8: 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 selectorsV lookup in Excel
- Adding dynamic visibility
- Troubleshooting interactivity
- Working with Business Requirements
Module 9: SAP BOBI 4.0 BI Launchpad & Web Intelligence 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
- AlertsInput Control
- Scheduling
- Sharing Web Intelligence Documents
- FilterFormula
- FunctionsVariable
- 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
Module 10: 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
