Show TOC

Example: Entering Comments in a QueryLocate this document in the navigation structure

The task is to be able to enter or change comments in a query. These comments are in the form of short texts, which depend on specific key figure values.

DataStore Object with Short Text Attribute

This is achieved in the following example by creating a DataStore object for direct updates, which contains in its key all the characteristics that specify the key for the short text. In order to be able to enter short texts for more than one structure element of the query, you can add a characteristic that contains these key figures.

In this example, the data fields of the DataStore object contain the characteristic COMMENT 250, which has a length of 250 characters but no master data, and which is used as a key figure. The following illustration shows how this Data object can be modeled.

MultiProvider for Connecting Transaction Data and the Short Text Attribute

To insert short texts into a query, we recommend that you use a MultiProvider, which contains the InfoProviders with transaction data and the DataStore object with short texts. Aggregation levels for the planning scenarios of your productive BW system are usually available on MultiProviders by default. A DataStore object with short texts can easily be added to these aggregation levels.

Defining a Query with a Short Text Attribute

To create columns for short texts in the query, you simply need to create a new structure element after each structure element to be commented. This structure element contains the key figure, which is filled from the short text attribute of the DataStore object, and is restricted to the key figure to be commented. The following illustration shows how this query can be modeled.

Example: Client with User-Defined Short Text

The following illustration shows what this query can look like after the comments have been entered. Note that if the the comment is consistent, it is entered in the result row. If the comment is not consistent, a special value is entered in the result row (in this case NONEX).