Book Image

SAP BusinessObjects Reporting Cookbook

By : Yoav Yohav
Book Image

SAP BusinessObjects Reporting Cookbook

By: Yoav Yohav

Overview of this book

Table of Contents (21 chapters)
SAP BusinessObjects Reporting Cookbook
About the Author
About the Reviewers

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...