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

Viewing the SQL

SQL stands for structured query language. It is code that is used for direct database querying when writing code using programming tools.

The universe outline generates SQL code as soon as objects are dragged-and-dropped into the Result Objects and Query Filters panes.

The user generates complex SQL code without understanding the nature of SQL.

As a best practice, the business user shouldn't access or deal with the SQL language, but on the other hand, it could be handy to get an idea of what's happening behind the scenes by viewing the SQL code. Of course, you need to be familiar with the SQL code and the table structure.

Viewing the SQL code is useful only for those users (Business Intelligence developers, advanced analysts, and the QA team) who are qualified to understand SQL code as well as have an understanding of the database structure.

We need a different type of join, that is, a special analytical or advanced SQL structure when we need to verify the origin tables of the...

Previous Section
End of Section 16
Next Section