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

Working with the Left Pane panels

The Left Pane panels are interactive panels that provide additional functionalities to the report and not just how to manipulate the data in it.

With the Left Pane report panels, the user can get important information regarding the report and query status, as we saw when we performed the drag-and-drop data tasks, and use advanced filters and navigate through the report structure.

Getting ready

We will explore the Left Pane panels' functionalities and options.

How to do it...

We will explore the Left Pane panels, starting from the top most one, as follows:

  • Document Summary: This provides the report's metadata, which is categorized into several topics discussed as follows:

    • General: This includes Type, Author, Creation date, Locale, Description, Keywords

    • Statistics: This includes Last Refresh Date, Last Modified, Last Modified By, and Duration of Previous Refresh

    • Document options: This supplies information about the properties defined in the Properties report...

Previous Section
End of Section 5
Next Section