SAP BO


Introduction to Business Objects and its product suite

  • BO Architecture
  • Designer tool – Universe Designer
  • Reporting tools – Desktop Intelligence, Web Intelligence, Crystal Reports
  • Administration tools- CMC, CMS
  • Different servers with its usage/Impact
  • Detailed Caching Mechanism.
  • Clustering Concepts

Universe Designer

  • What is Semantic Layer/Business Layer?
  • What is a Universe?
  • Understand the role of a Designer
  • Know more about the way Business Objects generates SQL
  • Universe parameters
  • Universe Connections - Types of Connection
  • Creating Connections
  • Creating a Universe
  • Universe Schema
  • Adding tables
  • Defining Joins
  • Cardinality
  • Detecting Cardinality
  • Creating Classes
  • What are Universe Objects?
  • Creating Objects
    • Dimensions
    • Details
    • Measure
  • Organize the universe into classes and sub-classes
  • Conditions
  • Loops
    • Define what a loop is
    • Detect and recognize loops within a universe structure
    • Resolve loops in a universe
    • Resolve loops using aliases – when and how to do it
    • Recognize candidates for aliases from the “table tree” concept
    • Resolve loops using contexts – when and how to do it
    • Context? In which context they are used? Advantages and Disadvantages of the same?
    • Understand when and why contexts need to be updated
    • Recognize situations in which manual resolution of loops is obligatory
  • Traps
  • List of values
    • Associate or remove a list of values for an object
    • Control how lists of values are refreshed
    • Export a list with the universe
    • Modify a list of values using a condition
    • Base a list of values on a personal data file
    • Cascading LOV.
  • Creating Prompts in Universe
  • Hierarchies
  • Integrity Check
  • Usage of @Functions in Designer, main focus on @aggregate_aware.
  • Row level security at Designer level with examples?
  • Linking universes? Advantages and disadvantages. Different approaches.
  • Exporting/Importing Universes
  • Maintaining, managing Universes
  • Testing universe with reporting tool

  • Desktop Intelligence

    • Introduction to Business Objects Analytical Reporting
    • Data Providers
    • Types of Data Providers
    • Inserting a Table, Chart, Cross Tab reports
    • Creating different Chart reports
    • Changing Chart style
    • Personal Data File as Data Provider Free hand SQL as Data Provider
    • Exporting documents to PDF, HTML etc.
    • Grouping of Data
    • Filtering Data
    • Alerter
    • Calculating and displaying Rank
    • Variables and functions
    • Creating Drill Down Reports
    • Publishing, Sending a Document to User(s)/Group(s)
    • Linking Data Providers
    • Creating and using Prompts

    Web Intelligence

    • About Infoview application
    • Getting started with Infoview
    • Creating and viewing WebIntelligence Documents on Web (Infoview)
    • Creating and viewing Full Client/Business Objects Documents on Web (Infoview)
    • Restricting data returned by a query
    • Create formulas and variables
    • Analyzing Data at a deeper level
    • Publishing Reports/Documents
    • Corporate documents, Personal documents, Inbox documents
    • Sending documents to user(s)/group(s)
    • Scheduling documents
    • Hands on practice session
    • Hyperlink

    Infoview

    • About Infoview application
    • Log on to and off from InfoView
    • Access documents
    • Manage document categories
    • Set password options
    • Use online Help
    • Customize a personalized view of InfoView
    • Create dashboards for My InfoView
    • Managing documents in InfoView
    • Viewing a Web Intelligence document in InfoView
    • Setting InfoView Preferences
    • Creating an InfoView dashboard with My InfoView
    • Set viewing options
    • View and modify WebIntelligence documents in HTML Interactive format
    • View documents in different formats
    • Analyze Web Intelligence documents in Drill mode
    • Refresh and Print documents from InfoView
    • Using Discussion and Encyclopedia

    Business Objects Security – CMC

    • Business Objects Repository, Creation and Maintenance
    • Business Objects Repository Domains – (Security, Universe and Document domains)
    • Creating groups
    • Creating users
    • Setting properties of users
    • Setting Privileges to users & groups

    Crystal Reports (Concepts and demo only. No hands on)

    • About Crystal Report Architecture.
    • Differentiate between Business Objects Reporting and Crystal Reporting.
    • Restricting data returned by a query
    • Create formulas and variables
    • Working with simple table report, Chart report, Cross-tab Report
    • Exporting Data
    • Analyzing Data at a deeper level
    • Creating Drill down reports
    • Calculating and displaying Rank

    Crystal Xcelsius (Concepts and demo only. No hands on)

    • Xcelsius Overview
    • Basic Dashboard Design
    • Using Charts
    • Drill-down charts
    • Selectors
    • Alerts
    • Dynamic visibility
    • Exporting Dashboards