SAP Business Objects Online Training

Duration 25 Hrs

Bo Integration

Overview - System Set up and Administration

• SAP BO Integration Kit
  
• Installation & Configuration
• SAP BO integrated solution approach
• Server administration
• SAP Authorization administration scenario

Overview

• Integrated solution architecture
  
• OLAP Universe design approach
  
• Connectivity Options
  
• Variables & Prompting
  
• Hierarchies
  
• Publishing
  
• OLAP universe maintenance

Reporting and data visualization

• WEB- I report on SAP BI source
  
• Design Principals
  
• List of Values
  
• Delegated Search
  
• Smart Measures
  
• Crystal reporting on SAP BI source
  
• Voyager on SAP BI
  
• Connectivity Overview (QaaWS and Live Office)
  
• Xcelsius on SAP BI

Performance Management

• BIA and BO integration
• Other performance management options

Crystal Reports Basic: Fundamentals of Report Design

Planning a Report

• Define database concepts
• Plan and develop a report prototype

Creating a Report

• Create a report
  
• Add tables
  
• Describe the design environment
• Insert objects on a report
• Preview a report
• Save a report
• Position and size objectso Format objects

Selecting Records

• Define the Select Expert
  
• Determine the criteria for record selection
  
• Understanding saved and refreshed data
  
• Apply record selection
  
• Apply additional record selection criteria
  
• Modify record selection
  
• Apply time-based record selection

Organizing Data on a Report

• Sort records
  
• Group records
  
• Summarize data

Formatting a Report

• Add graphical elements
  
• Combine text objects with database fields
  
• Apply specialized formatting
  
• Insert fields with pre-built functions

Applying Section Formatting

• Format sections
• Create a summary report

Creating Basic Formulas

• Define a formula and its purpose
  
• Create formulas
  
• Apply Boolean formulas
  
• Apply If-Then-Else formulas
  
• Apply date calculations
  
• Apply number calculations
  
• Apply string manipulation

Applying Conditional Reporting

• Determine trends in data
• Format data conditionally

Representing Data Visually

• Create a chart

Distributing a Report

• Export a report
• Save a report to BusinessObjects™ Enterprise

Crystal Reports: Business Reporting Solutions

Using the Repository

• Use the repository
  
• Create a report from a repository data source

Creating Formulas

• Use functions and operators
• Define control structures available in Crystal Reports Syntax

Managing Reports

• Use the Workbench
• Publish reports to Business Objects Enterprise

Using Variables and Arrays

• Use variables
  
• Use arrays

Using Report Templates

• Apply report templates
  
• Build a template without a data source
  
• Remove a template

Building Parameterized Reports

• Define and create parameters
  
• Build a report with multiple parameters
  
• Use edit masks and descriptions
  
• Create a date range parameter
  
• Group using parameters

Summarizing Data with Crosstabs

• Build a basic crosstab
  
• Format a crosstab

Using Report Sections

• Use sections
  
• Use group related functions to format sections
  
• Use section underlay
  
• Use multiple-column reporting

Building Specialized Reports

• Use the Running Total Expert
  
• Create a form letter
  
• Add a hyperlink to a report
  
• Use Dynamic Graphic Locations
  
• Build a report with alerts
  
• Build a top N report

Xcelsius 2008: Core and Connectivity
Creating a Model

• Producing interactive visualizations of your data
  
• Getting around in Xcelsius
  
• Working with your Excel workbook
  
• Visualizing data with charts
  
• Using Xcelsius Components
  
• Distributing your Xcelsius Visualization
  
• Applying best practices for designing models

Formatting a Model

• Applying formatting options
  
• Using themes and templates to apply formatting

Adding Interactivity to a Model

• Using selectors
  
• Adding dynamic visibility
  
• Troubleshooting

Creating a Connected Model

• Using live data sources
  
• Connecting to XML Data
  
• Connecting to data using an existing Web Service
  
• Connecting to Crystal Reports data
  
• Connecting to BusinessObjects Universes using Query as a Web Service
  
• Using Live Office data
  
• Using other connectivity components

Business Objects Universe Design

Understanding BusinessObjects Universes

• Define BusinessObjects universe concepts
  
• Use the universe development cycle

Creating the Course Universe

• Describe the course database and universe
  
• Create the course universes

Building the Universe Structure

• Populate the universe structure
  
• Define joins in a universe

Creating Dimension Objects

• Describe classes and objects
  
• Create classes and objects

Creating Measure Objects

• Define measure object concepts
  
• Create measure objects
  
• Create delegated measure objects

Resolving Loops in a Universe

• Understand loops
  
• Resolve loops using aliases
  
• Resolve loops using contexts

Resolving SQL Traps

• Understand SQL traps and universes
  
• Resolve fan traps
  
• Resolve chasm traps

Applying Restrictions on Objects

• Restrict the data returned by objects

Using @functions with Objects

• o Use @functions

Using Hierarchies

• Understand hierarchies and universes
  
• Work with hierarchies

Using Lists of Values

• Create a list of values
  
• Work with LOVs in Universe Designer
  
• Create a cascading LOV

Creating Derived Tables and Indexes

• Use derived tables
  
• Apply index awareness

Linking Universes

• Understand linked universes
  
• Create links between universes

Applying Universe Access Restrictions

• Set access restrictions on a universe

Managing Universes

• Understand linked universes
  
• Create links between universes

Applying Universe Access Restrictions

• Document universes
  
• Deploy universes
  
• Maintain universes
  
• Deploy universes in multiple languages

Business Objects Web Intelligence

Introducing Web Intelligence

• Describing Web Intelligence concepts
  
• Explaining Web Intelligence core functionality
  
• Describing Web Intelligence and BusinessObjects Enterprise

Creating Web Intelligence Documents with Queries

• Querying with Web Intelligence
  
• Creating a new document
  
• Modifying a document's query
  
• Working with query properties

Restricting Data Returned by a Query

• Restricting data with query filters
  
• Modifying a query with a predefined query filter
  
• Applying a single-value query filter
  
• Using wildcards in query filters
  
• Using prompts to restrict data
  
• Using complex filters

Designing Web Intelligence Reports

• Working with Web Intelligence documents
  
• Displaying data in tables and charts
  
• Creating tables
  
• Working with tables
  
• Presenting data in free-standing cells
  
• Presenting data in charts

Enhancing the Presentation of Data in Reports

• Using breaks, calculations
  
• Using sorts
  
• Formatting breaks and cross tabs
  
• Using report filters
  
• Ranking data to see top or bottom values
  
• Tracking data changes
  
• Using alerters to highlight information
  
• Organizing a report into sections
  
• Copying data to other applications

Formatting Reports

• Formatting documents
  
• Formatting charts

Calculating Data with Formulas and Variables

• Explaining formulas and variables
  
• Using formulas and variables

Using Multiple Data Sources

• Synchronizing data from multiple data sources
  
• Creating multiple queries in a document
  
• Synchronizing data with merged dimensions
  
• Using a personal data provider

Analyzing Data

• Analyzing the data cube
  
• Drilling in Web Intelligence documents
  
• Setting Web Intelligence drill options

Managing and Sharing Web Intelligence Documents

• Exporting documents to the CMS
  
• Logging into InfoView
  
• Managing documents in InfoView
  
• Viewing a Web Intelligence document in InfoView
  
• Sharing Web Intelligence documents
  
• Setting InfoView preferences
  
• Describing Web Intelligence report panels
  
• Logging off from InfoView