Book Image

SAP BusinessObjects Reporting Cookbook

By : Yoav Yohav
Book Image

SAP BusinessObjects Reporting Cookbook

By: Yoav Yohav

Overview of this book

Related Content you might be interested in

Current Title:

Small book image
SAP BusinessObjects Reporting Cookbook
Yoav Yohav
Aug, 2014 | 380 pages
No titles found
Table of Contents (21 chapters)
SAP BusinessObjects Reporting Cookbook
SAP BusinessObjects Reporting Cookbook
Credits
Credits
About the Author
About the Author
About the Reviewers
About the Reviewers
www.PacktPub.com
www.PacktPub.com
Preface
Preface
Free Chapter
1
Working with the BI Launch Pad
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
2
Creating New Queries
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
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
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
Working with Charts
Introduction
Working with the Line chart
Working with different chart types
Formatting charts
6
Formatting Reports
Formatting Reports
Introduction
Using sorts
Using calculations
Using sections and breaks
Ranking
Conditional rules
Data tracking
Outline and fold
7
Filtering the Report Data
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
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
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
Using Hyperlinks
Introduction
Connecting reports
Passing parameters between reports
Linking to a web page
Creating and editing hyperlinks manually
11
Using Drill
Using Drill
Introduction
Using the scope of analysis
Using a query drill
Using the drill formula
12
Scheduling Reports
Scheduling Reports
Introduction
Scheduling a report
Working with instance history
Publications
Advanced publication options
13
Working with BI Workspaces
Working with BI Workspaces
Introduction
Creating BI workspaces
Working with report parts
14
Web Intelligence Rich Client
Web Intelligence Rich Client
Introduction
Working with Web Intelligence Rich Client
Working with local data providers
Adjusting options
Index
Index

Using BEx queries

One of the new core capabilities of Web Intelligence is the integration with the SAP BW environment, which means that we can connect to BEx queries as well as to BW OLAP cubes.

Since this topic is worth an entire book by itself, I suggest that you should start with the following links in order to get some well-informed and detailed information regarding this subject: http://scn.sap.com/community/bi-platform/businessobjects-bi-for-sap/blog/2013/06/09/sap-businessobjects-bi-4x-with-sap-bw-and-sap-bw-on-hana--latest-documents and http://scn.sap.com/docs/DOC-35444.

Getting ready

We want to create a query based on one of our BEx queries in order to display the sales figures per division.

How to do it...

This time, when we select the data source, we will choose the BEx option. Right after that, we will need to choose the relevant BW connection for our query, as shown in the following screenshot:

After choosing the connection, we will get a list of queries we can use. By clicking on...

Previous Section
End of Chapter 2
Next Chapter