Boston Computer School

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- Intergration/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
• External Files (Flat files)
• SAP BW

Desktop Intelligence:

• Introduction to desktop intelligence
• Report Creation
• Publishing the report
• Report conversation (desktop) to (Webi)

Webi Reporting

• Accessing information with Web Intelligence
• 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
• 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
• Building parameterized and specialized reports
• 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
• Building query template in xcelsius
• 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