SAP BusinessObjects Reporting Cookbook电子书

SAP BusinessObjects Reporting Cookbook

Table of Contents

SAP BusinessObjects Reporting Cookbook

Credits

About the Author

About the Reviewers

www.PacktPub.com

Support files, eBooks, discount offers, and more

Why subscribe?

Free access for Packt account holders

Instant updates on new Packt books

Preface

What this book covers

What you need for this book

Who this book is for

Conventions

Reader feedback

Customer support

Errata

Piracy

Questions

1. Working with the BI Launch Pad

Introduction

Connecting to the BI launch pad

Getting ready

How to do it...

How it works...

There's more...

See also

Navigating within the BI launch pad

Getting ready

How to do it...

How it works...

See also

Using the BI launch pad toolbars

How to do it...

How it works...

See also

Adjusting the preferences

How to do it...

How it works...

See also

Searching documents

Getting ready

How to do it...

How it works...

There's more...

Launching applications

Getting ready

How to do it...

How it works...

There's more...

The report menu functionality

Getting ready

How to do it...

How it works...

See also

Working with different objects of the BI launch pad

Getting ready

How to do it...

How it works...

2. Creating New Queries

Introduction

The universe structure

How to do it...

How it works...

There's more...

See also

Creating a simple query

Getting ready

How to do it...

How it works...

See also

There's more...

Editing the query

Getting ready

How to do it...

How it works...

There's more...

Filtering the query results

Getting ready

How to do it...

How it works...

There's more...

Using prompts

Getting ready

How to do it...

How it works...

There's more...

See also

Using AND/OR logic in conditions

Getting ready

How to do it...

How it works...

There's more...

Creating nested filters

Getting ready

How to do it...

How it works...

There's more...

Using a subquery

Getting ready

How to do it...

How it works...

There's more...

See also

Using combined queries

Getting ready

How to do it...

How it works...

There's more...

See also

Adding another query

Getting ready

How to do it...

How it works...

See also

Working with several queries

How to do it...

There's more...

See also

Working with the query properties

Getting ready

How to do it...

How it works...

See also

Using the data preview

Getting ready

How to do it...

How it works...

There is more

See also

Viewing the SQL

How to do it...

How it works...

There's more...

Using other query results

Getting ready

How to do it...

How it works...

There's more...

See also

Scope of analysis

Getting ready

How to do it...

How it works...

See also

Using database ranking

Getting ready

How to do it...

How it works...

There's more...

See also

Using BEx queries

Getting ready

How to do it...

How it works...

There's more...

3. Working Inside the Report

Introduction

Understanding the structure of the Report layer

Getting ready

How to do it...

How it works...

Understanding the concept of the microcube

Getting ready

How to do it...

How it works...

There's more...

See also

Working with the Left Pane panels

Getting ready

How to do it...

How it works...

There's more...

See also

Working with the report toolbars

Getting ready

How to do it...

How it works...

Navigating between the view modes

How to do it...

How it works...

The File and Properties tabs

How to do it...

How it works...

4. Working with Tables

Introduction

Getting to know the structure of tables

Getting ready

How to do it...

How it works...

There's more...

See also

Working with different types of tables

Getting ready

How to do it...

How it works...

See also

Formatting tables

Getting ready

How to do it...

How it works...

Working with cross tables

Getting ready

How to do it...

How it works...

See also

Hiding dimensions

Getting ready

How to do it...

How it works...

There's more...

5. Working with Charts

Introduction

Working with the Line chart

Getting ready

How to do it...

How it works...

There's more...

See also

Working with different chart types

Getting ready

How to do it...

How it works...

See also

Formatting charts

Getting ready

How to do it...

How it works...

There's more…

6. Formatting Reports

Introduction

Using sorts

Getting ready

How to do it...

How it works...

There's more...

Using calculations

How to do it...

How it works...

There's more...

See also

Using sections and breaks

Getting ready

How to do it...

How it works...

There's more...

Ranking

How to do it...

How it works...

There's more...

See also

Conditional rules

Getting ready

How to do it...

How it works...

There's more...

Data tracking

Getting ready

How to do it...

How it works...

Outline and fold

Getting ready

How to do it...

How it works...

See also

7. Filtering the Report Data

Introduction

Applying a simple filter

Getting ready

How to do it...

How it works...

There's more...

Working with the filter bar

Getting ready

How to do it....

How it works...

There's more...

Using input controls

Getting ready

How to do it...

How it works...

There's more...

Working with an element link

How to do it...

How it works...

There's more...

8. Merging Data

Introduction

Merging data from several queries

Getting ready

How to do it...

How it works...

There's more...

See also

Understanding the merge logic

Getting ready

How to do it...

How it works...

There's more...

Merging data from different universes

How to do it...

How it works...

There's more...

Merging data from different data sources

Getting ready

How to do it...

How it works...

There's more...

Filtering matched values

Getting ready

How to do it...

How it works...

Troubleshooting aggregation problems

Getting ready

How to do it...

How it works...

There's more...

Extending the data synchronization

Getting ready

How to do it...

How it works...

See also

9. Using Formulas and Variables

Introduction

Using formulas

Getting ready

How to do it...

How it works...

See also

Working with variables

Getting ready

How to do it...

How it works...

There's more...

Using aggregate functions

How to do it...

How it works...

See also

Using character functions

How to do it...

How it works...

Using data provider functions

How to do it...

How it works...

Using date and time functions

How to do it...

How it works...

Using document functions

How to do it...

How it works...

There's more...

Using logical functions

How to do it...

How it works...

Using misc functions

How to do it...

How it works...

Using numeric functions

How to do it...

How it works...

Using extended syntax

How to do it...

How it works...

There's more...

10. Using Hyperlinks

Introduction

Connecting reports

Getting ready

How to do it...

How it works...

See also

Passing parameters between reports

Getting ready

How to do it...

How it works...

Linking to a web page

Getting ready

How to do it...

How it works...

See also

Creating and editing hyperlinks manually

Getting ready

How to do it...

How it works...

See also

11. Using Drill

Introduction

Using the scope of analysis

Getting ready

How to do it...

How it works...

Using a query drill

Getting ready

How to do it...

Using the drill formula

Getting ready

How to do it...

See also

12. Scheduling Reports

Introduction

Scheduling a report

Getting ready

How to do it...

How it works...

Working with instance history

Getting ready

How to do it...

How it works...

Publications

Getting ready

How to do it...

How it works...

There's more...

Advanced publication options

Getting ready

How to do it...

13. Working with BI Workspaces

Introduction

Creating BI workspaces

Getting ready

How to do it...

How it works...

There's more...

Working with report parts

Getting ready

How to do it...

How it works...

There's more...

14. Web Intelligence Rich Client

Introduction

Working with Web Intelligence Rich Client

Getting ready

How to do it...

How it works...

There's more...

Working with local data providers

Getting ready

How to do it...

How it works...

There's more...

See also

Adjusting options

Getting ready

How to do it...

See also

Index