HP Intelligent Management Center Standard Software Platform - Manual (Page 745)

• Business Elements
Users can access Business Views through products such as Crystal Reports
and the Report Application Server.
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 Enterprise 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
BusinessObjects Enterprise makes the report and all of its data available
to any user.
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
Crystal Reports 2008 SP3 User's Guide 745
26 Accessing Data Sources
Crystal SQL Designer files