Show TOC

Using Sign ReversalLocate this document in the navigation structure

Procedure

Setting sign reversal for a hierarchy basic characteristic

In InfoObject maintenance, you define whether or not sign reversal is possible for the InfoObject (seeTab 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

SeeSpecial Features when Loading Data via theĀ  PSA.

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

    For more information, seeDefining Variables.

See also:

Sign Reversal

Hierarchy Properties