Including Objects in a Query

The image below displays three objects that have been added to the Block panel. Each of these objects represents a unit of data that WebIntelligence will retrieve from the database when you run the query.

This image shows objects Resort, Sales Person, and Revenue in the block panel.

The sample query pictured above produces a simple table when you run it:

This image shows a simple table with information from the objects Resort, Sales Person, and Revenue.

Notice that the columns in the generated document appear in the same order as the objects of the same name in the Web Panel.

Since the order of the objects in the Section and Block panels affects their order in a table or chart, you may sometimes need to rearrange the objects, or insert one object between two others.

The following table describes how to add objects to, remove them from, and rearrange them in queries:

.
Actions on queries

To add an object
Double-click the object in the Classes and Objects panel. The object is added to the Detail panel. (You may need to drag it to the precise desired position.)
Note: If you drag and drop a class or subclass, all of its objects may be inserted.

Drag the object to the desired position in the Section/Detail panels.
Note: If you drop a class or subclass in the Detail panel, all of its objects may be inserted.

To remove an object
Drag the object back to the Classes and Objects panel.

Right-click the object, then select Delete from the contextual menu (ActiveX Web Panel only).

Select the object in the Section/Detail panel then press the Del key.

To insert an object between two other objects
Click and drag the object until the cursor is directly over one of the objects already in the Detail panel. The new object is inserted to the left of that object.

To move an object
Drag the object to the desired position.

Should you add an object to the Section or Block panel?

Simply using the Block panel, you can create new documents. These documents can contain standard tables or more complex to display the information you need, such as the following:

Table Format

Crosstab Format

Note: For more information about creating documents with either of these formats, see Tables or Crosstabs.
In some cases, a simple table may not suffice for your needs. WebIntelligence offers a range of tables and charts you can use to display your information. See Working with Block Types.

When you drop an object into the Section panel, however, you add an entirely new dimension by breaking the document into parts, or sections.

Example Creating a section by dropping an object in the Section panel

You want to create a simple table document containing sales revenue data for a set of stores. You want a separate block of data, however, for each quarter.

To do this, you arrange the relevant data objects in the Section and Block panels in the following way:

This image shows the object Quarter in the section panel, and the objects Store name and Sales revenue in the table panel.

The resulting document contains sections that look like this:

This image shows the Quarter in a separate header section, and the store name and sales revenue data in a table below.

For more information, see Breaking a Document into Parts.

Return to topic: The Document Creation Process

Return to topic: Creating and Editing WebIntelligence Documents

www.businessobjects.com
documentation@businessobjects.com