User`s guide

For detailed information about Business Views and how to create them, see the Business Views
Administrator's Guide .
Note:
• When you save a report that is based on a Business View, the Save As dialog box contains an
option called "Disconnect view security." Selecting this option disconnects the report from the Central
Management Server (CMS) so that users are not prompted for logon when they open the report.
Once a report is disconnected from the CMS, you cannot reconnect to BusinessObjects Business
Intelligence platform and its security features, nor can you refresh the report's data. This is a useful
option for times when you might want to share data that is normally secured, but you don't want
those who receive the report to be able to refresh the data later.
• It is the responsibility of the System Administrator, or the report designer who has Administrator
rights, to save reports based on Business Views to a secure location. If the Administrator creates a
report based a Business View that has row- or column-level security, saving the report with saved
data to a non-secure location and then disconnecting from SAP BusinessObjects Business Intelligence
platform makes the report and all of its data available to any user.
A.7 Crystal SQL Designer files
The Crystal SQL Designer file is a query which is simply a request for a specific set of data from a
database. Once the data is gathered, it can be stored as a Crystal SQL Designer file (.qry). The Crystal
SQL Designer file can then be used much like a database table. The data it gathers from your SQL
databases becomes a new data set that can be added to reports.
Note:
• Crystal SQL Designer files were created by a legacy program in Crystal Reports. While the program
is no longer supported, you can still use the resulting QRY files as report data sources.
• Crystal Reports also provides the ability to create SQL Commands; you can define your own SQL
statement to create a virtual table to use as a data source for your reports. These commands can
be stored in the BusinessObjects Enterprise Repository and shared between many users. For more
information, search for the topic called "Defining an SQL Command" in the Crystal Reports Online
Help .
A Crystal SQL Designer file gathers data from ODBC data sources (such as SQL servers) by means
of SQL (Structured Query Language). The SQL DBMS handles all of the actual data gathering, sorting,
and grouping, according to the instructions in the SQL statement. Only the final set of data is stored as
a query file.
Note:
If you are not familiar with SQL, see Linking options.
First, you refine an SQL statement and create a query file that contains only the data you need. Then
you design your reports based on the query file instead of on the original databases. Most of the data
gathering process is done on the SQL server when you design the query. When you design your report,
the Report Designer only needs to work with a small set of data, saving you time and trouble.
2012-03-14668
Accessing Data Sources