Fundamental Concepts
ü Definitions of Data warehouse
ü History of Data warehouseü Characteristics of Data warehouseü Data Martsü Tables (Dimensions and Fact Tables)ü Star Schema, Snowflake Schema/Extended Schema and Multiple Star SchemaDatabase Concepts:ü Introduction to databasesü Importance of Databaseü DDL, DML, DQL, DCL and TCLü Structuring of tables and Data Typesü Numeric Functions, Character Functions, Date Functions, Aggregate Functionsü Set Operatorsü Joins and Types of Joins and their importance (PK, FK)ü Group by, Having, Where conditionsLife Cycle Managementü Functional Specifications (FDD)ü Business Requirement (BRD)ü Project Planü Technical Design Document (TDD)ü Development executionü Unit Test case preparationü Deployment Check list

Pre requisites of BO

ü Non SAP applications as backend

• ODBC Connection (32 & 64 bit Operating System)

ü Knowledge on SAP BW BI (Cubes, BEX queries)

ü Knowledge on HANA

SAP BO Online Training Universes :

Universe Designer Tool – UDT	Information Designer Tool – IDT
Personal Connection	Local Connection (.CNX)
Shared Connection	Secured Connection (.CNS)
Secured Connection	Data Foundation (.DFX) – Connection, Context and Alias, Parameters and LOV’s
Linked universes	Business Layer (.BLX) – Classes & objects, Queries,Parameters and LOV’s and Navigation paths
è Universe parameters, Types of Business Objects Joins and their importance (Shortcut join, Theta Join etc.,)è Creation of Objects and types of Objects (Dimension, Measure and Detail)è Creation of Conditionsè Trap issues (Chasm and Fan)è Derived Tablesè Usage of @functions – @ Prompts, @Where, @Select, @Aggregate Awarenessè Types of Hierarchies and usage in Drilling functionalitiesè Managing Security from Universe – Row and Object Level Securityè Hiding and un hiding Objectsè Check Integrity of Data Foundation and Business layerè Single data sources and Multiple data sourcesè Performance Tuning methods

Business Intelligence Reports BOBI 4.1

Adhoc Reports	Canned Reports	Dashboards
Web Intelligence	Crystal Reports	Xcelsius
		Live Office -Plug in tool

Adhoc Reports

Web Intelligence Report
Introduction of web reporting	Charts, types of charts and various usage
Info Providers/Data Providers (Universe, Personal data Files )	Working with special Functions
Creation of reporting	Converting Horizontal, Vertical, Cross Tabs into Charts
Generating query’s	Drilling Functionalities – Drill up, Drill Down, Drill by
Viewing and Modifying a report	Purging of objects
Query Filters & various operators	Export Options (PDF, excel, CSV etc.,)
Query Prompts	Document Properties/Formatting
Sections/ Breaks	Input Controls
	Report Level Variables
Difference between Section & Break	Hyper Linking Functionalities
Alerter	Usage of Web Intelligence Rich Client Application
Ranking	Scheduling of Webi Report
Sorting	Folding and Unfolding of Reports
Merged Dimensions
Combined Queries (Union, Intersection and Minus)

Canned Reports

Crystal Reports
Introduction to CR	Field Explorer
Use of CR and its features	Repository Explorer & Database Expert
Difference between BO and CR	Report Templates
Standard Reports	Inbuilt Functionalities
Blank Report	SAP Platform interaction – BEX, Cubes, Info sets etc.,
Cross Tab Report	RDBMS Databases interaction
Creation of New CR	MS Access interaction
Different Data source Connections	** Maintenance and scheduling of Crystal Reports via BI Launch Pad application
Creation of CR with Universe
Creation of CR without Universe
Creation of Groups and Calculations
Working with Sub Reports
Charts

Dashboards

Dashboard Design (Static & Dynamic)
Introduction to Dashboards	Data Manager Connections
Types of Dashboards	Data Layer
Data Sources (or) Info Providers	Canvas layer
Generation of dashboards	Components Layer
Working with Data By Range, By Series	Properties Layer
Working with Dual Axis dashboard	Objects Browser
Working with Calendar & Bar Chart dashboard	Live Office (Universe, Web Intelligence, Crystal Report)
Working with Filter and multiple Charts dashboard	QAAWS Connectivity
Data Import and Exports	Query Builder

Web Based Applications of SAP BO Online Training :

ü BI Launch Pad

• Generation of Webintelligence reports
• Scheduling of Webi and Crystal reports
• Sending of Webi and Crystal reports
• Storage of Local documents (Organize and maintain documents)
• Folder structuring based on Line of Business

 

Performance Tuning Methods of SAP BO

• Tuning at Universe Level
• Tuning at Report Level
• Tuning at Database Level
• Query Optimization Methods

Error Handling Methods

• How to handle errors across the environments in Real Time scenarios.
• Trouble shooting tips and tricks

Project Explanation in terms of Real Time scenarios

• Project Overview (Life Cycle)
• Project Domain Explanation
• Designing the workflow
• Project Templates
• Report Requirement Templates

Assistance in Resume preparation

• Resume preparation tips and tricks

BO Architecture

Thanks…………………………………………………….!

sap bo Online training