Siebel Tools Reference > Siebel Tools Fundamentals >

Getting Reports About Object Relationships


You can get reports about the relationships between certain object types in the repository. This section provides an introduction to using the reports facility; for more information, see Siebel Reports Guide.

The list of records that displays in a repository report is not dependent on the currently selected object definition in the Object List Editor—for example, if you select the Contact business component in the Object List Editor and generate the business components and fields report, the report will show all business components, not just the Contact business component.

To restrict a report to a single parent object definition—that is, one business component, business object, dock object, table, or workflow object—do a query in the Object List Editor (for the parent object type) that restricts the list to the one object definition you want to see.

The following example shows how to get the Tables report for S_ORG_EXT.

To get a Tables report for the S_ORG_EXT table

  1. In the Object Explorer, select the Table object type.
  2. Activate the Object List Editor for tables by clicking on it.
  3. Choose Query > New Query from the menu bar.
  4. Enter a value of S_ORG_EXT in the Name property and press Enter.
  5. Choose Reports > Tables.
  6. The generated report will provide information only for the S_ORG_EXT table.

You can use a similar approach to restrict a report to a range of object definitions that have a property value in common. The report will include only those object definitions satisfying the current query. For example, you can get a Tables report of all extension tables, a business components report of all business components of a specific class, or any of the reports restricted to a single field.

The current object type in the Object Explorer determines the list of reports in the Reports menu. Repository reports are listed by current object type in Table 10.

Table 10. Reports Available for Each Object Type
Object Type
Report
Description
Applet
Applets by BusComp
Lists the applets in the repository alphabetically within each business component.
Business component
Business Component and Fields
Lists the fields in each business component alphabetically. For each field, the base column and join table, if any, are identified.
Business object
Business Object and Components
Lists the business object components in each business object. For each business object component, the business component and link are identified.
Dock object
Repository Dock Objects
For each dock object displays selected properties, and lists the member tables, visibility rules, and related dock objects.
Project
Project List
Lists all projects, and identifies the locking status, person locked by, and locked date for each.
Table
Tables
For each table displays selected properties, and lists the columns. The name, physical type, length, scale, comments, and various other properties are identified for each column.
Workflow Policy Object
Workflow Policy Objects
Lists the workflow components in each workflow object, and within each workflow component lists the columns.


 Siebel Tools Reference, Version 7.5, Rev. A 
 Published: 18 April 2003