Show TOC

Tab: GeneralLocate this document in the navigation structure

On the General tab, you can view the formula properties and make various settings.

General

This area displays the technical name and the description.

You can change the description. The new description text is different to the text specified for the key figure in InfoObject maintenance and is used for presentation in the query.

Formula Collision

Whenever you define two structures that both contain formulas, it may be unclear to the system how to calculate the formulas at the point where both formulas intersect. Collisions always occur when multiplication/division and addition/subtraction are mixed in competing formulas. If both formulas involve multiplication/division or addition/subtraction only, both calculation directions return the same result.

Example
Table 1: Example of Formula Collision
Column 1 Column 2 Column 1 x Column 2
Row 1 Value A Value B AxB
Row 2 Value C Value D CxD
Row 1 + Row 2 A+C B+D Formula Collision

In the cell in which the row formula and column formula meet, there is a formula collision: If you calculate according to the column formula in this cell, the cell contains (A+C)x(B+D). If you calculate according to the row formula in this cell, the cell contains (AxB)+(CxD). The result achieved therefore depends on the type of calculation performed.

When a formula collision occurs, you can specify how the formula is calculated.

Table 2: Resolving Formula Collisions
Option Description
(Default value) If you do not specify a value, the formula that was last specified and saved takes priority in a formula collision.
Use result of this formula Use result of this formula:

The result of this formula has priority in a collision.

Use result of concurrent formula Use result of concurrent formula

The result of a competing formula has priority in a collision.

Display

Under Display As, you can specify whether the formula is displayed and how. The following table provides an overview of the possible display options in the BW system:

Table 3: Display Type
Display Type Description
Hide Hide:

If you choose Always Show, the key figure is always visible.

If you choose Always Hide , the key figure is always hidden in the executed report.

If you choose Hide (Can be Shown), the key figure is initially hidden in the executed report but can be displayed again from within the report. You can use this setting to ensure that only information that is really necessary is displayed in the start view for the report. You can also show additional details if required.

Highlight Highlight:

You can choose whether to show the key figure using Normal Display or Highlighted Display.

Number of Decimal Places Number of decimal places:

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).

Scaling Factor Scaling factor:

You can specify a scaling factor between one and one billion.

If you set 1000 for example, the value 3000 is displayed in the report as 3.

Change Sign Change sign:

Specify whether you want to keep the signs (Keep +/- Sign) or reverse the signs (Reverse Sign).

If you choose Reverse Sign, a positive number is given a minus sign (85 becomes -85, for example) and a negative number is given a plus sign (-38 becomes +38, for example).

Note that reserve sign is purely a display function. If the key figure is added to a formula, for example, it is calculated with its correct values.

Node Status Node status:

If you have arranged the structure elements in hierarchical way, you can specify how the node is displayed in the structure: (expanded) or (collapsed). This property applies to the executed query and is unaffected by the status of the node in query definition.

Formula

This area displays the formula.

To change the formula definition, choose Edit. The Edit Formula dialog box appears.