Boston Computer School

You are here:  Home » Courses » Datawarehousing » BUSINESS OBJECTS 

BUSINESS OBJECTS

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

Course: BUSINESS OBJECTS

BCS Fees: $1500