SAP BUSINESS OBJECTS (BO)

Duration of Training : 8 weekends
Syllabus
      • Data Warehousing/Dimensional Modeling Practical Concepts
        • OLTP vs. OLAP
        • Types of OLAP
        • Dimensional modeling
        • Data mart/Data warehouse Life cycle
        • Star/Snow/Extended Star schema desig
      • Database Concepts Needed For Data Warehousing
        • Joins & Cardinality
        • Views/Materialized Views
        • Date/Time Functions
        • Conversion functions

Derived table & Stored Procedure

    • Architectural Overview
      • Client tier components
      • Application tier components
      • Intelligence tier
      • Processing tier
      • Data tier
      • Security management
      • Information flow
    • Universe Design
      • Understanding Business Objects Universes
      • Creating the Course Universe
      • Building the Universe Structure
      • Creating Dimension Objects
      • Creating Measure Objects
      • Resolving Loops in a Universe
      • Resolving SQL Traps
      • Using List of Values
      • Applying Restrictions on Objects
      • Using @Functions with Objects
      • Using Hierarchies
      • Deriving Tables & Indexes
      • Working with Aggregate Awareness
      • Designing Advanced Objects
      • Creating Predefined Condition
      • LOVs & Joins
      • Securing Universes
      • Implementing Universe Life Cycle Mgmt
      • Maintaining & Optimizing Universes
      • Creating Universe from Other Data sources
    • Web Intelligence
      • Understand concepts of Web intelligence
      • Create Web Intelligence documents with Queries
      • Restrict data returned by a query
      • Design a report
      • Enhance the presentation of data in reports
      • Format a report
      • Calculate data with formulas and variables
      • Use multiple data sources
      • Analyze data
      • Manage and share Web Intelligence documents
      • Work with Advanced Query techniques
      • Work with calculation contexts
      • Create formulas with character & date string functions
      • Use “If” logic
      • Work with additional reporting techniques
      • Create hyperlinks
  1. Crystal Reports
    • Planning a Report
    • Selecting Records
    • Formatting a Report
    • Representing Data Visually
    • Distributing Reports
    • Creating Basic Formulas
    • Organizing Data on a Report
    • Applying Section Formatting
    • Applying Conditional Reporting
    • Using the Repository
    • Using Report Templates
    • Creating Formulas
    • Building Parameterized Reports
    • Summarizing Data with Cross-Tabs
    • Using Report Sections
    • Managing Reports
    • Presenting Data Visually
    • Add hyperlinks to a report
  2. Dashboard Builder
      • Understanding Dashboard Manager
      • Setting Up Dashboard Manager
      • Creating Metrics
      • Automating Dashboards with Rules
      • Creating Analytics
      • Creating Personal Dashboards
      • Creating Corporate Dashboards
      • Guiding Dashboard Navigation
  3. Migration To Boxir3
  4. Migration Fundamentals
    • How Business Objects Enterprise XI 3.0
    • Migration concepts
    • Import Wizard Concepts
    • Understanding object migration
    • Understanding user and group migration
    • Migration planning and assessment
    • After migration with the Import Wizard
  5. Administration
    • Understand the Business Objects
    • Enterprise interface & architecture
    • Manage Business Objects Enterprise content
    • Secure Business Objects Enterprise content
    • Secure application security
    • Schedule content
    • Publish reports
    • Identify Business Objects Enterprise architecture
    • Perform common server management tasks
    • Manage the Business Objects Enterprise servers
  6. Widgets
    • Installing BI Widgets
    • Using BI Widgets to Access BI Content
    • working with widgets
    • BI Widgets Content Authoring Guidelines
    • Auto refresh of Widgets
  1. Desktop Intelligence
    • Introduction to desktop intelligence
    • Scope of analysis
    • Report creation
    • saving the reports in local repository
    • publishing the report
    • Report conversion (desktop) to (Webi)
  2. Webi-Rich Client
    • Installing Web Intelligence Rich Client
    • Web Intelligence Rich Client working modes
    • Launching Web Intelligence Rich Client
    • To set user preferences in Web Intelligence Rich Client
    • Working with documents
    • Working with universes in Web Intelligence Rich Client
    • Accessing Web Intelligence from Info View
    • Working with queries in Web Intelligence Rich Client
    • Working with reports
  3. Universe Builder & Query Builder
    • Universe Builder basics
    • Building universes from XML metadata sources
    • Updating XML metadata source universes
    • Exporting a universe to a XML file format
  4. Query As Web Service
    • Configuring the QWS with BO System
    • Creating Webservice report from Universes
    • Creating WSDL reports
    • Using WSDL reports in external application
  5. Voyager
    • Getting Started with Business Objects Voyager
    • Using Queries to Analyze Cube Data
    • Using Charts to Visualize Data
    • Selecting Members to Display in Crosstabs and Charts
    • Sorting, Filtering, and Ranking Data
    • Highlighting Exceptions in Data
    • Saving and Sharing Voyager Workspaces
  6. Security Implementation
    • Creating Secured users group
    • Creation secured connections
    • Creation of Secured objects
    • Creation of security at Table, Column row level
    • Creation of secured restriction set and mapping to users or groups
  7. Import Wizardpublishing Wizard
    • Using Import wizard
    • Creation of BIAR
    • Migrating the BO objects
    • From one CMS TO ANOTHER CMS
    • Migrating the objects from one
    • domain to another (dev/stage/Prod)
    • Backup Maintenance Deployment
  8. Business View Manager
    • Creation of Semantic layer for Crystal reports
    • Creation of Dynamic list of values in Crystal reports
    • Creation of Cascading list of values in Crystal reports
    • Creating Data connection and Dynamic data connection
    • Creation of Data foundation
    • Creation of Business Element
    • Creation of Business View
    • Creation of LOV
    • Saving the Business view to repository
    • Accessing the Business View in Crystal reports using Database expert
    • Creation of Crystal reports using Business
  9. Live Office Reporting
    • Describe the benefits of using Live Office
    • Connect to the repository
    • Navigate the Live Office menu
    • Insert charts, crosstabs, and fields from a Crystal report
    • Insert report parts from a Web Intelligence document
    • Insert a new query based on a Universe
    • Insert Live Office objects into an email
    • Navigate and refresh Live Office objects
    • Enable consolidated prompts
    • Set refresh settings for objects
    • Set parameter binding
    • Take a snapshot
    • Save Live Office documents to the repository
    • Open and view Live Office documents from the repository
  10. Sap webi/dashboard reporting:
    • Creation of Web intelligence reports using Info cube & BW Query
  11. Introduction To Bo-Sdk
    • Introduction of BO Enterprise SDK
    • Choosing the right SDK
    • Customizing the Webi reports using SDK
  12. Introduction To Bo Extension Points
  13. How To Use & Leverage Bo Extension Points In Business Objects
    • Comparison of all BO Versions (5.x/6.5/XIR1/XIR2/XIR3)
    • Performance Tuning of Database w.r.t BO
    • Installation of BOXIR3 suite with System/Audit/Performance mgmt repositories
    • Using  Oracle /SQLSERVER/SAPBW
    • Testing & Migration of BO components from Dev/Stage/Production environment
  14. BO XI R3 certification guidelines:
    • Sample questions on Business Objects Certified Professional – Business Objects Web
  15. Intelligence XI 3.0 – Level One
    • Sample questions on Business Objects Certified Professional – Business Objects Web
    • Intelligence XI 3.0 –Level two