Using Sign Reversal 
Procedure
Setting sign reversal for a hierarchy basic characteristic
In
InfoObject maintenance, you define whether or not sign reversal is possible
for the InfoObject (see 
Tab Page:
Hierarchy). The Sign Reversal for Nodes setting adjusted here is
valid for all hierarchies based on this InfoObject. If sign reversal is allowed for hierarchies,
the attribute 0SIGNCH is included into the communication structure for the
hierarchy nodes.
Sign reversal for hierarchy nodes
|
Setting sign reversal |
Information |
|
Set sign reversal per node in hierarchy maintenance |
Via Change Node from the context menu of a hierarchy node, you can set the sign reversal for this node. Note: The sign reversal only applies to the node itself not to its children or subnodes. |
|
Load the hierarchy attribute sign reversal flexibly |
BEx Query Designer: Creating formula variables
You have loaded data into your InfoProvider. To be able to use sign reversal in Reporting, you need to define a formula variable in the query definition:
...
1. You are in the Query Designer. Under Key Figures, use the context menu to choose New Formula. The Formula Builder opens.
2. Under Formula Variables, choose New Variable from the context menu. The variable wizard opens.
3. Give the variable a name and a short text. Choose Replacement Path as the processing type.
4. Choose your hierarchy basic characteristic.
5. Choose Hierarchy Attribute as the replacement. The attribute Sign Reversal is automatically displayed.
6. Save your formula variable. When defining the formula variable, you get the factor 1 or –1, with which you can multiply the required key figure.
Additional information about variables can be found
from Defining
Variables with the Variable Wizard.
See also: