Exploring the BusinessObjects Repository


Objects stored in the repository are exposed through a SQL-like language that allows the administrator to query the repository. For example, he might wish to know all the objects in the repository that were created by a certain user or after a certain date. Objects in the repository are assigned certain properties when they are saved to the system, logically grouped into components known as property bags. It is these properties that are exposed via the SQL expressions.

The Query Builder, as shown in Figure 17.1, is a Web-based application that allows an administrator to query the repository. A link to Query Builder can be found on the Administator Launchpad page at http://<Server>:<port>/businessobjects/enterprise11/adminlaunch/launchpad.html.

Figure 17.1. The Query Builder displaying all of the object's properties.


Tip

To get a listing of all exposed properties, an administrator could write a SQL statement such as SELECT * FROM CI_INFOOBJECTS. All objects and all properties would be selected. After the administrator has an understanding of the properties, specific queries can be written, such as SELECT * FROM CI_INFOOBJECTS WHERE SI_KIND = `CrystalReport` to display a listing of all Crystal Reports published to BusinessObjects XI.





Crystal Reports XI(c) Official Guide
Crystal Reports XI Official Guide
ISBN: 0672329174
EAN: 2147483647
Year: N/A
Pages: 365

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net