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 determined here applies to all hierarchies that are based on this InfoObject. If sign reversal is allowed for hierarchies, the attribute 0SIGNCH is included in the communication structure for the hierarchy nodes.
Sign reversal for hierarchy nodes
Determining sign reversal |
What You Need to Know |
Set sign reversal per node in hierarchy maintenance |
Choose Change Node from the context menu of a hierarchy node to set sign reversal for this node. Note: The sign reversal only applies to the node itself not to its children or subnodes. |
Load the sign reversal hierarchy attribute flexibly |
BEx Query Designer: Creating formula variables
You have loaded data into your InfoProvider. To be able to use sign reversal in reporting, you have 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 variables wizard appears.
3. Enter a name and a short text for the variable. 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.
For more information, see Defining Variables.
See also: