logo

Contact Us

info@scoopsolutions.com

Business Objects

Course content for these courses is designed to give the practitioner a thorough understanding of the fundamentals of these applications.

  • Web Intelligence 4.0 (3 Days)

    Introducing Interactive Analysis

    • Describing Interactive Analysis Concepts
    • Explaining Interactive Analysis Core Functionality
    • Describing Interactive Analysis and the SAP BO BI Platform

    Creating Interactive Analysis Documents with Queries

    • Querying with Interactive Analysis
    • Creating a New Document
    • Modifying a Document's Query
    • Working in the Query Panel

    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 Interactive Analysis Documents

    • Working with Interactive Analysis Documents
    • Displaying Data in Tables
    • Working with Tables
    • Presenting Data in Free-standing Cells
    • Presenting Data in Charts

    Enhancing the Presentation of Data in Documents

    • Using Breaks and Calculations
    • Using Sorts and Hiding Data
    • Formatting Breaks and Cross Tables
    • Filtering Report Data
    • Ranking Data
    • Tracking Data Changes
    • Highlighting Information with Formatting Rules
    • Organizing a Report into Sections
    • Copying and Pasting Data Blocks

    Formatting Interactive Analysis Documents

    • Formatting Documents
    • Formatting Charts

    Calculating Data with Formulas and Variables

    • Formulas and Variables
    • Using Formulas and Variables

    Using Multiple Data Sources

    • Synchronizing Data from Multiple Data Sources
    • Creating Multiple queries in a Document
    • Synchronized Data with Merged Dimensions
    • Using a Personal Data Provider

    Analyzing Data

    • Analyzing the Data Cube
    • Drilling in an Interactive Analysis Document

    Managing and Sharing Interactive Analysis Documents

    • Publishing Documents to the Corporate Repository
    • Logging in to the BI Launch Pad
    • Managing Documents in BI Launch Pad
    • Viewing an Interactive Analysis Document in BI Launch Pad
    • Sharing Interactive Analysis Documents
    • Setting BI Launch Pad Preferences
    • Logging off from BI Launch Pad

    Reviewing Web Intelligence core report design

    • Reviewing core report design concepts

    Working with advanced query techniques

    • Using Combined Queries
    • Using Subqueries
    • Creating a Query based on Another Query
    • Changing Data Sources

    Working with calculation contexts

    • Understanding Calculation Contexts
    • Redefining Calculation Contexts

    Creating formulas with character and date string functions

    • Using Character Strings
    • Using the Right() function
    • Using the Replace() function
    • Using the Substr() function
    • Using the Pos() function
    • Concatenating Different Character Strings
    • Using Date Functions

    Using If logic

    • Using If() to Group Data
    • Using the If() Function to Modify Calculation Behavior

    Working with additional reporting techniques

    • Using Data Tracking
    • Using Additional Report Functions

    Creating hyperlinks

    • Working with Hyperlinks in Interactive analysis Documents
    • Creating Hyperlinks in the Interactive Analysis Interactive Panel
    • Creating Hyperlinks in Interactive Analysis Desktop & the Java Report Panel
  • SAP BusinessObjects Dashboards 4.0 (2 Days)

    Creating a Dashboard

    • Producing Interactive Dashboards
    • Getting Around in Dashboards
    • Working with your Excel Work book
    • Visualizing Data with Charts
    • Using Dashboards Components
    • Applying Best Practices for Designing Dashboards
    • Distributing Your Dashboard

    Formatting a Dashboard

    • Applying Formatting Options
    • Using Themes and Templates to Apply Formatting

    Adding Interactivity to a Dashboard

    • Using Selectors
    • Adding Dynamic Visibility
    • Troubleshooting Unintended Behaviour in Your Dashboard

    Creating a Connected Dashboard

    • Using Live Data Sources
    • Connecting to XML data
    • Connecting to Data using an Existing Web Service
    • Connecting to Crystal Reports Data
    • Connecting to SAP BO Universes using Web Services Query (Query as a Web Service)
    • Connecting to SAP BO Universes using the semantic layer using the Query Browser
    • Using Live Office Data
  • Universe Design using Universal Designer 4.0 (5 days)

    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

    • 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

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

    Reviewing Universe Design Concepts

    • Use your universe design and BusinessObjects Universe Designer knowledge to solve business problems
    • Describe the course universe, database data, and structure

    Working with Aggregate Awareness

    • Define aggregate awareness
    • Apply aggregate awareness to objects

    Designing Advanced Objects

    • Combine database functions in objects
    • Construct relative date-time objects

    Creating Complex Predefined Conditions, LOVs, and Joins

    • Create complex predefined conditions
    • Work with advanced LOVs
    • Work with advanced join syntaxes

    Securing Universes

    • Define connection and user credential parameters
    • Work with Central Management Server (CMS) universe security
    • Work with table mapping

    Implementing Universe Life Cycle Management

    • Move content from development to production

    Maintaining and Optimizing Universes

    • Optimize universes
    • Apply foreign key index awareness
    • Apply best practices for universe design

    Universe Design – Information Design Tool (5 days)

    Introduction to the Information Design Tool

    • What is the Information Design Tool?
    • Introduction to Resources and Workflows

    Creating the Data Foundation

    • What is a Connection
    • Creating a Data Foundation
    • Defining Joins

    Creating a Business Layer

    • Describing Folders and Objects
    • Creating Measure Objects

    Resolving Loops in a Universe

    • Understanding Loops
    • Resolving Loops using Contexts

    Applying Restrictions

    • Defining Data Restrictions

    Using List of Values and Parameters

    • Creating a List of Values
    • Understanding Parameters

    Using @functions with Objects

    • Understanding @functions

    Using Navigation Paths

    • Navigation Path

    Aggregate Awareness

    • Defining Aggregate Awareness

    Creating Derived Tables and Indexes

    • Using Derived Tables
    • Applying Index Awareness

    Managing Universes

    • Deploying and Managing and Maintaining Universes

    SQL Traps

    • Understanding SQL Traps and Universes
    • Detecting and Resolving Chasm Traps
    • Detecting and Resolving Fan Traps

    Advanced Use of the @ Aggregate_Aware Function

    • Advanced Use of @Aggregate_Aware
    • Using @AggregateAware to resolve a 2-Table Fan Trap
    • Using @AggregateAware to resolve an Ambiguous Outer Join

    Creating Universes from different Data Sources

    • Creating Universes from Different Data Sources
    • Creating an OLAP Universe
    • Creating a Multisource Universe

    Deploying a Universe in different languages

    • Using the Translation Management Tool

    Managing and Optimizing Universes

    • Managing a Universe with Data Foundation and Business Layer Views
    • Working with a Shared Project
    • Optimizing the Universe
  • SAP Crystal Reports 2011/13 (5 days)

    Planning a Report

    • Defining Database Concepts
    • Planning and Developing a Report Prototype

    Creating as Report

    • Creating a Report
    • Adding Tables
    • Design Environment
    • Inserting Objects on a Report
    • Previewing a Report
    • Saving a Report
    • Positioning and Sizing Objects
    • Formatting Objects

    Selecting Records

    • Select Expert
    • Determining the Criteria for Record Selection
    • Saved versus Refreshed Data
    • Applying Record Selection
    • Setting Additional Criteria
    • Modifying Record Selection
    • Applying Time-Based Record Selection

    Organizing Data on a Report

    • Sorting Records
    • Grouping Records
    • Creating Nested and Multiple Groups
    • Adding a Specified Order Group
    • Grouping on Time-Based Data
    • Creating a Grand Total
    • Summarizing Data

    Formatting a Report

    • Adding Graphical Elements
    • Applying Specialized Formatting
    • Combining Text Objects with Database Fields
    • Inserting Fields with Pre-Built Functions

    Applying Section Formatting

    • Formatting Sections
    • Creating Summary Reports

    Creating Basic Formulas

    • Defining a Formula
    • Creating Formulas
    • Applying an If-Then-Else Formula
    • Applying Boolean Formulas
    • Applying Date Calculations
    • Applying Numeric Calculations
    • Applying String Manipulation

    Applying Conditional Formatting

    • Formatting Data Conditionally
    • Adding Key Performance Indicators

    Representing Data Visually

    • Creating a Chart
    • Charting on Details or Formula Information
    • Customizing a Chart

    Distributing a Report

    • Exporting a Report
    • Saving to SAP BO BI Platform

    Building Reports from Repository Objects

    • Organizing Repository Objects
    • Building a Report Based on Repository Objects

    Creating Formulas

    • Adding Functions & Operators to a Formula
    • Writing Control Structures in Crystal Syntax

    Managing Reports

    • Organizing Reports in the Workbench
    • Publishing Reports to SAP BO BI Platform

    Creating Variables and Arrays

    • Creating Variables
    • Creating Arrays

    Building Report Templates

    • Building a Template based on a Report
    • Building a Template without a Data Source
    • Removing an Applied Template

    Building Parameterized Reports

    • Creating a Parameter
    • Build a Report with Multiple Parameters

    Summarizing Data with Crosstabs

    • Creating a Basic Crosstab
    • Formatting a Crosstab

    Dividing a Report into Sections

    • Inserting Sections
    • Formatting Sections

    Building Specialized Reports

    • Building a Report with Running Totals
    • Building a Report with Linking
    • Building a Report with Alerts
    • Building a Top N Report
    • Building a Report with Flash Integration

    Understanding Report Processing

    • Multi-pass reporting
    • Applying evaluation time functions
    • Using a dynamic array

    Using Subreports

    • Defining subreports
    • Creating an unlinked subreport
    • Creating a linked subreport
    • Creating on-demand subreports
    • Using shared variables with subreports
    • Linking unlinkable data
  • SAP BusinessObjects Data Services 4.0 (5 days)

    Defining Data Services

    Defining Source and Target Metadata

    • Defining Datastores in Data Services
    • Defining Data Services System Configurations
    • Defining a Data Services Flat File Format
    • Defining Datastore Excel File formats

    Creating batch jobs for data integration

    • Creating Batch Jobs

    Troubleshooting batch jobs

    • Setting Traces and Adding Annotations
    • Using the Interactive Debugger
    • Setting up and Using the Auditing Feature

    Using functions, scripts and variables

    • Using Built-in Functions
    • Using Variables, Parameters and Scripts

    Using Platform Transforms

    • Using Platform Transforms
    • Using the Map Operation Transform
    • Using the Validation Transform
    • Using the Merge Transform
    • Using the Case Transform
    • Using the SQL Transform

    Setting up error handling

    Capturing change in data

    • Capturing change in data
    • Using Source-Based Change Data Capture (CDC)
    • Using Target-Based Change Data Capture (CDC)

    Using Text Data Processing

    • Using the Entity Extraction Transform

    Using the data integrator platform transforms

    • Using Data Integrator Platform transforms
    • Using the Data Transfer Transform and Performance Optimization
    • Using the Pivot Transform
  • Analysis – Edition for MS Office and Edition for OLAP (2 days)

    Overview of Analysis, Office edition & OLAP edition

    • The Design Panel
    • Navigation Options

    Charts

    • Overview of Analysis charts
    • Adding a chart
    • Adding data to a chart
    • Defining an analysis using an empty chart component
    • Chart types
    • Bar and column charts
    • Multi line charts
    • Multi pie charts
    • Other charts
    • To change the chart type
    • Scrolling through charts
    • Customizing charts
    • Sub-analysis name and description
    • Chart styles
    • Chart color palettes
    • Display font
    • Displaying totals in charts
    • Displaying hierarchical chart labels
    • Hiding the chart legend
    • Chart axis labels
    • Y axis scale and symbol
    • Scatter chart and bubble chart measures
    • Configuring pie chart labels

    Filtering & Sorting

    • Filtering by measure
    • Filtering SAP BW data by measure
    • Filter types
    • To filter by measure
    • To modify an existing filter
    • Removing a filter
    • Removing a sort
    • Filtering by member
    • To remove or add individual members
    • Finding members
    • To select a range of members
    • Showing only selected members
    • To change the display of member keys and text
    • Displaying parent names
    • Hierarchy view and leaf members view
    • Favorite filters
    • Removing displayed members
    • Background filters
    • Removing null and zero values

    Sorting

    • Sorting values
    • Sorting member names
    • Removing a sort
    • Automatically removed sorts and filters
    • Removing a sort
    • Filtering By Measure

    Working with Hierarchies

    Insert Components

    Using Formulas to add additional information

    Conditional Formatting & Prompting

    • Applying conditional formatting
    • Editing conditional formatting
    • Removing conditional formatting

    Change Variables in Prompts and Add Calculations

    Combination of multiple functions into one action

    Advanced scenarios for formula usage

  • SAP Business Objects Business Intelligence Platform: Administration and Security (2 DAYS)

    What is SAP Business Objects Business Intelligence platform?

    • Describing SAP BO BI Platform
    • Working in BI Launch pad
    • Working in the Central Management Control

    Managing content and objects in SAP Business Objects Business Intelligence platform

    • Adding Objects in the Repository
    • Managing objects in SAP BO BI Platform

    Securing users and groups in SAP Business Objects Business Intelligence platform

    • Managing Users and Groups
    • Administering Rights in SAP BO BI Platform

    Managing applications security

    • Securing your applications in SAP BO BI platform

    Distributing content using scheduling and alerting

    • Scheduling objects
    • Managing instances
    • Managing Calendars
    • Managing Events
    • Working with Alerting

    Publishing and Publications

    • Publishing personalized reports

    SAP Business Objects Business Intelligence Platform: Administering Servers (Windows) (3 DAYS)

    SAP Business Objects Business Intelligence Platform

    • BI and SAP BO BI Platform
    • SAP BO BI platform Architecture

    Installation and Configuration

    • Installing SAP BO BI Platform – Server side Installation
    • Installing SAP BO Bi platform – Client-side Installation

    Server Administration and Management

    • Using the Central Management Console (CMC)
    • Using the Central Configuration Manager (CCM)

    Managing the Web Application Servers

    Managing the Central Management Server Databases

    • Managing the Central Management Server and system database
    • Managing Auditing

    Managing the file Repository Servers

    • Managing the file Repository Servers
    • Using the Repository Diagnostic Tool

    Managing the Adaptive Servers

    • Understanding Adaptive Job Servers
    • Understanding Adaptive Processing Servers

    Managing the Crystal Reports Servers

    Managing the Web Intelligence Servers

    Managing the Dashboard Servers

    Managing the Connection Server

    • Configuring the Connection Server and Connection Server 32

    Managing the Explorer Servers

    • The role of Explorer Servers

    Managing the Event Servers

    • Understanding the Event Servers

    Troubleshooting SAP BusinessObjects Business Intelligence Platform