Business Objects(BO) 4.0

Business Objects (BO) Version 4.0

Introduction
SAP BusinessObjects business intelligence (BI) solutions provide comprehensive business intelligence functionality that can empower your users to make effective, informed decisions based on solid data and analysis.

All users, from the high-end analyst to the casual business user, have access to the information they need -with minimal dependence on IT resources and developers.

With these powerful solutions, users throughout your enterprise can access, format, analyze, navigate, and share information across the organization.

SAP BusinessObjects BI solutions enable the following:

  • Advanced analytics
  • Dashboards and visualization
  • Information infrastructure
  • Query, reporting, and analysis
  • Reporting
  • Search and navigation

Course Contents

Information Design Tool(IDT) 4.1

Introduction to IDT
Creating Projects
Create a connection to a relational database
Create a data foundation based on a single source relational database
Create a business layer based on a single relational data source
Publish a new universe file based on a single data source
Retrieve a universe from a repository location
Publish a universe to a local folder
Retrieve a universe from a local folder
Open a local project
Delete a local project
Convert a repository universe from a UNV to a UNX
Convert a local universe from a UNV to a UNX
Creating Data Foundations
Overview of OLAP Connections
Overview of SAP BW Connections
Overview of a Query on an OLAP Universe
Creating Business Layers
Publishing Business Layers on CMS
Query Panel in Business Layer
Consistency Checks

Introduction to Web Intelligence Reporting

Introduction to Business Objects (Reporter) Module (Part 1)
What’s New in Web Intelligence
Introduction to Java Launch Pad
Launching Web Intelligence
Setting Web Intelligence Preferences
Navigate the Web Intelligence Interface
Creating Documents with Queries
Components of a Universe
Create a query using a universe as the data source
Modify a document’s query
Changing Data Sources
Work with query properties
Exploring the Query Panel toolbar
Exploring the Result Objects Pane
Exploring the Query Filters Pane
Viewing the Query Script
Create a query using a BEx query and an Analysis View
Restricting Data with Query Filters
Components of a Query Filter
Adding a Predefined Query Filter
Creating a Single-Value Query Filter
Creating a Prompted Query Filter
Setting Prompt Properties
Creating Complex Query Filters
Prioritizing Operators and Grouping Filters
Creating a Subquery

Continuation to Web Intelligence Module (Part II)

Designing Web Intelligence Documents
Components of a Web Intelligence Document
Customize Document Preferences
Displaying Data in Tables
Displaying Data in Charts
Displaying Data in Free-Standing Cells
Inserting Free-Standing Cells
Organizing Document Data
Grouping and Calculating Data
Applying Breaks to Group Data
Calculating Data
Applying Sorts to Data
Editing Break Properties
Adding Sections to a Report
Filtering Report Data
Applying Report Filters
Selecting a Report Filter
Filtering Data with Input Controls
Organizing Data
Ranking Data to See Top or Bottom Values
Folding and Unfolding Report Data
Hiding and Unhiding Report Data
Copying Data Blocks
Highlighting Data
Tracking Data Changes
Highlighting Data with Formatting Rules
Applying Multiple Conditions to Formatting Rules

Continuation to Web Intelligence Module (Part III)

Formatting Documents
Viewing Reports in Different Modes
Modifying Report Properties
Formatting Tables, Cells, and Sections
Formatting Cross Tables
Formatting Charts
Calculating Data with Formulas and Variables
Creating Formulas and Variables
Adding Formulas to a Document
Creating Variables in a Document
Creating a Formula from a Prompt Response
Creating a Variable to Calculate Data
Creating a Variable Using Document Functions
Modifying Data with Character and Date String Functions
Using Character String Functions
Using Date Functions
Calculating Data with Conditional Logic
Grouping Data Values with the If() Function
Synchronizing Data from Multiple Data Providers
Working with Multiple Data Providers
Projecting Data from a Single Query in Multiple Blocks
Projecting Data from Multiple Queries Using a Single Universe
Projecting Data Using Multiple Universes
Synchronizing Data with Merged Dimensions
Merging Dimensions to Link Two Data Sources
Analyzing Data in Drill Mode
Setting General Drill Options
Setting the Scope of Analysis
Drilling in a Document
Drilling in a Data Hierarchy
Drilling in Charts

Demo of Rich Client & Webi intelligence with Features Highlighted

SAP Business Objects Dashboards 4.1

Xcelsius Dashboard Overview
Creating Dashboards using Query As A Web Service (QAAWS) and Live Office
Create Drill Down dashboard reports
What’s new in SAP Business Objects Dashboards 4.1
Creating a Visualization
Producing interactive visualizations
Getting around in Xcelsius
Working with your Excel workbook
Visualizing data with charts
Using Xcelsius Components
Formatting a Visualization
Applying formatting options
Using themes and templates to apply formatting
Adding Interactivity to a Visualization
Using selectors
Adding dynamic visibility
Using live data sources
Connecting to BO Universes using Query as a Web Service
Using Live Office data
Creating Complex dashboards

SAP Lumira

Intro: SAP Lumira and its place in the analysis environment

Part 1 – Data Import, Preparation, Manipulation
Data import options
Measures and dimensions
Semantic enrichments
Data manipulation using predefined tools and formulas
Integrating data from multiple sources

Part 2 – Data Discovery and Visualization
Which chart type to use when
Navigating through data in a visual way using charts
Advanced chart features for multidimensional data
Creating your own data

Part 3 – Sharing options and next steps
Data storytelling
Sharing options
Lumira cloud

Analysis and Design Studio

Components and Data Sources for Analysis
Using Analysis Components and Data Sources
Customization for Workbook Data Analysis
Using the Basic Components of Analysis
Sorting and Filtering Workbook Members
Filtering Selected Workbook Members by Measure for Enhanced Analysis
Using Hierarchies for Data Analysis in Workbooks
Using Inserted Components to Add Workbook Functionality
Configuring Filter Components Using Formulas to Enhance the Workbook Layout
Defining Conditional Formatting Options for Workbooks
Using a Prompting Dialog in Workbook Queries
Extending Workbook Display Options with Functions and Microsoft Excel VBA
Using Styles to Customize Workbook Appearance
Setting Preferences to Control Workbook Behavior
Publishing Analysis Documents to the BI Platform Server
Presentation of Workbook Analysis Data
Presenting Analysis Data for Business Users
Understand the positioning of SAP Business Objects Design Studio
Understand the different deployment types and architecture
Learn how to design generic analytical applications
Learn how to use the different layout features to adapt the look and feel to your needs
Learn how to design “dashboard-like” applications
Learn how to use the embedded scripting environment to apply your business logic to an application and its components
Learn how to optimize applications for mobile consumption
Run a case study