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