Characteristic Properties 

Use

In the Characteristic Properties dialog box for a specific characteristic, such as order type, you can set a range of functions. These settings then affect all key figures for this characteristic in a query drilldown.

Features

The Query Properties dialog box is divided into three tab pages, each covering different settings.

Tab Page: General

The settings that you can make here are identical to those in the Characteristic Properties dialog in the Query Designer. See Characteristic Properties

Tab Page: Presentation Hierarchy

You can present the characteristic hierarchically.

In the Hierarchy Name field, select the hierarchy required for this characteristic. When you click in the field, a dropdown box appears with all of the hierarchies that are available for this characteristic. Choose a hierarchy from the list.

The hierarchy is displayed in the Hierarchy Name field. The technical name of the hierarchy is displayed below it.

Select the Active checkbox to display the characteristic with the selected hierarchy in the query.

When you deactivate the Active selection box, the characteristic is displayed in the query not as a hierarchy but as a basic list.

When you have selected a hierarchy, you see the following options for the hierarchy:

Sorting Within the Hierarchy

You can set the sorting within the hierarchy according to the Key or Name in Ascending or Descending order.

Select Execute Sort and select the type of sorting and sort direction required.

If you do not make any entries, the values are sorted as determined in the hierarchy.

Hierarchy Properties

Each hierarchy has certain properties that you specify in the hierarchy definition. You can override the following hierarchy properties for the current hierarchy:

Select Other Level and enter a numerical value to show the hierarchy level to which you want to expand the hierarchy.

Select Other Position and choose whether the child nodes are positioned above (Down) or below (Up). Choose At the Top if, for example, you want to see the overall result at the bottom.

Select Other Setting and choose whether you want to Display or Suppress the values of posted nodes.

In hierarchies, nodes always display the aggregated values of the subordinate nodes and leaves. If a node has a posted values, you cannot see this. To display this posted value, an additional leave is inserted, which has the same name as the node. This leaf displays the value posted to the node.

For more information about this function in the form of an example, see Characteristic Properties.

Select Other Setting and choose whether you want to Display or Suppress the values of nodes with only one child. Suppressing nodes with only one child helps you to reach the more detailed information quickly.

For more information about this function in the form of an example, see Characteristic Properties.

Tab Page: Attributes

This tab page appears only when the characteristic has attributes.

You determine here which attributes you want to display for this characteristic in the query.

In the Display Type dropdown box, select the format in which you want to display the attribute.

You can choose from the following:

In the Display Type dropdown box, the system offers only those texts for selection that were created for this attribute in the InfoObject maintenance. See Tab Page: Attributes

Activities

In the Ad-hoc Query Designer, select the characteristic (from the rows, columns, filter or free characteristics) and from the context menu, choose Properties. The Characteristic Properties dialog box appears. Make the settings you need and choose Transfer.