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

Get SAP BusinessObjects Reporting Cookbook now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.