SAP-BI

 

Introduction

·  General Introduction.

·  SAP introduction.

·  Data warehousing/ BW/ BI Introduction

·  Master data; Attributes, Texts, and Hierarchies.

·  Standard Naming conventions in SAP and BI.

Defining extraction

·  For SAP source systems: Creating Generic data Source, C0-PA data Source and maintaining SAP  delivered LO and Non LO data Source

·  Or for files: Creating Data Sources for File Source Systems

OLAP and OLTP

·  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

Metadata and Document Management

·  BI Content: Definitions, How to install BI contents

Defining transformations

·  Transformations and different scenarios

·  Routines like- Start, End, Expert and Info object routines.

Defining the data flow

·  Creating data transfer process

·  Creating Info cube ,DSO, Multiprovider and Info set

·  Creating process chains

Performance optimization

·  Creating the aggregate Compression, Partition, Line Item and High Cardinality Dimensions and Index for an Info Cube.

·   Creating Attribute change run for master data

·  Creating Using the BIA index maintenance wizard.

BI Platform

·  Information Broadcasting (Overview)

·  Functions of the Broadcaster : Recalculating and Exporting into Enterprise Portal

·  User Guide : Distributing Queries and Web Templates, Scheduling Broadcasting

Scheduling and monitoring

·  Checking process chain runs

·  Monitor for extraction processes and data transfer processes

 

Reporting Activities

·  BEx Analyzer

·  BEx Web Application Designer

·  BEx Report Designer

Settings

·  Example Scenarios: Monthly Sales Reports, Ad-hoc Distribution Options.

Window

·  Web Applications : Creating Web Applications, Settings, Stylesheets, Symbols andProperties

·  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

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 .

 

Course Content for SAP-BO

  • Introduction to SAP BO
  • Introduction : Integration with SAP BI – BO
  • Tools Covered :
    1. Query As A Web Service
    2. Universe Designer
    3. Live Office
    4. Xcelcius
    5. Web Rich Client ( Web Intelligence)
    6. SAPBO-WIDGETS
    7. SAPBO-DASHBOARD BULDER

 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.SAPBO-WIDGETS

  • Installing BI Widgets
  • Using BI Widgets to Access BI content 19
  • Login to BI Widgets
  • Locating content BI content on one or more XI R3 servers
  • Using BI Widgets explorer to view content
  • Using BI Widgets with Xcelsius documents
  • Importing an Xcelsuis document as a widget
  • Selecting and opening a Web Intelligence Report
  • Viewing a Web Intelligence Document
  • Creating a Report Part Widget from a Report

 7.SAPBO-DASHBOARD BULDER

  • Getting started with Dashboard Builder
  • Creating Corporate Dashboards using Dashboard Builder
  • Creating Personal Dashboards using Dashboard Builder
  • Analyzing Dashboard Content
  • Setting Dashboard preferences in Info View
  • Customizing Dashboards