Course Overview
Business Objects(BO) is enterprise software company which specialized in business intelligence, and which was acquired by SAP in the year 2007. From then, SAP has worked to integrate BusinessObjects(BO) into its main offerings leading to today’s position of BusinessObjects as a flagship for SAP analytical solutions suite.
SAP BusinessObjects (SAP BO) has different enterprise applications to support the common functionalities of an analytical solution.
Requirements
- There is no need to have any specific skills for taking up this SAP BO training course
Curriculum
-
Administration
- Setting up groups and users
- Setting up groups and users
- 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
-
Modeling
- Introduction to SAP
- Introduction to Business Objects
- New features in SAP BO BI 4.0
- Data Warehousing Architecture
- Business Objects Architecture
- Data Modeling
- ER Modeling
- 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
- Different Types of Facts or Measures
- Bridge tables
- Lookup Tables
- Top Down Approach
- Bottom Up Approach
- ODS
- Data Mart (Dependent Data mart, Independent Data Mart)
- Staging Area
- Granularity
- Normalization
- De normalization
- OLTP
- OLAP
- Types of OLAPs
-
Oracle 10g (SQL)
- Introduction to Oracle Database
- Data Types
- SQL Statements: DDL – Data Definition Language
- SQL Statements: DML – Data Manipulation Language
- SQL Statements: DQL – Data Query language
- SQL Statements: DCL – Data Controlling language
- SQL Statements: TCS – Transaction Controlling Language
- Built-in functions: Character Functions
- Built-in functions: Numeric Functions
- Built-in functions: Data Functions
- Built-in functions: Conversion Functions
- Built-in functions: Aggregate Functions
- Joins: Inner Join
- Joins: Left Outer Join
- Joins: Cartesian Join
- Joins: Self-Join
- Joins: Right outer Join
- Joins: Full outer Join
- Joins: Natural Join
- Set Operators: Union
- Set Operators: Intersect
- Set Operators: Union All
- Set Operators: Minus
-
SAP BOBI 4.0 - Information Design Tool
- Creation of Project
- Relational Connection
- OLAP Connection
- Data Foundation Layer
- Business Layer
- Edit Connection
- Shortcut Connection
- Secured Connection
- Secured 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
- Arrange Tables: Filter Table values in Data Foundation
- Arrange Tables: Edit Table values: Removing Columns, Changing Data types & Keys
- Arrange Tables: Calculated Column in Tables
- Arrange Tables: Sort and re-ordering the columns in Data Foundation
- Arrange Tables: Refresh Structure
- Arrange Tables: Derived tables
- Arrange Tables: Create Views
- Arrange Tables: Detect Join, Cordiality, Alias, Keys, Row Counts
- Arrange Tables: Resolving Loops
- Arrange Tables: Alias
- Arrange Tables: Context
- Business Layer: Folders (Class)
- Business Layer: Sub Folder (Sub Class)
- Objects: Dimension
- Objects: Measure
- Objects: Attribute
- Filter: Native Filter
- 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
- 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
- Functions: @Prompts
- Functions: @Select
- Functions: @Where
- Functions: @Variable
- 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
