BOXI (Duration: 50 Hrs)

(Administration, Architect and Report Development)

DATA WAREHOUSING/DIMENSIONAL MODELING PRACTICAL CONCEPTS

micro

  • OLTP vs. OLAP
  • Types of OLAP
  • Dimensional modeling
  • Data mart/Data warehouse Life cycle
  • Star/Snow/Extended Star schema design

DATABASE CONCEPTS NEEDED FOR DATA WAREHOUSING

micro

  • 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

micro

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

micro

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

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

MIGRATION TO BOXIR3

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

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

WIDGETS

  • Installing BI Widgets
  • Using BI Widgets to Access BI Content
  • working with widgets
  • BI Widgets Content Authoring Guidelines
  • Auto refresh of Widgets

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)

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

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

QUERY AS WEB SERVICE

  • Configuring the QWS with BO System
  • Creating Webservice report from Universes
  • Creating WSDL reports
  • Using WSDL reports in external application

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

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

IMPORT WIZARD\PUBLISHING 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

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

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

SAP WEBI/DASHBOARD REPORTING:

  • Creation of Web intelligence reports using Info cube & BW Query



INTRODUCTION TO BO-SDK

  • Introduction of BO Enterprise SDK
  • Choosing the right SDK
  • Customizing the Webi reports using SDK

INTRODUCTION TO BO EXTENSION POINTS

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

BO XI R3 CERTIFICATION GUIDELINES:

  • Sample questions on Business Objects Certified Professional - Business Objects Web

INTELLIGENCE XI 3.0 - LEVEL ONE

  • Sample questions on Business Objects Certified Professional - Business Objects Web
  • Intelligence XI 3.0 -Level two