Creating Attribute Objects

Objective

After completing this lesson, you will be able to explain the purpose and properties of attribute objects in SAP BusinessObjects Information Design Tool.

Attribute Objects

A attribute object provides descriptive data about a dimension and is always attached to it.

Insert a Attribute

To insert an attribute object, first open the business layer in the editor by double-clicking its name in the Local projects view.

In the Business layer pane, select the dimension where you want to link the attribute.

Then, click the Insert object icon at the top of the pane and choose Attribute from the list. Once the attribute is created, you can edit its properties in the Attribute properties pane to suit your requirements.

The Attribute option is selected in the Master folder, and the Client Name dimension is configured to concatenate last and first names from the CLIENT table.

Turn a Dimension into an Attribute

To turn a dimension into an attribute, first open the business layer in the editor by double-clicking its name in the Local projects view.

Then, in the Business layer pane, select the dimension you want to convert. Right-click the selected dimension and choose Turn into attribute.

When the Select a parent dimension or measure dialog box appears, select the dimension to which the attribute will belong.

Attribute Object Properties

You have access to the same options as a dimension object, except for the Geo map tab.

The Client Address attribute is selected, with its SQL definition set to select CLIENT.CLIENT_ADDRESS from the CLIENT table and data type as String.

Attribute Object and SAP BusinessObjects Web Intelligence

When you use the Query panel in SAP BusinessObjects Web Intelligence, selecting an attribute automatically adds its associated dimension to the query. A dimension is included because an attribute cannot provide context on its own.

For example, if you add the customer address attribute to the query, the customer dimension is also added to your list of objects. This feature ensures that the data in your report is structured correctly.

Let's Summarize What You've Learned

  • Attribute objects provide descriptive data and are always linked to a specific dimension.
  • Attribute objects share most properties with dimension objects, except for Geo map options.
  • In SAP BusinessObjects Web Intelligence, selecting an attribute automatically adds its associated dimension to the query.
  • Including both attribute and dimension ensures your report data is structured and provides proper context.