Properties of Structure Elements and Data Cells 

Use

At the runtime for a BEx Web application, you can make various settings for a structure element, such as Credit Memo.

If you open the Properties of the Value <structure element>dialog box from the context menu of a structure element, the settings in the properties are applied to the structure element.

If you open the Properties of the Value <structure element> dialog box from the context menu of a data cell (intersection of two structure elements), the settings in the properties are applied to this data cell only.

You can also specify the properties of all structure elements in the drilldown for the Web application.

Features

You make the settings on the following tab pages:

General

To display and highlight the column with the relevant key figure values, select Highlighting.

The portal theme used defines how this highlighting is displayed in the Web application. You or your system administrator should make the corresponding setting for the portal theme under Font Weight of Emphasized Text. More information: Portal Themes.

Number Format

You can specify a scaling factor between one and one billion. If you set 1000, for example, 3000 is displayed in the report as 3.

You can define the scaling factor in the properties of the analysis grid. See the Analysis Web item.

You can specify the number of decimal places. Numbers can have any number of decimal places from zero up to nine decimal places (0, 0.0, 0.00... to 0.000000000).

The standard settings for the scaling factor and the number of decimal places correspond to the settings that you made for query design under Selection/Formula Settings/Cell. If you did not make any settings for query design, the system uses the default settings that you made in InfoObject maintenance on the Additional Properties tab page. See also Priority Rule with Formatting Settings.

Sorting

You have the following options for sorting the values of a structure element:

●      Use Current Sorting

●      Ascending

●      Descending

If you define the properties of all the data cells, the sort function is no longer relevant.

Calculations

You use this function to recalculate results rows and single values that are displayed in the query, according to specific criteria.

Under Calculate Single Values As, you specify the setting for the single values. For more information, see Calculate Single Values As.

Under Calculate Results As, you specify the setting for the results rows. For more information, see Calculate Results As.

Cumulate After Applying Details and Result Calculations:

You use this function to cumulate the individual cells in an area. The first value is added to the second value, the result is added to the third value, and so on. In the columns, the cells are cumulated from top to bottom, and in the rows, the cells are cumulated from left to right. With blocks of single values, that is, a drilldown in both the rows and the columns, the values are cumulated from top to bottom and from left to right.

Reverse Sign

Select whether +/- signs should be kept or reversed. When a sign is reversed, a positive number is given a minus sign (for example, 85 becomes -85) and a negative number is given a plus sign (for example, -38 becomes +38).

The reversal of plus and minus signs is purely a display function. If the key figure is added to a formula, for example, it is calculated with its correct values.

The sort direction and the display of conditions and exceptions take reversed signs into account. The definitions of the conditions and exceptions still contain the correct values.

For example, you sort the key figure values in decreasing order and then reverse the sign. The order of the numbers does not change and sorting is in ascending order.

A condition that displays the top 10 customers with regard to revenue displays the bottom 10 customers once you have reversed the sign.

The visualization of exceptions is reversed correspondingly once the sign has been reversed (for example, numbers that were highlighted in green are now highlighted in red).

 

The system provides additional options, depending on the settings you made to calculate the single values and the results rows.

Calculation Direction

The default calculation direction is not always as expected. You can change the calculation direction as required:

●      Use the default direction (from top to bottom and from left to right)

●      Calculate along the rows (from top to bottom)

●      Calculate along the columns (from left to right)

The Calculate Along the Columns setting is useful, for example, for all queries for which a time dimension is drilled down in the columns, and that generate a cumulated revenue. This is shown in the following example query:

Apply Detail Calculation to Results

You can also use the selected recalculation on the results rows under Calculate Results As… or Calculate Single Values As...

Note that the following functions cannot be used for hierarchy lists, that is, with an active display hierarchy, and do not have an effect on the characteristic with the hierarchy:

○       Calculate → Results As

○       Calculate → Single Value As → Ranked List or Ranked List (Olympic)

○       Calculate → Cumulated

Calculations Based on Results of Earlier Detail Calculations

If you already performed calculations for single values, you can use this function to specify that the system is to calculate the results rows using the results of the detail calculations.

Activities

If you want to specify the properties of a structure element or a data cell, choose Properties → Data Cell in the context menu of a structure element or a data cell in the Web application. The Properties for <structure element> dialog box appears.

To specify the properties of all structure elements in the drilldown of the Web application, choose Properties → All Data Cells in the context menu. The Properties for All Data Cells dialog box appears.

Make your settings and choose OK.