SAP Business Intelligence and Business Objects Curriculum

Introduction

General Introduction.
SAP introduction.
Data warehousing/ BW/ BI Introduction
Master data; Attributes, Texts, and Hierarchies.
Standard Naming conventions in SAP and BI

Data Modeling

InfoObjects: Definitions
Types: Characteristics, Key Figures, Time, and Unit.
InfoCubes: Definitions.
Types: Standards, real time, remote.
Design of Infocube: Star Schema concepts. Precautions.
DataStore objects (DSO):
Types: Standards, Real time.
InfoSets
MultiProviders: Scenarios to create Multiproviders.
Infocube VS DSO

Metadata and Document Management

BI Content: Definitions, How to install BI contents,

Defining extraction

For SAP source systems: Creating Generic dataSource and maintaining SAP delivered dataSource.
Or for files: Creating DataSources for File Source Systems

Defining transformations

Transformations and different scenarios.

Defining the data flow

Creating data transfer processes
Creating process chains

Scheduling and monitoring

Checking process chain runs
Monitor for extraction processes and data transfer processes

Performance optimization

Creating the first aggregate for an InfoCube
Using the BIA index maintenance wizard

User management

Setting up standard authorizations
Defining analysis authorizations

Transports Real business scenarios on different system environments, Moving objects from one system to another. BI SUITE: Business Explorer BEx Query Designer

Queries: New queries, Restricting Characteristics, Formulas and Exception Cells
Query Design: Defining Exceptions, Conditions, Restricted and Calculated KeyFigures
Variables: The Variable Wizard, Variable Types and Processing Types, query Properties
Component Properties: Properties of Characteristics, Attributes, Structure, Formula, KeyFigures
Structures: Creating Re-usable structures
Functions on BW Server: Copying queries between Cubes, Deleting Query Elements

Web Application Designer

WAD: Functions of WAD, Web Items Window, Template Window, Properties Window
Web Applications: Creating Web Applications, Settings, Stylesheets, Symbols and Properties
Design: Designing the Layout of Web Templates, working with Library for Web Items
Web Items: Tables, Filters, Checkboxes, Dropdown Box and other web items and their attributes

Activities

BEx Analyzer
BEx Web Application Designer
BEx Report Designer

BI Platform

Information Broadcasting (Overview)
Functions of the Broadcaster: Precalculating and Exporting into Enterprise Portal
User Guide: Distributing Queries and Web Templates, Scheduling Broadcasting Settings
Example Scenarios: Monthly Sales Reports, Ad-hoc Distribution Options.

OLAP

OLAP v OLTP: The OLAP Concept and differences between OLAP and OLTP
OLAP Functions: Aggregation, Currency Translation, Report-to-Report Interface
MetaData Repository: Searching for MetaData

Performance in depth

Data Model for Performance: Line Item Dimensions, Navigational attributes, Time-Dependent
BW Statistics: Query Analysis Tools, Performance Tables
Reporting Performance: Effective query design, Line-Item, Compression, Partitioning
Introduction to Aggregates
Data Load Performance: Parallelism, Impact of Aggregates

SAP Business Objects Introduction to SAP BO

Introduction : Integration with SAP BI – BO

Query As A Web Service
Universe Designer
Live Office
Xcelcius
Web Rich Client ( Web Intelligence)
Crystal Report

1.Query as Web service

Usage of Query as web service
How to configure and use
Viewing the Universe and Webi reports using web service
Viewing the Crystal XCelsius reports using web service

2. Universe Designer

Understanding how universes allow users to query databases using their everyday business terms
Creating an ODBC connection to the course database
Creating a universe
Populating the universe structure
Defining joins in a universe

3. Live Office

Introduction
How Data can be extracted using Live office
Extracting data in Xcelcius using Live Office

4.Xcelcius

Introducing Crystal Xcelcius with SAP implementation options.
Create a Crystal Xcelsius Dashboard from SAP data stored in a Microsoft Excel spreadsheet
sourced through Crystal Reports or Web Intelligence
Create a Crystal Xcelsius Dashboard fon SAP data stored in a Microsoft Excel Spreadsheet
created through the use of live Office
Create a Crystal Xcelsius Dashboard from SAP data stored in a Microsoft Excel spreadsheet
Created through the use of query as a Web Service (QaaWS)
Crystal Xcelsius Dashboards Using Analytics as part of Dashboard Manager
Create an Analytic Dashboard from SAP data through a Universe

5.Web Rich Client ( Web Intelligence)

Introduction to desktop intelligence
Report Creation
Publishing the report
Understanding how universes allow you to query database using everyday business terms
Understanding Web Intelligence core functionalities
Creating a document in the Web Intelligence Rich Client
Viewing a Web Intelligence document in Info View
Building a simple query
Modifying a document query
Working with query properties
Restricting data with query filters
Modifying a query with a predefined query filter
Applying a single-value query filter
Using prompts to restrict data
Using complex filters
Working in the Report Panel
Displaying data in tables and charts
Using breaks and cross tabs
Formatting break, calculations, and report filters
Formatting breaks and cross tabs
Using default and custom sorts
Ranking data to see top or bottom values
Using alerter to highlight information
Organizing a report into sections
Copying data to other applications
Preparing document for PDF and print
Document formatting
Exporting documents from the Rich Client
Accessing Info View

6.Crystal Reports:

Introduction to Crystal Reports
Creating Reports
Selecting Records
Organizing Data on Reports
Formatting & Section Formatting
Creating basic and complex formulas
Using Variables and Arrays
Using Report Templates
Applying Conditional Reporting
Building parameterized and specialized reports
Summarizing Data with Cross Tabs
Using Report Sections
Representing Data Visually
Managing Reports
Distributing Reports
Using Repository and Repository data sources
Report Processing
Using sub Reports