Business Objects Course Content
Overview:
Business Objects offers a broad portfolio of tools and applications designed to assist you optimize business performance by connecting individuals, data and businesses across the business networks. It can take the form of a data array but is not a database itself. It presents business entities such as an invoice, a transaction or a person. BO’s are inherently scalable due to the architecture of object-oriented software applications.
Training Objectives of BO:
Business Objectives are the ends that an organization sets out to achieve. A business creates business plans to enable it to achieve these ends – thus plans are nothing but ends. The objectives and plans that an organization creates are determined by balancing the requirements of the various stakeholders in the organization. The Complete course provides a detailed outlook on queries, analysis and reporting techniques that equips users in the basic skills required to create basic reports.
Target Students / Prerequisites:
Students must be familiar with Windows based software and able to log in to the network and also having a Business Objects account.
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- SAP 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