Facebook Twitter google plus LinkedIn

Email:contact@psntrainings.com
india:Whatsapp No+91 86860 29160 USA:+1 228 586 3560

SAP BO Training



Course Description

Introduction

  • Datwarehouse concepts
  • Difference between Versions 5.x/6/5/XI R1, R2, R3
  • Business objects XIR3 Suite
  • Extendibility of Business objects XIR3 (Introduction to BO- SAP Integration/Dashboard/Xcelsius/Query as Web Service)
  • Role of Business objects in Data warehousing real time life cycle.

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
  • Understanding classes and objects
  • Creating classes and objects
  • Understanding measure objects
  • Working with LOVs in Designer
  • Creating a cascading LOV
  • Resolving loops using aliases
  • Resolving loops using shortcut joins
  • Resolving loops using contexts
  • Resolving chasm traps
  • Resolving fan traps
  • Restricting the data returned by objects
  • Using @ Functions
  • Working with hierarchies
  • Using derived tables
  • Creating links between universes
  • Setting access restrictions on a universe
  • Documenting universes
  • Deploying and maintaining universes

Advanced Designer

  • Use your universe design and Business Objects Universe Designer knowledge to solve Business problems
  • Define aggregate awareness
  • Apply aggregate awareness to objects
  • Combine database functions in objects
  • Construct relative data-time objects
  • Create complex predefined conditions
  • Work with advanced LOVs
  • Work with advanced join syntaxes
  • Define connection and user credential parameters
  • Work with Central Management Server (CMS) universe security
  • Move content from development to production
  • Maintain universe design
  • Work with OLAP universes

Designing Topics We can Show by using Following Databases

  • Oracle
  • Ms-Access
  • SqlServer
  • TeraData
  • SAP BW

Desktop Inte

  • Displaying data in tables and charts
  • Using breaks and cross tabs
  • 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
  • Formatting charts
  • Understanding formulas and variables
  • Understanding how Web Intelligence calculates data
  • Creating formulas and variables to calculate data
  • Adding a new query using a personal data provider
  • Creating multiples queries in a document
  • Synchronizing data with merged dimensions
  • Analyzing the data cube
  • Drilling into the data
  • Setting Web Intelligence drill options
  • Exporting documents from the Rich Client
  • Accessing Info View
  • Managing documents in Info View
  • Scheduling a Web Intelligence document
  • Setting Info View preference

Advanced Webi reporting

  • Using combined queries
  • Using sub-queries
  • Creating a query based on another query
  • Changing data sources
  • Understanding the impact of the query drill on performance
  • Understanding calculation contexts
  • Redefining calculation context
  • Using character string functions
  • Using the replace( ) function
  • Using the right ( ) function
  • Using the Substring ( ) function
  • Using the Pos ( ) function
  • Using If ( ) to group data
  • Using data tracking
  • Using additional report function
  • Understanding the options for creating hyperlinks in Web Intelligence
  • Creating hyperlinks in the different Web Intelligence interfaces

Webi rich client

  • Web Intelligence Rich Client general preferences
  • To create a new document in Web Intelligence Rich Client without Universe
  • To select a universe in Web Intelligence Rich Client
  • How does Web Intelligence generate combined queries?
  • Scope of analysis
  • Levels of scope of analysis
  • To set the scope analysis 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 Introduction to Dashboard Creating Dashboards Contents
  • What is Dashboard Builder?
  • Creating an Analytic based on a Universe Query
  • Creating a Corporate Dashboards folder
  • Creating a pie chart based on sales of product lines
        *   Selecting data for the pie chart
        *   Saving your pie chart
  • Creating a bubble chart that compares product line sales to Revenues
  •     *   Selecting data for the bubble chart
        *   Saving your bubble chart
  • Scheduling an Analytic Refresh
  •     *   Scheduling a refresh on your bubble chart
  • Designing a Corporate Dashboard
  •     *   Analytics in dashboards
        *   Set the dashboard preferences
        *   Creating a dashboard
        *   Add a text analytic to the dashboard
  • Creating a speedometer gauge that shows profit margins
  •     *   What is a speedometer?
        *   Getting Started Creating Dashboards
        *   Selecting the data for the speedometer
  • Creating a dashboard tab that contains analytics
  • Creating a dashboard sub tab with web page and viewer analytics
  •     *   Creating a sub tab
        *   Adding a web page analytic to the sub tab
        *   Adding a viewer to the dashboard sub tab

    Data source Migration

    • Migrating reports and data sources
    • Migration options
    • Modifying the migration setting

    Import Wizard / Report Conversation

    • Using Import wizard
    • Creating of BIAR
    • Migrating the BO objects from one CMS to another CMS
    • Migrating the objects from one domain to another (dev/stage/Prod)

    Publishing

    • Publish the Webi report between different CMS
    • Publish the converted reports (deski to webi) to destination servers
    • Publishing the repository objects

    CMC/CCM/CMS

    • Introduction of Window and web based Central management in BOXIR3
    • Roles and responsibilities of Contents of CCM/CMS/CMC
    • When to use CCM/CMS/CMC
    • Detail description of contents of CCM/CMS/CMC
    • Case study

    BO-SAP INTEGRATION

    • Understanding common interfaces between BOXIR3 and SAP
    • Installation and Integration methods
    • Bring the SAP environment in to BOXIR3 and vice versa
    • Working with SAP objects in Crystal 2008 (Info cubes/SAP Table)

    Crystal Report 2008

    • 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
    • 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
    • Using Custom Functions
    • How to Publish Crystal Report in Bo-Enterprise Portal
    • Scheduling

    CRYSTAL XCELSIUS

    • Understanding crystal xcelsius
    • Creating templates
    • Creating scorecard and dashboard using xcelsius

    BO-VOYAGER

    • Understanding Voyager
    • Creation of personal and corporate voyager
    • Publishing the voyager
    • Importing cubes in voyager & Report Development

    Bo-Administration

    • Computer setup
    • Business Objects Enterprise Architecture
    • Creating Folders, Users and groups
    • Publishing and configuring the servers
    • Scheduling

    Topic on Report Conversion Tools



    Enquiry