You're reading from SAP BusinessObjects Reporting Cookbook Over 80 recipes to help you build, customize, and distribute reports using SAP BusinessObjects

Product type Paperback

Published in Aug 2014

Publisher

ISBN-13 9781782172437

Length 380 pages

Edition 1st Edition

Tools

SAP BusinessObjects

Concepts

Business Intelligence

Author (1):

Yoav Yohav

View More author details

Table of Contents (16) Chapters

Preface

What this book covers
What you need for this book
Who this book is for
Conventions
Reader feedback
Customer support

1. Working with the BI Launch Pad FREE CHAPTER

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

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

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

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

5. Working with Charts

Introduction
Working with the Line chart
Working with different chart types
Formatting charts

6. Formatting Reports

Introduction
Using sorts
Using calculations
Using sections and breaks
Ranking
Conditional rules
Data tracking
Outline and fold

7. Filtering the Report Data

Introduction
Applying a simple filter
Working with the filter bar
Using input controls
Working with an element link

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

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

10. Using Hyperlinks

Introduction
Connecting reports
Passing parameters between reports
Linking to a web page
Creating and editing hyperlinks manually

11. Using Drill

Introduction
Using the scope of analysis
Using a query drill
Using the drill formula

12. Scheduling Reports

Introduction
Scheduling a report
Working with instance history
Publications
Advanced publication options

13. Working with BI Workspaces

Introduction
Creating BI workspaces
Working with report parts

14. Web Intelligence Rich Client

Introduction
Working with Web Intelligence Rich Client
Working with local data providers
Adjusting options

Index

Chapter 6. Formatting Reports

In this chapter, we will cover the following recipes:

Using sorts
Using calculations
Using sections and breaks
Ranking
Conditional rules
Data tracking
Outline and fold

The rest of the chapter is locked

You're reading from SAP BusinessObjects Reporting Cookbook Over 80 recipes to help you build, customize, and distribute reports using SAP BusinessObjects

Table of Contents (16) Chapters

Chapter 6. Formatting Reports

Authors (1)

Personalised recommendations for you

You're reading from SAP BusinessObjects Reporting Cookbook Over 80 recipes to help you build, customize, and distribute reports using SAP BusinessObjects

Table of Contents (16) Chapters

Chapter 6. Formatting Reports

Unlock this book and the full library FREE for 7 days

Authors (1)

Personalised recommendations for you