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


  • 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

Leave a Comment

Your email address will not be published. Required fields are marked *

Scroll to Top