Show TOC

Including CharacteristicsLocate this document in the navigation structure

By including a characteristic in the query, you specify that this characteristic should be available for navigation in the query data.

Procedure

In the BW Repository, choose the required characteristics and drag them to the relevant part of the query: In the Rows, Columns or under Free Characteristics. Alternatively, you can choose Add Characteristics in the context menu. The dialog box for selecting characteristics appears.

If you insert a characteristics that has a compound characteristic, the system automatically inserts this too. This also applies to copying and pasting. The system always inserts the compound characteristic into the filter's characteristic restrictions.

Example

Characteristic Country is compounded with characteristic Region. Drag characteristic Region to Free Characteristics. The system automatically inserts characteristic Country into the filter's characteristic restrictions.

You can use as many characteristics as you want in the query.

Restriction

If you want to release the query for Remote Access by OLE DB for OLAP (in the properties of the query, Screen Area: Remote Access), note the following restriction: Rows and columns together can contain a maximum of 50 - <number of structures> characterstics.

If the query does not contain a structure, a total of 50 characteristics are permitted in the rows and columns. If the query contains a structure, a total of 49 characteristics are permitted in the rows and columns. If the query contains two structures, a total of 48 characteristics are permitted in the rows and columns.