SAP BusinessObjects Reporting Cookbook

Over 80 recipes to help you build, customize, and distribute reports using SAP BusinessObjects
Preview in Mapt
Code Files

SAP BusinessObjects Reporting Cookbook

Yoav Yahav

1 customer reviews
Over 80 recipes to help you build, customize, and distribute reports using SAP BusinessObjects
Mapt Subscription
FREE
$29.99/m after trial
eBook
$10.00
RRP $32.99
Save 69%
Print + eBook
$54.99
RRP $54.99
What do I get with a Mapt Pro subscription?
  • Unlimited access to all Packt’s 5,000+ eBooks and Videos
  • Early Access content, Progress Tracking, and Assessments
  • 1 Free eBook or Video to download and keep every month after trial
What do I get with an eBook?
  • Download this book in EPUB, PDF, MOBI formats
  • DRM FREE - read and interact with your content when you want, where you want, and how you want
  • Access this title in the Mapt reader
What do I get with Print & eBook?
  • Get a paperback copy of the book delivered to you
  • Download this book in EPUB, PDF, MOBI formats
  • DRM FREE - read and interact with your content when you want, where you want, and how you want
  • Access this title in the Mapt reader
What do I get with a Video?
  • Download this Video course in MP4 format
  • DRM FREE - read and interact with your content when you want, where you want, and how you want
  • Access this title in the Mapt reader
$0.00
$10.00
$54.99
$29.99 p/m after trial
RRP $32.99
RRP $54.99
Subscription
eBook
Print + eBook
Start 30 Day Trial

Frequently bought together


SAP BusinessObjects Reporting Cookbook Book Cover
SAP BusinessObjects Reporting Cookbook
$ 32.99
$ 10.00
Robot Operating System Cookbook Book Cover
Robot Operating System Cookbook
$ 39.99
$ 10.00
Buy 2 for $20.00
Save $52.98
Add to Cart

Book Details

ISBN 139781782172437
Paperback380 pages

Book Description

This book will educate you on the best practices in SAP BusinessObjects reporting and analysis, including how to create enhanced report formatting and synchronize data sources in simple and easy ways.

The book starts by introducing a working Web Intelligence environment and its capabilities. Next, it moves on to creating queries, working with the formatting components, and explaining how to work with different types of data presentation such as tables and charts. The book then guides you through the main report functionality such as using filters, sorts, and calculations; merging data; and using formulas. The book also explains how to work with advanced features such as drills and hyperlinks.

This book will take you from the most basic level of how to build a query and elementary concepts such as the nature of data to the most advanced and updated reporting and formatting techniques.

Table of Contents

Chapter 1: Working with the BI Launch Pad
Introduction
Connecting to the BI launch pad
Navigating within the BI launch pad
Using the BI launch pad toolbars
Adjusting the preferences
Searching documents
Launching applications
The report menu functionality
Working with different objects of the BI launch pad
Chapter 2: Creating New Queries
Introduction
The universe structure
Creating a simple query
Editing the query
Filtering the query results
Using prompts
Using AND/OR logic in conditions
Creating nested filters
Using a subquery
Using combined queries
Adding another query
Working with several queries
Working with the query properties
Using the data preview
Viewing the SQL
Using other query results
Scope of analysis
Using database ranking
Using BEx queries
Chapter 3: Working Inside the Report
Introduction
Understanding the structure of the Report layer
Understanding the concept of the microcube
Working with the Left Pane panels
Working with the report toolbars
Navigating between the view modes
The File and Properties tabs
Chapter 4: Working with Tables
Introduction
Getting to know the structure of tables
Working with different types of tables
Formatting tables
Working with cross tables
Hiding dimensions
Chapter 5: Working with Charts
Introduction
Working with the Line chart
Working with different chart types
Formatting charts
Chapter 6: Formatting Reports
Introduction
Using sorts
Using calculations
Using sections and breaks
Ranking
Conditional rules
Data tracking
Outline and fold
Chapter 7: Filtering the Report Data
Introduction
Applying a simple filter
Working with the filter bar
Using input controls
Working with an element link
Chapter 8: Merging Data
Introduction
Merging data from several queries
Understanding the merge logic
Merging data from different universes
Merging data from different data sources
Filtering matched values
Troubleshooting aggregation problems
Extending the data synchronization
Chapter 9: Using Formulas and Variables
Introduction
Using formulas
Working with variables
Using aggregate functions
Using character functions
Using data provider functions
Using date and time functions
Using document functions
Using logical functions
Using misc functions
Using numeric functions
Using extended syntax
Chapter 10: Using Hyperlinks
Introduction
Connecting reports
Passing parameters between reports
Linking to a web page
Creating and editing hyperlinks manually
Chapter 11: Using Drill
Introduction
Using the scope of analysis
Using a query drill
Using the drill formula
Chapter 12: Scheduling Reports
Introduction
Scheduling a report
Working with instance history
Publications
Advanced publication options
Chapter 13: Working with BI Workspaces
Introduction
Creating BI workspaces
Working with report parts
Chapter 14: Web Intelligence Rich Client
Introduction
Working with Web Intelligence Rich Client
Working with local data providers
Adjusting options

What You Will Learn

  • Master advanced report building techniques using SAP BusinessObjects
  • Discover tools to work efficiently in a BI environment
  • Learn using real scenarios, varied examples, and systematic execution of the solutions
  • Build variables and formulas to enhance the report calculation functionality such as if-then statements
  • Use drill-down and drill-through tasks to perform detailed analysis
  • Filter data using simple and advanced filters and advanced features such as input controls

Authors

Table of Contents

Chapter 1: Working with the BI Launch Pad
Introduction
Connecting to the BI launch pad
Navigating within the BI launch pad
Using the BI launch pad toolbars
Adjusting the preferences
Searching documents
Launching applications
The report menu functionality
Working with different objects of the BI launch pad
Chapter 2: Creating New Queries
Introduction
The universe structure
Creating a simple query
Editing the query
Filtering the query results
Using prompts
Using AND/OR logic in conditions
Creating nested filters
Using a subquery
Using combined queries
Adding another query
Working with several queries
Working with the query properties
Using the data preview
Viewing the SQL
Using other query results
Scope of analysis
Using database ranking
Using BEx queries
Chapter 3: Working Inside the Report
Introduction
Understanding the structure of the Report layer
Understanding the concept of the microcube
Working with the Left Pane panels
Working with the report toolbars
Navigating between the view modes
The File and Properties tabs
Chapter 4: Working with Tables
Introduction
Getting to know the structure of tables
Working with different types of tables
Formatting tables
Working with cross tables
Hiding dimensions
Chapter 5: Working with Charts
Introduction
Working with the Line chart
Working with different chart types
Formatting charts
Chapter 6: Formatting Reports
Introduction
Using sorts
Using calculations
Using sections and breaks
Ranking
Conditional rules
Data tracking
Outline and fold
Chapter 7: Filtering the Report Data
Introduction
Applying a simple filter
Working with the filter bar
Using input controls
Working with an element link
Chapter 8: Merging Data
Introduction
Merging data from several queries
Understanding the merge logic
Merging data from different universes
Merging data from different data sources
Filtering matched values
Troubleshooting aggregation problems
Extending the data synchronization
Chapter 9: Using Formulas and Variables
Introduction
Using formulas
Working with variables
Using aggregate functions
Using character functions
Using data provider functions
Using date and time functions
Using document functions
Using logical functions
Using misc functions
Using numeric functions
Using extended syntax
Chapter 10: Using Hyperlinks
Introduction
Connecting reports
Passing parameters between reports
Linking to a web page
Creating and editing hyperlinks manually
Chapter 11: Using Drill
Introduction
Using the scope of analysis
Using a query drill
Using the drill formula
Chapter 12: Scheduling Reports
Introduction
Scheduling a report
Working with instance history
Publications
Advanced publication options
Chapter 13: Working with BI Workspaces
Introduction
Creating BI workspaces
Working with report parts
Chapter 14: Web Intelligence Rich Client
Introduction
Working with Web Intelligence Rich Client
Working with local data providers
Adjusting options

Book Details

ISBN 139781782172437
Paperback380 pages
Read More
From 1 reviews

Read More Reviews

Recommended for You

SAP BusinessObjects Dashboards 4.1 Cookbook Book Cover
SAP BusinessObjects Dashboards 4.1 Cookbook
$ 39.99
$ 10.00
Learning SAP BusinessObjects Dashboards Book Cover
Learning SAP BusinessObjects Dashboards
$ 43.99
$ 10.00
SAP Data Services 4.x Cookbook Book Cover
SAP Data Services 4.x Cookbook
$ 47.99
$ 10.00
Real Time Analytics with SAP HANA Book Cover
Real Time Analytics with SAP HANA
$ 31.99
$ 10.00
SAP Lumira Essentials Book Cover
SAP Lumira Essentials
$ 35.99
$ 10.00
Getting Started with Oracle VM VirtualBox Book Cover
Getting Started with Oracle VM VirtualBox
$ 20.99
$ 10.00